Overview of Next Numbers and Next Numbers by Company Within EnterpriseOne Accounts Payable Setup (P0002, P00022)

Purpose

This document provides information on Next Numbers Next Numbers by Company for EnterpriseOne Accounts Payable.

Scope

This document is intended for EnterpriseOne users who are setting up the Accounts Payable module for use within their organization.

Details

Set Up Next Numbers

When a program retrieves a next number from the Next Numbers - Automatic table (F0002), it references a specific line in the next number table for the appropriate system. If the next number table becomes damaged or if entries are mistakenly deleted, you must set up the next number for the appropriate program on the specific line. Use fast path NN:

Search by system 04:

This table provides the description of each next number line listed above necessary to create the next number entries for the JD Edwards EnterpriseOne Accounts Payable system:

The Next Number program can be accessed by either typing NN in the Fast Path, or from the General Systems menu (G00) selecting Setup Next Numbers by System. Next Numbers are used to automatically assign essential numbers throughout the Accounts Payable application. For example, the Document Number (data dictionary item DOC) for vouchers is assigned automatically using the Next Numbers (P0002) program. Next numbers work in conjunction with the Data Dictionary. Each Data Dictionary item that uses Next Numbers contains an index value that corresponds to the line number with the correct Next Number value. The Next Numbers program (P0002) assigns numbers to documents using either one of the following methods:

• Standard Numbers: The next available number in the Next Numbers (F0002) table is retrieved and assigned to the document.
• Next Numbers by Company and Fiscal Year: The system finds the next available number either for a specific company and fiscal year, or by the company only in the Next Numbers by Company/Fiscal Year - Automatic (F00021) table.

When using Next Numbers (P0002), the following rules apply:

• Do not use blank as a Next Number value.
• Do not change a Next Number. Changing the numbers can result in duplicates, as well as the inability to locate previously added numbers. If a next number must be changed, it should be changed to a greater value only.
• Do not delete next number values.
• Do not change the sequence of the next numbers in the table. Each next number must remain on its current line because the system references a specific line in the table.

Check Digit Used

Check Digit Used Select to specify that the system adds a number to the end of each next number assigned. For example, if you use check digits and the next number is 2, the system adds a check digit such as 7, making the last two numbers 27. The check digits option provides a method for increasing numbers randomly to prevent the assignment of transposed numbers. In this example, the system would never assign next number 72 while the check digits option is activated.

Set Up Next Numbers By Company and Fiscal Year

You may want to set up next numbers by Company and Fiscal Year. Below provides how to set up and use the Next Numbers (P0002) by Company and Fiscal Year.

Next Numbers Constants

Open the Next Numbers (P0002) program

Select Form Exit and NN Constants

Select one of the following options:

• Option 2: Implement Next Numbers by Company/Fiscal Year. The Next Numbers will default to 1 if not configured for a specific company.
• Option 3: Implement Next Numbers by Company/Fiscal Year. The standard Next Number will be used if not configured for a specific company.

Fiscal Years

A fiscal year cannot be added to or removed from an existing Next Numbers by Company/Fiscal Year - Automatic (F00021) record. To do so, a user must remove the existing record and create a new one with the desired changes.

Same-As Doc Type

Enter a value from UDC table 00/DT (Document Type- All Documents). In certain cases, it is necessary for several Document Types to share a Next Number. For example, Debit Memos (document type PD) should use the same next number sequence as Standard Vouchers (document type PV). Therefore, in the Next Numbers by Co/Fiscal Year (W0002H) form, the record for Document Type (data dictionary item DCT) PD should have the Same-As Doc Type set to PV.

Imbed Digits

Enter the number of digits that the system places at the beginning of an assigned document number to represent the fiscal year. This field only applies when next numbers are by fiscal year. Valid values are:

1. Imbed one digit. The last digit of the fiscal year will be imbedded in the first position of an assigned document number. For example, in 70012345, the first digit represents the 7 from 2007. The remainder of the number (0012345) is the next number value.Imbed two digits. The last two digits of the fiscal year will be imbedded in the first two positions of an assigned document number. For example, in 07012345, the first two digits represent the 07 from 2007. The remainder of the number (012345) is the next number value.

Auto Reset

Enter the number that the system uses when resetting next numbers for a new fiscal year. This field only applies when next numbers are by fiscal year.

Next Numbers for Payment Control Group

When running Create Payment Control Groups (R04570) for Automatic Payment Processing, the system retrieves next numbers for the Payment Group Control Number field (HDC) in the AP Payment Processing Header File (F04571) during the Accounts Payable payment process and the payment ID (PYID) from the Unique Key table (F00022). Fast path using P00022 and inquire on F0413 and F04571.  This feature is included in all releases above ERP8.0.  

Inquire on F04571

Common Next Numbers (P0002) Questions

Question 1: Is it possible to retrieve previous configurations of Next Numbers (P0002)?

Answer 1: There is no audit trail for Next Numbers (P0002).

Question 2: What happens if a next number has reached its maximum value (99999999)?

Answer 2: Once the maximum number is reached, the next number is reset to 1. The system will only use next numbers that are available in the system and have not been used for other records. Enhancement Bug 10943887 has been entered requesting a warning message when a next number has reached its maximum.

Question 3: Check numbers are incorrectly incrementing when creating EFT payments, why?

Answer 3: Check the Special Handling Code (data dictionary item SPHD) for the EFT payments print program (i.e. P04572T2) in UDC table 04/PP (Produce Bank File). To avoid this issue, the Special Handling Code needs to be set to 2.