The Inventory Update Report (RIU) does the end-of-month processing on every inventory item (SKU). It moves the field for "units sold" from this month to last month, the units sold from last month to the month before that, and so on. It also provides an accurate count of inventory records by department. This report is run at the end of each period so that the new period will start accumulating data in the current period field.
Note: POS updates the current month field immediately as transactions are processed. It is critical that this report finish its processing before any sales activity occurs in the new period.
The end-of-period dates are set up in the Date Table (MDT). The RIU report prints only the figures for the oldest history periods because these are deleted from the system. Therefore, when you have been using the system for a year (and have data in these fields), you should save this report for reference.
Note: This report should be run as part of your end-of-month queue.
From the Eagle Browser, click Reports Menu, Inventory Reports, Inventory Update Report (RIU). The Inventory Update Report window displays.
If you have set up a Default Report Profile for this report, you can simply click Run to use the defaults. Or, you can retrieve a saved report, make any necessary changes, and click Run. Otherwise, continue with the next step.
From the Print Setup page:
If you are entering this report in an end-of-month or end-of-year queue, then in the Print To field, choose either A (to print and spool), or S (to spool only). In the Channel Number field, use the same channel as the other reports in the queue. In the Totals Only field, select Y.
Review the default entries in the other fields and make changes if needed. For a definition of each field, click here.
Click .
A page of fields displays.
In the Update Per/Yr field, enter 99/99 so the system will automatically calculate the update period/year when the report is run.
Review the default entries in the other fields and make changes if needed. For a definition of each field, click here.
(Optional)
Click .
A page of fields displays. Fill in the fields if you want to fax the
report.
For a definition of each field, click here.
Click Run if you are running this report now, or click
if you are adding this report to a queue. For more information
about creating queues, click here.