PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/12/2018 2:29 PM by  Chesca
Fiscal date mapping
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Chesca
Programmer/analyst
State
Veteran Member
(1036 points)
Veteran Member
Posts:486


Send Message:

--
10/11/2018 8:27 AM
    I have a query that pulls Purchase orders from POLINE, PURCHORDER, and MMDIST. I having a hard time mapping the fiscal year, does someone know how to get the fiscal year for each po?
    Ragu Raghavan
    Private
    Private
    Veteran Member
    (890 points)
    Veteran Member
    Posts:310


    Send Message:

    --
    10/11/2018 10:13 AM
    if the FY is current/prev/next, you can possibly use GLSYSTEM. Compare MMDIST.Posted_date to GLSYSTEM.Per_end_date. if between 1-13, current FY. If between 14-26, Last FY. 27-39 Next FY.

    or maybe code the logic. Let us say your FY runs from 4/1 - 3/31. if MMDIST.posted_date >= 4/31/2017 and <= 3/31/2018, FY = 2017 and so forth?
    Chesca
    Programmer/analyst
    State
    Veteran Member
    (1036 points)
    Veteran Member
    Posts:486


    Send Message:

    --
    10/12/2018 2:29 PM
    Awesome, thank you for your time and effort!
    You are not authorized to post a reply.