Default Bill Cutoff Date
Until now, on clicking the Generate button in the Bill screen, the Generate window appeared where the cutoff date was set to the system date. Now, to address some of the business requirements, the system will drive the default cutoff date based on the below stated logic.
If one or more completed bills exist for the account, the system will consider all its frozen bill segments and derive the start or end date of the bill segment with the latest date. The system considers the bill segment start or end date depending on whether the Billable Charges Date - Non Recurring option type of the C1_FINTRANOP feature configuration is set to S or E, respectively.
If the Billable Charges Date - Non Recurring option type of the C1_FINTRANOP feature configuration is set to S, the system will derive the start date of the frozen bill segment with the latest date. Similarly, if the Billable Charges Date - Non Recurring option type of the C1_FINTRANOP feature configuration is set to E, the system will derive the end date of the frozen bill segment with the latest date. Once the latest frozen bill segment date of the account is available, the system derives the next window end date of the bill cycle after the latest frozen bill segment date and sets it as the default cutoff date. However, if the bill cycle is not defined for the account or if the next window is not defined in the bill cycle, the system sets the system date as the default cutoff date.
If you are generating a bill for an account for the first time or if all the bills of the account are canceled for any reason, the system considers the account setup date or bill on or after date whichever is latest. If the bill on or after date is not defined for the account or if the latest date is the account setup date, the system derives the next window end date of the bill cycle after the account setup date and sets it as the default cutoff date. If the latest date is the bill on or after date and if the next window end date after the latest date is earlier than the system date, the system sets the next window end date as the default cutoff date. However, if the latest date is the bill on or after date and if the next window end date after the latest date is later than the system date, the system sets the system date as the default cutoff date.
Let us understand the above stated logic with the help of the following scenarios. Here, we have assumed that the Billable Charges Date - Non Recurring option type of the C1_FINTRANOP feature configuration is set to E in the system.
Scenario | Account | Bill | Bill Segment | Bill Segment Start Date | Bill Segment End Date | Account Setup Date | Bill On or After Date | Latest Bill Date | System Date | Derived Window | Default Cutoff Date |
---|---|---|---|---|---|---|---|---|---|---|---|
S1 | A1 | B1 | BS1 | 01-Jan-2020 | 15-Jan-2020 | 31-Dec-2019 | - | 31-Mar-2020 | 01-May-2020 | 01-Apr-2020 - 30-Apr-2020 | 30-Apr-2020 |
BS2 | 01-Jan-2020 | 01-Jan-2020 | |||||||||
B2 | BS3 | 01-Feb-2020 | 15-Feb-2020 | ||||||||
BS4 | 01-Feb-2020 | 29-Feb-2020 | |||||||||
B3 | BS5 | 01-Mar-2020 | 15-Mar-2020 | ||||||||
BS6 | 15-Mar-2020 | 31-Mar-2020 | |||||||||
S2 | A2 | B1 | BS1 | 01-Jan-2020 | 15-Jan-2020 | 31-Dec-2019 | - | 31-Mar-2020 | 01-May-2020 | No window is available after 31-Mar-2020 in the account's bill cycle | 01-May-2020 |
BS2 | 01-Jan-2020 | 01-Jan-2020 | |||||||||
B2 | BS3 | 01-Feb-2020 | 15-Feb-2020 | ||||||||
BS4 | 01-Feb-2020 | 29-Feb-2020 | |||||||||
B3 | BS5 | 01-Mar-2020 | 15-Mar-2020 | ||||||||
BS6 | 15-Mar-2020 | 31-Mar-2020 | |||||||||
S3 | A3 | - | - | - | - | 31-Dec-2019 | - | 31-Dec-2019 | 01-May-2020 | 01-Jan-2020 -31-Jan-2020 | 31-Jan-2020 |
S4 | A4 | - | - | - | - | 31-Dec-2019 | 31-May-2020 | 31-May-2020 | 01-Jun-2020 | 01-Jun-2020 -30-Jun-2020 | 01-Jun-2020 |
S5 | A5 | - | - | - | - | 31-Dec-2019 | 31-Mar-2020 | 31-Mar-2020 | 01-Jun-2020 | 01-Apr-2020 -30-Apr-2020 | 30-Apr-2020 |
S6 | A6 | - | - | - | - | 31-Dec-2019 | 31-May-2020 | 31-May-2020 | 01-May-2020 | - | - |
Scenario 1 - The system sets the next window end date of the bill cycle after the latest frozen bill segment date as the default cutoff date.
Scenario 2 - The system sets the system date as the default cutoff date because next window does not exist in the bill cycle.
Scenario 3 - The system sets the next window end date of the bill cycle after the account setup date as the default cutoff date.
Scenario 4 - The system sets the system date as the default cutoff date because the next window end date is later than the system date.
Scenario 5 - The system sets the next window end date as the default cutoff date because it is earlier than the system date.
Scenario 6 - No default cutoff date is derived because the bill after date is later than the system date.
If the bill on or after date does not exist for the account or if the bill on or after date is earlier than or equal to than the system date, the system, by default, displays the cutoff date. An appropriate message appears in the Generate window that indicates how the default cutoff date is derived for the account. You can change the cutoff date, if required.
However, if the bill on or after date is later than the system date, the system, by default, does not display the cutoff date and the Calculate button is also disabled in the Generate window. Note that the Calculate button is disabled because you cannot generate a bill for the account until the bill on or after date. An appropriate message appears in the Generate window indicating the reason why the system could not derive the default cutoff date.
Note that the above default cutoff date derivation logic is only available when you create a bill for an account from the user interface.