Company: Link Technologies
Case No: L12264. Project: 12.50: LinkSOFT Version 12.50
Logged By: Rashna (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 19 May 2021 03:13PM
Priority: Medium
Product: Payroll & HR
Group: New Feature
Time Taken: 38.00 (Weight: 40.00)
Version: 12.50.0726
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay, Sitla Sharma, Vineshwar Prasad
Resolve By: Thursday, 05 August 2021 11:59 PM [1065 days since logged date]
Status: Closed
Subject: “Acumatica” GL integration to LinkSOFT Payroll using CSV File Export
Summary:    

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

Field

Type

Size

Column

Comments

LinkSOFT

Branch

Text

4

A

Always “SUV1”



Account.


Code


6


B

GL Account Code

“GL Account Code” from “Paycodes” in LinkSOFT

Description

Text

30

C

GL Account Code description from Acumatica.

Menu: “Integration ~> GL Accounts” User will manually maintain this

SubAccount

Code

3

D

Cost Centre Code

  1. “Cost Centre Code” assigned to the employees from “Employee Maintenance – Employee Profile”.

  2. For components that are balance sheet items example “Salary Control” the “Sub Account” to be 000.



Ref Number

Code

14

E

Pay Sequence Number and Pay Date

Payroll Processing – Pay Processing

Format: PAYTEAMPAYNODDMMYYYY
FTN46025052021

Transaction Date

Date

8

F


Payroll Processing – Pay Processing (Bank Date) Format: YYYYMMDD

Quantity

Numeric

2

G

Always 0


UOM

Text

6

H

Always  “EA”


Debit Amount

Numeric

15

I

round to 2 dp

grouped by Cost Centre

Credit Amount

Numeric

15

J

round to 2 dp

grouped by Pay Code

Transaction Description

Text

50

K


Paycode Description

Reclassification Batch

Text

N/A

L

Empty String i.e. “”



Audit Notes:Edited by sanjay on 06/08/21 11:08. Edited by sanjay on 23/07/21 08:26. Edited by sanjay on 22/07/21 16:48. Edited by sanjay on 22/07/21 11:40. Edited by sanjay on 22/07/21 11:35. Edited by sanjay on 21/07/21 15:15. Edited by sanjay on 20/07/21 09:13. Edited by rashna on 14/07/21 14:06. Edited by rashna on 14/07/21 14:01. Edited by rashna on 14/07/21 06:38. Edited by rashna on 13/07/21 16:39. Edited by rashna on 01/07/21 14:30. Edited by rashna on 01/07/21 14:13. Edited by rashna on 01/07/21 10:54. Edited by rashna on 01/07/21 10:50. Edited by rashna on 29/06/21 13:49. Edited by rashna on 10/06/21 09:49. Edited by rashna on 31/05/21 10:22. Edited by rashna on 19/05/21 15:13. Edited by rashna on 19/05/21 15:13. Edited by rashna on 19/05/21 15:00. Edited by rashna on 19/05/21 14:55. 
10 Jun 202109:54AM Comment 1 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 11-06-2021 01:49 PM Time Taken: 5.00 Notes: ETC extended from: 20/05/2021 to 11/06/2021

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


01 Jul 202103:44PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 01-07-2021 06:31 PM Time Taken: 2.00 Notes: Edited by sanjay on 22/07/21 11:37. 

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

13 Jul 202104:41PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 14-07-2021 08:39 PM Time Taken: 1.00 Notes: ETC extended from: 11/06/2021 to 14/07/2021
  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. 

14 Jul 202102:19PM Comment 4 by Rashna (Edge Business Solutions) This comment has been removed
15 Jul 202106:14PM Comment 5 by Sanjay (Link Technologies) This comment has been removed
15 Jul 202107:30PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sitla Sharma (Edge Business Solutions) Followup Date: 16-07-2021 11:26 PM Time Taken: 0.50 Notes: Edited by rashna on 15/07/21 19:32. ETC extended from: 15/07/2021 to 16/07/2021

Hi Sitla, 

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

Thanks
Rashna


19 Jul 202109:24AM Comment 7 by Sitla Sharma (Edge Business Solutions) This comment has been removed
19 Jul 202103:49PM Comment 8 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-07-2021 07:48 PM

Hi Sanjay,

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


19 Jul 202105:36PM Comment 9 by Sanjay (Link Technologies) Case L12264 added to project 12.45
19 Jul 202105:38PM Comment 10 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-07-2021 09:36 PM Time Taken: 0.50
Cost allocated to Edge Business Solutions 

20 Jul 202109:13AM Comment 11 by Sanjay (Link Technologies) ETC was changed from 16/07/2021 to 16/07/2021
22 Jul 202111:30AM Comment 12 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 22-07-2021 03:23 PM Time Taken: 18.00
PART A - Development work for this case has been completed.

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


22 Jul 202104:06PM Comment 13 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-07-2021 04:04 PM Time Taken: 1.00 Notes: Edited by sanjay on 23/07/21 08:47. 
Part A - System Test/UAT Results
1. Developer comments are complete and accurate(Yes/No):
2. Complete Table 1 below:

Table 1 - Test Results
Test NoTest CasePass/FailComments
1
Created a new pay
pass

2
Verify changes to Pay FMIS Integration Report has the option to group by cost centre
pass

3
Close pay and verify the GL Journal output file format
pass





Part B: Next Step:UAT


04 Aug 202103:54PM Comment 14 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 05-08-2021 03:05 PM Time Taken: 6.00 Notes: ETC extended from: 16/07/2021 to 05/08/2021
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1HR Maintenance -> Cost Centre
  1. Can update GL Code
  2. "GL Code" is populated on "Pay FMIS Integration Report"
  3. "GL Code" is populated on "GL Journal File"
Pass
 
 2Integration -> GL Account
  1. Can Add records
  2. Cost Centre GL Code is populated on "GL Journal File"
  3. "Description" is populated on "GL Journal File"
Pass
 
 3Pay Processing
  1. Create a New Pay
  2. Update Pay
Pass
 
 4
Changes to "Pay FMIS Integration Report" has option to Group by Cost Centre
Pass

 5
Pay FMIS Integration Report
  1. Summary of GL Transaction to display Cost Centre
Pass

 6
Pay FMIS Integration Report
  1. Summary of GL Transaction to display Pay Component Description
Fail
refer Design Document 1.1.2.4.b
 7
Data flows to menu "FMIS Integration"
Pass

 8
Integration -> GL Journal
  1. Data flows to menu "GL Journal"
  2. Can Locate File in Attachments
  3. Can Download File from Attachments
Pass

 9
GL Journal File
  1. Data in File is in correct column
  2. Data in File is grouped correctly
Pass

 10
Data in File has correct Rows
Fail
1 extra Row at the end of the File

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


06 Aug 202109:10AM Comment 15 by Sanjay (Link Technologies) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 10-08-2021 08:11 AM Time Taken: 1.00
Table 1 - Test Results
#Test Case DetailsPass/FailCommentsDeveloper Comments
 6
Pay FMIS Integration Report
  1. Summary of GL Transaction to display Pay Component Description
Fail
refer Design Document 1.1.2.4.b
Changed the report to include the pay code description in the summary section
 10
Data in File has correct Rows
Fail
1 extra Row at the end of the FileThe extra line is due to the carriage return on the last data line. This is the standard behaviour of CSV files.

Updates will be available in 12.51.0806


06 Aug 202111:08AM Comment 16 by Sanjay (Link Technologies) ETC was changed from 05/08/2021 to 05/08/2021
06 Aug 202103:57PM Comment 17 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-08-2021 03:53 PM

Hi Sanjay,

Tested case as per comment 15 above- Result passed


Next Step 

Closure


09 Aug 202102:03PM Comment 18 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 10-08-2021 02:02 PM
Thanks Rashna

If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12264 in the subject line of all emails regarding this issue.

Document size: 53.5 KB
For call complaints, please contact the Managing Director of the company using this form