Hi after opening the [Sales Order] detail in NetSuite, I can click on the "Related Records" tab to see the related transaction records, but how does this internally correlate [SalesOrder] to [Item Fulfillment], [Sales Order] to [Invoice]?
I used SuiteQL to check the json data for [Purchase Order][Shipping][Invoice] which shows correlations in the related records, but I cannot see any unique keys, and I would like to know how this application is checking for correlation between them.
I would like to add something here.
The three slips below are [Sales Order], [Item Fulfillment], and [Invoice] generated by the same order transaction.
<Sales Order>
[
{
"links": [],
"abbrevtype": "salesorder",
"actualshipdate": "2022/08/08",
"balsegstatus": "5",
"billingaddress": "293554",
"billingstatus": "F",
"closedate": "2022/08/08",
"createdby": "919",
"createddate": "2022/08/08",
"currency": "1",
"custbody_15699_exclude_from_ep_process": "F",
"custbody_4392_includeids": "F",
"custbody_atlas_help_trans_lp_ref": "4",
"custbody_fb_auto_fulfillment": "T",
"custbody_fb_auto_location_body": "F",
"custbody_fb_cus_comment": "comment",
"custbody_fb_disp_price": "T",
"custbody_fb_itemdata_storage": "[{\"itemId\":\"8185\",\"itemName\":\"1661NV1M\",\"lotNumber\":\"210913\",\"expirationDate\":\"20220408\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"8161\",\"itemName\":\"1671NV1M\",\"lotNumber\":\"210913\",\"expirationDate\":\"20220408\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7693\",\"itemName\":\"6011WM1M\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7658\",\"itemName\":\"6021PK1L\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7660\",\"itemName\":\"6021MI1L\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7652\",\"itemName\":\"6021PK1S\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7601\",\"itemName\":\"6041WHLL\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"2.0\",\"locationId\":\"109\"},{\"itemId\":\"7524\",\"itemName\":\"6081NV1M\",\"lotNumber\":\"000000\",\"expirationDate\":\"20220214\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7521\",\"itemName\":\"6081WH1S\",\"lotNumber\":\"000000\",\"expirationDate\":\"20220331\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7453\",\"itemName\":\"6091PK1L\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"7447\",\"itemName\":\"6091PK1M\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"17738\",\"itemName\":\"6481P81F\",\"lotNumber\":\"211206\",\"expirationDate\":\"20220310\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"8122\",\"itemName\":\"9521NVXL\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"17389\",\"itemName\":\"9521DG1M\",\"lotNumber\":\"220114\",\"expirationDate\":\"20220408\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"8107\",\"itemName\":\"9521NV1S\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"17385\",\"itemName\":\"9521CC1L\",\"lotNumber\":\"210913\",\"expirationDate\":\"20220218\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"8091\",\"itemName\":\"9531NVXL\",\"lotNumber\":\"210913\",\"expirationDate\":\"20220408\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"17399\",\"itemName\":\"9531DG1M\",\"lotNumber\":\"220426\",\"expirationDate\":\"20220720\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"8076\",\"itemName\":\"9531NV1S\",\"lotNumber\":\"000000\",\"expirationDate\":\"\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"},{\"itemId\":\"17395\",\"itemName\":\"9531CC1L\",\"lotNumber\":\"210913\",\"expirationDate\":\"20220218\",\"inventoryQuantity\":\"1.0\",\"locationId\":\"109\"}]",
"custbody_fb_itemid_storage": "[\"8185210913109\",\"8161210913109\",\"7693000000109\",\"7658000000109\",\"7660000000109\",\"7652000000109\",\"7601000000109\",\"7524000000109\",\"7521000000109\",\"7453000000109\",\"7447000000109\",\"17738211206109\",\"8122000000109\",\"17389220114109\",\"8107000000109\",\"17385210913109\",\"8091210913109\",\"17399220426109\",\"8076000000109\",\"17395210913109\"]",
"custbody_fb_lend_sample": "F",
"custbody_fb_paid_order": "F",
"custbody_fb_shipping_slip_no": "350004178495",
"custbody_report_timestamp": "7/8/2022 17:46:32",
"custbody_sii_article_61d": "F",
"custbody_sii_article_72_73": "F",
"custbody_sii_is_third_party": "F",
"custbody_sii_not_reported_in_time": "F",
"daysopen": "0",
"entity": "2573",
"estgrossprofit": "64299",
"estgrossprofitpercent": "0.6053094845846081",
"exchangerate": "1",
"foreigntotal": "116840",
"id": "1199189",
"includeinforecast": "F",
"isfinchrg": "F",
"isreversal": "F",
"lastmodifiedby": "-4",
"lastmodifieddate": "2022/08/08",
"nexus": "1",
"number": "603257",
"ordpicked": "T",
"otherrefnum": "000050045(8/8 ordered)",
"paymenthold": "F",
"posting": "F",
"postingperiod": "183",
"printedpickingticket": "F",
"recordtype": "salesorder",
"shipcomplete": "F",
"shipdate": "2022/08/08",
"shippingaddress": "293554",
"status": "G",
"totalcostestimate": "41926",
"trandate": "2022/08/08",
"trandisplayname": "salesorder #sp_603257",
"tranid": "sp_603257",
"transactionnumber": "SALESORD0041537",
"type": "SalesOrd",
"typebaseddocumentnumber": "sp_603257",
"userevenuearrangement": "F",
"visibletocustomer": "T",
"void": "F",
"voided": "F"
}
]
<Item Fulfillment>
[
{
"links": [],
"abbrevtype": "Itemfulfillment",
"balsegstatus": "5",
"billingaddress": "293554",
"billingstatus": "F",
"createdby": "919",
"createddate": "2022/08/08",
"currency": "1",
"custbody_atlas_help_trans_lp_ref": "4",
"custbody_fb_auto_fulfillment": "T",
"custbody_fb_disp_price": "T",
"custbody_fb_lend_sample": "F",
"entity": "2573",
"exchangerate": "1",
"id": "1199190",
"includeinforecast": "F",
"isfinchrg": "F",
"isreversal": "F",
"lastmodifiedby": "512",
"lastmodifieddate": "2022/08/08",
"nexus": "1",
"number": "44764",
"ordpicked": "F",
"paymenthold": "F",
"posting": "T",
"postingperiod": "183",
"printedpickingticket": "F",
"recordtype": "itemfulfillment",
"shippingaddress": "293554",
"status": "C",
"trandate": "2022/08/08",
"trandisplayname": "Itemfullfilment #0044764",
"tranid": "0044764",
"transactionnumber": "0044764",
"type": "ItemShip",
"typebaseddocumentnumber": "0044764",
"userevenuearrangement": "F",
"visibletocustomer": "T",
"void": "F",
"voided": "F"
}
]
<Invoice>
[
{
"links": [],
"abbrevtype": "invoice",
"balsegstatus": "5",
"billingaddress": "293554",
"billingstatus": "T",
"createdby": "-4",
"createddate": "2022/08/08",
"currency": "1",
"custbody_15699_exclude_from_ep_process": "F",
"custbody_4392_includeids": "F",
"custbody_atlas_help_trans_lp_ref": "4",
"custbody_fb_auto_fulfillment": "T",
"custbody_fb_cus_comment": "comment",
"custbody_fb_disp_price": "T",
"custbody_fb_lend_sample": "F",
"custbody_fb_paid_order": "F",
"custbody_fb_shipping_slip_no": "350004178495",
"custbody_report_timestamp": "7/8/2022 17:46:32",
"custbody_sii_article_61d": "F",
"custbody_sii_article_72_73": "F",
"custbody_sii_is_third_party": "F",
"custbody_sii_not_reported_in_time": "F",
"daysopen": "0",
"entity": "2573",
"estgrossprofit": "64299",
"estgrossprofitpercent": "0.6053094845846081",
"exchangerate": "1",
"foreignamountpaid": "0",
"foreignamountunpaid": "116840",
"foreigntotal": "116840",
"id": "1202696",
"includeinforecast": "F",
"isfinchrg": "F",
"isreversal": "F",
"lastmodifiedby": "-4",
"lastmodifieddate": "2022/08/08",
"nexus": "1",
"number": "39025",
"ordpicked": "F",
"otherrefnum": "000050045(8/8)",
"paymenthold": "F",
"posting": "T",
"postingperiod": "183",
"printedpickingticket": "F",
"recordtype": "invoice",
"shipcomplete": "F",
"shipdate": "2022/08/08",
"shippingaddress": "293554",
"status": "A",
"totalcostestimate": "41926",
"trandate": "2022/08/08",
"trandisplayname": "請求書 #請求0039025",
"tranid": "請求0039025",
"transactionnumber": "CUSTINVC39025",
"type": "CustInvc",
"typebaseddocumentnumber": "請求0039025",
"userevenuearrangement": "F",
"visibletocustomer": "T",
"void": "F",
"voided": "F"
}
]
*The above data was obtained using SuiteQL to get the details from the ObjectID of each slip.
However, I cannot see any identifier in the above data to make them "the same" order transaction, and would like to know if there is a key that relates them.
Also, if there is a key, I would appreciate specific instructions on how to obtain its value.
Thank you in advance.