Why does the uI have a bin location, but when I query the Bin Record it gives null

AI generated answer (using internal Slack threads):

The issue you're experiencing, where the UI shows a bin location but querying the Bin Record returns null, could be due to the use of Advanced Bins in your NetSuite instance. Advanced Bins are a feature in NetSuite that provides more detailed tracking and management of inventory stored in bins. When using Advanced Bins, the bin number is not directly stored on the transaction line but is instead stored in an

inventorydetail

subrecord. This subrecord is associated with the transaction line and contains the bin number in the

tobinnumber

field. If you're trying to access the bin number from a transaction saved search, you might need to include the

inventorydetail

subrecord in your search criteria or results. For example, you could use a formula like

{inventorydetail.inventorynumber}

in your search criteria. If you're trying to access the bin number from a script, you would need to load the

inventorydetail

subrecord from the transaction line and then access the

tobinnumber

field. Here's a sample code snippet that demonstrates this:

javascript
var inventoryDetail = transactionLine.getSubrecord('inventorydetail');
var binNumber = inventoryDetail.getValue('tobinnumber');

Please note that this is a general guidance and the actual implementation might vary based on your specific use case and NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******