Inventory Export to Quickbooks

Same here see attached.


I have attached a short screen shot of the inventory adjustments. As you can see, many have no impact on our accounts. However, the large number of transactions will greatly increase the file size of our Quickbooks if we update our inventory daily.


Instead of individual transactions, we would like to have Inventory Adjustment. I have attached a screen capture of an example of a long inventory adjustment transaction.

Thank you for your reply and instruction. However, the issue is not with product that has zero quantity. The issue is with the export Inventory Adjustment being zero.

For example, if we had 3 parts in stock already in Quickbooks, and we have not sold any or added any to inventory, the export function creates an Inventory Adjustment with a net zero change to Quickbooks (Quickbooks had 3 in stock, export creates an Inventory Adjustment record changing the stock to 3 - no change). When we export inventory, this function is creating thousands of Inventory Adjustment records that are not needed, they produce no change in Quickbooks, and they significantly increase the Quickbooks file size.

The screen shots above posted by Brandon is a great example of the problem I am having as well. In the first screen shot, there is a huge list of Inventory Adjustments, many with zero dollar change to the books (no credit, no debit). All of these Inventory Adjustments are making my Quickbooks file really large. I need instead to have one Inventory Adjustment with all of the items listed in one record, like the second screen shot.

I hope that helps?

Yes, that would be great. Please contact me by e-mail and I can show you what we need.

Hello,

We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com

Maybe we are waiting for some information from your side? In this case please get back to us.

In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.

If you do not reply us back, the ticket will be automatically closed within 24 hours.

With kind regards,

The eMagicOne Administration Team

This is still a problem for us! Also another problem is that product syncing syncs grouped & configurable products, which quickbooks doesn't need to have since they are virtual products. We tried to fix that particular issue with a filter for only simple products to sync, but it doesn't save the filter for the automatic sync.

OK ill test that thanks, What can I replace in the export order to filter only completed?

Could you just modify and send us a filter built into the ExportOrdersSQL.sql file like you did ExportProductsSQL? We just want filter to work on automatic syncs, it should just be part of the module we purchased to sync automatically.

The tech. team showed us how filters work, but they only work for manual syncing. Your ExportProductSQL helped with product shipping, but we would like a solution to set filters on our automatic syncs of orders as well. We would like to only sync processing and completed orders.

Thanks can I make it both completed and possessing?