18.4.2.2 Dashboard: Period to Date History

AFCS will compute and persist day and period (month, quarter, and year) to date credit and debit movement figures. This section provides information about the Period to Date dashboard used in Balance Computation Results.

  • Effective Date: Click the calendar icon and select the effective date.
  • As of Date: Click the calendar icon and select the As of Date.
  • Run Surrogate Key: Select the Run Surrogate Key.
  • Legal Entity Name: Select the Legal Entity Name.
  • Fiscal Period: Select the Fiscal Period.
  • Function Currency: Select the Function Currency.
  • General Ledger Code: Select the general ledger code.

After updating the options, click Apply. To refresh the data in the fields click Reset.

A few reports also have filters at each reporting level which are detailed in the Report Descriptions section. Select the appropriate report filters so that data is displayed accordingly. Each report within a dashboard contains the following features:

  • Analyze: To analyze the values displayed in the report.
  • Edit: To edit the values displayed in the report.
  • Refresh: To update the values displayed in the report.
  • Export: To export data into multiple formats such as PDF, Excel, PowerPoint, and so on.

Table 18-13 Period to Date History Report Information

Report Name Period to Date History
Report Description

This report displays the following parameters of the selected entity:

  • As of Date
  • Account or Contract Number
  • Entity Name
  • Product Code
  • General Ledger Account Name
  • Organization Unit Name
  • Accounting Standard Description
  • Management Legal Entity Code Combination Identifier
  • Code Combination Identifier
  • Functional Currency
  • Entered Currency
  • Quarter to Date Accounting Balance in Entered Currency
  • Quarter to Date Accounting Balance in Functional Currency
  • Credit Movement Quarter to Date Accounting Balance in Entered Currency
  • Credit Movement Quarter to Date Accounting Balance in Functional Currency
  • Debit Movement Quarter to Date Accounting Balance in Entered Currency
  • Debit Movement Quarter to Date Accounting Balance in Functional Currency
  • Average Month to Date Accounting Balance in Entered Currency
  • Average Month to Date Accounting Balance in Functional Currency
  • Month to Date Accounting Balance in Entered Currency
  • Month to Date Accounting Balance in Functional Currency
  • Credit Movement Month to Date in Entered Currency
  • Credit Movement Month to Date in Functional Currency
  • Debit Movement Month to Date in Entered Currency
  • Debit Movement Month to Date in Functional Currency
  • Average Quarter to Date Accounting Balance in Entered Currency
  • Average Quarter to Date Accounting Balance in Functional Currency
  • Debit Movement Year to Date in Entered Currency
  • Debit Movement Year to Date in Functional Currency
  • Average Year to Date Accounting Balance in Entered Currency
  • Average Year to Date Accounting Balance in Functional Currency
  • Year to Date Accounting Balance in Entered Currency
  • Year to Date Accounting Balance in Functional Currency
  • Credit Movement Year to Date in Entered Currency
  • Credit Movement Year to Date in Functional Currency
  • Month To Date Net Movement In Entered Currency
  • Month To Date Net Movement In Functional Currency
  • Quarter To Date Net Movement In Entered Currency
  • Quarter To Date Net Movement In Functional Currency
  • Year To Date Net Movement In Entered Currency
  • Year To Date Net Movement In Functional Currency