When uploading a file to billing center, the system checks if the file conforms to the required format. The system checks the CSV file row by row for any empty field, missing column or incorrect format and displays its error message accordingly. The row with correct data will be saved in the database but the row with error will be skipped.
The following are the error messages you may encounter when uploading account, bill and payment file with incorrect data or format.
Missing details or empty fields
Missing Mandatory Field: *account_number* in Row: 1;Missing Mandatory Field: *account_name* in Row: 1;Missing Mandatory Field: *connection_date* in Row: 1;Missing Mandatory Field: *status* in Row: 1;Incorrect details
Invalid date format in row <number>. Date format should be mm-dd-yyyyInvalid biller code in row <number>Missing details or empty fields
Missing Mandatory Field: *billing_number* in Row: 1;Missing Mandatory Field: *account_number* in Row: 1;Missing Mandatory Field: *due_date* in Row: 1;Missing Mandatory Field: *issue_date* in Row: 1;Missing Mandatory Field: *service_dateto* in Row: 1;Missing Mandatory Field: *status* in Row: 1;Incorrect Details
Invalid account number in row <number>You cannot upload bill with status PAID in row <number>. To pay bill, upload it's paymentInvalid date format in row <number>. Date format should be mm-dd-yyyyMissing details or empty fields
Missing Mandatory Field: *account_number* in Row: 1;Missing Mandatory Field: *billing_number* in Row: 1;Missing Mandatory Field: *paid_amount* in Row: 1;Missing Mandatory Field: *paid_date* in Row: 1;Missing Mandatory Field: *pay_reference_number* in Row: 1;Missing Mandatory Field: *payment_method* in Row: 1;Incorrect Details
Invalid bill number in row <number>Invalid account number in row <number>Invalid payment method in row <number>Paid amount should be greater than bill amount in row <number>Reference number already exists in row <number>Ň characterÑ (enye letter) but not Ň or any similar variations. If you upload an account with this character, the upload will be unsuccessful and will stop at the row where the error was encountered. However, previous rows will be inserted to the database. Billing center is unable to catch this kind of error and will display In Progress message.In Progress message. Go to the accounts or bills list and refresh the page and eventually all records from the file will reflect in the list.In Progress message.