As I deal with users from outside of accounting & finance teams, I
heard many complaints around inventory reports. For accounting &
finance people whose main focus may be on the valuation of the inventory
and reconciliation, inventory reports that NetSuite provides out of box
may be well sufficient.
However, people who are in charge of business units that rely on the
inventory throughout multiple locations, they find NetSuite's report not
friendly at all, and I personally find this issue especially for
operations management or hardware repair environments with large
inventory (the specific organization I am referring to held more than
$2MM+ worth of inventory in only one of the warehouses).
Also, one interesting issue is that if you are a long-time NetSuite customer, if you inactivated items that had inventory on hand, then it is almost impossible to reconcile quantity on hands to the inventory valuation report (although I believe NetSuite had filed defect and changed behavior maybe around 2015 or 2016, so that when you inactivate an item, all the inventory information is wiped out, instead of preventing users from inactivating items with inventory on hand - what a great workaround).
I am adding a few SQL formulas you can use on your item saved search, which can help you to generate the report you may need. If you are interested in some more examples, please let me know - I will be more than glad to investigate and share the information with you!
But frankly speaking, NetSuite's SuiteAnalytics came along such a long way that you probably don't need to use SQL but use enhanced search fields such as Inventory Details Fields...
I find this usually helpful, because if the inventory was never touching a location, then the quantity is NULL, not 0, so you can easily exclude items that you will never see at a certain location by using below formula as criteria and results:
Formula (Numeric) > not equal to 0 > Formula: NVL(DECODE({inventorylocation},'location name',NVL({location.quantityonhand},0)), 0)
Also, you can use the formula below to see any item that currently has a PO issued:
Formula (Numeric) > not equal to 0 > Formula: NVL(DECODE({inventorylocation},'location name',NVL({location.quantityonorder},0)), 0)
Of course, you will need to adjust results, and creating the results page may be more painful than it may sound. We will simply have to create each column for each location using Formula (Text) fields.
Formula (Numeric) > not equal to 0 > Formula: NVL(DECODE({inventorylocation},'location name',NVL({location.quantityonhand},0)), 0)
No comments:
Post a Comment