[WT-10862] WT:- Invoice Management :- Issue for Additional fields for admin credentials mapped in Invoice mapping - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Environment:

QA
Bug Type:
Functional
Bug Severity:
Medium
Level:

Admin
Module:
BenAdmin - Report
Reported by:
Harbinger
Item State:
Production Complete - Closed
Browser:

Google Chrome
Sprint:
WT Sprint 36 - Bugs

Description

Steps:-
1] Log into the system using partner credentials.
2] Search and select any company
3] Click on Invoice Management option from Reports sub menu
4] Edit or add new invoice
5] Map the additional fields from Employee Fields in Display Fields section
6] Generate an invoice which consists these additional fields mapped
7] Log into the system using admin credentials
8] Click on Invoice Management option from Reports sub menu
9] Try to edit the template which has these additional fields mapped

Actual Result:-
Server Error is displayed on edit template screen

Expected Result:-
System should display the details saved on Edit Template Screen

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

adding new.png
81 kB
12/Sep/17 06:51 AM
Admin.png
85 kB
12/Sep/17 06:53 AM
Fields Mapped.png
209 kB
14/Sep/17 05:48 AM
New template.png
117 kB
12/Sep/17 06:53 AM
WT-10862_2.png
126 kB
18/Sep/17 08:59 AM
WT-10862_Partner.png
129 kB
12/Sep/17 06:50 AM
WT-10862._2png.png
154 kB
19/Sep/17 08:57 AM
WT-10862.png
128 kB
19/Sep/17 08:57 AM
WT-10862.png
81 kB
18/Sep/17 08:58 AM
WT-10862.png
88 kB
15/Sep/17 05:56 AM
WT-10862.png
83 kB
12/Sep/17 06:50 AM
WT-10862.png
83 kB
12/Sep/17 06:34 AM

Issue Links

causes

WT-11122 WT:- Invoice Management :- Issue for Edit invoice when mapped fields do not have right for CA user.

Open

relates to

WT-11122 WT:- Invoice Management :- Issue for Edit invoice when mapped fields do not have right for CA user.

Open

WT-10276 Quincy Invoice Template - additions

Production Complete

Activity

Ascending order - Click to sort in descending order

Rutuja Chilwar (Inactive) created issue - 29/Aug/17 09:46 AM

Venkatesh Pujari (Inactive) made changes - 29/Aug/17 09:47 AM

Field	Original Value	New Value
Link		This issue relates to ~~WT-10276~~ [ ~~WT-10276~~ ]

Parmeshwar Jumbad (Inactive) made changes - 06/Sep/17 09:55 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Parmeshwar Jumbad (Inactive) made changes - 06/Sep/17 09:56 AM

Assignee	Jyoti Agrawal [ jyoti.agrawal ]	Parmeshwar Jumbad [ parmeshwar.jumbade ]
Developer	Jyoti Agrawal [ jyoti.agrawal ]	Parmeshwar Jumbad [ parmeshwar.jumbade ]

Parmeshwar Jumbad (Inactive) made changes - 06/Sep/17 09:56 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Permalink

Parmeshwar Jumbad (Inactive) logged work - 06/Sep/17 12:46 PM - edited

Time Spent:

3.5h

Internal discussion and reproduce issue on local LB environment.
script changes and Unit testing

Parmeshwar Jumbad (Inactive) made changes - 06/Sep/17 12:48 PM

Remaining Estimate		0h [ 0 ]
Time Spent		4.5h [ 16200 ]
Worklog Id		77087 [ 77087 ]

Parmeshwar Jumbad (Inactive) made changes - 06/Sep/17 12:49 PM

Remaining Estimate	0h [ 0 ]	1h [ 3600 ]
Time Spent	4.5h [ 16200 ]	3.5h [ 12600 ]
Worklog Id		77087 [ 77087 ]

Prasanna Karlekar (Inactive) made changes - 07/Sep/17 04:28 AM

Sprint		WT Sprint 36 - Bugs [ 84 ]
Original Estimate		1h [ 3600 ]

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 08/Sep/17 05:13 AM

