David Waldmann
Active Member
   

Live to work, or work to live?
Posts: 1919
Gender:
|
If all you need is units you can use BKICMSTR, BKIC.PROD.UOH. However, you said "value report", so if you need the value you can use BKIC.PROD.AVGC. If you want to subtotal BY location (not just include all locations), you will need to also use MTICMSTR, and group by MTIC.PROD.LOC Regardless of how you make your report, you should be advised that in order to have accurate numbers you will need to refresh the stock status, which can be done when you do a Reorder Report (IN-D); it doesn't need to be actually printed. Two resources that we have found invaluable for determining where what data is are the "FILE NAMES" help page, and the XLS list of tables and fields (recently updated, includes a lot of description) available on the IS Tech Support site.
|