QuickBooks Online: Difference between revisions
Jkuehlthau (talk | contribs) |
Jkuehlthau (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
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= | =Errors= | ||
==[3100] message=DispatcherError; errorCode=003100; statusCode=401.== | ==[3100] message=DispatcherError; errorCode=003100; statusCode=401.== | ||
'''Make sure your "Company Id" on the QuickBooks Connection does NOT contain spaces.''' | '''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. | This error message tells you that your access token is no longer valid. Edit your QuickBooks Connection and re-authenticate. | ||
Revision as of 20:04, 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.