cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question you would like to ask our community of experts and fellow QuickBooks Accountants and SMB's? Post a question here
GopiK
Level 1

We are passing Tax Registration Number through Integration XML and Quickbooks Desktop UK Version Not accepting on Customer

We are integrating Salesforce to Quickbooks Desktop UK Version.
We are able to Push the Data to all the fields on Customer of Quickbooks Desktop but we are unable to pass value to TaxRegistrationNumber.

 

Please go through the Request Sent and Response received for reference.

 

Request sent is :
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0" ?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <CustomerModRq requestID="08e9e308-f550-4b49-aaba-0a84f6d82018:1">
            <CustomerMod>
                <ListID>80000444-1635261201</ListID>
                <EditSequence>1635875461</EditSequence>
                <Name>Mike Test No 4 Company</Name>
                <BillAddress>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street billing</Addr2>
                    <City>shipping city</City>
                    <PostalCode>111111</PostalCode>
                </BillAddress>
                <ShipAddress>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street shipping</Addr2>
                    <City>shipping city</City>
                    <PostalCode>22222</PostalCode>
                    <Country>tywerre</Country>
                </ShipAddress>
                <Phone>[removed]</Phone>
                <Email>[email address removed]</Email>
                <Cc>[email address removed]</Cc>
                <SalesTaxCodeRef>
                    <FullName>S</FullName>
                </SalesTaxCodeRef>
                <SalesTaxCountry>UK</SalesTaxCountry>
                <TaxRegistrationNumber>45353543</TaxRegistrationNumber>
            </CustomerMod>
        </CustomerModRq>
    </QBXMLMsgsRq>
</QBXML>

 

 

Response Received =
<?xml version="1.0" ?>
<QBXML>
    <QBXMLMsgsRs>
        <CustomerModRs requestID="08e9e308-f550-4b49-aaba-0a84f6d82018:1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
            <CustomerRet>
                <ListID>80000444-1635261201</ListID>
                <TimeCreated>2021-10-26T16:13:21+00:00</TimeCreated>
                <TimeModified>2021-11-09T14:21:52+00:00</TimeModified>
                <EditSequence>1636467712</EditSequence>
                <Name>Mike Test No 4 Company</Name>
                <FullName>Mike Test No 4 Company</FullName>
                <IsActive>true</IsActive>
                <Sublevel>0</Sublevel>
                <BillAddress>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street billing</Addr2>
                    <City>shipping city</City>
                    <PostalCode>111111</PostalCode>
                </BillAddress>
                <BillAddressBlock>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street billing</Addr2>
                    <Addr3>shipping city</Addr3>
                    <Addr4>111111</Addr4>
                </BillAddressBlock>
                <ShipAddress>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street shipping</Addr2>
                    <Addr3>reter</Addr3>
                    <Addr4>hjytuj</Addr4>
                    <City>shipping city 22222 tywerre</City>
                </ShipAddress>
                <ShipAddressBlock>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street shipping</Addr2>
                    <Addr3>reter</Addr3>
                    <Addr4>hjytuj</Addr4>
                    <Addr5>shipping city 22222 tywerre</Addr5>
                </ShipAddressBlock>
                <ShipToAddress>
                    <Name>Ship To 1</Name>
                    <Addr1>Mike Test No 4 Company</Addr1>
                    <Addr2>this si the new street shipping</Addr2>
                    <Addr3>reter</Addr3>
                    <Addr4>hjytuj</Addr4>
                    <City>shipping city 22222 tywerre</City>
                    <DefaultShipTo>true</DefaultShipTo>
                </ShipToAddress>
                <Phone>[removed]</Phone>
                <Email>[email address removed]</Email>
                <Cc>[email address removed]</Cc>
                <AdditionalContactRef>
                    <ContactName>Main Phone</ContactName>
                    <ContactValue>[removed]</ContactValue>
                </AdditionalContactRef>
                <AdditionalContactRef>
                    <ContactName>Main Email</ContactName>
                    <ContactValue>[email address removed]</ContactValue>
                </AdditionalContactRef>
                <AdditionalContactRef>
                    <ContactName>CC Email</ContactName>
                    <ContactValue>[email address removed]</ContactValue>
                </AdditionalContactRef>
                <Balance>1770.00</Balance>
                <TotalBalance>1770.00</TotalBalance>
                <SalesTaxCodeRef>
                    <ListID>80000001-1489495407</ListID>
                    <FullName>S</FullName>
                </SalesTaxCodeRef>
                <SalesTaxCountry>UK</SalesTaxCountry>
                <CreditLimit>30000.00</CreditLimit>
                <JobStatus>None</JobStatus>
                <PreferredDeliveryMethod>None</PreferredDeliveryMethod>
                <CurrencyRef>
                    <ListID>80000016-1489495329</ListID>
                    <FullName>British Pound Sterling</FullName>
                </CurrencyRef>
            </CustomerRet>
        </CustomerModRs>
    </QBXMLMsgsRs>
</QBXML>.......

 

 

1 Comment 1
Giovann_G
Moderator

We are passing Tax Registration Number through Integration XML and Quickbooks Desktop UK Version Not accepting on Customer

Hi there, GopiK.

 

I can share some information regarding integrating Salesforce with QuickBooks Desktop.

 

Please make sure that the fields in Salesforce correspond to the fields in QuickBooks Desktop. Since the Tax Registration Number column in Salesforce may not match the data in QuickBooks, the system will reject the entry.

 

To fix this, choose Add custom field throughout the integration procedure to create a new custom field in QuickBooks. If you're still having problems, I recommend contacting Salesforce customer service. They'll have the tools they need to double-check the settings before importing the data into QuickBooks.

 

Feel free to visit our QuickBooks help page if you need assistance managing your other tasks. Here you will find articles that will assist you in completing some processes.

 

Keep me posted if you have further questions or concerns. I'm always here to help you.