RE:[sap-log-mm] Day by Day Consumption for a Group of Materials

Posted by Sap Land Tuesday, 27 September 2011 10:19

Posted by Vlad_Nistor
on Sep 27 at 1:19 PM

Hello,
Thanks a lot. I will try this as soon as possible. Maybe I'll find also a method to export the results into an Excel file. I would need them in Excel format to be able to calculate the standard deviations of consumption for a specific period.

Thanks again.

---------------Original Message---------------
From: ChrisO
Sent: Monday, September 26, 2011 4:52 AM
Subject: Day by Day Consumption for a Group of Materials

If you're already using MCBE, try the following. Run the report for the period and materials selected. Then in the main menu go to "'Extras' > 'Detailed info' > 'Issues diagram' > 'Stock qty". This gives a bar graph of daily issues for the period selected. If you want to see stock balance as a result of both issues and receipts, chose "'Extras' > 'Detailed info' > 'Stock level' > 'Stock qty".

I don't think that this data can be extracted as a table of numbers but if you're just using the info to make stock holding decisions this is probably going to be of use, as it is for us.

Hope this helps
ChrisO

__.____._