Symptom
Payment Document numbers are skipped and are not in sequence. It is not possible to retrieve them in the system.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Payment Management work center.
- Navigate to the Payment Monitor view.
- It can be seen that the payment document numbers have been skipped and are not in sequence. eg sequence: 1, 2, 6, 7, 8 (3-5 are missing and unused)
Cause
SAP uses a main memory buffering concept for payment management number allocation. Due to this design, chronological order and gap-free numbering are not guaranteed.
This behavior occurs because number ranges are buffered in the application server's main memory. In general, the same number is never allocated twice. However, under certain circumstances, allocated numbers may be lost:
- If an application instance is restarted, all buffered numbers that were loaded into memory are lost.
- If a number is assigned but the transaction is rolled back, the number is not returned to the buffer and therefore cannot be reused.
- If a user starts creating a payment document but does not complete the process for any reason, the assigned number is lost.
Example Scenario
- User 1 starts creating a payment document and is assigned a document number.
- At the same time, User 2 starts creating another payment document and is assigned the next available number.
- User 1 does not complete the document creation due to reasons such as a system failure, power outage, application interruption, or abandoning the process.
- As a result, the number assigned to User 1 is not used and will appear as a missing number in the sequence.
Resolution
This is expected system behavior.
Keywords
Document ID; Payment ID; range; skipped; jumped; missed; gaps; payment monitor; document id,payment id,range,skipped,jumped,missed,gaps,payment monitor , KBA , AP-PAY , Payment Processing , How To
SAP Knowledge Base Article - Public