Cash Book Sub-System {FGLP-7}

TThe program posts the cash book sub system to the general ledger.

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 Cashbook Sub-System Cycle will be Incremented. On Completion of this posting (Y)es / (N)o	A1

Sort Order	Per	Comments
	Year, Cycle , Transaction Type, Credit , Debit, Cost Centre, Account

Example:

Processing Rules
The program firstly select the CB 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. Select the years and cycles of unposted cash book transactions. Locks the cash book table (FALCBJ) Selects the cashbook transaction types for all unposted transactions. Selects the posting indicators (summary or detail) on for all unposted 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 - CB GL Reference - CB-SUMMARY User - SUM-AUTO Process Summary debit transactions per GLA The fields below are populated as follows GL Note - CONSOLIDATED DEBIT - CB GL Reference - CB-SUMMARY User - SUM-AUTO Process detail credit transactions per GLA The fields below are populated as follows GL Note - Credit CB GL Reference - Bank Reference Process detail debit transactions per GLA The fields below are populated as follows GL Note - Debit CB GL Reference - Bank Reference Update Updaet Cash Book Table Set the following fields: Post = Y Post Date = System Date Debit / Credit GL Posting Sequences End Of Cash Book Subsystem Posting Increment the CB 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 CB 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.

Select the years and cycles of unposted cash book transactions.

Locks the cash book table (FALCBJ)

Selects the cashbook transaction types for all unposted transactions.
Selects the posting indicators (summary or detail) on for all unposted 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 - CB
GL Reference - CB-SUMMARY
User - SUM-AUTO

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

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

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

GL Note - Credit CB
GL Reference - Bank Reference

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

GL Note - Debit CB
GL Reference - Bank Reference

Update Updaet Cash Book Table

Set the following fields:

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

End Of Cash Book Subsystem Posting

Increment the CB 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
01-Jun-2009	v01.0.0.0	Charlene van der Schyff	t158348	New manual format.
28-Jan-2011	v02.0.0.0	Marchand Hildebrand	t160879	Add GL sequence to link transaction to the posting.
16-Oct-2014	V03.0.0.0	Marchand	t195346	Open Cycles