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

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.

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

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.

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

Sitla.

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.

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.

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

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