Generate Cost Splitting Journals {FPRN-9} 


This program may be used to generate General Ledger journals to distribute salary costs based on the information entered in "Split Salary Costs" {FPRI-11}


Before this program can be used, the following should exist

 
User Selection Prompt Text
* an item between square brackets [ ] is the default answer
Type
&
Length
Comments
Run in (T)rial or (U)pdate Mode A1   
  If the response to prompt 1 is (U)pdate Mode    
2
Reference Number
A12 Will be used as reference for the General Ledger Journals
3
Reference Date
DD-MON-YYYY Will be used as reference date for the General Ledger Journals
 

Example
:

Date : 13-JAN-2010 16:45:04                     ITS Integrator                                      Page:   1
Program : f5wccc.pc v02.0.0.0 Payroll Journal Postings to GL for Payroll Financial Cycle 2008/07
Trial/Update Run: U, Journal Number: 40436, Reference: 13JanRB, Ref. Date: 13-JAN-2009

Trans
GLA Type Debit Credit
0320 0101 991 4000.40
0400 0101 991 2000.20
0400 0101 991 10001.00
1061 0101 991 4000.40
------------------ ------------------
10001.00 10001.00
================== ==================

***** End Of Report *****




Processing
Rules
 
1 The program will validate that for each Person/Start- and End Cycle/Stats Row combination in block 1 of "Split Payroll Costs" {FPRI-11}, the percentage distribution is entered in block 2 of the same screen
2 The program will validate that the total percentage for each Person/Start- and End Cycle/Stats Row as entered in block 2 of "Split Payroll Costs" {FPRI-11} adds up to 100 percent.
3 The program will validate that the GLA's to be used are active for the Financial Year and the subsystem "PR - Payroll".
4 The total amount per GLA for the Person/Stats Row - combination will be calculated and General Ledger Journals will be generated to distribute the amounts according to the percentages indicated.
5 General Ledger Journals will be written
  • The one leg of each journal will use the GLA as used in the Salary- or Late Rollback transaction (This is a reversal of the amounts posted)
  • The other leg will use the Cost Centre indicated on the post to which the amount is distributed and the Account Code as used in the Salary- or Late Rollback transaction
  • The Financial Year- and Cycle of the Payroll System will be used
6 Only transactions that were posted to the General Ledger (Refer to "(Post to )Payroll Subsystem" {FGLP-5}) are included in the calculation.
7 Salary- and Late Rollback transactions that was distributed will be flagged. The program will then exclude transactions that was flagged with a previous run.


See Also:

History of Changes

Date System Version By Whom Job Description
14-Jan-2010 v02.0.0.0 Frans Pelser
t162641 New manual