This article will outline what Method can sync to when using the Advanced Inventory feature in QuickBooks.
QuickBooks has instituted a feature called Advanced Inventory. This feature allows QuickBooks to manage inventory by tracking bin location, sites and locations, lot numbers and a number of other features.
To accommodate this feature, Method’s sync engine will sync with a portion of the Advanced Inventory features to create a more seamless integration with QuickBooks. Please be aware that customization will be required to implement these features on your Method screens.
At this time, the following can be synced with Method:
- Site tracking (Limited)
Method does not track inventory per Site Location, therefore, you will see ALL Site Locations for ANY particular item on a transaction line.
- Lot Numbers
- Serial Numbers
Sales Orders and Invoices can take advantage of these additional fields. When creating a Sales Order or Invoice, you can specify which site the inventory item is from, as well as the lot number or serial number of the item, and send that as part of the transaction to QuickBooks.
Your Inventory Sites are located in the InventoryControlLocation table. The LocationSite, SerialNumber and LotNumber are available on both the SalesOrderLine table and the InvoiceLine table.