Stock Valuation by Batch / Serial

The Stock Valuation report currently allows you to value your stock based on the current cost price or, optionally, on a FIFO basis. This release includes an additional feature, when valuing on a FIFO basis, to use the batch/serial cost price for the stock valuation instead of the FIFO table.

Installation

System Profiles

A new parameter has been added to the Stock System Profiles to enable the system to use the batch/serial cost in preference to the FIFO table. To update the profiles select Installation from the main menu followed by Application Manager and then System Profiles. Select the Stock Control application, parameter screen 1 contains the new parameter.

Use Batch Cost for Stk Valuation Report – if set then instead of using the FIFO table the system will use the cost price from the batch / serial items instead. Note that the option to use FIFO for stock costing must also be set.

Application User Facilities

When printing the Stock Valuation Report the system doesn’t, by default, print the FIFO / Batch breakdown. To enable this option you need to update the report parameters. Right-click against the menu option for the Stock Valuation report within the Stock reports menu and select to Configure Option. Alternatively users can select Installation from the main menu followed by Application Manager and then Application User Facilities. Select the Stock Control application as required before selecting Stock Reports and Stock Valuation.

Report FIFO Values – if set then report will show the FIFO breakdown except where stock items are flagged for batch/serial tracking in which case the batch details will be shown.