2022

Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Issue: Amount value from salesforce is not getting pushed to QuickBooks because of decimal places exceeding more than two values.

 

Reason: QuickBooks does not support amount values more than two decimal places. Thus Invoices can not be created through Sync due to amount value exceeding two decimal places.

 

 

Fig 1: Amount field Mapping

 

 

Fig 2: Logs

 

Solution:

  1. Open the Workflow that needs to be updated.
  2. Update the Amount field by LSPLIT(VALUE("UnitPriceCustom__c"),".")+"."+RIGHT(RSPLIT(VALUE("TotalPrice"),"."),2)      
  3. Save and close. Save the workflow.

 


Fig 3: Updated mappings

4. Run the sync.

 

Fig 4: Logs of success 

 

 

 

  • No labels