7 Replies Latest reply: Feb 11, 2015 9:40 AM by simona farcas RSS

    Custom Calendar with posting periods

      Hi All.

      I need to build a calendar to resemble the SAP Posting Periods as follows :

      SAP Calendar is in the format bellow :

      Fiscal Year Variant  | Year | Calendar Month |  Calendar Day | Posting Period | Year Shift |

      ----------------------------------------------------------------------------------------------------------------------------

          Z1                         | 2014 |     1                       |      22                |        1                 |       0          |

          Z1                         | 2014 |     2                       |      21                |        2                 |       0          |

          Z1                         | 2014 |     3                       |      24                |        3                 |       0          |

          Z1                         | 2014 |     4                       |      23                |        4                 |       0          |

           .

           .

           .

         Z1                          | 2014 |     12                     |      22                |        1 2              |       +1        |   Year change

         Z1                          | 2015 |     1                       |      23                |        1                 |       0          |

         Z1                          | 2015 |     2                       |      23                |        2                 |       0          |

      and so on.

       

      I am trying to build a Calendar as follows :

       

       

      fYearPosting PerDateMonth
      2013123 Dec 2013 (period starts on 23 Dec 2013)Dec
      2014101 Jan 2014Jan
      2104102 Jan 2014Jan
      ...............................................................
      2014223 Jan 2014 (new posting period starts)

      Jan

      2014224 Jan 2014Jan
      2014225 Jan 2014Jan
      .................................................
      2014221 Feb 2014 (Posting period ends)Feb
      2014322 Feb 2014Feb
      2014323 Feb 2014Feb
      ..................................................................
      20141222 Dec 2014Dec
      2014123 Dec 2014 (New Posting period starts)Dec
      .................................................................
      2015101 Jan 2015 (year change)Jan
      2015102 Jan 2015Jan

       

       

          Has anyone done anything similar ? Thanks in advance.