by Pramod Joshi | Jan 21, 2020 | How To
In this blog post, I will try to cover how to build saved search to display bin level information by item where there could be multiple bins at same location for same item. The plan is to find out which bin (that has stock at a particular location) can be considered...
by Pramod Joshi | Sep 4, 2019 | How To
In this blog post, I will cover how to export data from a custom record and why a saved search may not be recommended. We have a custom record type named ‘Item attributes’ and it has more than 200 fields (columns). This is linked to the NetSuite ITEM record and it is...
by Pramod Joshi | Aug 1, 2019 | How To, NetSuite
NetSuite currently provides reports based on ‘negative stock by location’ and it doesn’t include bin even though bin is enabled in company settings as shown below. Currently NetSuite report or view is as shown below, and it doesn’t include bin. As explained above, the...
by Pramod Joshi | May 1, 2019 | How To, NetSuite
Scenario: A company has setup items with bins and expects all inventory related transactions to have valid bin associated with the stock movement. While NetSuite enforces bin for most transactions, some of them are not fully enforced or not enforced at all. In...
by Pramod Joshi | Mar 18, 2019 | How To, NetSuite
This blog post details the process of fetching FIFO cost in NetSuite based on a particular date. Currently NetSuite does not have an option to directly show the FIFO cost for an item (and also bin if required). The saved search below also helps to find out the stock...