Troubleshooting Next Numbers Within EnterpriseOne Accounts Payable (P0002, P00022)

Error Message - "Insert to table F0414 failed"

Question 1: During Standard Voucher Entry (P0411), the same voucher Document Number can be entered for different companies, even though next numbers by company is not activated, why?

Purpose

This document helps troubleshoot common errors with Next Numbers within EnterpriseOne Accounts Payable.

Troubleshooting Steps

Common Next Number Errors

Error Message - "Insert to table F0414 failed"

Scenario: The system triggers error "Insert to table F0414 failed" when updating an automatic payment or creating a manual payment, why?

Solution: This error may be caused if the system is unable to assign a Payment ID (data dictionary item PYID) for the new payment. To verify this may be the cause, check the following:

The last used Payment ID (PYID) in the Accounts Payable Matching Document Detail (F0414) and Accounts Payable Matching Document (F0413) tables should be in sync.
The next number for Payment ID (PYID) in the Unique Keys File (F00022) is higher than the highest Payment ID (PYID) used in the Accounts Payable Matching Document Detail (F0414) and Accounts Payable Matching Document (F0413) tables.

Note:You can use the Next Unique Key Number application (P00022) to increment the next PYID number to a higher and unique number.

Common Next Number Issue(s)

Question 1: During Standard Voucher Entry (P0411), the same voucher Document Number can be entered for different companies, even though next numbers by company is not activated, why?

Answer 1: On voucher records, the Document Number (data dictionary item DOC) is a key field only in conjunction with the Company Number (data dictionary item CO). Therefore, the system allows document numbers to be reused for different companies. Using Next Numbers (P0002) by Company just provides separate next number values that will be assigned automatically based on the Company Number (CO).