Who's On?

	Membership:
	Latest: Jeffin Joy
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 4988

	People Online:
	Visitors: 56
	Members: 0
	Total: 56

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

Fiscal date mapping

2 Replies

0 Subscribed to this topic

45 Subscribed to this forum

Sort:

Author

Messages

Chesca

Veteran Member

Posts: 490

New Poster

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: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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

New Poster

10/12/2018 6:29 PM

Awesome, thank you for your time and effort!