QuickBooks Online: Difference between revisions
Jump to navigation
Jump to search
Jkuehlthau (talk | contribs) No edit summary |
Jkuehlthau (talk | contribs) |
||
Line 5: | Line 5: | ||
LineAggregate can be tricky to populate. It requires XML. Here is an example: | LineAggregate can be tricky to populate. It requires XML. Here is an example: | ||
<source lang="xml"> | |||
<Line><Amount>0.01</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>2</ItemRef></SalesItemLineDetail></Line> | <Line><Amount>0.01</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>2</ItemRef></SalesItemLineDetail></Line> | ||
<Line><Amount>0.02</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>3</ItemRef></SalesItemLineDetail></Line> | <Line><Amount>0.02</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>3</ItemRef></SalesItemLineDetail></Line> | ||
</source> | |||
=Errors= | =Errors= |
Latest revision as of 20:05, 4 January 2024
The QuickBooks online connector is based on CData's connector. Please see their documentation for additional help: https://cdn.cdata.com/help/RNJ/ado/default.htm
Origin
Inserting Invoices
Inserting and Invoice requires two fields: CustomerRef and LineAggregate.
LineAggregate can be tricky to populate. It requires XML. Here is an example:
<Line><Amount>0.01</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>2</ItemRef></SalesItemLineDetail></Line> <Line><Amount>0.02</Amount><DetailType>SalesItemLineDetail</DetailType><SalesItemLineDetail><ItemRef>3</ItemRef></SalesItemLineDetail></Line>
Errors
[3100] message=DispatcherError; errorCode=003100; statusCode=401.
Make sure your "Company Id" on the QuickBooks Connection does NOT contain spaces. This error message tells you that your access token is no longer valid. Edit your QuickBooks Connection and re-authenticate.