Skip to Content
0
Nov 20, 2013 at 11:03 AM

Inventory Report with Unit Cost, Qty and Value

1170 Views

Hi,

I have entered an A/P Invoice for an item with Qty as 3 pcs and Unit Cost as Rs. 10,000.

In the Inventory Audit Report, it shows the Cumulative Qty as 3 and Cumulative Value as 30,000. But the Cost column is blank. If I expand the black arrow, it shows document wise Cost. But I want to know the Cost per Unit of the Items in Stock. Currently, I have to manually divide Cumulative Value by Cumulative Qty to arrive at the Unit Cost.

Is there any report in SAP B1 which can show the Unit Cost at Item Level, instead of Document Level?

Thanks.