Integration of Accounting Documents
The system classifies accounting document (journal entry) line items into the following categories:
Posting on a customer or vendor account (Receivables or Payables)
Posting on a bank clearing account (Cash in Transit)
Posting on a bank account (Cash)
The system distinguishes the different categories as follows:
Receivable or Payable
Items with account type D (Customer) or K (Vendor)
Cash in Transit
Items with a G/L account that is:
Either
Maintained in account determination of payment program (T042I)
A balance sheet account (SKA1-XBILK)
Not a reconciliation account (SKB1-MITKZ)
Or
Maintained in account determination of bank-to-bank transfer (T042Y)
A balance sheet account (SKA1-XBILK)
Not a reconciliation account (SKB1-MITKZ)
Or
Marked as cash relevant (SKB1-XGKON) and
With open item management (SKB1-XOPVW)
Cash
Items with a G/L account that is:
Either
Maintained in house bank accounts (T012K)
Or
Marked as cash relevant (SKB1-XGKON) and
Without open item management (SKB1-XOPVW)
For these accounting document items, the system derives the following flow types:
Note
The system only recognizes “positions”, examples of which are Regular Receivables, Unallocated Receivables, or Incoming Bank Confirmed Cash. Every position is considered separately and thus, first added to then subtracted from One Exposure. For further information, see the examples in Integration of Bank Statements.
Accounting Document Item | Default Flow Types |
|---|---|
Receivable or Payable | 600000 - Regular Receivables Increase 600001 - Regular Payables Increase 600200 - Unallocated Receivables Increase 600201 - Unallocated Payables Increase |
Revenue and Expenses | 600500 - Delivered Goods/Services Increase 600501 - Received Goods/Services Increase 600510 - Received Goods/Services Decrease 600511 - Delivered Goods/Services Decrease |
Tax | 300000 - Input Tax Increase 300001 - Output Tax Increase 300010 - Output Tax Decrease 300011 - Input Tax Decrease |
Cash in Transit | 800006 - Incoming Cash in Transit Increase 800008 - Outgoing Cash in Transit Increase |
Cash | 900006 - Incoming Bank Confirmed Cash Increase 900008 - Outgoing Bank Confirmed Cash Increase |
Date and Amount
The transaction date and amount are determined based on the billing date and the invoiced amount together with the payment terms.
For these accounting document items, the system offers the following options to derive liquidity items:
Based on G/L accounts
Use the following Customizing activity:
Financial Supply Chain Management
Cash and Liquidity Management
Cash Management
Liquidity Items
Derivation Rules for Liquidity Items
Define Default Liquidity Items for G/L Accounts
.Based on queries of origin C (for Receivables or Payable) or D (Cash in Transit or Cash)
Use the following Customizing activity:
Financial Supply Chain Management
Cash and Liquidity Management
Cash Management
Liquidity Items
Derivation Rules for Liquidity Items
Define Queries for Liquidity Item Derivation
.Based on a derivation function (exit)
Use the following Customizing activity:
Financial Supply Chain Management
Cash and Liquidity Management
Cash Management
Liquidity Items
Derivation Rules for Liquidity Items
Define Liquidity Item Derivation Settings for Company Codes
.
For these accounting document items, the system offers the following options to derive planning levels:
From the G/L account, where it is defined in the master record for company code-specific data.
For customer or vendor postings, it is derived from the planning group.
Use the following Customizing activity:
Financial Supply Chain Management
Cash and Liquidity Management
Cash Management
Planning Levels and Planning Groups
Define Planning Groups
.For special G/L transactions, such as down payment requests, you can derive specific planning levels.
Use the following Customizing activities:
Financial Supply Chain Management
Cash and Liquidity Management
Cash Management
Planning Levels and Planning Groups
Special G/L Transaction Levels
.
One Exposure derives cash forecasts for items representing receivables, payables, or cash in transit, and it stores actual cash from items representing cash. It stores this information with the following certainty levels.
Certainty Level | Description | Meaning |
|---|---|---|
| Actual | Accounting document line items from bank statements or accounting document line items with G/L accounts representing cash |
| Self-Initiated Cash in Transit | Cash forecast from a self-initiated payment |
| Regular Receivable | Cash forecast from an open item of a receivable |
| Regular Payable | Cash forecast from an open item of a payable |
These forecasts and actuals contain information inherited from the offsetting accounting document line items of the corresponding receivable or payable. They are split based on this inherited information. The inheritance uses the linkage between the affected accounting document items to analyze these accounting document chains. By doing so, the following information from the offsetting accounting document line items of the receivable or payable is available in the forecasts and actuals:
Accounting Assignments:
Business Area
Profit Center
Cost Center
WBS Element or a Project
Segment
Company
Material
Liquidity Item
Example
The following example illustrates the inheritance and split logic for both forecasts and actuals:
A company receives a vendor invoice. The company purchased materials for two different cost centers, CC01 and CC02. This information is passed on to the cash forecast of the payable and thus this cash forecast is split into two flows according to the expense line items.
Vendor Invoice
Cash Forecast
Expense 01: 60 EUR for CC01
Expense 02: 40 EUR for CC02
Account Payable: 100 EUR
Forecast from Payable for CC01: 60 EUR
Forecast from Payable for CC02: 40 EUR
The company then pays this vendor invoice. The cost center information is passed on to the cash forecast from cash in transit and thus this cash forecast is split into two flows according to the expense line items.
Vendor Payment
Cash Forecast
Account Payable: 100 EUR
Bank Clearing Account: 100 EUR
Forecast from Cash in Transit for CC01: 60 EUR
Forecast from Cash in Transit for CC02: 40 EUR
This payment is then confirmed by a bank statement. The cost center information is passed on to the actual cash from the bank statement and thus this actual cash is split into two flows according to the expense line items.
Bank Statement
Actual Cash
Bank Account: 100 EUR
Bank Clearing Account: 100 EUR
Actual Cash for CC01: 60 EUR
Actual Cash for CC02: 40 EUR
The following flow types are generated for forecasts and actuals in One Exposure:
Forecasts and Actuals | Default Flow Types |
|---|---|
Cash Forecasts from Receivables or Payables | 900900 - Incoming Cash from Invoices 900901 - Outgoing Cash from Invoices |
Cash Forecasts from Cash in Transit | 900902 - Incoming Cash from Payments 900903 - Outgoing Cash from Payments |
Actuals from Cash | 900910 - Incoming Cash from Bank Statements 900911 - Outgoing Cash from Bank Statements |
Central Finance
If Central Finance is deployed, all accounting documents that were created based on the accounting documents from your local systems can also be integrated into One Exposure. Accounting document line items in a Central Finance system are, then categorized in the same way as described above and integrated into One Exposure accordingly. With Central Finance, therefore, a side-by-side scenario for integrating accounting documents into One Exposure is also possible.
Activities
Customizing Activities
Assign Flow Types to G/L Accounts
If you want additional accounting document items to be processed by One Exposure from Operations, you have to define them using this Customizing activity. You do this by assigning the corresponding G/L accounts to the following flow types, which are currently available to you. For example:
Category of Accounting Document Item
Default Flow Types
Cash in Transit
800006 - Incoming Cash in Transit Increase
800008 - Outgoing Cash in Transit Increase
Cash
900006 - Incoming Bank Confirmed Cash Increase
900008 - Outgoing Bank Confirmed Cash Increase
If an item debits an account of this type, the system uses the first flow type; if an item credits the account, the system uses the second flow type. These flow types are provided as standard. There is no need to create additional customer-specific flow types in this case.
CautionDo not assign flow types to a G/L account that is characterized as a reconciliation account.
End of the caution. NoteYou repeat the following Customizing activities each time an additional company code is activated for the source application Financial Operations.
End of the note.Rebuild Flow Types in Accounting Documents
If you want to process existing accounting document line items, you use this activity to derive and rebuild flow types for those line items.
Rebuild Liquidity Items in Accounting Documents
If you want to process existing accounting document line items, you use this activity to derive and rebuild liquidity items for those line items. This Customizing activity offers two modes to derive liquidity items:
Initial Load for initial runs
Rebuild for rebuilding liquidity items subsequent to an initial run
Rebuild Planning Levels, Groups, Dates in Accounting Documents
If you want to process existing accounting document line items, you use this activity to derive and rebuild planning levels, planning groups, and planning dates for those line items.
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 Financial Operations was activated, you use this Customizing activity.
Alternatively, you can also use the Customizing activity
Build Cash Flows from Operations
to load transaction data from the source application Financial Operations into One Exposure.Customize the Flow Builder
If you want the system to trigger regular updates of accounting documents into One Exposure, you use this activity to schedule automatic background jobs.