# JD Edwards Next Numbers Capacity Worksheet > Source: https://netray.co/tools/jde-next-number-capacity-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer List the next number series you track, their current and ending values and annual volume, and see how many years of headroom remain. ## Category oracle ## Erp Oracle JD Edwards EnterpriseOne ## Audience - JDE functional consultant - JDE CNC administrator - Finance systems ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### System code **Key:** system **Type:** text #### Series / use **Key:** series **Type:** text #### Method **Key:** method **Type:** select **Options:** - Standard - By company / fiscal year - Check digit used #### Current next number **Key:** current **Type:** number #### Ending value **Key:** ending **Type:** number #### Used per year **Key:** annual **Type:** number #### Numbers remaining **Key:** remaining **Type:** number **Expr:** ending - current #### Years of headroom **Key:** years **Type:** number **Expr:** remaining / annual **Format:** decimal #### Action **Key:** action **Type:** text **Rows:** **System:** 42 **Series:** Sales order number **Method:** By company / fiscal year **Current:** 482310 **Ending:** 999999 **Annual:** 120000 **Action:** Review at year end **System:** 43 **Series:** Purchase order number **Method:** By company / fiscal year **Current:** 318900 **Ending:** 999999 **Annual:** 45000 **Action:** None **System:** 00 **Series:** Address book number **Method:** Standard **Current:** 5201440 **Ending:** 99999999 **Annual:** 18000 **Action:** None **System:** 31 **Series:** Work order number **Method:** Standard **Current:** 893400 **Ending:** 999999 **Annual:** 60000 **Action:** Plan range extension **System:** 04 **Series:** Voucher number **Method:** By company / fiscal year **Current:** 640200 **Ending:** 999999 **Annual:** 150000 **Action:** Review at year end **Totals:** #### Series tracked **Key:** series **Agg:** count **Format:** integer #### Shortest headroom (years) **Key:** years **Agg:** min **Format:** decimal **Notes:** Example values only. Read the real current and ending values from the Next Numbers application (P0002) in the environment you are checking. Rows with zero annual volume show zero years because no usage was entered. ## Content **Intro:** A JD Edwards series that reaches its ending value stops issuing numbers, and users see errors at the worst possible moment. This worksheet keeps a running view of how much headroom each tracked next number series has left. **Sections:** #### How to use the worksheet **Body:** List the series you care about: sales orders, purchase orders, work orders, vouchers, address book, batch numbers. Enter the current next number and the ending value from the Next Numbers application, and your estimated annual usage from reports or last year's growth. The worksheet calculates the numbers remaining and the years of headroom. Anything under two or three years deserves an action. **Bullets:** - Check each environment separately. - Include series configured by company and fiscal year. - Review the sheet at every year end. #### Where next numbers live **Body:** In EnterpriseOne, the Next Numbers application (P0002) maintains the series by system code and index. Some systems also support next numbers by company and fiscal year, and the check digit option adds a digit to the issued number. Those variations change the effective capacity, so record the method alongside each series. Remember the series is also bounded by the field size of the data item that stores the number. #### Fixing a short runway **Body:** Options include extending the ending value, if the data dictionary field size allows it, moving to a by-company or by-fiscal-year method, or resetting at year end where your business rules permit. Each choice affects reports, integrations and anything that assumes number length or ordering. Test the change in a lower environment and tell integration owners before you change production. #### Common mistakes **Body:** Teams copy next numbers from production into a test environment and then test with numbers that collide with real ones. They ignore series that look huge but are used by an integration at high volume. They forget that the ending value may be larger than the field can display. Keep the sheet current and attach it to your year end checklist. **Cta:** If you want next numbers, table sizes and other capacity indicators watched automatically across JDE environments, Netray can discuss a read-only monitoring approach. **Faq:** #### What happens when a next number series is exhausted? **Answer:** The system cannot issue a new number for that series, so the transaction fails or the user receives an error. Fixing it under pressure in production is risky, which is why checking headroom ahead of time is worth the effort. #### How do I estimate used per year? **Answer:** Count documents created in the last twelve months from the relevant table or a standard report, then add expected growth. For a rough check, subtract the next number a year ago from today's value. #### Can I just raise the ending value? **Answer:** Often, but only up to the size the data item and downstream systems can hold. Confirm field lengths, report layouts and integrations that parse the number before changing it. #### Should test environments be reviewed too? **Answer:** Yes, mainly for collisions after a refresh. A test environment copied from production carries production next numbers, which can clash with integrations or with a second system that uses the same ranges. ## Search terms jde next numbers, jd edwards next number exhausted, jde p0002 next numbers review, jde next number range worksheet, jde next numbers by company fiscal, jde document number rollover, jd edwards next number audit --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json