Company:	Link Technologies
Case No:	L12784. Project: 14.20: LinkSOFT Version 14.20 - November 2022
Logged By:	Vineshwar Prasad (Edge Business Solutions) on behalf of Sanjay (Link Technologies) on 30 Aug 2022 02:02PM
Priority:	Medium
Product:	Payroll & HR
Group:	Enhancement
Time Taken:	165.00 (Weight: 165.00)
Assigned To:	Development
Circulation:	Development, Sanjay, Vineshwar Prasad
Resolve By:	Wednesday, 30 November 2022 02:02 PM [814 days since logged date]
Status:	Closed

Subject:

Restrict Company filter on Reports to companies that the user has access to

Summary:

Issue: When generating certain reports, for example, the Pay Summary Report, the Company filter displays all the company names. We need to restrict this so that clients don't see other client names.
i.e. Restrict the Company List based on the logged-in user's Company Access.

Audit Notes:

Edited by sanjay on 31/10/22 16:33. Edited by sanjay on 31/10/22 16:33. Edited by sanjay on 18/10/22 11:32. Edited by sanjay on 13/10/22 10:57. Edited by sanjay on 07/10/22 14:51. Edited by sanjay on 07/10/22 14:49. Edited by sanjay on 30/08/22 14:02.

26 Aug 2022

03:04PM Comment 1 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-08-2022 03:03 PM

We can restrict the company list based on what the user has access to. Transfer to DEV and assign to Sanjay.

30 Aug 2022

12:04PM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 02-09-2022 12:04 PM Notes: ETC extended from: 31/08/2022 to 02/09/2022

Transferred to Development

30 Aug 2022

02:02PM Comment 3 by Sanjay (Link Technologies) Case L12784 added to project 14.20

30 Aug 2022

02:02PM Comment 4 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 30-11-2022 02:02 PM Notes: ETC extended from: 02/09/2022 to 30/11/2022

Allocated to Project 14.20

13 Oct 2022

01:17PM Comment 5 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 20-10-2022 01:14 PM Time Taken: 46.00

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

1. The change will be available in version:14.20

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

Added restriction to all 116 reports using COMPANY Filter to allow users to select only companies they have access to in the menu "Global Administration ~> User Maintenance ~> COMPANY Tab ~> Enabled"

3. Affected Areas:

All reports using the COMPANY filter

4. The issue was caused by:

Security Concern

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

21 Oct 2022

02:25PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-10-2022 02:17 PM Time Taken: 119.00

The following tests were performed:

Test Setup Instructions:

Give user "Admin" access to companies A and B
Create a new user called "Admin1" access to company C

Test No	ReportDescription	Result	Status
1	Superannuation Report (Australia)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
2	Bank Pay Submission Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
3	Performance Appraisal Bonus Award Letter	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
4	Employee Position History Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
5	Performance Plan	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
6	Time Entry for Payroll Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
7	Paycode Accumulator Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
8	Pay Labour Analysis Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
9	Employee Deduction Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
10	Employee Profile Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
11	Employee Leave Analysis	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
12	Payslip Consolidated	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
13	Tax Report (Samoa)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
14	Cost Centre Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
15	Pay Edit Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
16	Performance Appraisal Caution Letter	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
17	Interview Panel Member Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
18	Pay FMIS Integration Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
19	Employee Training History Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
20	Payslip Packet	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
21	Pay Edit Cost Centre Detail	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
22	Leave Code Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
23	Training Plan Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
24	Employee Issuable Items Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
25	Employee Listing Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
26	Back Pay Schedule	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
27	Payslip A4 (2 columns)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
28	Employee Discipline Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
29	Employee Start Date Anniversary Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
30	Employee Entry/Exit Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
31	Employee Exit Details	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
32	OHS Incident Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
33	Training Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
34	Roster Schedule Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
35	Pay Edit Report - Year to date	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
36	Performance Appraisal Detail Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
37	Leave Liability Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
38	Roster Schedule Report Signature	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
39	Succession Planning Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
40	Position Listing/Occupancy	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
41	Payroll Timesheet Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
42	Employee Allowance/Benefit Audit	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
43	Employee User Defined Fields Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
44	Package Calculation Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
45	Employee Rate Audit	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
46	Project Budget/Actual/Variance	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
47	Pay Analysis Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
48	Position Structure - Organisation	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
49	Leave Transaction Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
50	Pay Code Summary Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
51	Employee Composition	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
52	Employee Cost Analysis	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
53	Employee Retirement Provision	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
54	Employee Accumulator Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
55	Employee Pay Rate Utility Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
56	Employee Payment History	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
57	Performance Appraisal Summary Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
58	Bureau of Statistics (Fiji)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
59	Payslip A5	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
60	Tax Reconciliation Report (Fiji PAYE <= 2012)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
61	Employee Direct Credit Audit	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
62	Tax Report (Papua New Guinea)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
63	Employee Probation Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
64	Pay Coinage Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
65	Employee Induction Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
66	Superannuation Report (Fiji FNPF)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
67	Employee Standard Pay Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
68	Payroll Timesheet Absent Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
69	Leave Liability Analysis - Detail	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
70	Employee Qualification Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
71	Single Touch Payroll Submission Report (Australia)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
72	Tax Deduction Report (Fiji)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
73	Payslip A6	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
74	Employee Transfer Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
75	Meeting Records Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
76	Paycode Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
77	Performance Appraisal Form	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
78	Employee Birthday Anniversary Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
79	Performance Appraisal Bonus Calculation Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
80	Employee Job Duties Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
81	Pay Audit Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
82	Pay Component/Deduction/Banking Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
83	OHS Committee Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
84	Employee Year of Service	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
85	Superannuation Report (Samoa)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
86	Pay Signature Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
87	Tax Employee Certificate (Fiji PAYE)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
88	OHS Claim Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
89	Performance Appraisal Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
90	Vacancy Applicant Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
91	Employee Pay Register	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
92	Tax Employer Monthly Schedule (Fiji)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
93	Applicant Profile Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
94	Levy Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
95	Pay Settlement Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
96	Vacancy Advertisement Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
97	Employee Experience Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
98	Key Performance Indicator Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
99	Employee Membership Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
100	Training Schedule Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
101	Leave Liability Analysis - Summary	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
102	Employee Hours Analysis	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
103	Tax Reconciliation Report (Fiji PAYE >= 2013)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
104	Performance Appraisal Improvement Plan	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
105	Tax Deduction Report by State (Australia)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
106	Leave Balances (summary) Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
107	Tax Employee Certificate (Australia PAYG)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
108	Tax Annual Summary (Fiji PAYE)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
109	Payroll Timesheet by Pay Period Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
110	Course Listing	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
111	Payslip A4	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
112	Pay Summary Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
113	Tax Employee Certificate (Papua New Guinea)	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
114	Payroll Timesheet - Weekly Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
115	Employee Discipline Form	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass
116	Leave Allocation Report	User Admin should be able to see company A and B. User Admin1 should be able to see company C only.	Pass

Environment Details

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

Next Step: Closure

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

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