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 [135 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
  1. Version - 15.10.231129.GA
Audit Notes:Edited by sanjay on 18/12/23 11:05. 
01 Dec 202303: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

0

EA

0

615.38

Bank South Pacific

SUV1

330001

Salary Control

0

XXXXX

20231201

0

EA

0

20.56

Superannuation Fund

SUV1

330001

Salary Control

0

XXXXX

20231201

0

EA

0

20.56

Superannuation Fund

SUV1

330001

Salary Control

0

XXXXX

20231201

0

EA

0

390.67

Westpac Banking Corporation

SUV1

420001

Accrual - Leave

0

XXXXX

20231201

0

EA

0

39.49

Accrued Leave Provision

SUV1

420001

Accrual - Leave

0

XXXXX

20231201

0

EA

0

3.95

Accrued Leave Provision

SUV1

420001

Accrual - Leave

0

XXXXX

20231201

0

EA

0

3.95

Accrued Leave Provision

SUV1

420001

Accrual - Leave

0

XXXXX

20231201

0

EA

0

3.95

Accrued Leave Provision

SUV1

420001

Accrual - Leave

0

XXXXX

20231201

0

EA

0

1.58

Accrued Leave Provision

SUV1

420001

Accrual - Leave

0

XXXXX

20231201

0

EA

0

1.58

Accrued Leave Provision

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

SUV1

811400

 

530

XXXXX

20231201

0

EA

3.95

0

Accrued Leave Expense

SUV1

811400

 

530

XXXXX

20231201

0

EA

3.95

0

Accrued Leave Expense

SUV1

811400

 

530

XXXXX

20231201

0

EA

3.95

0

Accrued Leave Expense

SUV1

811400

 

530

XXXXX

20231201

0

EA

1.58

0

Accrued Leave Expense

SUV1

811400

 

530

XXXXX

20231201

0

EA

1.58

0

Accrued Leave Expense

SUV1

812100

 

530

XXXXX

20231201

0

EA

20.56

0

Superannuation Fund


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

  1. 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

    54

    23.67

    0.00

     

     

     

     

     

     

     

     

     

     

     

    811100-530

    Accrued Leave Expense

    AAL10

    54

    15.82

    0.00

     

     

     

     

     

     

     

     

     

     

     

    811100-350

    Normal Hours

    ANHRS

    54

    615.38

    0.00

     

     

     

     

     

     

     

     

     

     

     

    811100-530

    Normal Hours

    ANHRS

    54

    411.23

    0.00

     

     

     

     

     

     

     

     

     

     

     


  2. 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
  1. Database Hosted on: LINKQA4
  2. Database Name: CLIENT-XXXXX
  3. Version: 15.10.231129.GA
  4. URL: http://LinkQA1-EBS/XXXXX
We will get our technical team to diagnose further and advise.

Regards
Vineshwar Prasad

05 Dec 202303:20PM Comment 2 by Sanjay (Link Technologies) Case L12982 added to project 15.10
05 Dec 202303: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):

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

     

3. Affected Areas:

  1. 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:

  1. 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