Student Debtors {FGLP-2}

This option will allow the user to do student debtor postings.

User Selection	Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
	Is this the last posting for this Period / Cycle, if so: the Student Debtor Cycle will be Incremented.
	On Completion of this posting (Y)es / (N)o	A1
	Your Next SD Interest Calculation is on the : DATE WILL BE SPECIFIED.
	Is the above Date correct for the Next Cycle	A1

Sort Order	Per	Comments

Example:

Processing Rules
The program firstly select the SD financial year and cycle from the financial system cycles table {FCSM-2}, the year and cycle is used to determine the current year cycle of the subsystem and used when incrementing the cycles. If last posting the program validates the value of the system operational paramtere code RA - '"Apply Student Income Recognition" If (Y)es It firther validates that a path have been set up for the function "CONSUM" in {BATCH-7}. Selects the next interest date as per code SJ - "Date Next Interest Calculated" {FCSM-1b2) and prompts the user "Your next SD Interest Calculation is on date "Is the above date for the next cycle (Y/N)" If not Y The program returns "The SD Month End Process will not continue. Do the SD Interest Calculation first Then re-do your SD Month End. Please enter to proceed. and stops processing Else Checks if all Payroll Transactions were copied back to SD Check for Unapproved Payment Transactions If Un Approved Exists and Cycle 12 and the Prompt Increment system cycle is "Y" the message "THERE ARE UNAPPROVED RECORDS IN THE SD SYSTEM (See List Above).A YEAR END MAY ONLY BE PROCESSED AFTER THESE RECORDS HAVE BEEN APPROVED AND/OR REJECTED. ===== No action taken =====) Select the years and cycles of unposted cash book transactions. Locks the cash book table (IAMLOG) Selects the SD transaction types for all un-posted transactions. Selects the posting indicators (summary or detail) on for all un-posted cash book transactions types flagged to post to GL. Process Summary credit transactions per GLA The fields below are populated as follows GL Note - CONSOLIDATED CREDIT - SD GL Reference - SD-SUMMARY User - SUM-AUTO Process Summary debit transactions per GLA The fields below are populated as follows GL Note - CONSOLIDATED DEBIT - SD GL Reference - SD-SUMMARY User - SUM-AUTO Process detail credit transactions per GLA The fields below are populated as follows GL Note - Student Number GL Reference - Reference Number Process detail debit transactions per GLA The fields below are populated as follows GL Note - Student Number GL Reference - Reference Number Update Updaet Cash Book Table Set the following fields: Post = Y Post Date = System Date Debit / Credit GL Posting Sequences End Of SD Subsystem Posting Increment the SD system cycle If the user answers to the Prompt "Is This The Last Posting For This Period/Cycle, If So The Cash Book System Cycle Will Be Incremented On Completion Of This Posting - Y/N :" is Y. If Y and the cycle is less than 12 the cycle is incremented with 1 If the cycle is 12 the year is incremented with 1 and the cycle is set to 1.
When posting to the General ledger transactions are posted into the cycle that was committed / saved on the record when the transaction was created. On creating a transaction the cycle is obtained from the subsystem definition {FCSM-2} which is incremented through this program when a final posting is done. If the “Open Cycles” are used the cycle is derived from the document / reference date on the transaction. If the derived cycle is equal or greater to the system cycle for the subsystem {FCSM-2} the derived cycle is used as the transaction cycle. If the derived cycle is less than the system cycle for the subsystem, the system cycle is used as the transaction cycle.

Processing
Rules

The program firstly select the SD financial year and cycle from the financial system cycles table {FCSM-2}, the year and cycle is used to determine the current year cycle of the subsystem and used when incrementing the cycles.

If last posting the program validates the value of the system operational paramtere code RA - '"Apply Student Income Recognition"
If (Y)es
It firther validates that a path have been set up for the function "CONSUM" in {BATCH-7}.

Selects the next interest date as per code SJ - "Date Next Interest Calculated" {FCSM-1b2) and prompts the user "Your next SD Interest Calculation is on date "Is the above date for the next cycle (Y/N)"
If not Y
The program returns "The SD Month End Process will not continue. Do the SD Interest Calculation first Then re-do your SD Month End. Please enter to proceed. and stops processing
Else
Checks if all Payroll Transactions were copied back to SD

Check for Unapproved Payment Transactions
If Un Approved Exists and Cycle 12 and the Prompt Increment system cycle is "Y" the message "THERE ARE UNAPPROVED RECORDS IN THE SD SYSTEM (See List Above).A YEAR END MAY ONLY BE PROCESSED AFTER THESE RECORDS HAVE BEEN APPROVED AND/OR REJECTED. ===== No action taken =====)

Select the years and cycles of unposted cash book transactions.

Locks the cash book table (IAMLOG)

Selects the SD transaction types for all un-posted transactions.
Selects the posting indicators (summary or detail) on for all un-posted cash book transactions types flagged to post to GL.

Process Summary credit transactions per GLA
The fields below are populated as follows

GL Note - CONSOLIDATED CREDIT - SD
GL Reference - SD-SUMMARY
User - SUM-AUTO

Process Summary debit transactions per GLA
The fields below are populated as follows

GL Note - CONSOLIDATED DEBIT - SD
GL Reference - SD-SUMMARY
User - SUM-AUTO

Process detail credit transactions per GLA
The fields below are populated as follows

GL Note - Student Number
GL Reference - Reference Number

Process detail debit transactions per GLA
The fields below are populated as follows

GL Note - Student Number
GL Reference - Reference Number

Update Updaet Cash Book Table

Set the following fields:

Post = Y
Post Date = System Date
Debit / Credit GL Posting Sequences

End Of SD Subsystem Posting

Increment the SD system cycle
If the user answers to the Prompt "Is This The Last Posting For This Period/Cycle, If So The Cash Book System Cycle Will Be Incremented On Completion Of This Posting - Y/N :" is Y.

If Y and the cycle is less than 12 the cycle is incremented with 1
If the cycle is 12 the year is incremented with 1 and the cycle is set to 1.

When posting to the General ledger transactions are posted into the cycle that was committed / saved on the record when the transaction was created. On creating a transaction the cycle is obtained from the subsystem definition {FCSM-2} which is incremented through this program when a final posting is done. If the “Open Cycles” are used the cycle is derived from the document / reference date on the transaction. If the derived cycle is equal or greater to the system cycle for the subsystem {FCSM-2} the derived cycle is used as the transaction cycle. If the derived cycle is less than the system cycle for the subsystem, the system cycle is used as the transaction cycle.

History of Changes

Date	System Version	By Whom	Job	Description
26-Oct-2010	v02.0.0.0	Marchand Hildebrand	t160879	Add GL sequence to link transaction to a posting
14-Oct-2011	v02.0.0.1	Marchand Hildebrand	f178105	maual corrections SOD RA
16-Oct-2014	v03.0.0.0	Marchand	t195346	Open Cycles