Department Report (RDE)

The Department Report (RDE) allows you to print information from the Department Maintenance window (which is accessible by clicking GoTo from the Inventory Maintenance window). You can print the Department Report in four different formats, including

• Sales and Purchase Data. You must use this format when running period-end rolls. This format prints the last 25 periods of sales, sales forecast and purchase history.
• No History. This format prints a simple list of your departments (no sales or purchase history prints).
• Purchase Data Only. This format prints a comparison of the purchase history for the current period against one of the older periods or against a year-to-date total. You specify the comparison period it prints. The left-most columns of data on the printed report are the Current Period; the right-most columns are the figures for the comparison period.
• Sales Data Only.  This format prints a comparison of the sales history for the current period against one of the older periods or against a year-to-date total. You specify the comparison period it prints. The left-most columns of data on the printed report are the Current Period; the right-most columns are the figures for the comparison period.

The sales figures that print on the Department Report are updated exclusively by the Daily Inventory Update Report (RDI) with Option F. Back office operations performed in the Open Item Maintenance (MOI) window are not reflected in these figures.

You also use the Department Report to perform the end-of-month "roll" of the department records. It is important that you finalize all receiving for the month before the end-of-month Department Report is run.

Top

Printing the Department Report

1. From the Eagle Browser, click Reports Menu, Inventory Reports, Department Sales/Purchase History (RDE). The Department Report window displays.
2. 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.
3. From the page, review the default entries in the fields and make changes if needed.  For a definition of each field, click here.
4. Click .  A page of fields displays.

• In the Report Format field, select the format you want.
• A: Report Format type A prints each department's sales and purchase history for the last 13 periods. IMPORTANT: Only select A if you are running or queueing end-of-month.
•  N: Report Format type N prints a list of departments including only the department number, Store, Name, and Desired GP % (no sales or purchase history).
• P: Report Format type P prints a comparison of the purchase history for the current period against one of the older periods or against a year-to-date total. You must specify a comparison period. The left-most columns of data on the printed report are the Current Period; the right-most columns are the figures for comparison period. No sales data appears on this report.
• In the Compare Period field, type a period number from 2-13, or a Y for year-to-date, to determine which figures will be compared to the Current Period. This field can only be used when the Report Format is P or S, and is required with either of those formats. The layout of the report is changed from printing sales on the left side and purchases on the right side, to printing the Current Period on the left and the Comparison Period on the right.
•  IMPORTANT: Only fill in the Update Period and Update Year fields if you are running or queueing end-of-month or end-of-year.  
• IMPORTANT: Do not use the Options below the line unless instructed to do so by Epicor Customer Support.

For a definition of each field on the screen, click here.

6. Click .  A page of fields displays.

   • multistore:  In the Store field, enter the appropriate store for which you want to run the report .   
   • (Optional) In the Department fields, select a range of departments to include on the report. To include all departments, leave the Department fields blank.

For a definition of each field, click here.

7. (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.

8. Click Run if you are running this report now, or click Queue if you are adding this report to a queue. For more information about creating queues, click here.