IT Help Desk

1. Open SQL and use the following query in IvyNetSuite-NET

SELECT * FROM OPENQUERY([NETSUITE],'

SELECT

TransactionStatus.Name AS Status,

BUILTIN.DF(transaction.custbody_nb2_sales_order_status) AS OrderStatus,

Transaction.TranID AS SoNumber,

CUSTOMRECORD_NB2_DELIVERY_LOAD.Name AS LoadNumber,

CUSTOMRECORD_NB2_DELIVERY_LOAD.CustRecord_NB2_Load_Delivery_Date AS LoadDeliveryDate

FROM

Transaction

LEFT JOIN

CUSTOMRECORD_NB2_DELIVERY_LOAD ON Transaction.ID = CUSTOMRECORD_NB2_DELIVERY_LOAD.CustRecord_NB2_Sales_Order

INNER JOIN 

TransactionStatus ON Transaction.Type = TransactionStatus.TranType AND Transaction.Status = TransactionStatus.ID

WHERE 

Transaction.Type=''SalesOrd''

AND CUSTOMRECORD_NB2_DELIVERY_LOAD.Name=''SLC160425''

AND TO_CHAR(CUSTOMRECORD_NB2_DELIVERY_LOAD.CustRecord_NB2_Load_Delivery_Date,''YYYY-MM-DD'') = ''2025-04-16''

');

2. Change Load name in Line 16 to match the Load Number and change the date to be the delivery date of the Load. (AUTO and STORE will display the delivery date, and third pary orders will have the date in the load number) and then press Execute.

If the error is AUTOXX or STOREXX with a - P or - B, just take the first part of the load number.

3. Check the Order Status for each line. 

90% of the time the order will be Loaded so can ignore. You only need to action this further if the status is With Picking or Planned. You can clear the error (mark as read) if they are loaded or cancelled.