Accounts Receivable {FGLP-4}

This option allows the user to do accounts receivable 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 (Y), the Accounts Receivable Sub-System Cycle will be Incremented. On Completion of this posting.
	Last Posting for this cycle (Y)es / (N)o	A1
	This sub-System will be incremented. Are you sure that ALL Required Processes before Period End has been completed?
	Please Enter (Y)es / (N)o	A1

Sort Order	Per	Comments

Example:

Processing Rules
The program firstly select the AR 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. Checks if all Payroll Transactions were copied back to AR If not all Payroll transactions are copied back and the posting is the last posting the Program Stops Processing Check for Unapproved Payment Transactions If Un Approved Exists and Cycle 12 and the Prompt Increment system cyle is "Y" the message "At Year End - Cycle Will Not Be Incremented Here. The Accounts Receivable Subsystem Year End Procedure Must Be Performed"; is written to the output file and the program stops processing. If Un Approved Exists and Secondary Ledger Year End is Due and the Prompt Increment system cyle is "Y" the message "Secondary Ledgers Are At Year End And / Or Unapproved Records Exists, ===== No action taken =====" is written to the ouitput file and the program stops processing. Locks Accounts Receiveable Tables Process change Debtor Currency Process foreign currency profit / loss on paid up foreign currency accounts. Selects the transaction types used in the accounts receivable for all unposted transactions. Selects the posting indicators (summary or detail) on for all unposted accounts receivable of transactions types. Process Summary credit transactions per GLA The fields below are populated as follows GL Note - SUMMARY CREDIT POSTING FROM AR GL Reference - AR-SUMMARY User - SUM-AUTO Process Summary debit transactions per GLA The fields below are populated as follows GL Note - SUMMARY DEBIT POSTING FROM AR GL Reference -AR-SUMMARY User - SUM-AUTO Process detail credit transactions per The fields below are populated as follows GL Note - Debtor Name GL Reference - Document Number Process detail debit transactions per GLA The fields below are populated as follows GL Note - Debtor Name GL Reference - Document Number Update Accounts Receiveable Table Set the following fields: Post Date = System Date Debit / Credit GL Posting Sequences End of AR Postings Increment the AR system cycle If the user answers to the Prompt "Is This The Last Posting For This Period/Cycle, If So The Counter System Cycle Will Be Incremented On Completion Of This Posting - Y/N :" is Y and a year-end close was performedand cycle is less than 12 the cycle is incremented with 1 If the cycle is 12 the Yend Close program FARM-2 increment with 1 and the cycle is set to 1 provided. When the system ic incremented the following sub systems are also incremented HM, AS, CO, CR,SO
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 AR 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.

Checks if all Payroll Transactions were copied back to AR
If not all Payroll transactions are copied back and the posting is the last posting the Program Stops Processing

Check for Unapproved Payment Transactions

If Un Approved Exists and Cycle 12 and the Prompt Increment system cyle is "Y" the message "At Year End - Cycle Will Not Be Incremented Here. The Accounts Receivable Subsystem Year End Procedure Must Be Performed"; is written to the output file and the program stops processing.

If Un Approved Exists and Secondary Ledger Year End is Due and the Prompt Increment system cyle is "Y" the message "Secondary Ledgers Are At Year End And / Or Unapproved Records Exists, ===== No action taken =====" is written to the ouitput file and the program stops processing.

Locks Accounts Receiveable Tables

Process change Debtor Currency

Process foreign currency profit / loss on paid up foreign currency accounts.

Selects the transaction types used in the accounts receivable for all unposted transactions.
Selects the posting indicators (summary or detail) on for all unposted accounts receivable of transactions types.

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

GL Note - SUMMARY CREDIT POSTING FROM AR
GL Reference - AR-SUMMARY
User - SUM-AUTO

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

GL Note - SUMMARY DEBIT POSTING FROM AR
GL Reference -AR-SUMMARY
User - SUM-AUTO

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

GL Note - Debtor Name
GL Reference - Document Number

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

GL Note - Debtor Name
GL Reference - Document Number

Update Accounts Receiveable Table

Set the following fields:

Post Date = System Date
Debit / Credit GL Posting Sequences

End of AR Postings

Increment the AR system cycle
If the user answers to the Prompt "Is This The Last Posting For This Period/Cycle, If So The Counter System Cycle Will Be Incremented On Completion Of This Posting - Y/N :" is Y and a year-end close was performedand cycle is less than 12 the cycle is incremented with 1

If the cycle is 12 the Yend Close program FARM-2 increment with 1 and the cycle is set to 1 provided.

When the system ic incremented the following sub systems are also incremented HM, AS, CO, CR,SO

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	v02.0.0.0	Marchand Hildebrand	t160879	Add GL sequence to link a transaction to a posting
16-Oct-2016	v03.0.0.0	Marchand	t195346	Open Cycles