Company: Link Technologies
Case No: L12659. Project: 13.30: LinkSOFT Version 13.30
Logged By: Sitla Sharma (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 30 Nov 2021 07:13PM
Priority: Medium
Product: Payroll & HR
Group: Software Defect
Time Taken: 46.00 (Weight: 52.00)
Version: 13.30
Assigned To: Development
Circulation: Development, Sanjay, Sitla Sharma, Vineshwar Prasad
Resolve By: Tuesday, 04 January 2022 11:59 PM [870 days since logged date]
Status: Closed
Subject: Sub Account not showing in File Export for Acumatica
Summary:    
Section A - Describe what the issue is about. Include Error Message (Include screenshots) 

Sub Account not showing in File Export for Deduction Pay Codes

Table 1: 
Environment Details where this issue can be seen
Server Name: LINKQA4
Database name: DEMO-LINKOFT
Application Hosted on: https://www.link247.com.au/LinkCustomerSupport
LinkSOFT Version:13.11.1021.GA 

Section B. The issue can be reproduced by performing the following steps: 
  1. Update GL Code on the following Pay Codes
    • FSL - Staff Loan Deduction - 5001
    • UNIF - Uniform Fee - 5002
    • FSCLB - Staff Social Club - 5003
  2. Created entries under GL Accounts
    • 5001 - Staff Loan
    • 5002 - Uniform
  3. Created Pay
    • Pay No - 507
    • Emp - E029
Audit Notes:Edited by sanjay on 22/02/22 15:16. Edited by sanjay on 18/02/22 10:15. Edited by sanjay on 27/01/22 16:56. Edited by sanjay on 25/01/22 16:12. Edited by sanjay on 14/01/22 11:02. 
07 Dec 202107:16AM Comment 1 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 10-12-2021 09:15 AM Notes: ETC extended from: 15/12/2021 to 10/12/2021

Hi Sanjay, Need a solution to this case as the client is not able to complete their month-end.


08 Dec 202108:53AM Comment 2 by Sanjay (Link Technologies) Assigned To: Sitla Sharma (Edge Business Solutions) Followup Date: 09-12-2021 10:50 AM Time Taken: 1.00
Hi Sitla, there is not enough information on this case for me to address.

Bring this to a discussion on Teams and show me what the issue is. You can then rewrite this case and submit it for development work.


23 Dec 202103:20PM Comment 3 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 24-12-2021 05:10 PM Notes: ETC extended from: 10/12/2021 to 24/12/2021

Hi Sanjay,

As discussed, this case relates to Mindpearl customization done on case number L12264- “Acumatica” GL integration to LinkSOFT Payroll using CSV File Export.

The Sub Account is not picking on new deduction pay codes from the Cost Center GL Account - Menu "Payroll and HR Maintenance ~> Territory Branch Cost center". as per the design.

  • FSL - Staff Loan Deduction - 5001
  • UNIF - Uniform Fee - 5002
  • FSCLB - Staff Social Club - 5003



29 Dec 202103:11PM Comment 4 by Sitla Sharma (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 04-01-2022 10:59 AM Time Taken: 2.00 Notes: ETC extended from: 24/12/2021 to 04/01/2022

Hi Sanjay,

I have done testing on the Mindpearl Database and the Sub Account not showing in File Export for any of the Deduction Pay Codes irrespective of when it was created.

Table 1: Environment Details where this issue can be seen
Server Name:LINKQA4
Database name:Client-Mindpearl-LINKOFT
Application Hosted on:http://linkqa4/CLIENT-MINDPEARL-LINKSOFT
LinkSOFT Version:13.20.1215.GA 

Section B. The issue can be reproduced by performing the following steps: 
  1. Checked all Integration setup as per Initial Customisation Case Number L12264
  2. Created Pay DTD -  09.01.2022
    1. Pay No. 44
    2. Emp - M051046
  3.  Used the Following Deduction Codes
    1. BSP Medical
    2. Headsets Deduction
    3. Recovery
    4. Carpenters Finance
    5. Vinod Patel
    6. Recovery - Administration Fee
    7. Medical Recovery
    8. Vodafone recovery
    9. Access Card/ID Card Deduction
    10. PC Monitor Damage
    11. Recovery - Travel Airfare
    12. Recovery Travel Other
    13. ?Staff Loan
  4. Generated FMIS File as per below figure:

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

20

0

BSP Medical

SUV1

873000

Stationery

0

FTN109012022

20220109

0

EA

20

0

Head sets Deduction

SUV1

630000

Revenue

0

FTN109012022

20220109

0

EA

20

0

Recovery

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

20

0

Carpenters Finance

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

20

0

Vinod Patel

SUV1

630000

Revenue

0

FTN109012022

20220109

0

EA

0

4

Recovery - Administration Fee

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

20

25

Medical Recovery

SUV1

821300

Communication Costs-Mobile Phones

0

FTN109012022

20220109

0

EA

0

25

Vodafone recovery

SUV1

873000

Stationery

0

FTN109012022

20220109

0

EA

20

0

Access Card/ID Card Deduction

SUV1

822200

Maintenance-EDP Equipment

0

FTN109012022

20220109

0

EA

0

25

PC Monitor Damage

SUV1

841000

Travel-Airfare

0

FTN109012022

20220109

0

EA

10

0

Recovery - Travel Airfare

SUV1

843000

Travel-Other

0

FTN109012022

20220109

0

EA

0

25

Recovery Travel Other

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

81.52

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

81.52

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

420001

Accrual - Leave

0

FTN109012022

20220109

0

EA

0

5.43

Accrued Leave Provision

SUV1

811400

Salaries And Wages-Leave Liability

301

FTN109012022

20220109

0

EA

5.43

0

Accrued Leave Expense

SUV1

811100

Salaries & Wages

301

FTN109012022

20220109

0

EA

1412.96

0

Normal Hours

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

0

300

Australia New Zealand Banking Group

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

0

1051.67

Bank South Pacific

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

0

46.64

PAYE

SUV1

330002

Salary Control

0

FTN109012022

20220109

0

EA

10

0

Staff Loan

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

0

70.65

Superannuation Fund

SUV1

330001

Salary Control

0

FTN109012022

20220109

0

EA

0

70.65

Superannuation Fund

SUV1

812100

Pension

301

FTN109012022

20220109

0

EA

70.65

0

Superannuation Fund

 

5. FMIS Integration Report also does not show the Cost center:
  1. Generated Pay FMIS Integration Report
    1. Filtered by: 26.12.2021 to 09.01.2022
    2. Company ID:1001
    3. Payrun ID: 44
    4. Group BY  -Cost Center


Please refer to the original Customation case for details: L12264. Appreciate urgent attention.

Sitla.



14 Jan 202212:04PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sitla Sharma (Edge Business Solutions) Followup Date: 18-01-2022 01:02 PM Time Taken: 6.00

Hi Sitla, The reason you are not seeing the Sub Account is that the accounts that are Expenses are the only ones that get a sub-account.

Refer to case L12264 - Case Header Table 1 that states:

  1. “Cost Centre Code” is 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.


25 Jan 202204:05PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 26-01-2022 05:26 PM Time Taken: 3.00 Notes: Edited by sanjay on 25/01/22 16:13. Edited by sanjay on 25/01/22 16:11. Edited by sanjay on 25/01/22 16:10. 

Development Meeting Journal:

  1. The issue is that the Cost Center is not showing based on the Account type. The definition of ACCOUNT TYPE in the original design is based on the Component.
    1. Check how this was programmed in Version 12.50.0806

Next Step:

We all agreed that to resolve this issue, the only change we need to do is base the Cost Center on the menu "Integration ~> GL Accounts ~> Account Type"

Users will need to enter the word "Balance Sheet" as the Account Type in the menu "Integration ~> GL Accounts ~> Account Type" where the account is a balance sheet account. All other account codes will be considered P&L accounts.

Agreed to get this done in version 13.30.


25 Jan 202204:12PM Comment 7 by Sanjay (Link Technologies) Case L12659 added to project 13.30
27 Jan 202205:01PM Comment 8 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 28-01-2022 06:56 PM Time Taken: 18.00
PART A - Development work for this case has been completed.

1. The change will be available in version: 13.30

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

  1. Added a new Payroll configuration for FMIS.GL.Format. Details below:
  2. Configure the format for GL Accounts when Payroll transactions are created. The segment Separator is "-". Valid values are:
    1. "A" - GL Account use "Component, Territory, Branch and Cost Center"
    2. "B" - Balance Sheet Accounts use "Component" GL Account only. All Other accounts use "Component, Territory, Branch and Cost Center". Balance Sheet Accounts are determined by Menu: "Integration ~> GL Accounts" where "Account Type" contains the word "Balance Sheet"
    3. "C" - DEBIT Entries use "Component, Territory, Branch and Cost Center". Debit entries are made up of "Pay Components" where the "Paycode Type" is "Gross Pay, Taxable Allowance, Benefit, Non-Taxable Allowance, Non Pay Items". All other "Paycode Type" uses "Component" GL Account.
    4. "D" - GL Account = "Component" GL Account only.
  3. Added function to check Account Type
  4. Amended Acumatica output file to use "Account Type" from GL Account Maintenance
     

3. Affected Areas:

  1. File Export - Acumatica
  2. FMIS Transaction Build GL Accounts now uses this configuration
     

4. The issue was caused by:

  1. Change request and improvement

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT - also check FTP Upload functionality in File Export. Error message was not updating the event log


09 Feb 202210:56AM Comment 9 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 10-02-2022 12:51 PM Time Taken: 16.00
The following tests were performed:

Table 1 - Test Results
NoTest CaseExpected ResultPass/FailComments
1Set the FMIS.GL.Format configuration to A. Recreate FMIS Transactions and Verify. Generate FMIS Export file and verify
GL Account use "Component, Territory, Branch and Cost Center"
Pass

2Set the FMIS.GL.Format configuration to B. Recreate FMIS Transactions and Verify. Generate FMIS Export file and verify
Balance Sheet Accounts use "Component" GL Account only. All Other accounts use "Component, Territory, Branch and Cost Center". Balance Sheet Accounts are determined by Menu: "Integration ~> GL Accounts" where "Account Type" contains the word "Balance Sheet"
Pass

3Set the FMIS.GL.Format configuration to C. Recreate FMIS Transactions and Verify. Generate FMIS Export file and verify
DEBIT Entries use "Component, Territory, Branch and Cost Center". Debit entries are made up of "Pay Components" where the "Paycode Type" is "Gross Pay, Taxable Allowance, Benefit, Non-Taxable Allowance, Non Pay Items". All other "Paycode Type" uses "Component" GL Account
Pass

4Set the FMIS.GL.Format configuration to D. Recreate FMIS Transactions and Verify. Generate FMIS Export file and verify
GL Account = "Component" GL Account only.
Pass

5Verify Aucmatica file export uses GL Account Balance Sheet to set Sub Account values
The output file has 000 when the account is Balance Sheet
Pass

Environment Details

  1. OS version: Win10
  2. Application version:13.30
  3. Setup on:
    1. Server: LinkQA4
    2. Database: LinkSOFT
    3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
  4. Login Details: Standard username and password for user "admin"

Next Step: Closure


18 Feb 202210:15AM Comment 10 by Sanjay (Link Technologies) ETC was changed from 04/01/2022 to 04/01/2022
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12659 in the subject line of all emails regarding this issue.

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