2022
...
Panel |
---|
Other items such as ItemNonInventory, ItemInventory, ItemDiscount are not supported in QuickBooks Online Edition. |
Code Block |
---|
select * from Invoice,Customer where Invoice.MaxReturned=500 and Invoice.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName |
The above query joins Invoice and Customer QBXML responses into one XML, so that the transformation engine can avoid multiple processes. This is done to optimize data flow to and from QuickBooks.