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

            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

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

            Cause: This issue is because of WT-6331 new enhancement during the this change column definition get changes

            Correction: We handle this with code change.

            CC-Rohan J Khandave,Vinayak Kulkarni,Rakesh Shahane

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Concern : Getting server error when exporting Billing Data Template when Invoice is generated and its finalized . Cause : This issue is because of WT-6331 new enhancement during the this change column definition get changes Correction : We handle this with code change. CC- Rohan J Khandave , Vinayak Kulkarni , Rakesh Shahane
            Hide
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

            Affected Files: OES_SP_Export_ProviderWiseInvoiceReport

            Show
            Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Affected Files: OES_SP_Export_ProviderWiseInvoiceReport
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited

            Tested this change on LB with following scenarios

            a) Generating invoice but not finalizing it.
            b) Generating and finalizaing invoice

            Both above scenarios are considered for Rowise Columnwise type of templates along with below

            1) Verified on Changes and full files
            2) Verified on Group Templates (Same Companies)
            3) Verified on Group Templates (Different Companies)
            4) Verified for Multiple Providers and single provider
            5) Verified by deleting run dates from group as well as company level templates

            Records exporting on files are as expected. Ready for Stage Deployement

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - - edited Tested this change on LB with following scenarios a) Generating invoice but not finalizing it. b) Generating and finalizaing invoice Both above scenarios are considered for Rowise Columnwise type of templates along with below 1) Verified on Changes and full files 2) Verified on Group Templates (Same Companies) 3) Verified on Group Templates (Different Companies) 4) Verified for Multiple Providers and single provider 5) Verified by deleting run dates from group as well as company level templates Records exporting on files are as expected. Ready for Stage Deployement
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Updating hours including LB stage and Production testing estimates along developers time spent

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Updating hours including LB stage and Production testing estimates along developers time spent
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            We are BLOCKED to test WT-6949 and WT-5308 on Stage as we are unable to generate invoice and finalize it (as Export file needs finalized invoices).

            We have committed 12/12/2016 Production date for this BCC Providerwise Export enhancement which can be delayed due to this. Will resume testing once WT-6989 gets deployed on stage

            CC: Prasanna Karlekar Rohan J Khandave Satya Hrishikesh DeshpandeSamir

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - We are BLOCKED to test WT-6949 and WT-5308 on Stage as we are unable to generate invoice and finalize it (as Export file needs finalized invoices). We have committed 12/12/2016 Production date for this BCC Providerwise Export enhancement which can be delayed due to this. Will resume testing once WT-6989 gets deployed on stage CC: Prasanna Karlekar Rohan J Khandave Satya Hrishikesh Deshpande Samir
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this on Stage on company level as well as on group level template. Working as expected.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this on Stage on company level as well as on group level template. Working as expected.
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates is working as expected.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates is working as expected.

              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