1. Line Collection Setup Guide
  2. Product
  3. Asset Billing Rate
  4. Asset Billing Batch Job

4.7.5 Asset Billing Batch Job

The billing batch job TXNDDT_BJ_100_01 (BILLING/DUE DATES PROCESSING) facilitates to process the asset billing dues on account for Home collateral and posts the corresponding transactions.

Listed below is the sequence of processing steps:
  1. Billing batch job picks-up the Vacation Ownership (VO) parameters from Servicing > Account > Collateral (Home) > Vacation Ownership tab.
    • The required accounts for Asset billing batch job processing is selected based on the type of account selected in Due Amt Account Type field. I.e. in Vacation Ownership Details section if the Billing option is checked and the Due Amt Account Type is selected as Current or Linked or Master Account, then the billing batch job posts the transactions based on Asset Billing Rate setup in Current account or Linked Account of current Account or Master Account of current Account respectively.
    • In addition, system includes the asset billing points of Linked Account/Associated Account only if the status of those accounts are in any of the status defined in lookup code ACC_STATUS_BILLING_CD (ACCOUNT STATUS FOR ASSET BILLING CODES). Account statuses which are not maintained in the lookup code are excluded for asset billing calculation. However, If no statuses are maintained in the lookup, then system will consider all statuses for consolidation.
      • If billing flag is checked and Due Amt Account Type = Current Account, billing batch job posts the transactions based on Asset Billing Rate setup in Current account.
      • If billing flag is checked and Due Amt Account Type = Linked Account, billing batch job post the transactions based on Asset Billing Rate setup in Linked Account of current Account.
      • If billing flag is checked and Due Amt Account Type = Master Account, billing batch job post the transactions based on Asset Billing Rate setup in Master Account of current Account.

      Before the due calculation, batch job validates VO parameters with the following:

    • If the selected Usage Type sub code is FULL, system considers Full points for rate derivation and Billing points is considered for Transaction Amount calculation.
    • If the selected Usage Type sub code is HALF, system considers Billing Points for Transaction Amount calculation but rate is derived using full points.
    • If the First Year Proration check box is selected, then the rate is derived using full points and the Transaction Amount is calculated based on prorated points (not on full points).
    • The prorated points are calculated based on Asset Usage Start Date.

      • If the usage start date year is equal to first due year, then system prorates the points as indicated in example below:

        If First Due Date = 01/01/2018, Usage Start Date = 01/10/2018,

        Prorated Points = Billing Points * (13-1)/12= Billing Points *1

        If First Due Date = 01/01/2018, Usage Start Date = 03/10/2018

        Prorated Points = Billing Points * (13-3)/12= Billing Points*10/12

        Note: Number 13 here is used as constant.

    • If the usage start date year is before the due date year, system considers the full points for calculating the Transaction Amount and no proration is required here.
  2. Batch job looks of best matching Asset Rate details and Asset Billing definition in Setup.
  3. Batch job checks for status (Y/N) of Multiple Billing Asset Rate indicator at Account Details > Contract > Billing level to decide if multiple asset rates are applicable for one billing period or not.
    • If N, system picks the latest rate which is less than or equal to DUE DATE. In this case only one best match record is fetched to derive Transaction Amount and no multiple asset rates are applicable for one billing period.
    • If Y, system fetches multiple rates only when rate End Date (i.e. rate start date + rate frequency) ends with one or more cycle(s) before the next due date. This implies that current rate record does not cover the entire billing period.
    • However, if Multiple Billing Asset Rate is set to Y but there is no Rate available for Due period beyond the Rate End date, system applies the same rate that is picked for Due Period which is Less than or Equal to Due End Date.
  4. Batch job posts the matched transactions at account level based on calculation method. The following Asset Billing Rate Details are stamped on the transaction posted:
    • Asset Id (Assets)
    • Asset Rate Id (Asset Billing Rate Definition)
    • Asset Rate Details Id (Asset Billing Rate Details)
    • Rate Start Date (Asset Billing Rate Details)
    • Rate Frequency (Asset Billing Rate Details)
    • Calculation Method (Asset Billing Rate Details)
    • Rate (Asset Billing Rate Details)
    • In case of Tiered Rate, Effective Rate is stamped
    • Base Points (Asset Billing Rate Details)
    • Slab Points (Asset Billing Rate Details)
    • % Increase (Asset Billing Rate Details)
    • Billing Year (Asset Billing Rate Details)
    On posting the transactions, following validations and outcome are handled:
    • If the respective balance for transaction is missing, batch job fails with an error message indicating Account #: Transaction posting failed Balance not available in Batch > Request Results block and does not process the account due amount calculation.
      • This can be rectified by posting Add balance to Account non-monetary transaction. For more information, refer to Appendix - Non-Monetary transactions section in Servicing User Guides.
    • If the transaction posting failed due to an issue in Access grid configuration or Product configuration at transaction codes, batch job displays error indicating Account #: Transaction posting failed <Reason> and does not process the account due amount calculation.
    • If the Resulted transaction amount is less than Min Amount defined, batch job considers the Min amount and posts the transaction.
    • If the Resulted transaction amount is greater than Max Amount defined, batch job considers the Max amount and posts the transaction.

Parent topic: Asset Billing Rate