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.