Questions? We have answers.

MBER1127 - Invalid value in row for : ''.

Article author
Kate H
  • Updated

Summary

An amount column has an invalid (non-numeric) value, which result in errors like the following:

MBER1127 - Invalid value in row for : ''. Correct or remove the value
and try again - Args({row=277100, column=debit, value=BBY", lineNumber=277099})
MBER1127 - Invalid value in row for : ''. Correct or remove the value and try again - Args({row=948280, column=credit, value=1235.120002019 3244331 40-100-434-410-12100 Accounts Receivable GJ 2019-10-30 00:00:00.000 qawety GL434 434 GL 0918385-YQDRG, PDERA -CHG 30.00000 0.000002019CHG" 1535.12000 0.00000})

Resolution

  • Solution #1: go to the row number indicated in the error message and examine the value
    • For example, in the first error message above, the row number is 277100, in the debit column, with value BBY:
      MBER1127 - Invalid value in row {{row}} for : ''. Correct or remove the value 
      and try again - Args({row=277100, column=debit, value=BBY", lineNumber=277099})
      Upon visual examination of the source file, you can see that the value in column V spilled over to column W in rows 277100 and 277101 and caused the columns to be shifted over one column to the left: mceclip1.png
    • This can also happen if a line has unmatched " or ' or \ (double or single quotation mark or backslash) characters, which would make system think that the rest of the line and all subsequent lines until the next matching " or ' are the value in the column, like in the second example above.
    • If there is just one or a few isolated spots where there is column shifting or otherwise a bad value, you can manually fix it, but if there are too many for you to handle, free to reach out to our support team!

Anything else on your mind?
Log in to MindBridge to chat with us, submit a request, or reach out to your assigned Customer Success Manager.


Related Articles

Share this:

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.