Hi,
Suppose we create 2 Draft Document for Outgoing Payment. System assigns DocEntry 1 and 2 in sequence. We can query OPDF table and verify.
Now, from the Payment Drafts report, suppose we delete the last Draft i.e. DocEntry 2.
When we query OPDF table, the DocEntry 2 is deleted from database.
When we create the next Draft Payment, system assigns it DocEntry 3.
How does system know that DocEntry 2 was the last assigned number and so the next number should be DocEntry 3? Where does it store the information, since the row in OPDF table is deleted?
Thanks.