3.6.2 Proration of Future Account Dues

OFSLL has a facility to derive future dated dues on an account using the input file processing mechanism. This helps to view the future dues on accounts in bulk even before posting on the account and without generating a mock statement on the account.

Similar to other input files processing, the required Account numbers and Due Dates on which the due is to be calculated are to be added as individual record in the file and uploaded into the system by placing in input folder path. For more information on this process, refer to above section.

The Input file is processed in the system on running the batch job IADPRC_BJ_100_01 (ACCOUNT DUES FILE UPLOAD) in SET-IFP batch job set and to the location as per the system parameter CMN_FILE_PROCESS_TO_LOB value.

Using an internal function, system calculates the future dated due for the specific Account(s) and stores the computed values in database table. The same has to be queried to view the details. The due amount returned by this function is the regular bill amount calculated with considering any other outstanding dues. This is the proration amount that is posted on the same account before the next due is generated.

Note that, only ACTIVE status accounts are processed. Else system displays an error indicating Invalid Account Status.