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.
Article ID: 24
Created On: Fri, Jun 8, 2012 at 11:25 AM
Last Updated On: Thu, Jun 22, 2023 at 11:39 PM
Online URL: https://kb.datafile.co.uk/article/stock-valuation-by-batch-serial-24.html