When uploading the usage record file, csv or excel, the record cannot be uploaded and in the Import Notification: Failed notification, the message looks like:
Import Status: Failed
Status Description: There are some invalid records in this import.
The sample usage file:
Solved! Go to Solution.
In this example, the billing period for July is closed once an invoice is generated using a bill run target date of August 1st. For this monthly charge, setting the bill run target date to the next bill cycle day (that is, August 1st) will close the July billing period and open up the next billing period for August. Once the July billing period is closed, any additional usage records dated in July will not be uploaded and picked up for billing.
As the workaround/resolution, you may cancel the invoice with target date August 1st, this will reopen the July billing period. Upload the usage file and rerun the bill run.