Generate 3rd Party ACB Payments Tape Trial  {FPRN-30}

The purpose of this menu option is to generate 3rd Party ACB Tapes in Trial only. The program functionality also caters for late calcs, rollbacks and recalced transactions from current or prior cycles into consideration when creating the current month’s file.

Before this program may be used, payments should be generated with Generate Payments {FPRN-5}.
The report can be run using the batch prompts below:
                          
Field Type
&
Length		 Description
Supply 1st  of  9 Calculation number or [ALL] N1
Supply 1st of 10 Calculation Sequence Number or [Return] N1
Must this Calc Number and Sequence be Included in Tape? A1
Supply 2nd of 10 Calc. Sequence Numbers or [RETURN]
Enter the Earliest Pay Cycle to Include N6 DD-MON-YYYY

The Pay Cycle in which the program will select the transaction to include
Enter Report Code 1 of 30 or ALL N2
NB: {FPRN-30} Trial Mode only; GLA transactions created when Update Mode is run 
Run in [T]rial only or [U]pdate mode		 A1 Default parameter “T” to restrict to only trial mode.
 
Note: Local Software development is required to generate the ACB in the required format by the Institution using this functionality.  The client specific Local Software program is called when running this process and the option to run in Trial or Update Mode is available.  For client’s that have not had Local Software development, Trial only mode is available.  ****PLEASE NOTE**** When run in Update Mode, the GLA Transactions are generated and posted into the ITS Integrator Finance System

Processing Rules:

When the option is executed in Trial Mode:
  1.  Program will Include all transactions where the payroll cycle falls within the start date of event K and the cycle of event K and the tape generation number is null and the Ed code is linked to a Group Code which is linked to a Report Code entered in the batch prompts and for the specific calc number and sequence number entered in the batch prompt for which an event “C”and “Q” exists for the specified calc number and sequence number.
  2. No update will be made to the system
  3. The program will generate the following 5 reports for validation purposes
When the option is executed in Update  Mode:
  1. Program will Include all transactions where the payroll cycle falls within the start date of event K and the cycle of event K and the tape generation number is null and the Ed code is linked to a Group Code which is linked to a Report Code entered in the batch prompts and for the specific calc number and sequence number entered in the batch prompt for which an event “C”and “Q” exists for the specified calc number and sequence number.
  2. Record will be inserted in the log file {FPRM-3}.
  3. GLA Postings and Cashbook transaction will be created {FGLPR1-5}
  4. ACB Tape will be generated
  5. The program will generate the following 5 reports for validation purposes

Example:
fprn-30p2.jpg
Excel Detail Report
fprn-30p1.jpg
ACB Tabe Report

fprn-30p3.jpg

Summary Report
fprn-30p4.jpg



Detail Report
fprn-30p5.jpg
Postings and Cah Book Journals
fprn-30p6.jpg



History Of Changes

Date System Version By Whom Job Description
07-Aug-2017
 v03.0.0.0 Sakhile Ntimane t222536 New Development
20-Mar-2020 v04.1.0.0 Nomhle Lubisi t242048 Added new processing rules and integretor screen sprint