3C's:
Concern: Issue for Additional fields for admin credentials mapped in Invoice mapping
Cause: Member Field Rights referred from incorrect DB table (From OnlineEnrollment DB instead of Company specific DB)
Correction: For admin user login we are referring additional fields from company specific DB table.

Affected Area(s): Reports, Invoice

Affected File(s): /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetAddFieldLabelReports.StoredProcedure.sql

Tested Scenario(s):
1. Check that fields are appearing or not on reports.
2. Checked report save and Edit functionality.
3. Checked invoice create And Edit functionality with Additional fields.
4. Checked resulted data (stored procedure result) from back-end.

CC: Prasanna Karlekar

Show

Parmeshwar Jumbad (Inactive) added a comment - 08/Sep/17 05:13 AM 3C's: Concern : Issue for Additional fields for admin credentials mapped in Invoice mapping Cause : Member Field Rights referred from incorrect DB table (From OnlineEnrollment DB instead of Company specific DB) Correction : For admin user login we are referring additional fields from company specific DB table. Affected Area(s) : Reports, Invoice Affected File(s) : /MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_GetAddFieldLabelReports.StoredProcedure.sql Tested Scenario(s) : 1. Check that fields are appearing or not on reports. 2. Checked report save and Edit functionality. 3. Checked invoice create And Edit functionality with Additional fields. 4. Checked resulted data (stored procedure result) from back-end. CC: Prasanna Karlekar

Parmeshwar Jumbad (Inactive) made changes - 08/Sep/17 05:13 AM

Code Review Date		07/Sep/2017
Code Reviewed By		Prasanna Karlekar [ 11907 ]

Khandu Kshirsagar (Inactive) made changes - 08/Sep/17 10:45 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parmeshwar Jumbad (Inactive) made changes - 08/Sep/17 11:00 AM

Assignee

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 08/Sep/17 12:06 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 08/Sep/17 12:06 PM

Venkatesh Pujari

Show

Sachin Hingole (Inactive) added a comment - 08/Sep/17 12:06 PM Venkatesh Pujari

Sachin Hingole (Inactive) made changes - 08/Sep/17 12:06 PM

Assignee

Sachin Hingole [ sachin.hingole ]

Amita Sangani [ amita.sangani ]

Amita Sangani (Inactive) made changes - 11/Sep/17 04:45 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Amita Sangani (Inactive) made changes - 12/Sep/17 06:34 AM

Attachment

WT-10862.png [ 61233 ]

Amita Sangani (Inactive) made changes - 12/Sep/17 06:50 AM

Attachment		WT-10862.png [ 61234 ]
Attachment		WT-10862_Partner.png [ 61235 ]

Amita Sangani (Inactive) made changes - 12/Sep/17 06:51 AM

Attachment

adding new.png [ 61236 ]

Amita Sangani (Inactive) made changes - 12/Sep/17 06:53 AM

Attachment		Admin.png [ 61237 ]
Attachment		New template.png [ 61238 ]

Hide

Permalink

Amita Sangani (Inactive) added a comment - 12/Sep/17 06:54 AM

Hi [~parmeshwar.jumbade],
Partner login
Credentials:smitap/Password@1
Admin Credentils: Testvenky/Password@1

For QA CAISO company

For existing template this issue is working fine for admin level.

But when we add new template with partner it is generated successfully but after log in with admin and Click on Invoice Management option from Reports sub menu and
Try to edit the template which has these additional fields mapped

Actual: Server Error is displayed on edit template screen

PFA:
Existing Template

Add New Template

CC:Sachin Hingole,Prasad Pise,Rakesh Roy

Show

Amita Sangani (Inactive) added a comment - 12/Sep/17 06:54 AM Hi [~parmeshwar.jumbade] , Partner login Credentials:smitap/Password@1 Admin Credentils: Testvenky/Password@1 For QA CAISO company For existing template this issue is working fine for admin level. But when we add new template with partner it is generated successfully but after log in with admin and Click on Invoice Management option from Reports sub menu and Try to edit the template which has these additional fields mapped Actual: Server Error is displayed on edit template screen PFA: Existing Template Add New Template CC: Sachin Hingole , Prasad Pise , Rakesh Roy

