Import build assemblies into QuickBooks

You can import build assemblies from text, Excel and IIF files directly into QuickBooks using Zed Axis.  Please follow these steps:
Import Build Assemblies into QuickBooks
QuickBooks Field Format Description
Item Inventory Assembly Ref str 159  The name of the Inventory Assembly item (matches Assembly item in QuickBooks)
Inventory Site Ref str 31 Inventory site for the Built assembly
Inventory Site Location Ref str 31 Inventory site bin location for the built assembly
Serial Number str 4095 The serial number of the assembly item
Lot Number str 40 The lot number of the assembly item
Txn Date Date Date of the assembly build
Ref Number str 11 Reference number for the assembly build
Memo str 4095 Additional information
Quantity to Build Quan The number of assemblies to be built, if there are insufficient component items available the build will fail
Mark Pending If Required bool Whether the build assembly is to be marked as pending, (true) use if there are insufficient quantities on hand of component items

Add Feedback