2022
Issue: Salesforce custom Custom field to QuickBooks custom Custom field.
Root Cause: Requirement on mapping Quickbooks desktop custom Custom field on Customer entity.
Solution:
Let’s go through a used use case where in we have to sync a Salesforce standardStandard/custom Custom field to QuickBooks Custom field on either customerCustomer/vendor Vendor entity.
We have a field “Client Name” created in Salesforce which . The field has to be synced to a custom Custom field “CLIENT NAME” in QuickBooks desktop under Customer.
Create a rule under the desired workflow
. Select the target as DataExt and perform Mapping and Writer as Follows
:
Mapping
Seq 1: Client Name in
...
Salesforce to Client Name in
...
QuickBooks:
DataExtModRq/DataExtMod/DataExtName | = | "Client Name" |
DataExtModRq/DataExtMod/DataExtValue | = | VALUE("Client_Name__c") |
DataExtModRq/DataExtMod/ListDataExtType | = | "Customer" |
DataExtModRq/DataExtMod/ListObjRef/FullName | = | VALUE("Name") |
OR | ||
DataExtModRq/DataExtMod/ListObjRef/ListID | = | VALUE("newid") |
DataExtModRq/DataExtMod/OwnerID | = | "0" |
VALIDATEROW | = | "true" |
In Explanation of the above mappings,:
DataExtName is the name of the custom Custom field in QuickBooks.
DataExtValue is the value of salesforce the Salesforce field.
ListDataExtType is the name of an entity in QuickBooks where the custom Custom field is added.
ListObjRef/FullName or ListObjRef/ListID are the reference fields in QuickBooks. We can use either of the mappingmappings.
OwnerId is default has defaulted to 0.