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
I downloaded the Zed Axis 12.1 and am interested in purchasing it. I cannot get the mapping to allow more than one Inventory Line Item on my mapping. My assemblies will have multiple line items per assembly. How can I get multiple inventory Line Items per mapping?
Matt Lebold (March 27, 2018 at 1:22 AM)
Hi Matt, the components are set on the Item Inventory Assembly if you need to change what components are on the assembly then you need to modify the Item Inventory Assembly not the Build Assembly.
Steve (August 28, 2018 at 12:12 AM)

Add Feedback