Company:	Link Technologies
Case No:	L09761. Project: 11.40: LinkSOFT Version 11.4
Logged By:	Rashna (Edge Business Solutions) on 18 Dec 2018 12:56PM
Priority:	High
Product:	Framework
Group:	Software Defect
Time Taken:	34.50 (Weight: 34.50)
Version:	11.3.0902
Assigned To:	Rashna (Edge Business Solutions)
Circulation:	Alvis, Development, Rashna, Sanjay
Resolve By:	Wednesday, 19 December 2018 12:00 AM [1950 days since logged date]
Status:	Closed

Subject:

Sorting of records in reports are by CODE which makes it difficult to navigate

Summary:

Issue: Sorting of records in reports are by CODE which makes it difficult to navigate

Below is the list of reports we need corrections on:

Table 1 - List of reports to correct

No	Report	module	Comment	Status	Effort
1	Asset Listing	FMIS	Sorted by Asset Code	Pending	2
2	Asset Register	FMIS	Sorted by Asset Code	Pending	2
3	Asset Register Book	FMIS	Sorted by Asset Code	Pending	2
4	Applicant Profile	HR	The report is sorted by code. Sorting is incorrect when "User Defined" applicant codes are manually created from BO.	Pending	4
5	Course Feedback	HR	Employees part of a "Training Schedule" are sorted by "Code". The "Course Feedback" is also sorted by "Code". Codes are user-defined.	Pending	2
6	Course Learning Outcome	HR	Employees part of a "Training Schedule" are sorted by "Code". The "Course Feedback" is also sorted by "Code". Codes are user-defined.	Pending	2
7	Employee Entry Exist Report	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
8	Employee Experience Report	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
9	Employee Induction Report	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
10	Employee Induction Topic	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
11	Employee Probation	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
12	Employee Qualification	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
13	Interview Panel Member Listing	HR	Report is currently sorted by code. Sorting is not aligned with user-defined codes.	Pending	2
14	OHS Claim	HR		Pending	2
15	OHS committee Listing	HR	Sorted by Employee ID	Pending	2
16	Performance Standards Listing	HR	Sorted by Code	Pending	2
17	Training Report	HR	Attendees are sorted by Employee ID	Pending	2
18	Training Schedule Listing	HR		Pending	2
19	Inventory Aging Report	INV		Pending	3
20	Inventory Category Listing	INV	Sorted by Code. Report does not have a description for the categories	Pending	1
21	Inventory Cost Listing	INV		Pending	2
22	Inventory Cycle Code Listing	INV		Pending	1
23	Inventory Dead Stock Report	INV		Pending	2
24	Inventory Expiry Listing	INV		Pending	2
25	Inventory Kit Listing	INV		Pending	2
26	Inventory Location Listing	INV	Sorted by Code. Report does not have description for the location.	Pending	1
27	Inventory Master-Detail Listing	INV		Pending	2
28	Inventory Promotional Price Setup for POS Locations	INV		Pending	2
29	Inventory Reconciliation by Shift	INV		Pending	3
30	Inventory Sub-Category Listing	INV	Sorted by Code. Report does not have description category or sub category	Pending	1
31	Inventory UOM Conversion Listing	INV	Sorted by Code. Report does not have description for the part numbers.	Pending	1
32	Supplier Audit	INV	Sorted by supplier code	Pending	2
33	Supplier Quote Audit Report	INV	Sorted by supplier code	Pending	2
34	System Verification Report	INV	Sorted by supplier code	Pending	3
35	Tax Code Audit Report	INV	Sorted by supplier code	Pending	1
36	Employee Accumulator Detail	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	6
37	Employee Allowance/Benefit Audit	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	1
38	Employee Composition	PAYROLL	The report is sorted by code. Sorting is incorrect when "User Defined" employee codes are mannually created.	Pending	1
39	Employee Cost Anaylsis	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	4
40	Employee Deduction Audit Report	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	1
41	Employee Direct Credit Audit	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	1
42	Employee Normal Pay	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	6
43	Employee Pay Rate Utility	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	2
44	Employee Pay Register	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	4
45	Employee Pay Register Compare Last Pay	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	4
46	Employee Payment History.	PAYROLL	Employee list is sorted within the pay team	Pending	3
47	Employee Profile Audit	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	3
48	Employee Rate Audit	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	2
49	Employee Retirement Provision	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	4
50	Leave Due	PAYROLL	Sorted by Employee ID	Pending	2
51	Leave History	PAYROLL	Sorted by Employee ID	Pending	2
52	Leave Liability	PAYROLL	Sorted by Employee ID	Pending	4
53	Leave Liability Analysis - Detail	PAYROLL	Sorted by Employee ID	Pending	1
54	Leave Transaction	PAYROLL	Sorted by Employee ID	Pending	4
55	Levy Report	PAYROLL		Pending	2
56	Pay Audit Report (332-5-2)	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	4
57	Pay Code Listing	PAYROLL	Sorted by Code	Pending	2
58	Pay deduction Report (332-5-7)	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	3
59	Pay Edit BY Cost Centre	PAYROLL	Sorted by Employee ID	Pending	3
60	Pay Edit Report (332-5-1)	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	3
61	Pay Edit Report YTD	PAYROLL	Sorted by Employee ID	Pending	3
62	Pay Signature Report (332-5-8)	PAYROLL	Report is currently sorted by code. Sorting is not aligned with user defined codes.	Pending	3
63	Paycode Accumulator Detail	PAYROLL	Sorted by Employee ID	Pending	6
64	PAYE Reconciliation Report	PAYROLL	Sorted by Employee ID	Pending	3
65	Roster Schedule Report	PAYROLL	Sorted by Employee ID	Pending	3
66	Roster Schedule Report Signature	PAYROLL		Pending	1
67	Tax deduction Report	PAYROLL	Sorted by Employee ID	Pending	2
68	Time Absent Report	PAYROLL		Pending	2
69	Timesheet Import Log Report	PAYROLL	Sorted by employee ID	Pending	4
70	Timesheet Payroll Report	PAYROLL	Sorted by employee ID	Pending	3
71	Timesheet Report	PAYROLL		Pending	3
72	Timesheet Summary Report	PAYROLL	Sorted by employee ID	Pending	3
73	Weekly Timesheet Report	PAYROLL		Pending	3
74	Years of Service	PAYROLL	Sorted by Employee ID	Pending	2
75	YTD Listing	PAYROLL	Sorted by Employee ID	Pending	2
76	Customer Audit Report	POS	Sorted by code, but sorting is correct.	Pending	2
77	Debit / Credit Note Listing	POS	Customer Name and Code are separated. Name is output under the "Reference" column.	Pending	2
78	Doctor Listing	POS		Pending	2
79	Sales by Location Comparison	POS		Pending	3
80	Top N Sales Analysis	POS		Pending	3
81	Vacancy Applicant	RM	Sorted by applicant code	Pending	2
82	Vacancy Listing	RM	Sorted by Vacany Code and applicants are sorted by applicant code	Pending	2
					200

