Company: Link Technologies
Case No: L10440. Project: 11.40: LinkSOFT Version 11.4
Logged By: Rashna (Edge Business Solutions) on 05 Jun 2019 09:58AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 5.00 (Weight: 5.00)
Version: 11.3.0902
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Thursday, 06 June 2019 12:00 AM [1778 days since logged date]
Status: Closed
Subject: LinkWEB "Payroll Maintenance - Pay Code" User Testing
Summary:    

Unable to add new a paycode.

Error 1: Cannot insert the value NULL into column 'COMPONENT_TYPE', table 'LINKSOFT_DEMO_11_RASHNA.dbo.PR_COMPONENT'; column does not allow nulls. INSERT fails.

Version: 11.603

Steps

  1. Add New
  2. Enter 
    1. Code - ABONUS
    2. Description - Bonus
    3. Paycode Type - Gross Pay
    4. Use Staff Rate - Yes
    5. Rate by - Value
    6. Rate - 1
    7. Calculate Leave - Yes
    8. Include Super - Yes
    9. Save.


Error 2: Cannot insert the vCannot insert the value NULL into column 'COMPONENT_RATE', table 'LINKSOFT_DEMO_11_RASHNA.dbo.PR_COMPONENT'; column does not allow nulls. UPDATE fails.alue NULL into column 'COMPONENT_RATE', table 'LINKSOFT_DEMO_11_RASHNA.dbo.PR_COMPONENT'; column does not allow nulls. UPDATE fails.

  1. Mark "Rate" field as required.
Audit Notes:Edited by sanjay on 11/09/19 15:49. Edited by alvis on 07/06/19 15:24. Edited by rashna on 05/06/19 09:58. 
07 Jun 201903:48PM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 07-06-2019 03:48 PM Time Taken: 2.50

Development work for this case has been completed.

The change will be available in version: 11.0.0607

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

  1. Issues identified have been resolved.

2. The issue was caused by:

  1. Field binding issue

3. Next Step:

  1. UAT

4. Notes:


20 Jun 201910:56AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-06-2019 10:56 AM Time Taken: 2.50
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1
  1. Add New
  2. Enter 
    1. Code - ABONUS
    2. Description - Bonus
    3. Paycode Type - Gross Pay
    4. Use Staff Rate - Yes
    5. Rate by - Value
    6. Rate - 1
    7. Calculate Leave - Yes
    8. Include Super - Yes
    9. Save.
Record should be saved without errors
Pass
2

Validate that correct fields are loaded for each paycode type.


Create a "Gross Pay" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. PayCode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Is Tax Paycode
  9. Calculate Leave
  10. Includes super
  11. Benefit Type
  12. Tax Scale Code
  13. Benefit Is Taxable
  14. GL Account Code
  15. Creditor Code
  16. Comission Percent
  17. Commission Gl Code
  18. Group GL Transaction


Create a "Benefit" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Is Tax Paycode
  9. Calculate Leave
  10. Includes super
  11. Benefit Type
  12. Tax Scale Code
  13. Benefit Is Taxable
  14. GL Account Code
  15. Creditor Code
  16. Commission Percent
  17. Commission Gl Code
  18. Group GL Transaction



Create a "Deduction" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Is Tax Paycode
  9. Includes Banking
  10. Bank Code
  11. Bank Account
  12. Benefit Is Taxable
  13. GL Account Code
  14. Creditor Code
  15. Commission Percent
  16. Commission Gl Code
  17. Group GL Transaction

Create a "Non Pay Items" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Is Tax Paycode
  9. GL Account Code
  10. Creditor Code
  11. Commission Percent
  12. Commission Gl Code
  13. Group GL Transaction

Create a "Non Taxable Allowance" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Is Tax Paycode
  9. Includes Super
  10. GL Account Code
  11. Creditor Code
  12. Commission Percent
  13. Commission Gl Code
  14. Group GL Transaction

Create a "Non Pay Items" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. GL Account Code
  9. Creditor Code
  10. Commission Percent
  11. Commission Gl Code
  12. Group GL Transaction


Create a "Tax Adjustment" code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Includes Super
  9. Benefit Type
  10. Tax Scale Code
  11. Benefit Is Taxable
  12. GL Account Code
  13. Creditor Code
  14. Commission Percent
  15. Commission Gl Code
  16. Group GL Transaction

Create a "Tax Allowance code, the following details should be populated, editable and successfully saved.
  1. Code
  2. Description
  3. Paycode Type
  4. Classification
  5. Use Staff Rate
  6. Rate By
  7. Rate
  8. Is Tax Paycode
  9. Includes Super
  10. Benefit Type
  11. Tax Scale Code
  12. Benefit Is Taxable
  13. GL Account Code
  14. Creditor Code
  15. Commission Percent
  16. Commission Gl Code
  17. Group GL Transaction
Pass
3Verify that the paycode details are correctly updated in the "PayCode Listing"reportPass

Note - Copy record feature is not available in this build

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 11.0.0613
  3. Setup: Demo
  4. Server : 10.0.0.14
  5. Database: LINKSOFT-DEMO-11-RASHNA

Next Step: for closure


    09 Oct 201908:17AM Comment 3 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - Cleared queue due to large number of calls
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L10440 in the subject line of all emails regarding this issue.

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