2022
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.
Info |
---|
VALUE("UnitPrice") |
Pricelevelid
Info |
---|
TLOOKUP("Select productpricelevelid from productpricelevel where productnumber='"+VALUE("FullyQualifiedName")+"'") |