2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Info

VALUE("UnitPrice")


Pricelevelid

Info

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