Access Hospitality - Ideas Portal

Help us shape the future of our products by submitting your own ideas and reviewing ideas submitted by other users. If you see an idea you like, feel free to vote it up and add any comments that you feel would be beneficial.
This is a collaborative community, so please join in, contribute your innovative ideas and help our product teams to shape their roadmaps and future product development.

Our teams will review the ideas which have received the most votes on a regular basis, meaning that not all ideas will receive updates. When an idea has received enough votes, the status will be updated to 'Under Review' and then a decision made.

Aged Stock Report

EPOS Retail - Aged Stock Report specification

Data filters

The report should have the same filters as the “Stock Valuation Report”.

User should just be able to select a “report date”, which will be the driver to the data selection (it should not filter by a data range)

Data selection

Report should only show items that are in stock : Stock Quantity > 0
For each product the system should select the “last delivery date”
For each product should select the “last sale”, regardless of date

Data display

Report title

“Aged Stock Report”
Date user has selected
Location user has selected

Data items (columns):

Product Category
Product Number
Product description
Product Unit
Total stock quantity of item as of date selected by user
Cost as per user selection in report filter
Last Date of receipt (last delivery)
Last Quantity received
Date of last sale
Inventory Age (Days) = [Report date selected - Last Date of receipt (last delivery)]

Attach files

Enter a subject