SAP Knowledge Base Article - Public

2832526 - GL Account Balances Migration Error: Mandatory value missing in column line item currency

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

  1. Go to Business Configuration work center
  2. Select the  Implementation Projects subview.
  3. Open Activity List and navigate to Integrate and Extend.
  4. Search for Migration of Accounting Transaction Data and select Migrate accounting transaction data using the migration tool
  5. Select the Migration Unit and Execute Migration.
  6. Select the Migration Object : G/L Account Balances and Process the file.
  7. 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

  1. Update the migration template by entering the currency in the Line Item Currency field for each G/L accounts added in the template.
  2. Enter the corresponding value in the Amount under the Line Item Currency field.
  3. Save the updated migration template.
  4. Repeat the validation.
  5. 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

Product

SAP Business ByDesign all versions