About Cash and Treasury Management cubes

Some of the reports in Infor Rich Client are Cash and Treasury Management cubes. Cube-based reporting is a feature that allows for multidimensional reporting. Cubes are useful built-in tools for visualizing and sorting data in CTM. The CTM cubes differ from other reports in some major areas:

  • The data displayed is not real-time data. It is the data as it stood when the cube was last refreshed. A process must be set in place by your organization to refresh the cube as often as it makes sense for your organization. Cubes can be refreshed from Treasury Administrator > Utilities menu.

  • Some measure values have links that bring up a list. These lists represent real-time data. Therefore, if the data changed after the cube was refreshed, it is possible that the total number of records may not correspond to the record count that displays on the cube.

  • Some of the cubes have graphic representations such as charts. You can hover over or click on the graphics of some cubes to highlight more detailed data. You can also click Detail next to any cube to display a more detailed breakdown of the data.

  • If you have access, you can change both the dimension defaults and the measures that display for cubes.

In Cash and Treasury Management, all roles with a web app can view cube data.

To access cube data, open any Cash and Treasury Management web app (except for Statement Processing) and click one of the options to view cube data. To toggle between the screens, click the number or arrow buttons at the bottom of the dashboard. For more information on cube data, see "Treasury Manager and Treasury Accountant" in Infor Lawson Cash and Treasury Management User Guide.

There are three cubes in Cash and Treasury Management:

Cash Position

  • Table used: BankStatementLine

  • Dimensions:

    • FinanceGroup

    • StatementDatePeriod (daily time dimension)

    • CashTransactionCategory

    • CashManagementAccount (operating accounts only)

    • CashManagementAccount Main Contact

    • FinancialInstitution

    • CashManagementLocation

  • Measures:

    • ClearedDeposit

    • ClearedPayment

    • SignedClearedPayment

    • NetActivity

    • LineAmount

    • CashPositionTarget

  • Recommended update conditions and frequency:

    • When a new record is added for one of the dimensions, excluding StatementDatePeriod (Infrequent)

    • When the Main Contact, FinancialInstitution, or CashManagementLocation (CompanyLocation) are changed on the CashManagementAccount (Infrequent)

    • After bank statements are imported (Daily)

    • After bank statement lines are recategorized (Daily)

    • After bank statement lines are split (Daily)

Cash Forecasting

  • Table used: CashForecastPeriodAmount

  • Dimensions:

    • FinanceGroup

    • ForecastDatePeriod (daily time dimension)

    • CashForecast (active or closed status only)

    • CashTransactionCategory (categories on active forecasts)

    • CashManagementAccount (accounts on active forecasts)

    • CashManagementAccount Main Contact

    • FinancialInstitution

    • CashManagementLocation

  • Measures:

    • ForecastAmount

    • DerivedActualAmount

    • VarianceAmount

    • YTDActualChange

    • OriginalForecastAmount

    • OriginalVarianceAmount

    • WeeklyPublishedForecastAmount

    • MonthlyPublishedForecastAmount

    • WeeklyPublishedVarianceAmount

    • MonthlyPublishedVarianceAmount

  • Recommended update conditions and frequency:

    • When a new record is added for one of the dimensions, excluding ForecastDatePeriod (Infrequent)

    • When the Main Contact, FinancialInstitution, or CashManagementLocation (CompanyLocation) is changed on the CashManagementAccount (Infrequent)

    • After the Cash Forecast is activated or approved (Infrequent)

    • After adjustments are made to the ForecastAmount on an active Cash Forecast (Daily)

    • After a week is published on an active Cash Forecast (Weekly)

    • After a month is published on an active Cash Forecast (Monthly)

Bank Services (Fee Analysis)

  • Table used: BankServiceDetail

  • Dimensions:

    • FinanceGroup

    • StatementDatePeriod (monthly time dimension)

    • BankServiceCode

    • BankServiceCategory

    • CashManagementAccount

    • FinancialInstitution

    • CashManagementLocation

  • Measures:

    • BankChargedAccount

    • Quantity

  • Recommended update conditions and frequency:

    • When a new record is added for one of the dimensions, excluding StatementDatePeriod (Infrequent)

    • When the FinancialInstitution or CashManagementLocation (CompanyLocation) is changed on the CashManagementAccount (Infrequent)

    • After bank fee statements are imported (Monthly)