2022

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

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")+"'")






  • No labels