DBSync Cloud Workflow (iPaaS)

2022

Page tree

Versions Compared

Old Version 49

changes.mady.by.user Tushar Singh

Saved on

compared with

New Version Current

changes.mady.by.user Tushar Singh

Saved on

Key

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

...

  • 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"),":"),"")),"")
  • Similarly, open the Sequence No.4 mapping.

  • 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 where 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"),":"),"")),"")

  • Similarly, open the Sequence No.5 mapping.
  • Find the target field "ItemNonInventoryAddRq/ItemNonInventoryAdd/Name".  Replace the source 
     Code Block
     by copy-pasting the following:
     Code Block
    IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQuickBooks__QuickBooks_ItemType__c"),"ItemNonInventory"),
RSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")

...