Ansicht
Dokumentation
RFKKOP03 - FI-CA: Key Date-Based Open Item List
General Data in Customer Master General Material DataThis documentation is copyright by SAP AG.
Description
This report creates a key-date-related list of open items for business partners in Contract Accounts Receivable and Payable (FI-CA). You use this report during closing operations (monthly, quarterly, annually) or for reconciliation with the general ledger.
An item is an open item with regard to the entered key date if the following applies:
- The item is not statistical.
- If the item is open with regard to the system date, the posting date must be before or the same as the key date.
- If the item is no longer open, the posting date must be before or the same as the key date, and the clearing date must be after the key date
If the item is no longer open, the clearing date is after the key date, and the posting date is after
or the same as the key date, but the posting date of the clearing item is before or the same as the key date, then the clearing item is an open item with regard to the key date entered.
If you do not enter a key date, the report determines the current open items. Statistical items are not considered.
In addition, the list shows the following:
- Accounts to be reclassified
- Age grid of accounts to be reclassified
- Age grid of open items
-
Be aware of the following rules:
An account appears either in the reclassifications or in the age grid. The determination always takes place in local currency. For the grid, you can select how credits are treated and how the grid is output.
- Consideration of clearing accounts for tax on sales and purchases
-
These accounts, like the reconciliation accounts, are open item accounts.
The grouping level defines balance groups and controls the display of the subtotals.
Using grouping level 1, you define the subledger account used to determine the reclassifications.
Using grouping level 2, you define an additional output of subtotals for this level.
Level 1 is always defined with at least the business partner; level 2 does not have to be defined.
Currencies
The report calculates the totals in the first local currency. You can also calculate totals in the transaction currency. However, if you enter a currency type, the report replaces the first local currency with a currency with this currency type. If this currency is not defined in the company code, an error occurs. The system exports the reclassification in the currency used.
You post these using the Post Reclassification app.
If you also enter a valuation variant and a valuation key date, the report does not display the original amounts of the items; instead, it displays the amounts calculated by the currency valuation for the valuation key date.
Requirements
Output
The report totals and sorts the data by grouping level 1 and, if it exists, then by grouping level 2. If level 2 is defined, subtotals are always output for it.
The report always outputs the totals for each company code and reconciliation account. You can suppress the output of additional totals in transaction currency. The report always outputs reclassifications and the age grid only in local currency.
These totals sheets appear at the end of the list:
- Totals
- Customers with credit balances
- Vendors with debit balances
- Age grid
If you output line items, for some items the field S (Simulation) is set in the last column. These are items in clearing documents that are open with regard to the key date (see point 4). Note the following for the document display for such items:
The Clearing Document Number field contains the number of the document whose items were cleared. If you display the document for an item marked with S in the list with the document number specified in the list, the business partner items are displayed under Cleared Items.
If you have not set the indicator No Totals in Transaction Currency, the
report prints and exports the totals in transaction currency in addition to the local currency selected
with the reclassification totals. Using the overall total in local currency, the program decides for each partner whether the account has to be reclassified.
Grid Interval
If you want to reclassify based on due dates, then enter how you want to group the open items or installment plan items. You make these specifications in the grid interval. Enter the intervals beginning with the smallest value and then increase sequentially. For reclassification by due date, the system considers only those items that are open on the key date, but are not yet due.
When considering items that are open and already due on the key date, the grid interval is viewed as 'due for n days', where the grid value n that you enter represents the upper limit of the interval.
When considering items that are open and not yet due on the key date, you have to enter the grid intervals in the form of negative values; these represent the lower limit of the time interval being considered. The examples below illustrate how this works.
Example 1: Entering Positive Grid Values
Grid interval number: | R1 | R2 | R3 | R4 | R5 |
Grid intervals in days: | 30 | 60 | 90 | 180| 365|
These entries cause the following intervals to be created:
Number of days before key date Number of days after key date
365 180 90 60 30 Key Date 30 60 90 180 365
=======|=====|=====|=====|=====|======I======|=====|=====|=====|=====|=======>
<--------|<----|<----|<----|<----|------------------------------------------->
( R6 ) | R5 | R4 | R3 | R2 | R1
Example 2: Entering Negative Grid Values
Grid interval number: | R1 | R2 | R3 | R4 | R5 |
Grid intervals in days: | -365 | -180 | -90 | -60| -30|
These entries cause the following intervals to be created:
Number of days before key date Number of days after key date
365 180 90 60 30 Key Date 30 60 90 180 365
=======|=====|=====|=====|=====|======I======|=====|=====|=====|=====|=======>
<----------------------------------------------|---->|---->|---->|---->|------->
( R6 ) | R5 | R4 | R3 | R2 | R1
Interval R6 groups together all items that could not be assigned to another interval. You do not have to enter this interval explicitly. The system also does not consider this interval when it determines the dates for reclassification by due date.
Note that the export only considers intervals with a negative value. This is to prevent overlapping with items that are already due. If you want the system to consider all items that are due after the key date, then you have to enter a value of -1 for the last interval.
Example
Description
Requirements
Provided that the reclassification of customer with a credit balance or vendor with a debit balance is necessary, you have to define receivables and payables accounts that you have to reclassify in the context of the balance sheet in the configuration activity Define Receivables and Payables Accounts.
There you can activate the display of the reclassifications for account groups and company code groups as well as for individual accounts.
CPI1466 during Backup RFUMSV00 - Advance Return for Tax on Sales/Purchases
This documentation is copyright by SAP AG.
Length: 10954 Date: 20240520 Time: 131017 sap01-206 ( 172 ms )
