Page History

...

• Click on "Edit" link for  " **********_map.xml"* to open the mapping in a new tab or window.

...

• Click on "Edit" link for  " **********_map.xml"* to open the mapping in a new tab or window and make the following changes in the mapping window.

...

• Add the mapping where target field = "ItemServiceAddRq/ItemServiceAdd/ParentRef/FullName" and source field as the following.

  Code Block
  IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemService"), (IF(VALUE("PricebookEntry/Product2/Name").contains(":"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")),"")

• A screenshot illustrates both the mapping changes. 

...

• Similarly open the Sequence No 4 mapping and click on "Edit" link for  " *********_map.xml*"** to open the mapping in a new tab or window.

...

• Add the mapping where target field = "ItemInventoryAddRq/ItemInventoryAdd/ParentRef/FullName" and source field as the following.

  Code Block
  IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemInventory"), (IF(VALUE("PricebookEntry/Product2/Name").contains(":"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")),"")

• Similarly open the Sequence No 5 mapping and click on "Edit" link for  " *********_map.xml*"** to open the mapping in a new tab or window.

...

• Add the mapping where target field = "ItemNonInventoryAddRq/ItemNonInventoryAdd/ParentRef/FullName" and source field as the following.

  Code Block
  IF(EXACT(VALUE("PricebookEntry/Product2/AVSFQB__QuickBooks_ItemType__c"),"ItemNonInventory"), (IF(VALUE("PricebookEntry/Product2/Name").contains(":"), LSPLIT(VALUE("PricebookEntry/Product2/Name"),":"),"")),"")

•  The above example illustrates Product Hierarchy mapping for OpportunityToInvoice state. Based on the transaction you use, a similar procedure can be followed for other transaction states like OpportunityToEstimate,OpportunityToSalesOrder,OpportunityToSalesReceipt,OpportunityToCreditMemo.