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

ACA: Export | In case of from date of export is blank should refer fiscal year start date

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
    • Environment:
      QA
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Production Complete - Closed
    • Severity:
      Simple

      Description

      Current Implementation : While exporting data for change file scenario, if there is any retro changes,then that needs to be pulled out on the file. If From date/To date is not provided while exporting file, then it considers from date as 1st day of previous month and to date as last day of previous month.

      New Implementation : In this case, from date should set to fiscal year start date. To achieve this user should give input of from date as fiscal year start date.If this date is blank ,then in that case from date should automatically consider the date of fiscal year start date.

      While exporting a data for change file scenario if there is any retro changes that can be pulled out on the file as from date should be of fiscal year start date. And To achieve this user should be input the from date as fiscal year start date even though this date is blank in that case should automatically consider the date of fiscal year start date.

        Attachments

          Issue Links

            Activity

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Smita Pawar , Please find the technical documentation. Attachment: TechSpec_WT-10365_ACA Export In case of from date of export is blank should refer fiscal year start date.doc Thanks, Revan Yogesh Chaudhari Nandkumar Prabhakar Karlekar Kumar Chhajed
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Manually code reviewed due to code review portal is not working.

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Manually code reviewed due to code review portal is not working.
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Affected files:
            \App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
            \App\BusinessLogic\ImportExportDTS\ExecuteExportDTS.vb

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Affected files: \App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb \App\BusinessLogic\ImportExportDTS\ExecuteExportDTS.vb
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            IMPACT: Once this patch is deployed on Production, must modify schedule of export files for the monthly files to that month end day midnight if missed out to do the same it will fetch the records till
            whatever date is set date considered as todate.

            For ex. To export the July month files is scheduled as on dated 08/10/2017
            if not changed schedule as 07/31/2017 11:59:59
            it will consider from date-01/01/2017, todate as 08/10/2017

            If changed
            It will consider from date-01/01/2017, todate as 07/31/2017

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - IMPACT: Once this patch is deployed on Production, must modify schedule of export files for the monthly files to that month end day midnight if missed out to do the same it will fetch the records till whatever date is set date considered as todate. For ex. To export the July month files is scheduled as on dated 08/10/2017 if not changed schedule as 07/31/2017 11:59:59 it will consider from date-01/01/2017, todate as 08/10/2017 If changed It will consider from date-01/01/2017, todate as 07/31/2017
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Smita Pawar,

            Please confirm the stage date.

            Thanks,
            Revan

            Yogesh Chaudhari Nandkumar Prabhakar Karlekar Sachin Hingole Rakesh Roy

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Smita Pawar , Please confirm the stage date. Thanks, Revan Yogesh Chaudhari Nandkumar Prabhakar Karlekar Sachin Hingole Rakesh Roy
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned enhancement on LB.
            Its working fine,
            PFA test case document for further details

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned enhancement on LB. Its working fine, PFA test case document for further details
            Hide
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi All,
            Attaching production deployment approval email for reference:
            !Re Request for Production deployment - 25 Nov 2017.msg
            Regards
            Gaurav

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi All, Attaching production deployment approval email for reference: !Re Request for Production deployment - 25 Nov 2017.msg Regards Gaurav
            Hide
            yogita.bhadane Yogita Bhadane (Inactive) added a comment -

            Verified this fix on stage. It is working as expected.

            Thanks,
            Yogita

            CC - Prajakta Belhe | Smita Pawar

            Show
            yogita.bhadane Yogita Bhadane (Inactive) added a comment - Verified this fix on stage. It is working as expected. Thanks, Yogita CC - Prajakta Belhe | Smita Pawar
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned change request on production company [Metso for Hspl].
            We have exported change and full file without giving form date and to date,
            PFA screen shot for additional information,

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned change request on production company [Metso for Hspl] . We have exported change and full file without giving form date and to date, PFA screen shot for additional information,

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              revansiddha.gaur Revansiddha Gaur (Inactive)
              Developer:
              Revansiddha Gaur (Inactive)
              QA:
              Smita Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 30h Original Estimate - 30h
                  30h
                  Remaining:
                  Time Spent - 23.5h Remaining Estimate - 17.5h
                  17.5h
                  Logged:
                  Time Spent - 23.5h Remaining Estimate - 17.5h
                  23.5h