DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Tushar Singh

Saved on

compared with

New Version Current

changes.mady.by.user Munira Majumdar

Saved on

Key

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

Issue

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

Image Added


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

Image Added


Image Added


We should also map amount and PricelevelID fields as shown:

Amount

Info

VALUE("UnitPrice")

Image Added


PricelevelID

Info

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

Image Added