Company:	Link Technologies
Case No:	L12982. Project: 15.10: LinkSOFT Version 15.10
Logged By:	Sanjay (Link Technologies) on 05 Dec 2023 03:20PM
Priority:	High
Product:	Payroll & HR
Group:	Software Defect
Time Taken:	8.00 (Weight: 4.00)
Assigned To:	Sanjay (Link Technologies)
Circulation:	Nirupa Kumar, Sanjay, Vineshwar Prasad
Resolve By:	Tuesday, 05 December 2023 03:20 PM [147 days since logged date]
Status:	Closed

Subject:

Figures get consolidated into 1 GL Code in the Acumatica FMIS Integration Output File

Summary:

1. Problem Details

Figures get consolidated into 1 GL Code in the Acumatica FMIS Integration Output File

2. Environment Details

Version - 15.10.231129.GA

Audit Notes:

Edited by sanjay on 18/12/23 11:05.

01 Dec 2023

03:13PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 05-12-2023 02:53 PM Time Taken: 4.00 Notes: Edited by sanjay on 05/12/23 15:23. ETC extended from: 30/11/2023 to 05/12/2023

Bula Team,

We did a test in the copy of the Client Database in our Training Environment. Below are the details;

Created Payrun ID: 54

Pay Date	Pay Frequency	Pay Run ID	Employee ID	Employee Name	Pay Code	Pay Code Description	Amount
29/05/2022	Fortnightly	54	XXXXX	XXXXX	ANHRS	Normal Hours	411.23
29/05/2022	Fortnightly	54	XXXXX	XXXXX	FSUPE	Superannuation Fund	-20.56
29/05/2022	Fortnightly	54	XXXXX	XXXXX	HSUPE	Superannuation Fund	20.56
29/05/2022	Fortnightly	54	XXXXX	XXXXX	WBC	Westpac Banking Corporation	-390.67
29/05/2022	Fortnightly	54	XXXXX	XXXXX	ANHRS	Normal Hours	615.38
29/05/2022	Fortnightly	54	XXXXX	XXXXX	BSP	Bank South Pacific	-615.38

FMIS Integration Journal

Account No	Line Description	Reference1	Reference2	Debit	Credit	Seg1	Seg2	Seg3	Seg4	Seg5	Seg6	Seg7	Seg8	Seg9	Seg10	FMIS Ref
330001	Bank South Pacific	BSP	54	0.00	615.38
330001	Superannuation Fund	HSUPE	54	0.00	20.56
330001	Superannuation Fund	FSUPE	54	0.00	20.56
330001	Westpac Banking Corporation	WBC	54	0.00	390.67
420001	Accrued Leave Provision	AAL10	54	0.00	39.49
420001	Accrued Leave Provision	AALYR3	54	0.00	3.95
420001	Accrued Leave Provision	AALYR4	54	0.00	1.58
420001	Accrued Leave Provision	AALYR1	54	0.00	3.95
420001	Accrued Leave Provision	AALYR5	54	0.00	1.58
420001	Accrued Leave Provision	AALYR2	54	0.00	3.95
811100-350	Accrued Leave Expense	AAL10	54	23.67	0.00
811100-350	Normal Hours	ANHRS	54	615.38	0.00
811100-530	Accrued Leave Expense	AAL10	54	15.82	0.00
811100-530	Normal Hours	ANHRS	54	411.23	0.00
811400-350	Accrued Leave Expense	AALYR2	54	2.37	0.00
811400-350	Accrued Leave Expense	AALYR1	54	2.37	0.00
811400-350	Accrued Leave Expense	AALYR3	54	2.37	0.00
811400-530	Accrued Leave Expense	AALYR2	54	1.58	0.00
811400-530	Accrued Leave Expense	AALYR1	54	1.58	0.00
811400-530	Accrued Leave Expense	AALYR3	54	1.58	0.00
811400-530	Accrued Leave Expense	AALYR5	54	1.58	0.00
811400-530	Accrued Leave Expense	AALYR4	54	1.58	0.00
812100-530	Superannuation Fund	HSUPE	54	20.56	0.00
				1,101.67	1,101.67

