Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Inventory report - On Hand + on Order
Hi,
I am trying to design a report that gives me all our stock items with their current quantity on hand and include any open POs.
I tried customising the Open PO reports and added the quantity in hand column to it, but then it only shows the items are are currently on order. If I had a stock item with no open orders, they don't come up on the report. The standard "Current Inventory Status" report is not good enough as it doesn't allow a drill down into the "On Order" column.
Anyone got any ideas how I could do this? Thanks in advance....
0