DBSync Cloud Workflow (iPaaS) : Transaction failed to update when there is Group Line Item

Created by Shri Raksha N on Dec 07, 2021

Salesforce to QuickBooks Transaction will fail to update when there is a Group Line Item

Issue:

  • Transaction failed to update when there is Group Line Item

Description:

You may notice few issues for transactions to be failed. One among them is updating the invoice with the group line item. 

Solution:

  • Let’s consider the Target Object as QuickBooks Invoice and follow the below steps 

* Login into mydbsync.com using your DBSync credentials.

* Open the workflow that needs to be updated.

* In the rule Invoice update.

* Please add the below mapping to the TxnLineId field.

*Save and close the workflow.

* Run the Sync.


TxnLineID

  =

IF(VALUE("Product/QuickBooks_ItemType").equals("Group"),"-1","")

Note: We have used TxnLineID field for this particular project it may differ for other projects.