Overview of importing build assemblies.

In QuickBooks desktop a build assembly is a transaction that combines component items together to make an assembly item, for example an interior door kit that is shown in the example below. Using Zed Axis you can import build assemblies from text and Excel files directly into QuickBooks Desktop.

Steps to import build assemblies

Please follow these steps:

Open your QuickBooks company file and connect Zed Axis.
Select the import tab and browse to the file that contains the build assembly data
Create a new map between the columns in your import file and the QuickBooks fields
Click the import button and your build assemblies will be directly imported into QuickBooks.

More help?

Download a Build Assembly sample template

Where the fields appear on a build assembly

Detailed description of the fields you can map

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 more here
Inventory Site Location Ref	str 31	Inventory site bin location for the built assembly more here
Serial Number	str 4095	The serial number of the assembly item more here
Lot Number	str 40	The lot number of the assembly item more here
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

Article ID: 274, Created: 5/29/2015 at 4:48 AM, Modified: 8/21/2020 at 12:31 AM

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 (3/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 (8/28/2018 at 12:12 AM)

Does the import build assembly work for Qucikbooks Enterprise with Advanced inventory (inventory sites) enabled?
I have tried many different options, including importing a super simple assembly from a text file and I always get...
This feature is not enabled or not available in this version of QuickBooks.
The Error location is

Please advise.
Richard Carman (5/15/2020 at 12:49 AM)

Hi Richard, Yes it does work with Sites and Bins in Enterprise, can you check the your company file to make sure that you have Inventory Site and Bin switched on in QuickBooks.
Steve (8/21/2020 at 12:33 AM)

Does this feature work with the QB Enterprise feature 'Automatically Build Sub Assemblies' ? This is an option when you manually create a build assembly. Please let me know. Thx!
Richard Carman (11/11/2021 at 2:45 AM)

Import build assemblies into QuickBooks