Questions? We have answers.

Missing Data (MBER1319 MBER1171)

Article author
Kate H
  • Updated

The Problem

While trying to import GL, get an error like one or more of the following:

  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})

 

Possible solutions

  • 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, which could result in excluding rows that should be included (such as if the account number is missing) or excluding rows that should be excluded (such as if there are no amount, debit, or credit values because the amount should be 0).
  •  
  • Solution #2: Columns could be misaligned
    • If you are sure that each row does have a value in all required fields (account number, effective date, and either amount or debit or credit), check whether some columns are shifted over, for example, if the debit or credit amounts are not in the expected columns for some rows farther down in the file

 

Reference/Other

Link to misaligned columns?

 

If none of the solutions work, reach out to our amazing Support Team! :)

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.