Import group items on invoices into QuickBooks

Axis

Overview

If you need to import group items (group items are special types of QuickBooks items they group together individual items that you often sell together for example a Decorating Kit consisting of Paint, Paint Brushes and Pots) on invoices into QuickBooks using Zed Axis then you need to map your data to different items fields than you would for other standard items types as QuickBooks handles these imports in a different way.

When setting up your import mapping for an invoice transaction in Zed Axis you need to map your data to the following fields:
 
Import Group Items
 
 QuickBooks Field FormatDescription 
 Item Group Name str 31The name of the Group Item sold on the invoice 
 Item Group Quantity quanThe quantity of the Group Item sold
 Item Group Unit Measure str31The unit of measure of the Group Item
 
 
Notes:
 
  • It is not possible to set the Item Group Price or Amount as QuickBooks do not permit those fields to be imported.
  • The Item Group Name should be a separate column from the ItemRefFullName
  • You can map both ItemGroup and Items on the same transaction but they cannot be on the same row
Article ID: 159, , Modified: 6/3/2022 at 6:46 AM

Feedback

How about if my group items are different amounts each time, where can i map the amounts for each item in the group?
Jacob Neuman (10/3/2018 at 9:27 PM)

Was this article helpful?

Share this article