QuickBooks non-inventory items

[ccorbett1Participant]

Hi there, we have helped setup Open Sync for several of our clients. We have just installed a trial for a client wanting to report on item sales back to invoice accounts. We have successfully setup data sync to SQL including mapping invoice details lines to the iteminventory table to get the relevant sales account. We have tried to do the same thing for non-inventory items however there is no income account reference in this table (itemnoninventory). Any suggestion on how we link the relevant income account for a non-inventory item please?

Attachments:

You must be logged in to view attached files.

[Yudel RosalesKeymaster]

-ItemNonInventory Table
Name (Required)
ParentRef FullName or ListID
ListID (Required)
SalesTaxCode ListID or FullName (Required)
-SalesAndPurchaseDetail Table
PurchaseCost
PurchaseDescription
PrefVendor ListID or FullName
First Time Add Only
ExpenseAccount ListID or FullName (Required)
IncomeAccount ListID or FullName (Required)
-SalesOrPurchaseDetail Table
Amount
AmountIsPercent
Description
First Time Add Only
Account ListID or FullName (Required)

[Yudel RosalesKeymaster]

-ItemInventory Table
AssetAccount ListID or FullName (Required)
CogsAccount ListID or FullName (Required)
IncomeAccountRef ListID or FullName (Required)
PurchaseCost
PurchaseDescription
ReorderPoint
SalesDescription
SalesPrice
SalesTaxCode ListID or FullName
PrefVendor ListID or FullName
ListID (Required)
Name (Required)
ParentRef FullName or ListID
First Time Add Only
Income Account ListID or FullName (Required)

[Author]

Posts