Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) Stock on hand

Stock on hand

(0) Share

Report

Posted on by Community Member

Hi,

I'm wondering how I can add a 'stock on hand' column for items when they are generated in a detailed sales report. This would be really useful when using data in PivotTables in Excel so we can compare stock levels to how many are being sold over a period of time, thus adjust our ordering appropriately.

Any help with this would be great!

Thanks

EDIT //

I am aware you can add the "On Hand" column to the generated sales report but this doesn't seem to copy over in the tables to Excel...

*This post is locked for comments