The QBO integration sees the GL account passed at the invoice header level and not the line item.
The direction we received from QBO was to use their Item Code to define the product/service.
The item code is pre-defined in QBO and you set a GL code against the item. The end result is that the general ledger reflects the sale account based on the item.
The first step is to define the product/services in QBO.
There are 3 methods of setting the Item Code on an invoice in IQ for Quick Books Online Integration
Product Category (Single or Multi-Line invoices)
General Ledger Account (Single or Multi-Line invoices)
Reporting Code (requires multi-line invoices)
This is a system setting. It will be set to whichever option you want by your printIQ Support Representative when QBO is being configured for your site.
For multi-line invoices using either GL Accounts or Reporting Codes, the entries for these are located together on the different entries in printIQ.
For Operations, the GL Accounts and the Reporting Codes are entered through the Reporting and Accounts tab on the operation definition.
For presses, the GL Accounts and Reporting Codes are configured at the bottom of the Press Definition Details screen.
For Guillotines you need to click the icon to the right of the Guillotine definition…
to open the Extra References modal. Set the GL Accounts and Reporting Codes in here…
Product Category
The Product Category definitions (Admin > Factory Capabilities > Product Categories) have a field in the Product and Filters area called Invoice Code…
When a job, for a product from this Product Category (letterheads in this example) is invoiced, the item code field on the invoice details is populated with this value…
General Ledger Account
If printIQ is configured for single line invoicing, the GL Code is taken from the Default General Ledger Account on the Product Category…
And on the invoice, it will appear like…
If printIQ is set to create multi-line invoices the Item Code will be populated by the value of the GL Code set on each of the operations, presses, stocks etc.
GL Account Definition
Corresponding Item Codes on Invoice…
Reporting Code
If Reporting Codes are to be used to populate the Item Code field on the invoice details, multi-line invoices must be enabled.
On the Press Definition the Reporting Code for Press References was set to ‘Printing’…
While the Stock / Substrate Reference Reporting Code was set to ‘Digital’
On the invoice, the Item Code is populated with the relevant Reporting Code…
When exported to CSV, you can see the Item Code column has the above values…