Questions? We have answers.

MBER1319, MBER1171 - Missing data

Article author
Kate H
  • Updated

Symptoms

Receive one of the following errors, when importing a general ledger file:

  MBER1319 - There was a problem importing a record. There was a missing account
  information on line number: . - Args({lineNumber=5443})
MBER1171 - There was a problem importing a record. Missing mandatory data was detected in column: , on line number: . - Args({lineNumber=2, columnNames=account,effective_date,amount})
MBER1171 - There was a problem importing a record. Missing mandatory data was detected in column: , on line number: . - Args({lineNumber=5443, columnNames=account,effective_date,debit,credit})

 


Resolution

Solution #1:

Ensure that every entry in your GL that should be included in the analysis has an amount for account number, effective date, and either amount or debit or credit.

    • Rows that do not have all of the above, required fields, will be ignored. This could result in excluding rows from the analysis that should be included (such as if the account number is missing) or excluding rows that should be excluded (for example, if there are no amount, debit, or credit values because the amount should be 0).

Solution #2:

Ensure that columns are properly aligned.

    • If you are sure that each row does have a value in all required fields, check to see if there are shifted columns. For example, if the debit or credit amounts are not in the expected columns for some rows farther down in the file (halfway through the file, the debits/credit column was shifted into a new column).


Root Cause

This error is an indication that required data is missing, either due to blank values in required columns or due to the column headers and the respective column data not being properly aligned (i.e. "Credits" header is in column J, but further down in the file some credit data was shifted and is found in column K).


Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.