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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
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