View Cost Analysis Report (RPCSTA) page

Use the Cost Analysis Report page as an analysis tool which reflects invoiced sales from shippers.

• Miscellaneous invoices and credit memos are not included in total sales.

• This report is not designed to be a reconciling tool.

  If items are make, costs are estimated from the job. If items are stock, costs are based on the invent- ory costing method from the item master. Invoices from sales orders may include items that are not shipped; all invoices from sales orders will pull costs from the Sales Order Price Summary.

  By default, generic filters are available to generate this report. You can use Advanced Filters to cus- tomize or expand your filter criteria. For more information on Advanced Filters, click here.

To generate Cost Analysis Report

1. Open the Cost Analysis Report (RPCSTA) page.

Select Financial Management > Financial Reports > Order Costing >

Cost Analysis Report.

Or

1. Search for RPCSTA in the Navigation box and then select Cost Analysis Report.

   Cost Analysis Report (RPCSTA) page appears.

2. In the Selection list, select the information you want to view.

3. In the Sort Order list, select how to sort the report.

   The Sort Order list is populated based on the type of report selected in the

   Selection list.

4. In the Layout list, select the layout in which you want to view the report.

   The Layout list is populated based on the type of report selected in the Selec- tion list.

5. In the Date Range area, type/select the date range for the report to be gen- erated. You can select the date in the From and To fields only if the Custom option is selected in the Fill Dates list.

   The Date On field is populated based on the type of report selected in the Selec- tion list.

   To include the entire time frame, leave the date fields blank.

   In the Fill Dates list, you can select from the predefined date ranges. They are:

   » Custom:

Selecting this option enables the From and To fields in the Date Range area.

» Calendar Year:

Selecting this option displays the Calendar Year list. You can select any of the predefined calendar year formats from the list.

» GL Periods:

Selecting this option displays the GL Periods list. You can select any of the predefined GL period formats from the list.

1. In the Sort Range list, you can sort the information.

   The Sort On field is populated based on the type of report selected in the Selec- tion list.

   The available sort ranges are:

   » Single: Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

   ≡ Type the item reference in the From field.

   ≡ Click the Lookup Reference and from the Lookup For From

   window, select the required sort item and click Select.

» Range: Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

≡ Type the first and last values of the range in the From and To

fields.

≡ Click the Lookup Reference (if available) and from the Lookup For window, select the required sort item and click Select.

» All: Select this to include all available items.

1. On the Toolbar, click Run Report to generate the report.

   Select Open now to open the report in a new tab or select Notify when Com- plete to get notification. You can open the downloaded report from My Reports page.