Crystal Reports Stock Report Descriptions › Chargeback GL Account Activity Report

Chargeback GL Account Activity Report

Description

The GL-centric report provides a summary that shows debits and credits for a GL period. Below the summary-level presentation, a detailed presentation shows transactions. This report is used for auditing. The report provides different layouts, depending on the option selected for the Group-By parameter (Investment or Resource).

The report includes information about the following: Active and inactive investments, all investment types, approved and unapproved investments (if transactions exist).

Prerequisites

• The investment requires enabling financially.

  See the Project Management User Guide for more information.

• Transactions required for the investment.
• Invoices require approvals to show on the Credit to Allocation.
• GL-Period End and GL-Period Start require belonging to the same entity and same period type. For example, monthly.

Parameters

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.

Investment

Indicates the name of the investment to generate data in the report. Click the Browse icon and select the investment from the list that appears.

Resource

Indicates the name of the resources to generate data in the report. Click the Browse icon and select names from the list that appears.

Report Fields

Account

Displays the account identifier.

Database Tables and Columns:

cbk_gl_account.main_account_id

cbk_gl_account.sub_account_id

Account Description

Displays in text what the corresponding account number represents.

Database Tables and Columns:

cbk_gl_account.sub_account_id

Charge to Allocation

Displays the share (or allocation) to be charged to a customer. The share is based on the transaction amount and the debit-rule, splitting the total transaction cost between accounts.

Database Tables and Columns:

If cbk_gl_txns.chargeback_type = “ “ THEN cbk_scaled_gl_txns.scaled_amount

Credit to Allocation

Displays the share of transactions of approved invoices to credit to a provider. Total cost is split between provider accounts according to credit rules.

Database Tables and Columns:

If cbk_gl_txns.chargeback_type = “ “ THEN cbk_scaled_gl_txns.scaled_amount

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

Investment

Displays the name of the investment to generate the report.

Database Tables and Columns:

prteam.prprojectid

Resource

Displays the resource associated with charges at the detailed level in the report.

Database Tables and Columns:

srm_resources.last_name

srm_resources.first_name

Task

Displays a project task being reported.

Database Tables and Columns:

prtask.prname

Transaction Date

Displays the transaction date in the mm/dd/yyyy format.

Database Tables and Columns:

cbk_scaled_gl_txns.transaction_date