Page History

...

• Map the fields as shown below and Save. Left side it has Target fields (Salesforce) and right side it has source fields (QuickBooks). PriceBook1 is the name of Salesforce PriceBook and PriceLevel1 is the name of the QuickBooks Price Level.

Covered so far

...

• Create another Map and Writer to sync QuickBooks PriceLevel2 with Salesforce PriceBook2 and connect them as shown below.

...

• The same Reader will be used to connect with the second Map and Writer.

• Open Writer Properties and enter the details as shown below and Save.

...

• Open Map Properties, enter the sequence number and the description as required and Save.

...

• Open Map Properties, click on edit to map the fields in the next tab of browser.

...

• 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 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 and Save. Left side it has Target fields (Salesforce) and right side it has source fields (QuickBooks). PriceBook2 is the name of Salesforce Price Book PriceBook and PriceLevel2 is the name of the QuickBooks Price Level.

...

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 new QuickBooks Price Level, repeat the above process. For every PriceLevel in QuickBooks, create a new Map and Writer and edit the properties and maps Rule and map as discussed above.