How to create auto-generated numbers for a catalog item based on Fiscal Years
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
Hello all,
I have a requirement to create auto-generated numbers for a catalog item based on Fiscal Years.
Our fiscal year starts in July. Hence, I want these auto-generated numbers to update on July 1 of each year.
So when the numbering starts with 25, that means it will be fiscal year 25/26 July 1, 2025 (already in past) and end June 30 2026. Then 26 will be fiscal year 26/27 starting July 1 2026 and end June 30 2027.
I hope this makes sense.
The expectation is format example below:
25-50000
25-50001
26-60000
26-60001
27-70000
27-70001
It seems like I could manually create this for each fiscal year (using the Numbers), but I don't want to do this every fiscal year.
It also seems like I could use the Fiscal Periods to set these up, but I am not sure how to use or otherwise integrate the fiscal periods to auto-generate these.
Seems like there is a better solution.
Maybe some sort of onLoad script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Hello @Nicholas Hromya
Are these requirements for RITM numbering, or is there a custom field on the form that needs to be populated with these numbers?
ServiceNow Technical SME
If my answer helped, please mark it helpful.
Let’s grow together in the ServiceNow Community!
