Crystal Reports Stock Report Descriptions › Customer & Provider Chargeback Report

Customer & Provider Chargeback Report

Description

The report displays financial customer and provider portfolio status and chargeback information. By design, the report displays only one entity information at a time. The report does not support displaying investments from multiple entities. GL periods are required field parameters, and they are tied to a specific entity. Therefore, only that entity details are displayed. If GL period start is from one entity and GL period end is from another entity, the report displays no results.

Prerequisites

• Chargeback data for the investment required for the investment and its actuals to show on a report.
• A budget or planned cost required to display budget or planned cost data.
• An All-* debit rule required for the investment or systemwide to show a pro-rated budget for the customer.
• The All-* rule required to calculate budget/planned cost and forecast costs split across departments. If a department has actual charges but is not defined in the All-* rule, the department does not appear in the report.
• If the budget/planned cost/forecast start date does not have an allocation in the All-* rule, the investment does not display in the report.
• Every investment requires the following dates with a corresponding allocation in the All-* rule:
  • Planned dates
  • Budget dates
  • Forecast dates

  If not, the investment does not display in the report.

• An entity defined and the project enabled financially.

Parameters

Customer

Indicates the department charged with the investment cost according to the debit rule allocation. Click the Browse icon and select a name from the list that appears.

GL-Period End

Indicates the end of the reporting period. Click the Browse icon and select a date from the list that appears.

GL-Period Start

Indicates the start of the reporting period. Click the Browse icon and select a start time from the list that appears.

Group By

Indicates the grouping and presenting of information on the report. Select an option from the drop-down.

Plan Type

Indicates the plan type to filter the report. Select the plan type from the drop-down list in the field.

Provider

Indicates the department providing the service. Click the Browse icon and select a name from the list that appears.

Report Fields

Budget

Displays the prorated budget/planned cost for a specific customer based on the total investment budget split using the All-* debit rule.

Database Tables and Columns:

fin_financials.budget_cst_total* odf_ssl_gl_all_dtl_pct.slice

Customer

Displays the department receiving and paying for a service.

Database Tables and Columns:

departments.description

Entity

Displays the entity the investment belongs to.

Database Tables and Columns:

entity.entity

Forecast-to-Date (FTD)

Displays the prorated forecast (Actuals + Remaining Planned Cost) as of the current date, based on the total investment forecast split using the All-* debit rule.

Database Tables and Columns:

fin_financials.forecast_cst_total* odf_ssl_gl_al_dt_pct.slice

GL-Period

Displays the GL time period for generating the report in the yyyy/mm format.

Database Tables and Columns:

biz_com_periods.period_name

Inception-to-Date (ITD)

Displays all actuals charged to a customer from the investment start date to the current date.

Database Tables and Columns:

cbk_scaled_gl_txns.scaled_amount

Investment

Displays the name of the investment to generate the report.

Database Tables and Columns:

prteam.prprojectid

Period-to-Date (PTD)

Displays the actuals charged to a customer from the investment start period to the current date.

Database Tables and Columns:

cbk_scaled_gl_txns.scaled_amount

Planned Cost

Displays the plan of record for the investment pro-rated using the All-* rule.

Database Tables and Columns:

fin_financials.planned_cst_total* odf_ssl_gl_all_dtl_pct.slice

Provider

Displays the department responsible for the investment.

Database Tables and Columns:

departments.description

Year-to-Date (YTD)

Displays the actuals charged to a customer from the beginning of the year to the current date.

Database Tables and Columns:

cbk_scaled_gl_txns.scaled_amount