Kontakt

Ansicht
Dokumentation

RGLOFAA_GB_MREV_MIG - GB Revaluation for Central Authorities – initial migration

RGLOFAA_GB_MREV_MIG - GB Revaluation for Central Authorities – initial migration

Vendor Master (General Section)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

You use the Revaluation for Central Authoritiesmigration report to enable you to migrate data of company codes to post to G/L accounts with the specification of fixed asset numbers.

Integration

You can only use this report for company codes using the GB Revaluation for Central Authorities solution.

Prerequisites

  1. You have made the required settings for the GB Revaluation for Central Authorities solution (see attachment of SAP Note 3106651).
  2. You have prepared a TXT file, separated by tabulators, with the following columns: Fixed Asset Main Number, Fixed Asset Subnumber, and Amount to Be Posted.
Note:
  • You can use the first row to add the column descriptions.

  • You can create the file in a spreadsheet application and then save the file as a TXT file.

  • You can enter positive and negative amounts.

Features

Selection

Fill in the mandatory fields:

  • In the Organizational Structuresand Document Headerfield groups, specify the company code, currency, and document type.
  • In the Posting Datefield, enter your migration date.
  • In the Migration Typefield group, select one of the following options:
  • G/L Account Balance by Assets: You select this option to migrate initial balances of some G/L accounts (revaluation reserve account, for example) by fixed assets. This step is optional.

  • Posted Revaluation Reserve Depreciation: You select this option in case your company codes have the Automatic Transfer of Reserves active and if there has been a migration during the year to migrate revaluation reserve depreciation already posted in the legacy system.

Example:
Let us suppose you migrate your data at the end of period 6 in fiscal year 2022. The revaluation reserve depreciation posted for your fixed asset 30000-0 in the legacy system in 2022 was 900 GBP (150 in each period 1 to 6). You enter the record for your asset 30000-0 with the amount +900 GBP into your migration file (positive amounts should be used for this migration type). Then, once depreciation is posted for the period 7 in the SAP system, the migrated amount will be recognized and not posted again. If the amount is not migrated, the system will post the amount calculated for periods 1 to 6 to the posting period 7 for fixed asset 30000-0.
  • In the G/L Accountfield, specify the G/L account in which the asset line items specified in the file should be posted to.
  • In the Maximum Number of Selected Rowsfield, indicates the maximum number of rows in one document. With the default value as 100, a separate document is created for each selected 100 asset lines.
  • In the Contra Line Items G/L Accountfield, specify the G/L account to be used in the contra G/L item which is generated for each G/L document. The amount is calculated to reach zero balance automatically. The contra posting G/L item is updated without any fixed asset number.
Note that you can use the dedicated data migration balance sheet account.
  • In the Migration TXT Filefield group, specify the full path to the text file described in the Prerequisites section.

Standard Variants

Output

The report displays the file content in the following columns in addition to the three columns specified in the file:

  • G/L Account: Indicates the migrated G/L account.
  • Debit/Credit: Indicates if the G/L account will be updated on debit or credit based on the amount sign.
  • Subledger-Specific Line Item Type: This is an internal field that enables you to update G/L accounts with fixed asset numbers.
Note that the value 07806 identifies the revaluation reserve depreciation that has been already posted within Revaluation for Central Authorities solution. Hence, this value is used if you select the corresponding Migration Type.
  • Assignment: Indicates the migration items in G/L reports.
  • Amount Previously Posted: This is the amount previously posted with the same subledger-specific line item type on the same fixed asset. With the initial migration, the amount should be zero. Therefore, amounts other than zero are reported as warning.
  • Message Text and Message Type: Indicates any warning or error messages while running the report. These fields are also used to report posting errors returned by the accounting interface.

Activities

  1. If there are errors, make sure the errors are solved.
  2. Run the report again.
  3. Select the rows that you want to migrate and select the Migrate button.
The system posts the FI documents. Once the FI documents are posted successfully, the report displays the posted document numbers.
In case of errors, check the message fields for more details.

Example

Let us suppose that your file contains 900 rows with fixed assets. You entered 100 in the Maximum Number of Rows field. In the report output, you selected all rows and selected Migrate. As a result, 9 financial accounting documents are posted with 101 lines each (100 asset line items and 1 contra account line item).






BAL Application Log Documentation   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.

Length: 6523 Date: 20240601 Time: 024901     sap01-206 ( 105 ms )