Category Gross Profit reports allow users to compare gross profit dollars for a selected GL period with data from twelve previous periods.
Reports are available in summary format for both parent and child profit centers.
When you select Category Gross Profit reports, the system displays the following report criteria screen:
The following selection criteria allow you to specify the period you want to compare on the report and the way the report is viewed.
Enter the ending date for the period you wish to compare. You must make an entry in this field and it must be in mm/dd/yy format. For example:
01/10/99
Note: You do not need to know the exact Period End Date. The system will find the actual End date for any date you enter.
You may specify how you want to view and/or print the report by choosing from the following selections:
· View Report Directly
· Condense Print
· Print Directly to LPN
· Display/Print Selection Page
Category Gross Profit Reports print in landscape format.
The following information is listed on Category Gross Profit reports:
Period End Date
Profit Center
Merch Category
Total
Note: Table MR_SALES is used to determine sales values.
The report columns are as follows:
Period Ending Date
The Period Ending Date columns display the gross profit data for the specified date. The first Period Ending Date is the date entered as selection criteria. Each subsequent Ending date is a prior period.
Thirteen months are displayed on the Category Gross Profit report. The first month is the period selected on the report criteria screen. Prior months are chosen by subtracting one month from the selected Period Ending date, and then subtracting one month from each subsequent Period Ending Date.
The following sections are listed on the report:
Profit Center
The report displays the name and number of the profit center represented by the corresponding report data.
If a profit center has a child profit center, it appears as a hyperlink. Clicking on the hyperlink allows you to view Category Gross Profit reports for child profit centers.
Merchandise Category
The Merchandise Category rows describe the merchandise reported for the corresponding period at the profit center. Sub-categories under the heading are in alphabetical order and represent individual sales categories.
Total values are the sum of the columns for the specified periods at the profit center.
If a profit center has child profit centers, you may click on the parent profit center’s hyperlink on the Category Gross Profit report to view report information for its child profit centers.
The Category Gross Profit child report is based on the same selection criteria you entered for the parent profit center.
Information for child profit centers is calculated in the same manner as it is for parent profit centers. See the Category Gross Profit report section for more information.
You may notice a slight rounding difference between totals on detail and summary reports. Click here to see why.