Bula Alvis,

Reddy Group required the below enhancement to their existing format: 

1. Change in the current file name. 
   The current file name is "2019-11-20T101955-102101.csv" from which users are not able to identify which company and which pay team the file belongs too.
   For better understanding they required the file to be in the format of CompanyID- PayTeam-PayrunID-PayNo-PayDate.csv, for example: 1001-BIMTH-6099-20-20191231.csv
   
   
   
2. Enhancement required in Rule 4: 
   

   Rule 4 : Rules to apply for entries where the GL account is defined in 233 as "GL Account Government Levy", "GL Account Leave Liability", "GL Account Super Liability", "GL Account Tax on Benefit Liability", "GL Account Non-Cash Benefit", "GL Account Non-Pay Items Liability " 

   1. All accounts set at payroll configuration (Menu 233) should display the account number in column C.

   2. For these entries, Columns F to Column M will be left blank except for leave liability GL. For leave liability GL, all dimensions needs to be displayed

    

   Business Scenario for Rules 4

   Employee 1155 is paid the following items in pay number 33

   • Normal Hours of $215.20 (ANHRS)

   • Night Allowance of $15   (NTALLOW)

   • Employer Superannuation deducted of $23.02 (HSUPE)

   • Employee Superannuation of $18.42 (FSUPE)

   • Pay as you earn Tax of $10 (FPAYE)

   • Leave Accruals of $9.93 (ALH1)

   • Employees Net Wages is Deposited in Westpac Bank  $201.78 (WBC)

   Employees Dimensions

   • The GL code set at branch for this employees is TIH

   • The GL code set at Cost Centre for both employees is ADM

   • The employee manning is set as A02.

   Pay code Setup:

   • ANHRS "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

   • NTALLOW "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

   • HSUPE  "GL account code" is set as 3001 and "Group GL transactions" is set to "Yes"

   • FSUPE "GL account Code" is blank, "Creditor Code" is set as "VF008" and "Group GL transactions" is set to "Yes"

   • FPAYE "GL account Code" is blank, "Creditor Code" is set as "VF036" and "Group GL transactions" is set to "Yes"

   • WBC "GL account Code" is blank, "Creditor Code" is set as "TANOA" and "Group GL transactions" is set to "Yes"

   • GL Account Leave Liability at menu 233 is set as 6109

   • GL Account Government Levy at menu 233 is set as VF006

   • GL Account Super Liability at menu 233 is set as VF008

   The GL output file for Superannuation Liability (Credit Entry), Government Levy Liability (Credit Entry), Pay as You earn Liability (Credit Entry), Leave Liability (Credit Entry), Banking amount (Credit Entry) and Duavata Saminiti Club Refund (Debit Entry)would look as below:

   14/08/2018	33-2018	VF008	Employer Super Contribution	- 23.02
   14/08/2018	33-2018	VF008	Employee Superannuation Fund	- 18.42
   14/08/2018	33-2018	VF006	Government Levy	-   2.30
   14/08/2018	33-2018	VF036	PAYE	-    10
   14/08/2018	33-2018	6109	Annual Leave Hotel 0-4	- 9.93	TIH	ADM					A02
   14/08/2018	33-2018	TANOA	Westpac Banking Cooperation	-201.78

Regards
Aarti

Development work for this case has been completed.

The change will be available in version:10.155 & 11.5

1. The following changes were made(Include Database object names, Program classes and any other relevant information):

1. Changed Journal file name format in version 11.5 to <CompanyID>-<PayTeamCode>-<PayrunID>-<PayNo>-<PayDate in format YYYYMMDD>-<datetimestamp>.<FileExtension>. We cannot change the filename format in version 10 due to framework limitations.
2. Changes to rule 4 as requested in case header

2. Affected Areas:

1. Reddy Group GL Journal Output file

3. The issue was caused by:

1. Change request

4. Notes: 
5. Next Step: UAT

The account code is blank because there is no GL Account Code in the pay code setup. Refer to custom rule 5.