Mariia Zaharova
posted this
26 December 2017
Admin
As we can see from your account, you have successfully added new task Quickbooks Products <> 365 Products to your package.
If the issue is still actual, please describe the difficulties with some screenshots.
Also, in your package you have encountered this error: SQLite error no such table: Item_product_CacheID
There is a known issue related to such a scenario and we are working on it. We will contact you as soon as any news are available.
This error occurs in case when package previously had one task and was performed successfully, however, additional task was added later and the error occurred. The recommended option is to use separate packages for new tasks or re-create the package with several tasks (new tasks and tasks that you have in an existing package).
As for the Quickbooks Invoices, please note the Line field in the QuickBooks Invoice entity is mandatory and must be mapped. The Line field stores the specification of the Invoice and it is stored in the JSON format. During the execution of an import or synchronization package that import data into QuickBooks Invoices, data will be automatically added to Invoice and to the InvoiceLineItem detail table that is mapped to it. Note that data in the Line column should be in the JSON format. Refer to: https://skyvia.com/resources/docs/index.html?quickbooks_connections.htm
For example, you can insert the following value in the Line field:
"[
{
""Id"": ""1"",
""LineNum"": 1.0,
""Amount"": 189.78,
""DetailType"": ""SalesItemLineDetail"",
""SalesItemLineDetail_ItemRefId"": ""1"",
""SalesItemLineDetail_ItemRefName"": ""Sales"",
""SalesItemLineDetail_UnitPrice"": 189.78,
""SalesItemLineDetail_Qty"": 1.0
},
{
""Amount"": 189.78,
""DetailType"": ""SubTotalLineDetail""
}
]"
Please tell us if this information helps.
