Fiscal calander

[Krish2459_58]

Hi ,

I need to build a fiscal calander where start month is 10th(October).

Please see the below flow required. Also attached the requirement sheet.

client monthnum start	Date	Fisacl	Actual	Sales	YTD Sales Fisacl
10	202312	Sep-23	Dec-23	10
10	202401	Oct-23	Jan-24	3	3
10	202402	Nov-23	Feb-24	40	40
10	202403	Dec-23	Mar-24	50	50
10	202404	Jan-24	Apr-24	45	45
10	202405	Feb-24	May-24	36	36
10	202406	Mar-24	Jun-24	23	23
10	202407	Apr-24	Jul-24	67	67
10	202408	May-24	Aug-24	4
10	202409	Jun-24	Sep-24	345
10	202410	Jul-24	Oct-24	3455
10	202411	Aug-24	Nov-24	355
10	202412	Sep-24	Dec-24	38
10	202501	Oct-24	Jan-25	78
10	202502	Nov-24	Feb-25	34
10	202503	Dec-24	Mar-25	90
10	202504	Jan-25	Apr-25	68

[pallavi_96]

Hi @Krish2459_58 ,

While your script is generating the fiscal calendar,

You have the variable set as follows.

set vFiscalYearStartMonth = 10

[Krish2459_58]

Could you please share the script if any.

[Krish2459_58]

Also sharing the requirement doc to implement fiscal calander.

[Krish2459_58]

Hi,

Any suggestions please.

[Krish2459_58]

Hi any suggestions.