-
How to get inventory number Created Date via ODBC query?
Hello, When creating an Inventory numbers saved search, you can add a field "Date Created" to the results tab. This basically is a timestamp for when the inventory number/lot was created. I am having trouble pulling this information through ODBC query and it is crucial to get this information in the dataset. I can't seem…
-
When do On Hand Qty and Available Qty on Items are updated?
When do On Hand Qty and Available Qty on Items -> Inventory Detail subtab -> Inventory Numbers subtab and Purchasing/Inventory subtab-> Location subtab get updated? Inventory Numbers Available Qty: When an Item Fulfillment is created but in Picked/Packed status? Inventory Numbers On Hand Qty: When an Item Fulfillment is…
-
NetSuite Admin Tip: Getting Inventory Number of an Item and its Number Internal ID.
A User would like to know the Inventory Number Internal ID/Inventory Number of a lot/serialized item using SOAP Web Services. The user could create a search via UI and call it on the SOAP request or use the search on the SOAP request with the criteria/filters to get the results. You could see below an example on how to do…
-
See last transaction date on inventory number
I'm trying to do a saved search of the last transaction dates on inventory numbers in a specific bin. I've tried an item search, a inventory/bin search, and a transaction search to no avail. It seems I can't get everything on the same search (inventory number, transaction date, bin). Basically my end goal is to see how…