Prev
Next
Forums Financial Management Lawson S3 Financials

Fiscal date mapping

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
10/11/2018 12:27 PM
    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
    Veteran Member
    Posts: 476
    Veteran Member
    10/11/2018 2:13 PM
      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
      Veteran Member
      Posts: 490
      Veteran Member
      10/12/2018 6:29 PM
        Awesome, thank you for your time and effort!