FMIS Integration Output File

SUV1	330001	Salary Control	0	XXXXX	20231201	EA	0	615.38	Bank South Pacific
SUV1	330001	Salary Control	0	XXXXX	20231201	EA	0	20.56	Superannuation Fund
SUV1	330001	Salary Control	0	XXXXX	20231201	EA	0	20.56	Superannuation Fund
SUV1	330001	Salary Control	0	XXXXX	20231201	EA	0	390.67	Westpac Banking Corporation
SUV1	420001	Accrual - Leave	0	XXXXX	20231201	EA	0	39.49	Accrued Leave Provision
SUV1	420001	Accrual - Leave	0	XXXXX	20231201	EA	0	3.95	Accrued Leave Provision
SUV1	420001	Accrual - Leave	0	XXXXX	20231201	EA	0	3.95	Accrued Leave Provision
SUV1	420001	Accrual - Leave	0	XXXXX	20231201	EA	0	3.95	Accrued Leave Provision
SUV1	420001	Accrual - Leave	0	XXXXX	20231201	EA	0	1.58	Accrued Leave Provision
SUV1	420001	Accrual - Leave	0	XXXXX	20231201	EA	0	1.58	Accrued Leave Provision
SUV1	811100		530	XXXXX	20231201	EA	39.49	0	Accrued Leave Expense
SUV1	811100		530	XXXXX	20231201	EA	1026.61	0	Normal Hours
SUV1	811400		530	XXXXX	20231201	EA	3.95	0	Accrued Leave Expense
SUV1	811400		530	XXXXX	20231201	EA	3.95	0	Accrued Leave Expense
SUV1	811400		530	XXXXX	20231201	EA	3.95	0	Accrued Leave Expense
SUV1	811400		530	XXXXX	20231201	EA	1.58	0	Accrued Leave Expense
SUV1	811400		530	XXXXX	20231201	EA	1.58	0	Accrued Leave Expense
SUV1	812100		530	XXXXX	20231201	EA	20.56	0	Superannuation Fund

The FMIS Integration Output File has grouped the Data by similar Reference1. Example;

Data from FMIS Integration Journal

Account No

Line Description

Reference1

Reference2

Debit

Credit

Seg1

Seg2

Seg3

Seg4

Seg5

Seg6

Seg7

Seg8

Seg9

Seg10

FMIS Ref

811100-350

Accrued Leave Expense

AAL10

23.67

0.00

811100-530

Accrued Leave Expense

AAL10

15.82

0.00

811100-350

Normal Hours

ANHRS

615.38

0.00

811100-530

Normal Hours

ANHRS

411.23

0.00

Output in FMIS Integration File
SUV1
811100

530
XXXXX
20231201
0
EA
39.49
0
Accrued Leave Expense
SUV1
811100

530
XXXXX
20231201
0
EA
1026.61
0
Normal Hours

Below are the environmental details

Database Hosted on: LINKQA4
Database Name: CLIENT-XXXXX
Version: 15.10.231129.GA
URL: http://LinkQA1-EBS/XXXXX

We will get our technical team to diagnose further and advise.

Regards
Vineshwar Prasad

05 Dec 2023

03:20PM Comment 2 by Sanjay (Link Technologies) Case L12982 added to project 15.10

05 Dec 2023

03:28PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 05-12-2023 09:23 PM Time Taken: 4.00

PART A - Development work for this case has been completed.

1. The change will be available in version: 15.10.231205 and individual Patch for 14.X (LinkSOFT_14.XX_E02704_AcumaticaFileGroup.zip)

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

File Data grouping changed to "Paycode, PayCodeGL, CostCenter"
Changed "order by" to "Branch,Account,SubAccount"

3. Affected Areas:

FMIS Integration for Acumatica. We found that in version 12, the grouping was by GL Account, not PaycodeGL Account.

4. The issue was caused by:

Client identified the change in version 14. We don't know the reason this group was removed. Since "MindPearl" is the only client using this integration, we will monitor this output file for anomalies.

5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): Close

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

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