MBER1127 - Invalid value in row for : ''. – z3nadrian English

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:
- This can also happen if a line has unmatched " or ' (double or single quotation mark) 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.