We really need help on an SBO issue.
The question is how to run a simple inventory report that shows the value of the current inventory, using the actual cost. NCS is using FIFO costing, and the cost for the same item might be different in each warehouse. There is an audit report, but it shows every in and out transaction. What's needed is a simple report that shows at least: item, description, warehouse, quantity, cost (or averaged cost if multiple FIFO layers exist), and extended value. Grand total and warehouse subtotals are needed.
Just to clarify, we found reports that can run inventory using a user-maintained PriceList, but none that would use actual cost (which isn't maintained in a PriceList).