Page History

...

• In DBSync platform, under Customer Workflow, click the More option within Rule section.
  • Enable Update Source
  • Select Update Source as Database
  • Select Operations as Upsert
  • Select Target object as table name (Example: customer_status_dbsync)
• Click "On Success" and following are the mapping for success criteriaValidate Row = criteria 
  • the validate row should contain the condition as "true" so that the mapping for the sequence works
  • Map customer _id = VALUE("customer_id")
  •  qb_id = VALUE("newid")
  •  qb_status = id  of QuickBooks with customer id field of database 
  • Map newid  of QuickBooks with  QuickBooks id field of database 
  •  Write QuickBooks status field as "Synced"
  • Save and Close the page
• Click "On Error" and following are the mapping for error criteria
  
  • Validate Row = the validate row should contain the condition as "true" so that the mapping for the sequence works
  • Map customer _id = VALUE("customer_id")qb_status = id  of QuickBooks with customer id field of database 
  • Write QuickBooks status field as "Not Synced"
  • Save and Close the page
• Click "Save Workflow" once the above changes are made

Limitation 

• QuickBooks can support up to five hierarchy level

...