2022
...
Table of Contents |
---|
Panel |
---|
Integration from |
...
QuickBooks to Salesforce |
...
...
...
...
...
...
...
...
...
...
...
...
Panel |
---|
Integration from Salesforce to |
...
QuickBooks |
Find the target field "ItemServiceAddRq/ItemServiceAdd/Name". Then, replace the source code by copy-pasting the following:
Code Block |
---|
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQuickBooks__QuickBooks_ItemType__c"),"ItemService"),
RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")
|
Add the mapping where target field = "ItemServiceAddRq/ItemServiceAdd/ParentRef/FullName" and source field as the following:
Code Block |
---|
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQuickBooks__QuickBooks_ItemType__c"),"ItemService"),
(IF(VALUE("PricebookEntry/Product2/Name").contains(":"),
LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")),"")
|
Find the target field "ItemInventoryAddRq/ItemInventoryAdd/Name" and replace the source code by copy-pasting the following
.:
Code Block |
---|
...
IF(EXACT(VALUE("PricebookEntry/Product2/ |
...
AVSFQuickBooks__QuickBooks_ItemType__c")," |
...
ItemInventory"), RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
...
Find the target field "ItemNonInventoryAddRq/ItemNonInventoryAdd/Name". Replace the source code by copy-pasting the following:Add the mapping
ItemServiceAddRq/ItemServiceAddwhere target field = "ItemInventoryAddRq/ItemInventoryAdd/ParentRef/FullName
=" and source field as the following:
Code Block |
---|
IF(EXACT(VALUE("PricebookEntry/Product2/ |
AVSFQuickBooks__QuickBooks_ItemType__c"),"ItemInventory"), (IF(VALUE("PricebookEntry/Product2/Name").contains(":"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"") |
),"")
|
Code Block |
---|
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQuickBooks__QuickBooks_ItemType__c"),"ItemNonInventory"),
RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")
|
Add the mapping where target field = "ItemNonInventoryAddRq/ItemNonInventoryAdd/ParentRef/FullName" and source field as the following:
Code Block |
---|
IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQuickBooks__QuickBooks_ItemType__c"),"ItemNonInventory"),
(IF(VALUE("PricebookEntry/Product2/Name").contains(":"),
LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")),"")
|