2022

Page tree

Versions Compared

Key

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

...

  • In the Rules section, click on Add New Rule. Select Target as Salesforce, Operation as Update, Target Object as Product2 and click on Map.
  • Map the fields as shown below. Then, Save. Notice that, on the left side it has Target fields (Salesforce) and on the right side, it has source fields (QuickBooks). PriceBook1 is the name of Salesforce PriceBook and PriceLevel1 is the name of the QuickBooks Price Level.
Code Block
VALIDATEROW = IF(EQUALS(VALUE("Name"),"PriceLevel1"),"true","false")

...


VALIDATEROW = IF(EQUALS(VALUE("Name"),"PriceLevel1"),"true","false")

...


Product2 = Loop Over "PriceLevelPerItemRet"

...


AVSFQBQuickBooks_Idc = VALUE("ItemRef/ListId")

...


Name = VALUE("ItemRef/FullName")

...


Pricebook2Id = "PriceBook1"

...


UnitPrice = VALUE("CustomPrice")

...

  • In the Rules section, click on Add New Rule to add new Rule. Select Target as Salesforce, Operation as Update, Target Object as Product2 and click on Map.
  • Map the fields as shown below. Then, Save. Notice that, on the left side it has Target fields (Salesforce) and on the right side it has source fields (QuickBooks). PriceBook2 is the name of Salesforce PriceBook and PriceLevel2 is the name of the QuickBooks Price Level.
Code Block
VALIDATEROW = IF(EQUALS(VALUE("Name"),"PriceLevel2"),"true","false")

...


Product2 = Loop Over "PriceLevelPerItemRet"

...


AVSFQBQuickBooks_Idc = VALUE("ItemRef/ListId")

...


Name = VALUE("ItemRef/FullName")

...


Pricebook2Id = "PriceBook2"

...


UnitPrice = VALUE("CustomPrice")

...

  • To sync the new QuickBooks Price Level, repeat the above process. For every price level in QuickBooks, create a new Rule and map as discussed above.