Store Expenses Reports

Store Expenses reports allow users to view store expense data for profit centers during a particular date range. 

Reports are available in summary and detail formats for both parent and child profit centers.

When you select Store Expenses reports, the system displays the following report criteria screen:

The following selection criteria allow you to specify the date range to report and the way the report is viewed.

Beginning Date

Enter the starting date for which you want to view expense information.  You must make an entry in this field and it must be in mm/dd/yy format.  For example:

01/10/99

Ending Date

Enter the ending date for which you want to view expense information.  You must make an entry in this field and the date must be greater than the Beginning Date.  Use the mm/dd/yy format.  For example:

01/10/99

Note:  If the Ending Date is not greater than the Beginning Date, or if the Beginning and Ending dates are not within the same GL period, the system will display an error message.

View/Print Selections

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

Store Expenses Summary Reports

The following information is listed on Store Expenses Summary reports:

• Profit Center

• Total Cash Expense

• Total Charge Expense

• Total Expense Amount

Note:  Table CASHEXP is used to retrieve expenses paid by cash data.  CHGEXP is used to retrieve expenses charged to A/P data.

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 summary information for child profit centers. 

Total Cash Expense

The Total Cash Expense section displays the total cash expense amount for the specified date range at the profit center. 

Total Charge Expense

The Total Charge Expense section displays the total charge expense amount for the specified date range at the profit center.

Total Expense Amount

The Total Expense Amount column values are calculated by using the following formula:

X + Y

X = the Total Cash Expense value.

Y = the Total Charge Expense value.

Store Expense Detail Reports

The Store Expense Detail report displays expense information for each day of the selected date range. 

The following information is listed on Store Expense Detail reports:

• Vendor Name

• Item Code

• Item Description

• Store

• Selling Price

• Book Price

• Difference

Columns

The report columns are as follows:

Date

The report displays a row for every date in the specified date range.

Description

The Description field defines the store expense for the date.  The column displays up to twenty (20) characters.

Invoice Number

The report lists the invoice number for the expense on the date specified.  The column displays up to ten (10) digits.

Supplier

The Supplier field displays either “Cash” for cash expenses or the name of the vendor associated with the expense charged to A/P.  The column displays up to twenty (20) characters.

Invoice Date

The report displays the invoice date associated with each invoice number.

Invoice Amount

The Invoice Amount field displays the amount of the invoice being reported for the date.

Sections Listed On The Report

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 summary information for child profit centers. 

Store Expenses Child Reports

Child Summary Reports

If a profit center has child profit centers, you may click on the parent profit center’s hyperlink to view summary report information for its child profit centers.

The Store Expenses Child Summary report is based on the same selection criteria you entered for the parent profit center.

Profit centers on Store Expenses child Summary reports are in numeric order.  Expenses for the specified date range are depicted in the same manner as they are for parent profit centers.  See the Store Expenses Summary report section for more information. 

Child Detail Reports

Click on the child profit center’s hyperlink to view a Store Expenses Child Detail report. 

Detail information for child profit centers is calculated in the same manner as it is for parent profit centers. See the Store Expenses Detail report section for more information. 

Note:

You may notice a slight rounding difference between totals on detail and summary reports. Click here to see why.