Inventory Cost of specific serial number in QQube | CLEARIFY - Page 1

I wanted to verify that Q-Qube would be able to create a report showing the actual cost of a serialized item (not average).

Item 202 - Serial # 1 cost 12,000

Item 202 - Serial #2 cost 3,000

Item 202 - Serial #3 cost 10,000

So I would be able to run a report showing

Serial # 1 cost 12,000 but sold for 25,000

Serial #2 cost 3,000 but sold for 4,500

You absolutely could do that in QQube and there is an example in the QQube Configuration Tool for Excel, Excel Power Pivot - and Power BI.

They a variety of calculations, including first purchase date, last purchase date, sales for particular periods (quantity and dollars), on hand. You just need to bring in the lot number field tao the sample to make that work.