Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6949

Export->BCC Enhancement > Provider wise Billing Data logic need to change as per new invoice changes.

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Getting server error when exporting Billing Data Template when Invoice is generated and its finalized .

      Error Log:

      ErrorID : 0
      ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ExportProcessRowwise.ExportData->CommonExportRoutines.GetProviderWiseBillingData
      ErrorMessage: Invalid column name 'InvoiceForMonthYear'.
      Invalid column name 'InvoiceForMonthYear'.

        Attachments

          Issue Links

            Activity

            aniruddha.dev Aniruddha Dev (Inactive) created issue -
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Field Original Value New Value
            Link This issue causes WT-6331 [ WT-6331 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Remaining Estimate 1h [ 3600 ]
            Original Estimate 1h [ 3600 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Code Review Date 07/Dec/2016
            Code Reviewed By Vinalyak Kulkarni [ 12100 ]
            Dev Due Date 08/Dec/2016
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Remaining Estimate 1h [ 3600 ] 0h [ 0 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 11918 [ 11918 ]
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Environment LB [ 10800 ]
            Issue Type Bug [ 1 ] Change Request [ 10002 ]
            Workflow WT_Defects [ 28406 ] WT_Features [ 28410 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Original Estimate 1h [ 3600 ] 6h [ 21600 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 1h [ 3600 ] 3h [ 10800 ]
            Worklog Id 11997 [ 11997 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
            Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Aniruddha Dev [ aniruddha.dev ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            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)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Comment [ Adding LB Testing hours (after fix) 3hrs and time already spent (2hrs) along with developer's time spent (1hr) ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Original Estimate 6h [ 21600 ] 12h [ 43200 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 3h [ 10800 ] 8h [ 28800 ]
            Worklog Id 12104 [ 12104 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            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)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 8h [ 28800 ] 10h [ 36000 ]
            Worklog Id 12369 [ 12369 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            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)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Time Spent 10h [ 36000 ] 12h [ 43200 ]
            Worklog Id 13749 [ 13749 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Worklog Id 13749 [ 13749 ]
            aniruddha.dev Aniruddha Dev (Inactive) made changes -
            Attachment WT-6949.xls [ 56922 ]

              People

              Assignee:
              aniruddha.dev Aniruddha Dev (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              Developer:
              Ganesh Sadawarte (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 12h
                  12h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 12h
                  12h