QuickBooks Desktop has 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.
Advanced Inventory is available for QuickBooks Desktop users only. There is no feature for QuickBooks Online Advanced Inventory at this time.
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)
NOTE: 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.