Note: A more updated post to include additional fields can be found here.
Transaction Pro Importer 5.0 for QuickBooks will allow you to easily import your item assemblies into QuickBooks. In QuickBook, item assemblies contain a bill of materials which is a list of all the component items that are included in this item. The component items can only be of the following types: other inventory assembly items, inventory parts, non-inventory parts, service and other charge. Make sure you add these component items first in QuickBooks or use the Item List import in Transaction Pro to import them in.
What does my Import File Need to Look Like?
You need to repeat the item assembly name on each line of the item assembly on the same line as the component item. You can view a sample import file below.
Import Type Selection
Then when you start Transaction Pro Importer for QuickBooks you will use the browse button to select your import file and you will select an import type called Item Assembly from the drop down list. Select the Next button to advance to the next screen.
File Contents Screen
The File Contents screen displays the data from your import file in a grid format within Transaction Pro Importer 5.0 for QuickBooks. If you need to edit any of this data and/or delete any rows you can easily do it on this screen. Select the Next button to advance to the next screen.
Item Assembly mapping screen
On the Transaction Pro mapping screen you will see all the fields available to import or change an existing Inventory Assembly in QuickBooks . If you are using custom fields in your company file they will also appear at the end of the QuickBooks Fields list.
Below is a data dictionary for your review. If you would like to view the entire data dictionary you can find it on our support forum.
Item Assembly Data Dictionary
|Field||QuickBooks Form - Field Description||Required Field||Type/Length|
|Sales Tax Code||Inventory Assembly - Sales Tax Code||Char 3|
|Assembly Item Name||Inventory Assembly - Item Name/Number||Yes||Char 31|
|Income Account||Inventory Assembly - Income Account||Yes||Char 31|
|COGS Account||Inventory Assembly - COGS Account||Yes||Char 31|
|Asset Account||Inventory Assembly - Asset Account||Yes||Char 31|
|Purchase Cost||Inventory Assembly - Cost||Numeric|
|Purchase Description||Inventory Assembly - Description||Char 4095|
|Sales Price||Inventory Assembly - Sales Price||Numeric|
|Sales Description||Inventory Assembly - Description||Char 4095|
|Build Point||Inventory Assembly - Build Point||Numeric|
|Component Item Name||Inventory Assembly - Bill of Materials - Item||Char 31|
|Component Item Qty||Inventory Assembly - Bill of Materials - Qty||Numeric|
|Unit of Measure||Inventory Assembly - U/M Set||Char 31|
Import file fields mapped to QuickBooks fields
This next screen depicts how the data in your import file will be mapped to the QuickBooks fields. Review and select the next button.
QuickBooks Item Setting Screen
On most other import this last screen is used to create new items if they do not exist. In the case of an item assembly import Transaction Pro Importer 5.0 will not be creating new items but we do require that you fill this last screen out to start the import. Make your selections and then select the Finish button to start the import.
Free Fully Functioning Demo
If you would like to test this out you can request a free demo from here.