Happy Business Starts Here

Highlighted
Zuora Staff

Unable to update BillCycleDay with "Import Customer Accounts" batch update functionality

Problem: 

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"

 

Solution:

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.
For example: 
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,


1.PNG
The below article provides a detailed explanation of the process, 
https://knowledgecenter.zuora.com/BC_Subscription_Management/Customer_Accounts/A_Import_Customer_Acc...
https://knowledgecenter.zuora.com/CB_Billing/WA_Dates_in_Zuora/C_Customer_Account_Dates%3A_Bill_Cycl...