539 Stock Valuation Lists

Purpose & Benefits
Use this function to report on Stock levels and values using an international standard reporting tool. The report can be run with the FIFO report template to give you a FIFO ( First-In First-Out) or ‘actual cost’ valuation for your stock.

If you have the Trade option enabled, you can select All , a Single or a Range of Warehouse Codes to include in the report.

Filters

Decide which filters you want to apply to your report.

#	Filter Field	Options	Remarks/Notes
1	Cost Price Type	Average, Last or Standard
2	Product Code	All, Range or Single	If you select Single or Range, complete the From and To fields as required
3	Product Group	All, Range or Single	Product Group code. If you select Single or Range, complete the From and To fields as required
4	Warehouse Code	All, Range or Single	Only if the Trade option is enabled; if you select Single or Range, complete the From and To fields as required
5	Include Discontinued Products	Yes or No	The default is to include products which are flagged as discontinued in TAS, but you may wish to exclude them.
6	Include Zero Qty’s In Stock	Yes or No	By default you would not want to include products at any location where they have zero quantities in Stock. However, you can opt to include products which have zero quantities as a result of net movements or of having been set up, but without any movements. Remember, TAS overall may show zero quantity for a product but with the Trade option enabled, this could be because there is, for example, +10 in one location and -10 in another.

Report Options

Decide which Report Options you want to apply to your report.

#	Option	Options	Remarks/Notes
1	Preview	Yes or No	Whether or not you wish to see a preview of the report on screen before sending it to its destination.
2	Template	As Setup	The default report template appears, but you can change that. Remember that there is a standard FIFO Stock Valuation report, which can give you more accurate valuations where you have items in stock which arrived at different cost prices.
3	Report Title	As Setup	As set up for the selected template, but you can change to suit
4	Send To	None, Printer, File, Application, Email	The destination of the report. If you select File, Application or Email, a further set of options appears, as described in the next option(s)
5	Format	Character, CSV, Excel, HTML, PDF, Rich Text, Text, Word or XML	Select one of these File and Application formats.
6	Path		This defaults to the current TAS company’s data folder.
7	Use report date format	Yes or No	Uncheck if you want to use your Windows set up for dates
8	Use report number format	Yes or No	Uncheck if you want to use your Windows set up for numbers

You can select which Report Template to use from the drop-down menu; remember you can add one or more extra templates using the Document Templates function in the Central > Central Information menu. Having completed your selections, simply click the Process button to run the report.

The report is displayed for you to preview.