https://netsuiteprofessionals.com logo
Join Slack
Powered by
this is the item history from a sales order on a d...
# general
z
this is the item history from a sales order on a drop ship SKU. what would cause the Create PO field to be unset? the integration company making this says they are not setting that value at all.
l
try setting complete qty before sending drop shipment command and see if that makes a diff.
z
the integration company says they are not setting the "create PO" field at all... and they are not able to set it to back to 'DropShip'... which doesn't make sense to me. i will suggest to them to set complete qty first
l
and this is with item creation? is there a workflow at all?
z
this is with sales order creation, this SKU happens to be a drop ship item
no workflow that affects this sales order
l
the only thing i can think of, my last tool off the top of my head, they could be sending a “replace all” command in SOAP and “maybe”, just “maybe” that is causing that.
z
but its definitely being set/unset from their end, correct? i opened a support ticket to check if this is default netsuite behavior but we only have Basic tier support so they might tell me to kick rocks
l
not necessarily, there could be something that is triggering it on your end that is not because of the integrator. Review the soap request to review what they are sending.
🙏 1
k
It could be that whatever they are doing to set "Fulfilled" to 0 is removing the "Create PO" field value. It appears that there are two requests, one at 9:17 and one at 9:18. What is the 2nd request doing?
z
I'll ask if they will share the entire soap request. from my end as the user it just looks like the 9:18 request unsets the Create PO field
Copy code
<sps:NsRecord xmlns:sps="<https://www.spscommerce.com/integration/ns>" xmlns:platformCore="urn:<http://core_2022_2.platform.webservices.netsuite.com|core_2022_2.platform.webservices.netsuite.com>" xmlns:listRel="urn:<http://relationships_2022_2.lists.webservices.netsuite.com|relationships_2022_2.lists.webservices.netsuite.com>">
    <record xsi:type="tranSales:SalesOrder" xmlns:xsi="<http://www.w3.org/2001/XMLSchema-instance>" xmlns:tranSales="urn:<http://sales_2022_2.transactions.webservices.netsuite.com|sales_2022_2.transactions.webservices.netsuite.com>" xmlns:platformCore="urn:<http://core_2022_2.platform.webservices.netsuite.com|core_2022_2.platform.webservices.netsuite.com>" xmlns:platformCommon="urn:<http://common_2022_2.platform.webservices.netsuite.com|common_2022_2.platform.webservices.netsuite.com>">
        <tranSales:entity internalId="14">
        </tranSales:entity>
        <tranSales:tranDate>2024-03-21T10:00:00Z</tranSales:tranDate>
        <tranSales:orderStatus>_pendingApproval</tranSales:orderStatus>
        <tranSales:otherRefNum>012030321262</tranSales:otherRefNum>
        <tranSales:shippingAddress>
            <platformCommon:addressee>COSTCO VAN BUREN - DRY</platformCommon:addressee>
            <platformCommon:addr1>5860 BELLEVILLE RD</platformCommon:addr1>
            <platformCommon:city>VAN BUREN TWP</platformCommon:city>
            <platformCommon:state>MI</platformCommon:state>
            <platformCommon:zip>48111</platformCommon:zip>
        </tranSales:shippingAddress>
        <tranSales:shipDate>2024-05-12T10:00:00Z</tranSales:shipDate>
        <tranSales:itemList>
            <tranSales:item>
                <tranSales:quantity>7560.0</tranSales:quantity>
                <tranSales:price internalId="-1">
                </tranSales:price>
                <tranSales:rate>6.7</tranSales:rate>
                <tranSales:customFieldList>
                    <platformCore:customField scriptId="custcol_sps_linesequencenumber" xsi:type="platformCore:StringCustomFieldRef">
                        <platformCore:value>1</platformCore:value>
                    </platformCore:customField>
                    <platformCore:customField scriptId="custcol_sps_bpn" xsi:type="platformCore:StringCustomFieldRef">
                        <platformCore:value>1796195</platformCore:value>
                    </platformCore:customField>
                    <platformCore:customField scriptId="custcol_sps_vendorpartnumber" xsi:type="platformCore:StringCustomFieldRef">
                        <platformCore:value>1796195</platformCore:value>
                    </platformCore:customField>
                    <platformCore:customField scriptId="custcol_sps_purchaseprice" xsi:type="platformCore:DoubleCustomFieldRef">
                        <platformCore:value>6.7</platformCore:value>
                    </platformCore:customField>
                    <platformCore:customField scriptId="custcol_sps_orderqtyuom" xsi:type="platformCore:StringCustomFieldRef">
                        <platformCore:value>EA</platformCore:value>
                    </platformCore:customField>
                </tranSales:customFieldList>
            </tranSales:item>
            <tranSales:item>
                <tranSales:item internalId="4470">
                </tranSales:item>
                <tranSales:price internalId="-1">
                </tranSales:price>
                <tranSales:rate>-0.75%</tranSales:rate>
                <tranSales:amount>-379.89</tranSales:amount>
            </tranSales:item>
        </tranSales:itemList>
        <tranSales:customFieldList>
            <platformCore:customField scriptId="custbody_sps_purchaseordernumber" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>012030321262</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_purchaseorderdate" xsi:type="platformCore:DateCustomFieldRef">
                <platformCore:value>2024-03-21T00:00:00Z</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_tsetpurposecode" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>00</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_potype" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>SA</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_vendor" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>0003623100</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_department" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>34</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_departmentdescription" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>COSTCO DEPARTMENT</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_division" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>MW</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_st_locationcodequalifier" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>9</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_st_addresslocationnumber" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>1033918431203</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_carrierrouting" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>CALL TRAFFIC</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_fobpaycode" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>CC</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_foblocationqualifier" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>ZZ</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_foblocationdescription" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>NA</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_date_010" xsi:type="platformCore:DateCustomFieldRef">
                <platformCore:value>2024-05-12T10:00:00Z</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_date_002" xsi:type="platformCore:DateCustomFieldRef">
                <platformCore:value>2024-05-12T10:00:00Z</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_date_001" xsi:type="platformCore:DateCustomFieldRef">
                <platformCore:value>2024-05-18T10:00:00Z</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_termstype" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>01</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_termsbasisdatecode" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>2</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_termnetduedays" xsi:type="platformCore:LongCustomFieldRef">
                <platformCore:value>30</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_termsdescription" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>ROG 30</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_reference_yd" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>BHILDEB</platformCore:value>
            </platformCore:customField>
            <platformCore:customField scriptId="custbody_sps_routingkey" xsi:type="platformCore:StringCustomFieldRef">
                <platformCore:value>065ALLLOFTEXHO2</platformCore:value>
            </platformCore:customField>
        </tranSales:customFieldList>
    </record>
</sps:NsRecord>
they shared the soap request and now i'm more confused because i can't tell how they're setting the 1st item to sku 1796195
k
The SKU is being set here: 
<tranSales:item internalId="4470">
z
that's the 2nd line item. turns out for the 1st line (the one where 
<tranSales:quantity>7560.0</tranSales:quantity>
) this integrator actually creates a dummy "sps error item" then they have a script which checks against an cross-reference table and updates that line item to a real netsuite item. script runs userEventAfterSubmit, so i'm guessing the createPO field is being unchecked because the sales order record is being edited, not created. weird that on the system information there is no record of any scripts or workflows being ran crying sunglasses. (i only found it from checking the global script execution log because you guys pointed out it looked like there were 2 requests)
i wish this consultant had told me all this in the first place lmfao
20 Views
Open in Slack
PreviousNext
Powered by