Page History

Multiple Price Levels of QuickBooks can be integrated with the respective Salesforce Price Books using DBSync. This section explains the steps involved in DBSync customization for multiple Price Level Integration.

...

• In this new workflow, add the below query using Advanced Query Builder. Datasource should be QuickBooks. Batch size in properties will remain as 100 (default value)

  select * from PriceLevel where Pricelevel.Maxreturned=100

...

VALIDATEROW = IF(EQUALS(VALUE("Name"),"PriceLevel1"),"true","false")
Product2 = Loop Over "PriceLevelPerItemRet"
AVSFQBQuickbooksQuickBooks_Idc = VALUE("ItemRef/ListId")
Name = VALUE("ItemRef/FullName")
Pricebook2Id = "PriceBook1"
UnitPrice = VALUE("CustomPrice")

...

VALIDATEROW = IF(EQUALS(VALUE("Name"),"PriceLevel2"),"true","false")
Product2 = Loop Over "PriceLevelPerItemRet"
AVSFQBQuickbooksQuickBooks_Idc = VALUE("ItemRef/ListId")
Name = VALUE("ItemRef/FullName")
Pricebook2Id = "PriceBook2"
UnitPrice = VALUE("CustomPrice")

...