Audit Notes:

Edited by sanjay on 11/09/19 13:52. Edited by sanjay on 05/08/19 16:32. Edited by sanjay on 10/05/19 16:37. Edited by alvis on 28/03/19 16:03. Edited by alvis on 28/03/19 10:26. Edited by alvis on 25/02/19 16:57. Edited by sanjay on 15/02/19 08:32. Edited by sanjay on 15/02/19 08:23. Edited by rashna on 30/01/19 09:43. Edited by rashna on 25/01/19 11:48. Edited by rashna on 18/12/18 12:56.

18 Jan 2019

10:51AM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 18-01-2019 10:51 AM Time Taken: 1.50

This case does not have sufficient information to proceed.

25 Jan 2019

11:48AM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 25-01-2019 11:48 AM Time Taken: 2.50

Provide a list of all reports in LINKSOFT where we are sorting by codes.

Alvis will review these reports and determine if we display the description on the first column and sort by description. The code can be added to the description or in a column after the description.

25 Jan 2019

11:48AM Comment 3 by Rashna (Edge Business Solutions) Case 9761 added to project 10.2

29 Jan 2019

03:39PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Rashna (Edge Business Solutions) Followup Date: 29-01-2019 03:39 PM Time Taken: 6.50

I have verified all reports in Backoffice. Attached is excel with all reports sorted by code.d

30 Jan 2019

09:45AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Development Followup Date: 28-02-2019 12:00 AM Time Taken: 2.50

I have completed the analysis, attached is the excel "ReportSortingAnalysis" which has the results from reports in Backoffice and LinkWeb.

Case assigned to development for next step.

Thanks
Rashna

11 Feb 2019

04:03PM Comment 6 by Alvis (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 11-02-2019 04:03 PM Time Taken: 1.50

The following changes are required since multi-company is not supported in inventory:

Remove Inventory, purchasing data for company 1002 from demo database.
Restrict backoffice Inventory, purchasing menus to company 1001.

12 Feb 2019

01:06PM Comment 7 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 12-02-2019 01:06 PM Time Taken: 5.50

The following changes have been completed:

Removed Backoffice (INV, PUR, POS, DEB, EXT) modules, when logged in a company that is not 1001.
Removed default data for (INV, PUR, POS, DEB, EXT) modules from Demo database for company 1002.
Removed Link WEB (POS) menus, when logged in a company that is not 1001.
Rebuild New and demo build scripts.

25 Feb 2019

05:00PM Comment 8 by Sanjay (Link Technologies) Assigned To: Alvis (Link Technologies) Followup Date: 25-02-2019 05:00 PM Time Taken: 7.50

Development for the following items was completed:

Refactored report template and template procedures to implement report framework changes
1. Added CompanyID parameter
2. Added Search Parameter
3. Changed report sorting to use the description
Changed Advertisement report to use the report template.

28 Mar 2019

10:37AM Comment 9 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 28-03-2019 10:37 AM Time Taken: 1.50

Hi Rashna,

Please review the report list in table 1 and provide a new list with a column stating what needs to be done.

regards
Sanjay/Alvis

05 Aug 2019

04:35PM Comment 10 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-08-2019 04:35 PM Time Taken: 5.50

Hi Rashna,

The standard with JIWA and Epicor is to sort reports by Code then description, Refer to the following reports in JIWA:

Debtors balance as ar
Stock on hand
Chart of accounts
Stock Take etc

Therefore it makes sense for us to maintain the current sorting.

In future, please check with JIWA or Epicor so that we do not make changes that are nonstandard.

09 Oct 2019

08:17AM Comment 11 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: L09761 in the subject line of all emails regarding this issue.

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