Tasks to be completed when documenting an operation (from creation to publication)1. Enter the Title of the operation / page2. Add the following Labels :
3. Fill in all fields as described above4. Once the description of the operation is completed, ensure it is approved and published by launching the SBS-Finance approval workflow |
| Domain: Country Accounting |
Responsibility area: N/A |
The purpose of this document is to explain how to clear the open items in the Revaluation accounts.
The reason of this procedure is because the Inventory Revaluation procedure, which is performed each closure, generates several postings what are reversed in the next month.
This procedure applies to the company 7424.
See Finance Glossary:
The clearing of Revaluation accounts has to be done once a month, at D+8, being performed by SBS Service Center.
Enter in the transaction FBL3N and insert the variant 7424_REVAL_CLR , which contains the G/L accounts 31000109, 31000209, 31000309, 37000109, 37000309, 37000305, 34000200, 37000409. Execute.

Save the report in excel, using the option spreadsheet.
Using the template saved into the Google Drive folder 7424: Revaluation accounts clearing, copy all the information extracted from SAP and paste it (except the titles) in the table Information SAP.
Go on the table Pivot and click in the bottom Refresh to update the PivotTable.
In the table Pivot, refresh the Pivot Table. It will show the assignment to be used to clear the documents and the accounts to be cleared. The identification of the documents is the Reference Valuation and Valrev.
´
Use the transaction F-03 to clear the documents. Insert the Account, Company Code, Currency and the Clearing Date, which has to be the current day. In Additional Selections, choose "Others" in the next screen choose "Assignment".
In the column From insert the Assignment of the documents being cleared. Take this information from the Pivot Table. Click in Process open items.
Make sure that the total of Display from item is the same showed in the Pivot Table for the account that is being cleared.
If everything is okay, save it, copy the clearing document number and paste it in the field Clearing Doc. Number for the respective account. Also, update the Clearing date in the file with the current day.
Perform the same thing for all the accounts that contain documents to be cleared. Once it is done, save the file in the Google Drive folder 7424: Revaluation accounts clearing, with the name Revaluation accounts clearing MM.YYYY, where MM is the current month and YYYY is the current year.