Show TOC

Function documentationManual Entry of Bank Cash Balances in One Exposure from Operations

 

You can integrate forecasted cash from bank cash balances into One Exposure from Operations. In this integration scenario, you enter the cash balances in a Microsoft Excel sheet and load them into One Exposure. Since you have to upload the balances manually to One Exposure (central system), this integration scenario is also a side-by-side scenario.

Cash inflows and outflows contain the following information from bank cash balance uploads:

  • Company

  • Business Partner (filled with the bank of the bank account)

  • BAM Account

Certainty Level

One Exposure derives cash inflows and outflows for the given bank account balances. It stores this information with the certainty level ACTUAL.

Flow Type

The system uses the following flow types for the cash flows from bank cash balances in One Exposure:

Default Flow Types

900102 – Bank Cash Balance Increase

900103 – Bank Cash Balance Decrease

If errors occur during data upload, they are directly displayed in a log after executing transaction FQM21.

Prerequisites

You have to maintain connectivity path information for remote bank accounts in the bank account master data of the activity Manage Bank Accounts. There, you need to fill the ID category field with Remote System: House Bank Account or Remote System: G/L Account.

Activities

IMG Customizing Activities

  • Assign Planning Levels to Flow Types

    The system fills the planning level, if the planning level is assigned to the flow types the system uses.

  • Define Queries for Liquidity Item Derivation

    This offers you the possibility to enter derivation rules for data coming from bank cash balances. The liquidity item derivation is based on a subset of information available in One Exposure (origin X).

    If no liquidity item can be determined, the system updates the flow with an empty liquidity item.

  • Load Transaction Data from Source Applications into One Exposure from Operations Hub

    If you want to integrate transaction data that had already been created before the source application Bank Account Balances was activated, you use this Customizing activity.

  • Delete Data from One Exposure from Operations Hub

    If you want to use a new starting point within an implementation project, you can use this Customizing activity to delete all existing data or the source application Bank Account Balances from One Exposure. You do this for each company code and source application.

More Information

For further information on the import of bank cash balances, see the report documentation available in transaction FQM21.

The following cash management apps consume the information coming from bank cash balances:

  • Check Cash Flow Items

  • Cash Position

  • Cash Position Details

  • Liquidity Forecast

  • Liquidity Forecast Details

  • Develop Liquidity Plans

  • Liquidity Plans

For further information, see One Exposure from Operations