Amita Sangani (Inactive) made changes - 12/Sep/17 06:54 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Amita Sangani (Inactive) made changes - 12/Sep/17 06:55 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Amita Sangani (Inactive) made changes - 12/Sep/17 06:57 AM

Assignee

Amita Sangani [ amita.sangani ]

Parmeshwar Jumbad [ parmeshwar.jumbade ]

Permalink

Amita Sangani (Inactive) logged work - 12/Sep/17 07:05 AM - edited

Time Spent:

1.5h

<No comment>

Amita Sangani (Inactive) made changes - 12/Sep/17 07:06 AM

Remaining Estimate	1h [ 3600 ]	10m [ 600 ]
Time Spent	3.5h [ 12600 ]	4h 20m [ 15600 ]
Worklog Id		78145 [ 78145 ]

Amita Sangani (Inactive) made changes - 12/Sep/17 11:28 AM

Remaining Estimate	10m [ 600 ]	0h [ 0 ]
Time Spent	4h 20m [ 15600 ]	5h [ 18000 ]
Worklog Id		78145 [ 78145 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 12/Sep/17 12:58 PM

Time Spent:

0.25h

Internal discussion with QA

Parmeshwar Jumbad (Inactive) made changes - 12/Sep/17 12:58 PM

Time Spent	5h [ 18000 ]	5.25h [ 18900 ]
Worklog Id		78267 [ 78267 ]

Gaurav Sodani (Inactive) made changes - 14/Sep/17 05:04 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Gaurav Sodani (Inactive) made changes - 14/Sep/17 05:05 AM

Item State

Parent values: LB QA(10201)Level 1 values: Re-open(10212)

Parent values: Development(10200)Level 1 values: On Hold(10207)

Parmeshwar Jumbad (Inactive) made changes - 14/Sep/17 05:48 AM

Attachment

Fields Mapped.png [ 61444 ]

Hide

Permalink

Parmeshwar Jumbad (Inactive) added a comment - 14/Sep/17 05:48 AM

Hi Amita Sangani,

I have checked this issue and found that issue is due to there are few fields (Employee Type & EIN) which does not have rights to CA but those fields are selected in invoice template while creation by Partner.

For the same you can open new JIRA. Because, we had fixed issue to fields having rights to CA but still getting exception while Edit created invoice.

CC: Jyoti Agrawal Venkatesh Pujari Sachin Hingole Prasanna Karlekar

Show

Parmeshwar Jumbad (Inactive) added a comment - 14/Sep/17 05:48 AM Hi Amita Sangani , I have checked this issue and found that issue is due to there are few fields (Employee Type & EIN) which does not have rights to CA but those fields are selected in invoice template while creation by Partner. For the same you can open new JIRA. Because, we had fixed issue to fields having rights to CA but still getting exception while Edit created invoice. CC: Jyoti Agrawal Venkatesh Pujari Sachin Hingole Prasanna Karlekar

Parmeshwar Jumbad (Inactive) made changes - 14/Sep/17 05:49 AM

Assignee	Parmeshwar Jumbad [ parmeshwar.jumbade ]	Amita Sangani [ amita.sangani ]
Item State	Parent values: Development(10200)Level 1 values: On Hold(10207)	Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Permalink

Prasanna Karlekar (Inactive) logged work - 14/Sep/17 07:30 PM

Time Spent:

0.5h

Discussion on root cause for issue reopen

Amita Sangani (Inactive) made changes - 15/Sep/17 04:12 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Permalink

Parmeshwar Jumbad (Inactive) logged work - 15/Sep/17 05:07 AM

Time Spent:

1h

Check root cause of issue
internal discussion
JIRA update

Parmeshwar Jumbad (Inactive) made changes - 15/Sep/17 05:07 AM

Time Spent	5.25h [ 18900 ]	6.25h [ 22500 ]
Worklog Id		78838 [ 78838 ]

Amita Sangani (Inactive) made changes - 15/Sep/17 05:56 AM

Attachment

WT-10862.png [ 61557 ]

Amita Sangani (Inactive) made changes - 15/Sep/17 06:12 AM

Link

This issue causes WT-11122 [ WT-11122 ]

Hide

Permalink

Amita Sangani (Inactive) added a comment - 15/Sep/17 06:13 AM

Hi,
I have verified this issue is working fine.

But Some those fields which are mapped which admin has no rights to edit. Therefore admin getting server error. (Employee Type, EIN and Unique Identifier fields etc)
PFA:

CC:Sachin Hingole,Prasad Pise,Rakesh Roy

Show

Amita Sangani (Inactive) added a comment - 15/Sep/17 06:13 AM Hi, I have verified this issue is working fine. But Some those fields which are mapped which admin has no rights to edit. Therefore admin getting server error. (Employee Type, EIN and Unique Identifier fields etc) PFA: CC: Sachin Hingole , Prasad Pise , Rakesh Roy

Amita Sangani (Inactive) made changes - 15/Sep/17 06:13 AM

Link

This issue relates to WT-11122 [ WT-11122 ]

Amita Sangani (Inactive) made changes - 15/Sep/17 06:14 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Amita Sangani (Inactive) made changes - 15/Sep/17 06:40 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Permalink

Parmeshwar Jumbad (Inactive) logged work - 15/Sep/17 11:29 AM

Time Spent:

0.5h

Internal discussion with QA

Parmeshwar Jumbad (Inactive) made changes - 15/Sep/17 11:30 AM

Time Spent	6.25h [ 22500 ]	6.75h [ 24300 ]
Worklog Id		78975 [ 78975 ]

Permalink

Amita Sangani (Inactive) logged work - 15/Sep/17 12:26 PM

Time Spent:

1.5h

1.Lb Environment Issue
2. Internal Discussion with Parmeshwar
3.In testing this jira getting another issue.

Amita Sangani (Inactive) made changes - 15/Sep/17 12:29 PM

Time Spent	6.75h [ 24300 ]	8.25h [ 29700 ]
Worklog Id		79004 [ 79004 ]

Amita Sangani (Inactive) made changes - 18/Sep/17 04:17 AM

Production Due Date		19/Sep/2017
Stage Due Date		18/Sep/17 [ 2017-09-18 ]

Khandu Kshirsagar (Inactive) made changes - 18/Sep/17 07:17 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Amita Sangani (Inactive) made changes - 18/Sep/17 08:58 AM

Attachment

WT-10862.png [ 61710 ]

Amita Sangani (Inactive) made changes - 18/Sep/17 08:59 AM

Attachment

WT-10862_2.png [ 61713 ]

Hide

Permalink

Amita Sangani (Inactive) added a comment - 18/Sep/17 09:01 AM

Hi,
Partner: qatesting/Password@3
Admin: 45/Password@3
Company: JCCC For HSPL

I have verified this issue is working fine on stage.
PFA:

Marking as Ready for Production
CC:Sachin Hingole,Prasad Pise,Rakesh Roy

Show

Amita Sangani (Inactive) added a comment - 18/Sep/17 09:01 AM Hi, Partner: qatesting/Password@3 Admin: 45/Password@3 Company: JCCC For HSPL I have verified this issue is working fine on stage. PFA: Marking as Ready for Production CC: Sachin Hingole , Prasad Pise , Rakesh Roy

Amita Sangani (Inactive) made changes - 18/Sep/17 09:01 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Amita Sangani (Inactive) made changes - 18/Sep/17 09:01 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Permalink

Amita Sangani (Inactive) logged work - 18/Sep/17 09:03 AM - edited

Time Spent:

50m

<No comment>

Amita Sangani (Inactive) made changes - 18/Sep/17 09:03 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Amita Sangani (Inactive) made changes - 18/Sep/17 09:04 AM

Time Spent	8.25h [ 29700 ]	8.75h [ 31500 ]
Worklog Id		79202 [ 79202 ]

Prasanna Karlekar (Inactive) made changes - 18/Sep/17 10:47 AM

Time Spent	8.75h [ 31500 ]	9.25h [ 33300 ]
Worklog Id		79224 [ 79224 ]

Amita Sangani (Inactive) made changes - 18/Sep/17 12:49 PM

Time Spent	9.25h [ 33300 ]	58.75h [ 211500 ]
Worklog Id		79202 [ 79202 ]

Amita Sangani (Inactive) made changes - 18/Sep/17 12:50 PM

Remaining Estimate	0h [ 0 ]	49h 10m [ 177000 ]
Time Spent	58.75h [ 211500 ]	9h 35m [ 34500 ]
Worklog Id		79202 [ 79202 ]

Khandu Kshirsagar (Inactive) made changes - 19/Sep/17 07:18 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Amita Sangani (Inactive) made changes - 19/Sep/17 08:57 AM

Attachment		WT-10862._2png.png [ 61902 ]
Attachment		WT-10862.png [ 61903 ]

Hide

Permalink

Amita Sangani (Inactive) added a comment - 19/Sep/17 08:57 AM

Hi,

Additional fields for admin credentials mapped in Invoice mapping is working fine.

CC:Sachin Hingole,Prasad Pise,Rakesh Roy

Show

Amita Sangani (Inactive) added a comment - 19/Sep/17 08:57 AM Hi, Additional fields for admin credentials mapped in Invoice mapping is working fine. CC:Sachin Hingole,Prasad Pise,Rakesh Roy

Amita Sangani (Inactive) made changes - 19/Sep/17 08:57 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Amita Sangani (Inactive) made changes - 19/Sep/17 08:57 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Amita Sangani (Inactive) made changes - 19/Sep/17 08:58 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Amita Sangani (Inactive) made changes - 19/Sep/17 08:58 AM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Permalink

Amita Sangani (Inactive) logged work - 19/Sep/17 08:59 AM

Time Spent:

0.5h

<No comment>

Amita Sangani (Inactive) made changes - 19/Sep/17 08:59 AM

Remaining Estimate	49h 10m [ 177000 ]	48h 40m [ 175200 ]
Time Spent	9h 35m [ 34500 ]	10h 5m [ 36300 ]
Worklog Id		79613 [ 79613 ]

Satya made changes - 04/Nov/17 06:19 AM

Environment_New

LB [ 18444 ]

Transition	Time In Source Status	Execution Times

Parmeshwar Jumbad (Inactive) made transition - 06/Sep/17 09:55 AM

Open

In Development

8d 9m

Amita Sangani (Inactive) made transition - 12/Sep/17 06:55 AM

In LB Testing

Reopen in Local

3d 18h 48m

Gaurav Sodani (Inactive) made transition - 14/Sep/17 05:04 AM

Reopen in Local

In Development

1d 22h 9m

Amita Sangani (Inactive) made transition - 15/Sep/17 06:40 AM

In Development

In LB Testing

3d 3h 46m

Amita Sangani (Inactive) made transition - 18/Sep/17 09:03 AM

In LB Testing

Stage Testing

3d 2h 23m

Amita Sangani (Inactive) made transition - 19/Sep/17 08:58 AM

Stage Testing

In Production Testing

23h 54m

Amita Sangani (Inactive) made transition - 19/Sep/17 08:58 AM

In Production Testing

Production Complete

50s

People

Assignee:: Amita Sangani (Inactive)

Reporter:: Rutuja Chilwar (Inactive)

Developer:: Parmeshwar Jumbad (Inactive)

QA:: Venkatesh Pujari (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 29/Aug/17 09:46 AM

Updated:: 04/Nov/17 06:19 AM

Resolved:: 19/Sep/17 08:58 AM

Pre-Prod Due Date:: 18/Sep/2017

Production Due Date:: 19/Sep/2017

Code Review Date:: 07/Sep/2017

Time Tracking

Estimated:

Remaining:

48h 40m

Logged:

10h 5m