Business function to calculate the current period and current fiscal year

praveen1219

Member
Hi all,

To calculate the current period and current fiscal year i found one business function B8000009 in this BSFN i have given input "SL datetoday" for fiscal year i have declared one variable VA rpt fiscalyear_FY while i am trying to get fiscal year trough this BSFN it is not showing this variable.

Can any one please tell me how to find Current period and current fiscal year.

Thanks,
Praveen
 
Praveen,

Try X0903 - ReturnFYPN.

See attached screenshot.

Craig
 

Attachments

  • 152018-x0903.JPG
    152018-x0903.JPG
    87.4 KB · Views: 381
Hi Praveen

You can do this with one more method.

take VA rpt fiscalyear_FY= from the expression manager (advanced functions -- choose date functions and from there use system function -->date_year(SL date today)

now you have the fiscal year.if this value is in 4 digits i mean 2009 than take substring of this value again by using the system functions from advanced functions and take now text functions from their choose the substr() and take out the FY as "09".

similarly do this with PN(peroid number).

hope this will help you in doing your task.


Regards
Jitender
 
A bit old, but this thread helped me quite a bit.

Here's the ER I used to get last FY:
<font class="small">Code:</font><hr /><pre>
VA rpt_FiscalYear1 = substr(date_year([SL DateToday]),2,2)-1
</pre><hr />
 
Remember, that not all organizations follow an 'typical' financial year. Your organization could start its fiscal year in June, causing a six month offset.

You may have to look at each Company's Fiscal Pattern - to confirm how you want to validate your Period/Year.

(db)
 
Back
Top