Symptom
While executing the Migration of G/L Account Balances, the error occurs,
Error: Account Balances: Mandatory value missing in column line item currency.
Error: Account Balances: Mandatory value missing in column Amount in line item currency.
Environment
SAP Business ByDesign
Reproducing the Issue
-
Go to Business Configuration work center
-
Select the Implementation Projects subview.
-
Open Activity List and navigate to Integrate and Extend.
-
Search for Migration of Accounting Transaction Data and select Migrate accounting transaction data using the migration tool
-
Select the Migration Unit and Execute Migration.
-
Select the Migration Object : G/L Account Balances and Process the file.
- Error appears.
Error: Account Balances: Mandatory value missing in column line item currency.
Error: Account Balances: Mandatory value missing in column Amount in line item currency.
Cause
Mandatory fields like Currency is not filled in the GL Account balances template and because of this error occurs during Migration.
Resolution
- Update the migration template by entering the currency in the Line Item Currency field for each G/L accounts added in the template.
- Enter the corresponding value in the Amount under the Line Item Currency field.
- Save the updated migration template.
- Repeat the validation.
- The Migration of G/L Account Balances will be saved successfully.
Keywords
GL Account Balances migration error, Line Item Currency field, Amount, Business Configuration. , KBA , SRD-FIN-GL , General Ledger , Problem
SAP Knowledge Base Article - Public