Unable to update BillCycleDay with "Import Customer Accounts" batch update functionality
When I try to upload a CSV to Import customer accounts to update the Bill Cycle Day, I get these warnings (and the BCD isn't updated)
"Warning on Line 2: Bill Cycle Day in system not found Bill Cycle Day:20"
It was due to the wrong usage of the BCD format in the template, The correct format is "XX of the month" where XX denotes the date.
If the bill cycle day is 1, the correct format would be 1st of the month
If the bill cycle day is 2, the correct format would be 2nd of the month
If the bill cycle day is 3, the correct format would be 3rd of the month
If the bill cycle day is 20, the correct format would be 20th of the month
In case if you provide only the date as 20, you will get an error as per the below screenshot,
The below article provides a detailed explanation of the process,