DBSync Cloud Workflow (iPaaS)

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

« Previous Version 7 Current »

Issue

Amount field was not getting updated for those associated price list items in MSCRM.


Solution

We should write a new rule in QBItemsToMSCRMProduct workflow where the target object is product pricelevel and we are using update operation based on productpricelevelid which is a lookup field in MSCRM. The primary key would be productid



And also should do the following mappings in amount and pricelevelid fields as shown.

Amount

VALUE("UnitPrice")


Pricelevelid

TLOOKUP("Select productpricelevelid from productpricelevel where productnumber='"+VALUE("FullyQualifiedName")+"'")






  • No labels