Setup date intervals

This article describes how to setup Date Intervals in Dynamics AX 2012. Date intervals are very usefull in the financial statement.  This article describes the details of the setup of :

  • Current period
  • Next period
  • Previous period
  • Current quarter
  • 1st quarter of the current year
  • 2nd quarter of the current year

Access: GL > Setup > Periods > Date Intervals

1/ Current period

The first date interval to create is the currrent period.

  • Click on “New”,
  • Enter a Date interval code and a description,
  • The field in red are informatives fields. Use it to check if the setup is right.

DateIntervalsGL001

  • In the column “From date” : we want to be at the begining of the period
    • Before: select “Period” : it is the time unit we want.
    • Start/End: select “Start”: we want to start at the first day of the period.
    • In the date calculation zone, we can check that the starting point is the first day of the period. We don’t need to do an adjustement.

DateIntervalsGL002

  • In the column “To date” : we want to be at the end of the period.
    • Before: select “Period” : it is the time unit we want.
    • Start/End: select “End”: we want to be at the last day of the period.
    • In the date calculation zone, we can check that the starting point is the last day of the period. We don’t need to do an adjustement.

DateIntervalsGL003

  • In the top of the screen, we can check that for the 21/08/2013 (date of the current day), the current period will start on the 01/08/2013 and end on the 31/08/2013. That is correct !

DateIntervalsGL004

2/ Next period

Now, we want to create the next period. We are the 21/08/2013, the date interval must start the 01/09/2013 to end the 30/09/2013.

  • Click on “New”,
  • Enter a Date interval code and a description
  • In the column “From date” : we want to be at the begining of the next period
    • Before: select “Period” : it is the time unit we want.
    • Start/End: select “Start”: we want to start at the first day of the period.

DateIntervalsGL005

  • In the date calculation zone, we can check that the starting point is the first day of the current period, and not the next period. We need to do an adjustement.
  • In the field “+/-“, enter +1 and in the field “Days, months, years or periods”, select periods to add a period at the starting point.
  • In the date calculation zone, we can check that the starting point after adjustement is the first day of the next period.

DateIntervalsGL006

  • In the column “To date” : we want to be at the end of the next period.
    • Before: select “Period” : it is the time unit we want.
    • Start/End: select “End”: we want to be at the last day of the period.

DateIntervalsGL007

  • In the date calculation zone, we can check that the starting point is the last day of the current period. We need to do an adjustement.
  • In the field “+/-“, enter +1 and in the field “Days, months, years or periods”, select periods to add a period at the starting point.
  • In the date calculation zone, we can check that the starting point after adjustement is the last day of the next period.

DateIntervalsGL008

  • In the top of the screen, we can check that for the 21/08/2013 (date of the current day), the next period will start on the 01/09/2013 and end on the 30/09/2013.

3/ Previous period

We want to create the previous period. We are the 21/08/2013, the date interval must start the 01/07/2013 to end the 31/07/2013.

  • Click on “New”,
  • Enter a Date interval code and a description
  • In the column “From date” : we want to be at the begining of the previous period
    • Before: select “Period” : it is the time unit we want.
    • Start/End: select “Start”: we want to start at the first day of the period.
    • +/-: enter -1 to do the adjustement of the starting point
    • Days, months, years or periods: select periods.
  • In the date calculation zone, we can check that the starting point after adjustement is the first day of the previous period.

DateIntervalsGL009

  • In the column “To date” : we want to be at the end of the previous period
    • Before: select “Period” : it is the time unit we want.
    • Start/End: select “End”: we want to be at the last day of the period.
    • +/-: enter -1 to do the adjustement of the starting point
    • Days, months, years or periods: select periods.
  • In the date calculation zone, we can check that the starting point after adjustement is the last day of the previous period.

DateIntervalsGL010

  • In the top of the screen, we can check that for the 21/08/2013 (date of the current day), the previous period will start on the 01/07/2013 and end on the 31/07/2013.

4/ Current quarter

We want to create the current quarter. We are the 21/08/2013, the date interval must start the 01/07/2013 to end the 30/09/2013.

  • Click on “New”,
  • Enter a Date interval code and a description.
  • In the column “From date” : we want to be at the begining of the current quarter
    • Before: select “Quarter” : it is the time unit we want.
    • Start/End: select “Start”: we want to start at the first day of the quarter.
  • In the date calculation zone, we can check that the starting point is correct, we don’t need to do an adjustement.
  • In the column “To date” : we want to be at the end of the current quarter
    • Before: select “Quarter” : it is the time unit we want.
    • Start/End: select “End”: we want to be at the last day of the quarter.
  • In the date calculation zone, we can check that the starting point is correct, we don’t need to do an adjustement.

DateIntervalsGL011

5/ First quarter of the current year

We want to create the first quarter of the current year. We are the 21/08/2013, the date interval must start the 01/01/2013 to end the 31/03/2013.

  • Click on “New”,
  • Enter a Date interval code and a description.
  • In the column “From date” : we want to be at the begining of the first quarter of the year.
    • Before: select “Year” : we want to be in the current year.
    • Start/End: select “Start”: we want to start at the first day of the year
  • In the date calculation zone, we can check that the starting point is correct, we don’t need to do an adjustement.
  • In the column “To date” : we want to be at the end of the first quarter of the year.
    • Before: select “Year” : we want to be in the current year.
    • Start/End: select “End”: the starting point will be the last day of the year
    • +/-: enter -9, we want to be at the last the day of the third month of the year.
    • Days, months, years or periods: select months.
  • In the top of the screen, we can check that the from date and the to date are correct.

DateIntervalsGL012

There is an other option to setup the first quarter of the year: we can use the parameter “After” to specify that the date interval ends after a quarter.

DateIntervalsGL013

6/ Second quarter of the current year

We want to create the second quarter of the current year. We are the 21/08/2013, the date interval must start the 01/04/2013 to end the 30/06/2013.

  • Click on “New”,
  • Enter a Date interval code and a description.
  • In the column “From date” : we want to be at the begining of the second quarter of the year.
    • Before: select “Year” : we want to be in the current year.
    • Start/End: select “Start”: we want to start at the first day of the year
    • +/-: enter +3:  we want to start 3 month after the first day of the year.
    • Days, months, years or periods: select months.
  • In the column “To date” : we want to be at the end of the second quarter of the year.
    • Before: select “Year” : we want to be in the current year.
    • Start/End: select “End”: the starting point will be the last day of the year
    • +/-: enter -6, we want to be at the last the day of the 6th month of the year.
    • Days, months, years or periods: select months.

     

DateIntervalsGL014

  • In the top of the screen, we can check that the from date and the to date are correct.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s