Unable to add items to new Sales Order

[jnichel]

As the title says, I am having no luck adding item(s) to a Sales Order when using the NetSuite PHP API Client created by Ryan Winchester. I posted on Stack (https://stackoverflow.com/questions/75931178/netsuite-php-unable-to-add-items-to-new-sales-order), but have had no bites there. When I get to the items for the SO, I loop thru them as such:

$items = array();
foreach ($order->basketDetails->basketItems as $item) {
    $cartItem = new SalesOrderItem();
    $cartItem->item = $itemResponse->searchResult->recordList->record[0]->internalId;
    $cartItem->quantity = $item->productQuantity;
    $cartItem->rate = "42.97";
    $items[] = $cartItem;
}

Once I have all the items in the array, I add them to a SalesOrderItemList:

$itemList = new SalesOrderItemList();
$itemList->item = $items;

Then I add the item list to the Sales Order ($sale is created earlier in the script with: $sale = new SalesOrder();)

$sale->itemList->item = $itemList;

However, when I try to execute the creation of the Sales Order, I get this error:

[04-Apr-2023 15:11:52 UTC] PHP Fatal error: Uncaught SoapFault exception: [soapenv:Server.userException] org.xml.sax.SAXException: item on {urn:sales_2021_1.transactions.webservices.netsuite.com}SalesOrderItemList must be of type {urn:sales_2021_1.transactions.webservices.netsuite.com}SalesOrderItem in /var/www/composer/vendor/ryanwinchester/netsuite-php/src/NetSuiteClient.php:196

I'm not sure where to go from here as each item is its own SalesOrderItem object. Any help would be greatly appreciated.

[jrebs]

At a glance, it seems like you're building the request correctly, but something's obviously not quite right. My integrations are working fine, presently using 2022_1 web services, so there must be something going on that isn't evidenced by the info you've provided.

If I was debugging this issue myself, the first thing I'd probably be doing is jumping into the code at the point that the request is about to be sent and then dump the entire request object to see exactly what your SalesOrder looks like once all of the compilation is done. The message you're getting suggests that something untoward is happening with the item array.

One other thing that could be worth trying is setting $itemList->replaceAll = true just to see if that makes any difference.

[jnichel]

@jrebs Thank you for the response. Unfortunately, I'm getting the same error. It all looks correct to me, but obviously, I'm doing something wrong. The SalesOrderItemList looks like this right before it is assigned to the SO:

print_r ($itemList);
$sale->itemList->item = $itemList;

NetSuite\Classes\SalesOrderItemList Object
(
    [item] => Array
        (
            [0] => NetSuite\Classes\SalesOrderItem Object
                (
                    [job] => 
                    [subscription] => 
                    [item] => 825
                    [quantityAvailable] => 
                    [expandItemGroup] => 
                    [lineUniqueKey] => 
                    [quantityOnHand] => 
                    [quantity] => 1
                    [units] => 
                    [inventoryDetail] => 
                    [description] => 
                    [price] => 
                    [rate] => 42.97
                    [serialNumbers] => 
                    [amount] => 
                    [isTaxable] => 
                    [commitInventory] => 
                    [orderPriority] => 
                    [licenseCode] => 
                    [options] => 
                    [department] => 
                    [class] => 
                    [location] => 
                    [createPo] => 
                    [createdPo] => 
                    [altSalesAmt] => 
                    [createWo] => 
                    [poVendor] => 
                    [poCurrency] => 
                    [poRate] => 
                    [revRecSchedule] => 
                    [revRecStartDate] => 
                    [revRecTermInMonths] => 
                    [revRecEndDate] => 
                    [deferRevRec] => 
                    [isClosed] => 
                    [itemFulfillmentChoice] => 
                    [catchUpPeriod] => 
                    [billingSchedule] => 
                    [fromJob] => 
                    [grossAmt] => 
                    [taxAmount] => 
                    [excludeFromRateRequest] => 
                    [isEstimate] => 
                    [inventoryLocation] => 
                    [inventorySubsidiary] => 
                    [line] => 
                    [percentComplete] => 
                    [costEstimateType] => 
                    [costEstimate] => 
                    [quantityBackOrdered] => 
                    [quantityBilled] => 
                    [quantityCommitted] => 
                    [quantityFulfilled] => 
                    [quantityPacked] => 
                    [quantityPicked] => 
                    [tax1Amt] => 
                    [taxCode] => 
                    [taxRate1] => 
                    [taxRate2] => 
                    [giftCertFrom] => 
                    [giftCertRecipientName] => 
                    [giftCertRecipientEmail] => 
                    [giftCertMessage] => 
                    [giftCertNumber] => 
                    [shipGroup] => 
                    [itemIsFulfilled] => 
                    [shipAddress] => 
                    [shipMethod] => 
                    [vsoeSopGroup] => 
                    [vsoeIsEstimate] => 
                    [vsoePrice] => 
                    [vsoeAmount] => 
                    [vsoeAllocation] => 
                    [vsoeDeferral] => 
                    [vsoePermitDiscount] => 
                    [vsoeDelivered] => 
                    [expectedShipDate] => 
                    [noAutoAssignLocation] => 
                    [locationAutoAssigned] => 
                    [taxDetailsReference] => 
                    [chargeType] => 
                    [orderAllocationStrategy] => 
                    [requestedDate] => 
                    [customFieldList] => 
                )

        )

    [replaceAll] => 1
)

And the SalesOrder object looks like this:

NetSuite\Classes\SalesOrder Object
(
    [createdDate] => 
    [customForm] => 
    [entity] => NetSuite\Classes\RecordRef Object
        (
            [internalId] => 41343073
            [externalId] => 
            [type] => customer
            [name] => 
        )

    [job] => 
    [currency] => 
    [drAccount] => 
    [fxAccount] => 
    [tranDate] => 2023-03-21T20:39:32+00:00
    [tranId] => 
    [entityTaxRegNum] => 
    [source] => 
    [createdFrom] => 
    [orderStatus] => 
    [nextBill] => 
    [opportunity] => 
    [salesRep] => 
    [contribPct] => 
    [partner] => 
    [salesGroup] => 
    [syncSalesTeams] => 
    [leadSource] => 
    [startDate] => 
    [endDate] => 
    [otherRefNum] => 
    [memo] => 
    [salesEffectiveDate] => 
    [excludeCommission] => 
    [totalCostEstimate] => 
    [estGrossProfit] => 
    [estGrossProfitPercent] => 
    [exchangeRate] => 
    [promoCode] => 
    [currencyName] => 
    [discountItem] => 
    [discountRate] => 
    [isTaxable] => 
    [taxItem] => 
    [taxRate] => 
    [toBePrinted] => 
    [toBeEmailed] => 
    [email] => 
    [toBeFaxed] => 
    [fax] => 
    [messageSel] => 
    [message] => 
    [paymentOption] => 
    [inputAuthCode] => 
    [inputReferenceCode] => 
    [checkNumber] => 
    [paymentCardCsc] => 
    [paymentProcessingProfile] => 
    [handlingMode] => 
    [outputAuthCode] => 
    [outputReferenceCode] => 
    [paymentOperation] => 
    [dynamicDescriptor] => 
    [billingAddress] => 
    [billAddressList] => 
    [shippingAddress] => 
    [shipIsResidential] => 
    [shipAddressList] => 
    [fob] => 
    [shipDate] => 
    [actualShipDate] => 
    [shipMethod] => NetSuite\Classes\RecordRef Object
        (
            [internalId] => 4328
            [externalId] => 
            [type] => 
            [name] => 
        )

    [shippingCost] => 8.98
    [shippingTax1Rate] => 
    [isMultiShipTo] => 
    [shippingTax2Rate] => 
    [shippingTaxCode] => 
    [handlingTaxCode] => 
    [handlingTax1Rate] => 
    [handlingTax2Rate] => 
    [handlingCost] => 
    [trackingNumbers] => 
    [linkedTrackingNumbers] => 
    [shipComplete] => 
    [paymentMethod] => 
    [shopperIpAddress] => 
    [saveOnAuthDecline] => 
    [canHaveStackable] => 
    [creditCard] => 
    [revenueStatus] => 
    [recognizedRevenue] => 
    [deferredRevenue] => 
    [revRecOnRevCommitment] => 
    [revCommitStatus] => 
    [ccNumber] => 
    [ccExpireDate] => 
    [ccName] => 
    [ccStreet] => 
    [ccZipCode] => 
    [payPalStatus] => 
    [creditCardProcessor] => 
    [payPalTranId] => 
    [ccApproved] => 
    [getAuth] => 
    [authCode] => 
    [ccAvsStreetMatch] => 
    [ccAvsZipMatch] => 
    [isRecurringPayment] => 
    [ccSecurityCodeMatch] => 
    [altSalesTotal] => 
    [ignoreAvs] => 
    [paymentEventResult] => 
    [paymentEventHoldReason] => 
    [paymentEventType] => 
    [paymentEventDate] => 
    [paymentEventUpdatedBy] => 
    [subTotal] => 
    [discountTotal] => 
    [taxTotal] => 
    [altShippingCost] => 
    [altHandlingCost] => 
    [total] => 
    [revRecSchedule] => 
    [revRecStartDate] => 
    [revRecEndDate] => 
    [paypalAuthId] => 
    [balance] => 
    [paypalProcess] => 
    [billingSchedule] => 
    [ccSecurityCode] => 
    [threeDStatusCode] => 
    [class] => 
    [department] => 
    [subsidiary] => 
    [intercoTransaction] => 
    [intercoStatus] => 
    [debitCardIssueNo] => 
    [lastModifiedDate] => 
    [nexus] => 
    [subsidiaryTaxRegNum] => 
    [taxRegOverride] => 
    [taxPointDate] => 
    [taxDetailsOverride] => 
    [location] => 
    [pnRefNum] => 
    [status] => 
    [tax2Total] => 
    [terms] => 
    [validFrom] => 
    [vatRegNum] => 
    [giftCertApplied] => 
    [oneTime] => 
    [recurWeekly] => 
    [recurMonthly] => 
    [recurQuarterly] => 
    [recurAnnually] => 
    [tranIsVsoeBundle] => 
    [vsoeAutoCalc] => 
    [syncPartnerTeams] => 
    [salesTeamList] => 
    [partnersList] => 
    [giftCertRedemptionList] => 
    [promotionsList] => 
    [itemList] => stdClass Object
        (
            [item] => NetSuite\Classes\SalesOrderItemList Object
                (
                    [item] => Array
                        (
                            [0] => NetSuite\Classes\SalesOrderItem Object
                                (
                                    [job] => 
                                    [subscription] => 
                                    [item] => 825
                                    [quantityAvailable] => 
                                    [expandItemGroup] => 
                                    [lineUniqueKey] => 
                                    [quantityOnHand] => 
                                    [quantity] => 1
                                    [units] => 
                                    [inventoryDetail] => 
                                    [description] => 
                                    [price] => 
                                    [rate] => 42.97
                                    [serialNumbers] => 
                                    [amount] => 
                                    [isTaxable] => 
                                    [commitInventory] => 
                                    [orderPriority] => 
                                    [licenseCode] => 
                                    [options] => 
                                    [department] => 
                                    [class] => 
                                    [location] => 
                                    [createPo] => 
                                    [createdPo] => 
                                    [altSalesAmt] => 
                                    [createWo] => 
                                    [poVendor] => 
                                    [poCurrency] => 
                                    [poRate] => 
                                    [revRecSchedule] => 
                                    [revRecStartDate] => 
                                    [revRecTermInMonths] => 
                                    [revRecEndDate] => 
                                    [deferRevRec] => 
                                    [isClosed] => 
                                    [itemFulfillmentChoice] => 
                                    [catchUpPeriod] => 
                                    [billingSchedule] => 
                                    [fromJob] => 
                                    [grossAmt] => 
                                    [taxAmount] => 
                                    [excludeFromRateRequest] => 
                                    [isEstimate] => 
                                    [inventoryLocation] => 
                                    [inventorySubsidiary] => 
                                    [line] => 
                                    [percentComplete] => 
                                    [costEstimateType] => 
                                    [costEstimate] => 
                                    [quantityBackOrdered] => 
                                    [quantityBilled] => 
                                    [quantityCommitted] => 
                                    [quantityFulfilled] => 
                                    [quantityPacked] => 
                                    [quantityPicked] => 
                                    [tax1Amt] => 
                                    [taxCode] => 
                                    [taxRate1] => 
                                    [taxRate2] => 
                                    [giftCertFrom] => 
                                    [giftCertRecipientName] => 
                                    [giftCertRecipientEmail] => 
                                    [giftCertMessage] => 
                                    [giftCertNumber] => 
                                    [shipGroup] => 
                                    [itemIsFulfilled] => 
                                    [shipAddress] => 
                                    [shipMethod] => 
                                    [vsoeSopGroup] => 
                                    [vsoeIsEstimate] => 
                                    [vsoePrice] => 
                                    [vsoeAmount] => 
                                    [vsoeAllocation] => 
                                    [vsoeDeferral] => 
                                    [vsoePermitDiscount] => 
                                    [vsoeDelivered] => 
                                    [expectedShipDate] => 
                                    [noAutoAssignLocation] => 
                                    [locationAutoAssigned] => 
                                    [taxDetailsReference] => 
                                    [chargeType] => 
                                    [orderAllocationStrategy] => 
                                    [requestedDate] => 
                                    [customFieldList] => 
                                )

                        )

                    [replaceAll] => 1
                )

        )

    [shipGroupList] => 
    [accountingBookDetailList] => 
    [taxDetailsList] => 
    [customFieldList] => 
    [internalId] => 
    [externalId] => 
    [nullFieldList] => 
    [otherrefnum] => E4X001001129560
)

[jrebs]

Looks like you've nested the item list in your sales order incorrectly. The property SalesOrder::itemList should be of the type SalesOrderItemList. In your dump, it is a stdClass object containing an item list as its item property.

[jnichel]

@jrebs Thank you. Changing "$sale->itemList->item = $itemList;" to "$sale->itemList = $itemList;" and realizing that $cartItem->item was supposed to be a RecordRef and not the internal ID alone, I was able to get this working.