Purpose

INTJ0024 completes the process of finalising matched receipts and transactions in Callista 

After the end of a Fee Period or Financial Year

A parameter form is not required for this job, however Message Box (6636) states: No parameters exist for this job. Do you wish to schedule the job to run as soon as possible?

INTJ0024 is a 'master job' comprising several independent processes.

INTJ0024 completes the process of finalising matched receipts and transactions in Callista. INTJ0024 consists of two major components:

• Prepare invoice payment records
• Mark invoice payment records as fully processed

This job runs independently, but accesses invoices created by INTJ0021.

The context for this job is described in the overview.

Run Details

INTJ0024 can only run in batch mode, through the Job Control & Scheduling Subsystem.

Job Conflict

This job has been set up with conflict records preventing it running concurrently with INTJ0020, INTJ0021, INTJ0022, INTJ0023, INTJ0060 and INTJ0065. Nor can several instances of INTJ0024 run simultaneously.

Transfer Statuses

Transfer Status values in I_INVOICE_PAYMENT indicate progress in the transfer of payment-invoice matching information. Statuses are ACTIV, READY, SUCCESSFUL.

Timing

This job will always be the final process for any Fee Period, and interface, processing. Once Fee Periods are finalised, no further changes can be made within Student Finance for that Fee Period, and invoices and receipts cannot be modified in Callista.

Checking on the Job Run

Always check the run log in form JBSF5301 to see that the job ran successfully. Custom built messages in the log indicate the outcomes for each component of the job.

Prepare Records

This module checks for finalised fees in a Fee Period (fee type/calendar instance set to finalised) and sets all associated unprocessed records in the interface table I_INVOICE_PAYMENT to a Transfer Status of READY.

It then immediately takes all READY records and changes the status to SUCCESSFUL.

 Refer to Finalizing Fee Types for more information.

Mark invoice payments records as Fully Processed

The relationship in Callista between a particular payment (in I_PAYMENT) and a particular  invoice (in I_INVOICE_TRANS) at any point in time is recorded in the  I_INVOICE_PAYMENT table.

Payments are fully applied to invoices when the Transaction Amounts in I_INVOICE_PAYMENT are equal to the Transaction Amounts of  I_PAYMENT.

This module sets each fully applied invoice and/or payment as being fully processed in  I_PAYMENT by setting the Processed Status to FULL, and in I_INVOICE_TRANS by setting the Fully Processed Ind to Y.

Rules/Notes:

I_INVOICE_TRANS records are accessed in the view I_INVOICE_TRANS_V.

See Matching Receipts for more information.