Issue

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


Solution

We should write a new rule in QBItemsToMSCRMProduct workflow where the target object is ProductPrice level and we are using Update operation based on ProductPricelevelID - which is a lookup field in MSCRM. The primary key would be ProductID



We should also map amount and PricelevelID fields as shown:

Amount

VALUE("UnitPrice")


PricelevelID

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