Report 116

Sage 200 Reports: Stock Control

Report 116   Price £POA

Aged Stock Balances – 7 columns – Custom

Description

This ‘must have’ report allows you to monitor your stock levels and valuation by aged columns to quickly identify the slower moving items and if your money is tied up in stock that has not moved off the shelf for many months or years.

Each user will have different break points for the reported columns so the first five columns can be fixed by pre-set criteria and the sixth column can be set at run time so as to mark the start point (in days) for the final seventh column.

With this ‘moveable’ break point for column 7 the items captured in this column can be easily noted to have been in stock for at least the number of days entered.

Note: this report has the criteria for the warehouse fully functional – The standard Sage 200 Stock Valuation report only allows for the warehouse to be set as ALL or IS

This report has been formatted to ensure that when exported to Excel it is immediately available to be analysed further without the need to manipulate the output.

Criteria

Stock

Product Group

Warehouse

Bin

Search Values 1,2 and 3

Column 6 (Default = 210)

The pre-set columns are; 60, 90, 120, 150 and 180

Print report

View sample report

Excel report

View sample report

Designed to output to

Printer (& PDF) – Y    

Excel – Y    

CSV – N

To purchase this report please contact your Sage 200 Business Partner or email info@rich-reports.co.uk to send in your inquiry or purchase order.