Overview

1. Customer is implementing LinkSOFT "Payroll and HR" and is planned to go live on 01/08/2021.
2. They are using “Acumatica” for financial reporting.
3. Currently, the finance team gets pay data from the payroll team and prepares a manual file to upload into “Acumatica”. We advised the client that this can be automated with the "Integration" module in LinkSOFT. 

Request

1. LinkSOFT to generate a CSV output file that can be uploaded into Acumatica.
2. Changes to the "Pay FMIS Integration" report. Refer to Figure 2.
   1. The client has requested to add a column in the report to show employee "Cost Centre".
   2. The GL summary at the bottom of the report should:
      1. Group by "Cost Centre".
      2. Show the "Component Description" for the GL Account.

Output format for “Acumatica” is in table 1 below:

 Table 1: “CSV” file columns with field definitions

Hi Team, 

As per the meeting with Sanjay, the following has been updated in the case header.

1. We have modified the design specification to include:
   1. Clarification on which components are part of 
      1. Normal Hours
      2. Deduction
   2. The business approach when an employee is paid medical allowance
2. Evidence of cost has been added under Figure 1 and the approved LPO "LPO_000329.pdf" attached to the case.

Thanks
Rashna

Hi Rashna, can you expand on the following:

1. Discuss the option of using multi-company, one for processing Internal Employees, and another for Client Employees
2. Setup an environment with some data, e.g. GL Accounts, Employees etc so we can see the Normal Pay groupings
3. Move sections of the document that are already compliant to the Appendices section. The document should be specific to changes
4. Move Test cases to Appendices 
5. Change Bullet Points to numbering and cleanup document formatting
6. Label the tables
7. Correct table layout

1. Updated the case header with the modifications to the design requirement as per comment 2.

Next Step

1. Sitla and Rashna to review the document tomorrow at 4 pm. 

Hi Sitla, 

Please provide the quotation to the client as per comment 5.

Thanks
Rashna

Hi Sanjay,

Please go ahead with the development work. The client has approved the cost.
Regards,
Sitla.

1. The change will be available in version:12.50.0722

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

1. In the menu "Integration ~> File Export", for GeneralLedgerJournal, we have added a "FileDataFormat"
2. The following items are different from the design:
   1. The "Cost Center Sub Account" needs to be entered in the Cost Center GL Account - Menu "Payroll and HR Maintenance ~> Territory Branch Cost center"
3. Added a Parameter in the "PAY FMIS Integration Report" to Group By

3. Affected Areas:

1. Integration for GL File Export

4. The issue was caused by:

1. New Feature

5. Notes: Refactored all File Export functions to use "FileDataFormat"
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

Part B: Next Step:UAT

Environment Details

1. OS version:
2. Application version:12.50.0727.GA
3. Setup on:
   1. Server:LinkQA4
   2. Database:CLIENT-MINDPEARL-LINKSOFT
   3. LinkSOFT URL: HTTP://LINKQA2/LinkSOFT
4. Login Details: Standard username and password for user "admin"

Next Step:Review

Updates will be available in 12.51.0806

Hi Sanjay,

Tested case as per comment 15 above- Result passed

Next Step 

Closure