Open Forum

2020 Leap year errors

  • 1.  2020 Leap year errors

    BRONZE CONTRIBUTOR
    Posted Feb 16, 2021 03:59 PM
    Hi,

    I am trying to run some trailing 12 Management Reporter reports for 2020 and my Feb and March months are off.  To me it looks like it is trying to use Feb 28th for an end date instead of Feb 29th. So Feb is basically blank and March is doubled up.  Is there a way to fix this?  Is it the way the columns are set up?  We weren't using MR in 2016 so this is my first experience with a leap year issue like this.

    ------------------------------
    Nancy Ludin
    Chief Accounting Officer
    MyPath Support Services
    Dousman WI
    ------------------------------


  • 2.  RE: 2020 Leap year errors

    BRONZE CONTRIBUTOR
    Posted Feb 17, 2021 09:18 AM

    I just saw this exact same issue at a site where the fiscal calendar in GL Setup had recently been updated.  You need to rebuild your data mart.

     

    Michael Lee

    IT evolution Management, LLC

    970.587.6788 Direct

    970.590.4636 Mobile

    Mike.Lee@ITeMLLC.com

    www.ITeMLLC.com