Forums
Lawson S3 Financials
Fiscal date mapping
Author
Messages
Chesca
Veteran Member
Posts: 490
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: 468
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
10/12/2018 6:29 PM
Awesome, thank you for your time and effort!