Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Date Conversion modules

Former Member
0 Likes
570

I want to convert calendar month to a fiscal period, calendar year to a fiscal year, ( vice versa given a fiscal period how to find calendar month and given fiscal year the calendar year).

Please note that in both cases I will have the fiscal variant as well.

Please Help

Regards

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
516

It depends on how the fiscal periods are defined.

If the fiscal period begin the first day of the month and end the last day you could use the following fms...

DATE_TO_PERIOD_CONVERT -> given a date it returns the fiscal period...

PERIOD_DAY_DETERMINE -> given a fiscal period it returs start and end date.

(check OB37 for the Fiscal year variant)

If the fiscal period are defined across months (e.g. 2003.01 starts 23.09.2002 and ends 20.10.2002) It won't work...

Reward Helpful

Regards

2 REPLIES 2
Read only

andreas_mann3
Active Contributor
0 Likes
516

hi,

1) FTI_FISCAL_YEAR_MONTH_GET

2) G_POSTING_DATE_OF_PERIOD_GET

Message was edited by: Andreas Mann

Read only

Former Member
0 Likes
517

It depends on how the fiscal periods are defined.

If the fiscal period begin the first day of the month and end the last day you could use the following fms...

DATE_TO_PERIOD_CONVERT -> given a date it returns the fiscal period...

PERIOD_DAY_DETERMINE -> given a fiscal period it returs start and end date.

(check OB37 for the Fiscal year variant)

If the fiscal period are defined across months (e.g. 2003.01 starts 23.09.2002 and ends 20.10.2002) It won't work...

Reward Helpful

Regards