Design discussion with development team - Requirements redefined below:

Progress:

1. All DB development completed
2. Sanjeet to modify Pay Code screen by 29th Nov
3. UAT  to start Week of 30th Nov

XXXXX Group is requesting for the below alteration to their GL integration file for all their deductions paycode.

1. Export file for GL Integration to include a manning field. (The additional field of Position (Manning GL Code) can be used to track the manning dimension in Linksoft
   
   1. All debit entries to be summarised by :
      1. GL, Branch , Cost Centre, and manning type. (Manning type is the third dimension and this is by employee). 
      2. Export file for GL Integration to include a manning field. (The additional field of Position (Manning GL Code) can be used to track the manning dimension in Linksoft
   2. Handling 10% employer contribution. We want this to be allocated to the cost centres also which should be Branch, Department, GL and manning type in a summarised form.(HSUPE)
      
   3. Include the additional 1% accrual for FNTC (levy). This should be summarised by cost centres also which should be Branch, Department, GL and manning type in a summarised form.
2. We get 2.5% commission from BSP and LICI on the gross payment made to them for Insurance, hence the total amount for cheque written is less the commision amount.
3. Add two fields in Menu 311-1. Use fields in PAY CODE screen.
   1. Commission %
   2. GL Code
   3. Group GL Transactions
4. Amend export file to split commission into nominated account code
5. Remove global configuration for "Summarise in export file"
   
6. Amend pay code screen as follows:

1. Create tabs and enable tabs based on Classigication. See "Figure 1" below:

------------------------------------------------------------------------------------------------------------------------------

Hi Sanjeet

Further to my meeting with development team, please find below the costing :

Reddy Group is requesting for the below alteration to their GL integration file for all their deductions paycode.

1. All debit entries to be summarised by :
   • GL, Branch , Cost Centre, and manning type. (Manning type is the third dimension and this is by employee).  (4hours)
   • Import file to include a manning field. (The additional field of Position can be used to track the manning dimension in Linksoft
2. Handling 10% employer contribution. We want this to be allocated to the cost centres also which should be Branch, Department, GL and manning type in a summarised form.(HSUPE) ( 4 hours)
3. Include the additional 1% accrual for FNTC (levy). This should be summarised by cost centres also which should be Branch, Department, GL and manning type in a summarised form. ( 4 hours)
4. We get 2.5% commission from BSP and LICI on the gross payment made to them for Insurance, hence the total amount for cheque written is less the commision amount. We need this to be handled  in the import file.( 4 hours)

Currently the import file  summarises each of the above deduction type by employee number. The description of the deductions will differ in Clyde’s case but the concept will be the same. Please kindly schedule a time so that we can discuss on the costing involved for the above changes

Summary of effort for item 1 only:

Please kindly create quote and send to client for approval.

Kind Regards

Vineet Ram

Hi Akseer,

Quote has been sent. Please update call with followups.

Regards

Sanjeet

Reddy group is requesting for a discount.

See email from Reddy group below:

Hi Sanjeet

Thanks for your email. From my side item 1 is only mandatory. 2-4 are desirables something I can live without.

On a very high level calculation. I have now at least 4 payroll clerks looking after the various properties. After the summary file is created, all they have to do is extract that data into excel and simply multiple by 11% to accrue for FNPF and FNTC and other BSP and LICI commission.

Their average hourly rate comes to around $10. If they spend 1 hour per month doing this, my cost will come to $120 per year. For items 2-4, your cost is 15 hours x $125 cost is $1,875. It will take us 15 years to recover this ROI.

If I do take out item 2-4 then the analysis, design and others will subsequently reduce.

Again on a very high level and coming from a purely ROI prospective, I am happy to proceed with at best $3,500 as the whole package else I don’t mind at all opting for a little bit manual process. It doesn’t make my life easy but neither makes it too difficult.

For your consideration.

Bula Vinaka Shaneel,

I have had a meeting  with my MD yesterday regarding your request. As per my MD, he suggests the following

1. You can continue to pass manual journals and not go ahead with this customization since your cost of doing this manually is very low.

2. You will need to wait for this as our developers are tied with other project. We can build your customization at a cost of $3500 . Release for this patch will be in Late Feb, 2016

3. If you want this developed earlier, the original cost stays.

Regards

Sanjeet

Hi Vineet,

Find below comments from RG.

Please liase with development team for delivery.

"Hi Sanjeet

HI Team

I have spoken to Dhaval on the 4th, 5th and 6th and followed up with the LPO. We have not received this to date. I will update case and disscuss the requirement once once LPO has been received.

Vineet

Hi Team

We have received the LPO (Attached) for this task. Please kindly commence with the development for this.

------------------------------Tasks---------------------------------------

1. Create Demo environment with demo file setup (Shavindar 10-11-2015)
2. Development of this new customized file (Alvis and Sanjay TBA)
3. Testing by Link Fiji team (ShavindarTBA)
   
4. Deployment on site (Shavindar TBA)

Please create the demo environment for this using Reddy Group database and assign this back to me once done so that we can schedule time for this with developers accordingly.

Best Regards

Vineet Ram 

Hi Vineet,

I have scheduled a meeting with Abhishek on Friday (13th Nov) to discuss this case.

Regards

Hi Alvis,

I have restored reddy groups database on 10.0.0.10 (Fiji server)
Database name is : REDDY-LINKSOFT
login: manager ..pswrd: N3tw0rk

Below is the GL report for  the pay updated and attached is the sample CSV file that must be output when pay is updated.
Payrun ID: 1389
Note: Also need to show the Manning in the GL integrated report.

Sample Snap of what the Ouput file should be is below, same has been attached:

NOTE:

1. 

2. For all the pay-codes that will have a code in their additional field 1(UDF 1), Do Not show their manning, BUT show the code in the vendor column. This does not needs to be summarised by manning.
Eg: FLICI (look in the database)

3. All the manning will be entered in the Position in the additional field 1 (UDF 1).
( I have done a sample for the employees who are in this pay)

Hi Shavindar,

I don't understand your comments, is this a change request? It needs to go to awaiting approval then once approved it will be assigned to development and allocated a timeline.

Hi Alvis/Sanjay,

We have received PO for this development as per comment number two (2).

Please advise delivery date.

Regards

Sanjeet

Hi Sanjay,

PO for all four items  as per comment no.2 has been received. Attached is the same. Please confirm delivery date.

Regards

Sanjeet

Development commenced, the following has been completed:

1. Export file for GL Integration to include a manning field. (The additional field of Position (Manning GL Code) can be used to track the manning dimension in Linksoft
   
   1. All debit entries to be summarised by :
      1. GL, Branch , Cost Centre, and manning type. (Manning type is the third dimension and this is by employee). 
      2. Export file for GL Integration to include a manning field. (The additional field of Position (Manning GL Code) can be used to track the manning dimension in Linksoft
   2. Handling 10% employer contribution. We want this to be allocated to the cost centres also which should be Branch, Department, GL and manning type in a summarised form.(HSUPE)
      
   3. Include the additional 1% accrual for FNTC (levy). This should be summarised by cost centres also which should be Branch, Department, GL and manning type in a summarised form.
2. We get 2.5% commission from BSP and LICI on the gross payment made to them for Insurance, hence the total amount for cheque written is less the commision amount.
3. Add two fields in Menu 311-1. Use fields in PAY CODE screen.
   1. Commission %
   2. GL Code
   3. Group GL Transactions
4. Amend export file to split commission into nominated account code

Development completed for the following:

5. Remove global configuration for "Summarise in export file"

The following areas in the system has been affected by this change:

1. Payroll integration to FMIS for the following:
   1. JIWA
   2. EPICOR
   3. CSV
   4. Customization for FICAC 
   5. Customization for FNPF
   6. Customization for HBK
   7. Customization for Housing Authority
   8. Customization for LTA
   9. Customization for Reddy Group
   10. Customization for TLTB
2. Standard payroll journals includes the following entries:
   1. Gross, Taxable allowance, Non-taxable allowance, benefit (cash only), Deductions and Direct Banking
   2. Paycode commission
   3. Net pay journal for cash and cheque paid employees
      
   4. Journal entries for leave taken in this pay
      
   5. Non-Cash benefit GL Entries
      
   6. Leave Accrual Journal entries
      
   7. Leave liability adjustment for pay rate change
      
   8. Government Levy 1%
      
   9. Employer Super (HSUPE)
      
   10. Employer excess and sublimentry GL Entries (DSUEM, DSUSP)
       
   11. Super Guarantee (Applicable for Australian payroll)
   12. Non pay items
   13. Fringe benefit Tax employer journal entries

Updated header with Progress:

1. All DB development completed
2. Sanjeet to modify Pay Code screen by 29th Nov
3. UAT  to start Week of 30th Nov

Working on adding the 3 new fields in paycode maintenance. 

Fields has been separated by tab.

Expected completion 7/12/2015

Hi Vineet,

Completed development work for this call. Will be added to patch this evening. 

Please line in UAT sheet for this qa and delegate QA.

Regards

Sanjeet

Bula Vinaka Team

The below has been performed after net meeting with Alvis today.

Standard Scenario

1. Setup Linksoft and Jiwa7 database on QA1 and upgraded to update 8
2. Created pay for sample group of employees using all possible combination of pay codes from different classification types.
3. Created leave transactions for certain employees
4. Setup deduction paycodes with commision % and commission GL account
5. Created Pay and verified GL integration report.

Issue encounted was with employees having leave transactions. Imbalanced journals was created. This has been resolved in the standard scr and rested. Issue has been resolved.

Reddy Group Scenario

1. Creaed Pay for Bimonthly Payteam
2. Verified the GL intergration report to verify if the journal was balanced.
3. Updated Pay. Error was thrown as invalid GL group transaction field. This has been resolved by alvis and rested. No error thrown upon pay update.
4. Verified if the file out put had the 4th dimension included as well as all ungrouped GL had employee id's as a 5th dimension. Issue was encountered with all ungrouped GL which did not have the employee id as its 5th dimension. This has been fixed now and retested. No issue has been found.

Next step:

1. Contact Reddy group and have their team verify the output file and report from our test environment for final confirmation.
2. Upgrade and test the remaining 6 clients GL integration.

Best Regards

Vineet Ram

Hi Sanjeet

Alvis and I have tested the GL integration testing from our end. We have completed test for all GL interation files and related issues has been resolved.

However there are still issues relating the new paycode screen created. Below is a summary:

Please develop and reassign case for testing.

Note: FNPF and TLTB GL integration hasn't been tested as we do not have their testing environment. This will be tested by clients on their training environment after update 8 is released.

Best regards

Vineet Ram

Hi Sanjeet, given there are so many basic issues wit this screen and we are likely to miss our delivery timeline, I need you to put more effort into ensuring the quality of development.

Before you send an update to all staff to test backoffice changes, you need to hold a net meeting to take everyone through your changes so we dont waste time going back and forth.

Hi Vineet,

Completed the missing check.

Regards

Sanjeet

Bula Team

The above has been tested. The pay codes screen now displays tabs as per the design documented. This issue has been resolved.

Vineet