0

Currently I am using suitetalk 2020.1 called via c# code

In the UI if you have a purchase order with the selection on the MATCH BILL TO RECEIPT = true and you initialize and create a vendor bill, the corresponding items on the vendor bill will have the receipt linked to it (the billReceiptsList for the item in populated with the corresponding receipt.

If you delete that bill and then connect to your NetSuite account ( and do a vendor bill Initialize from the corresponding Initialize of a vendor bill for that same PO, it will return XML with that same billReceiptsList populated.

If you do a save of a vendor receipt (which also has that same bill receiptsList populated, the bill is successfully added but the receiptsList values that were passed in (the same ones that were created in the initialize of the vendor bill) do not show up on the vendor bill when it comes over via suiteTalk.

Included I will show the XML of the initialize result as well as the Add list for the vendor bill where you can see the receiptsList values populated and no error returned from the add list. The end result in Netsuite however does not have the Receipts populated. Does anyone know if there is something additional that might need done to link the receipt to the item line(s)

I have not included the code but know that the code would simply initialize that bill and fill in some various values as shown in the add requests xml

<soapenv:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soapenv:Header>
        <platformMsgs:documentInfo xmlns:platformMsgs="urn:messages_2020_1.platform.webservices.netsuite.com">
            <platformMsgs:nsId>WEBSERVICES_TSTDRV2473767_010320232025040423622525377_565de2</platformMsgs:nsId>
        </platformMsgs:documentInfo>
    </soapenv:Header>
    <soapenv:Body>
        <initializeResponse xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
            <readResponse>
                <platformCore:status isSuccess="true" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com"/>
                <record xsi:type="tranPurch:VendorBill" xmlns:tranPurch="urn:purchases_2020_1.transactions.webservices.netsuite.com">
                    <tranPurch:customForm internalId="153" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>Z - Vendor Bill</platformCore:name>
                    </tranPurch:customForm>
                    <tranPurch:billAddressList internalId="244963" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>Amazon</platformCore:name>
                    </tranPurch:billAddressList>
                    <tranPurch:account internalId="25" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>2000 Accounts Payable</platformCore:name>
                    </tranPurch:account>
                    <tranPurch:entity internalId="1552" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>Amazon</platformCore:name>
                    </tranPurch:entity>
                    <tranPurch:subsidiary internalId="1" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>Honeycomb Mfg.</platformCore:name>
                    </tranPurch:subsidiary>
                    <tranPurch:approvalStatus internalId="2" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>Approved</platformCore:name>
                    </tranPurch:approvalStatus>
                    <tranPurch:postingPeriod internalId="156" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>Jan 2010</platformCore:name>
                    </tranPurch:postingPeriod>
                    <tranPurch:tranDate>2023-01-03T00:00:00.000-08:00</tranPurch:tranDate>
                    <tranPurch:currencyName>USA</tranPurch:currencyName>
                    <tranPurch:exchangeRate>1.0</tranPurch:exchangeRate>
                    <tranPurch:dueDate>2023-01-03T00:00:00.000-08:00</tranPurch:dueDate>
                    <tranPurch:userTotal>284.0</tranPurch:userTotal>
                    <tranPurch:paymentHold>false</tranPurch:paymentHold>
                    <tranPurch:currency internalId="1" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:name>USA</platformCore:name>
                    </tranPurch:currency>
                    <tranPurch:itemList>
                        <tranPurch:item>
                            <tranPurch:item internalId="387" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                                <platformCore:name>ACC00001</platformCore:name>
                            </tranPurch:item>
                            <tranPurch:orderDoc>10830</tranPurch:orderDoc>
                            <tranPurch:orderLine>1</tranPurch:orderLine>
                            <tranPurch:quantity>4.0</tranPurch:quantity>
                            <tranPurch:description>400 Watt Power Supply</tranPurch:description>
                            <tranPurch:rate>71.00</tranPurch:rate>
                            <tranPurch:amount>284.0</tranPurch:amount>
                            <tranPurch:location internalId="2" xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                                <platformCore:name>01: San Francisco</platformCore:name>
                            </tranPurch:location>
                            <tranPurch:billreceiptsList xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                                <platformCore:recordRef internalId="10831">
                                    <platformCore:name>REC00000230</platformCore:name>
                                </platformCore:recordRef>
                            </tranPurch:billreceiptsList>
                        </tranPurch:item>
                    </tranPurch:itemList>
                    <tranPurch:customFieldList xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
                        <platformCore:customField xsi:type="platformCore:BooleanCustomFieldRef" scriptId="custbody_powf_se_ok" internalId="223">
                            <platformCore:value>false</platformCore:value>
                        </platformCore:customField>
                        <platformCore:customField xsi:type="platformCore:BooleanCustomFieldRef" scriptId="custbody_pacejet_quoted" internalId="5043">
                            <platformCore:value>false</platformCore:value>
                        </platformCore:customField>
                        <platformCore:customField xsi:type="platformCore:SelectCustomFieldRef" scriptId="custbodyhj_tc_po_status" internalId="4637">
                            <platformCore:value typeId="483" internalId="1">
                                <platformCore:name>New</platformCore:name>
                            </platformCore:value>
                        </platformCore:customField>
                        <platformCore:customField xsi:type="platformCore:BooleanCustomFieldRef" scriptId="custbody_hj_devqa_checkbox" internalId="4567">
                            <platformCore:value>false</platformCore:value>
                        </platformCore:customField>
                        <platformCore:customField xsi:type="platformCore:BooleanCustomFieldRef" scriptId="custbody_powf_ctrl_ok" internalId="220">
                            <platformCore:value>false</platformCore:value>
                        </platformCore:customField>
                    </tranPurch:customFieldList>
                </record>
            </readResponse>
        </initializeResponse>
    </soapenv:Body>
</soapenv:Envelope>

<soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <soap:Header>
        <preferences xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
            <warningAsError>false</warningAsError>
            <ignoreReadOnlyFields>true</ignoreReadOnlyFields>
        </preferences>
        <tokenPassport xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
            <account xmlns="urn:core_2020_1.platform.webservices.netsuite.com">TSTDRV2473767</account>
            <consumerKey xmlns="urn:core_2020_1.platform.webservices.netsuite.com">****************************************************************</consumerKey>
            <token xmlns="urn:core_2020_1.platform.webservices.netsuite.com">****************************************************************</token>
            <nonce xmlns="urn:core_2020_1.platform.webservices.netsuite.com">5261272433702077534</nonce>
            <timestamp xmlns="urn:core_2020_1.platform.webservices.netsuite.com">1672767849</timestamp>
            <signature algorithm="HMAC_SHA256" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">********************************************</signature>
        </tokenPassport>
    </soap:Header>
    <soap:Body>
        <addList xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
            <record externalId="HJ_BILL__17" xsi:type="q1:VendorBill" xmlns:q1="urn:purchases_2020_1.transactions.webservices.netsuite.com">
                <q1:customForm internalId="153">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Z - Vendor Bill</name>
                </q1:customForm>
                <q1:billAddressList internalId="244963">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Amazon</name>
                </q1:billAddressList>
                <q1:account internalId="25">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">2000 Accounts Payable</name>
                </q1:account>
                <q1:entity internalId="1552"/>
                <q1:subsidiary internalId="1">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Honeycomb Mfg.</name>
                </q1:subsidiary>
                <q1:approvalStatus internalId="2">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Approved</name>
                </q1:approvalStatus>
                <q1:postingPeriod internalId="156">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">Jan 2010</name>
                </q1:postingPeriod>
                <q1:tranDate>2022-12-28T00:00:00</q1:tranDate>
                <q1:currencyName>USA</q1:currencyName>
                <q1:exchangeRate>1</q1:exchangeRate>
                <q1:dueDate>2023-01-03T03:00:00-05:00</q1:dueDate>
                <q1:tranId>JCV1347</q1:tranId>
                <q1:paymentHold>false</q1:paymentHold>
                <q1:currency internalId="1">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">USA</name>
                </q1:currency>
                <q1:location internalId="2">
                    <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">01: San Francisco</name>
                </q1:location>
                <q1:expenseList replaceAll="false"/>
                <q1:itemList replaceAll="false">
                    <q1:item>
                        <q1:item type="inventoryItem" internalId="387">
                            <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">387</name>
                        </q1:item>
                        <q1:orderDoc>10830</q1:orderDoc>
                        <q1:orderLine>1</q1:orderLine>
                        <q1:quantity>4</q1:quantity>
                        <q1:rate>50</q1:rate>
                        <q1:amount>45</q1:amount>
                        <q1:location internalId="2">
                            <name xmlns="urn:core_2020_1.platform.webservices.netsuite.com">01: San Francisco</name>
                        </q1:location>
                        <q1:billreceiptsList>
                            <recordRef internalId="10831" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">
                                <name>REC00000230</name>
                            </recordRef>
                        </q1:billreceiptsList>
                    </q1:item>
                </q1:itemList>
                <q1:landedCostsList replaceAll="false"/>
                <q1:customFieldList>
                    <customField scriptId="custbody_powf_se_ok" internalId="223" xsi:type="BooleanCustomFieldRef" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">
                        <value>false</value>
                    </customField>
                    <customField scriptId="custbody_pacejet_quoted" internalId="5043" xsi:type="BooleanCustomFieldRef" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">
                        <value>false</value>
                    </customField>
                    <customField scriptId="custbodyhj_tc_po_status" internalId="4637" xsi:type="SelectCustomFieldRef" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">
                        <value typeId="483" internalId="1">
                            <name>New</name>
                        </value>
                    </customField>
                    <customField scriptId="custbody_hj_devqa_checkbox" internalId="4567" xsi:type="BooleanCustomFieldRef" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">
                        <value>false</value>
                    </customField>
                    <customField scriptId="custbody_powf_ctrl_ok" internalId="220" xsi:type="BooleanCustomFieldRef" xmlns="urn:core_2020_1.platform.webservices.netsuite.com">
                        <value>false</value>
                    </customField>
                </q1:customFieldList>
            </record>
        </addList>
    </soap:Body>
</soap:Envelope>
jvoigt
  • 400
  • 4
  • 23

0 Answers0