This guide is to print out the Inventory Valuation which will show the stock on hand as at the date that you require.
• Warehousing > Inventory Costing > Perform Inventory Evaluation > Fill in the needed details at selection range tab and options tab (if needed) > Click Perform
• There are 2 options of the report view. May tick the flat file format for 1st option and untick for 2nd option. (specific date: as per your requirement).
• Note: Options tab may filter as you wish. Try out the different Options in the Options tab until you get what you are looking for.
• Note: You can leave Item Valuation Group, Enterprise Unit and Warehouse Valuation Group as the default. (blank to ZZZZZZ)
• To extract to Excel for the 1st Option, after clicking on Perform, type in EXCEL in the Device field, and it will download as an Excel file.
• 1st option output, with Flat File Format ticked.
• 2nd Option output, with Flat File Format unticked.