Most EARP systems are data cemeteries. A lot of data comes in, nothing much ever comes out. To store data in Microsoft Dynamics NAV, the Entry Pattern is most popular with over 75 implementations in the standard product.
Although there are many variations, all entry tables have the same technical structure that can be expanded upon the functional requirements.
The Primary Key for all the entry tables is a field called Entry No. of the type Integer. The value of the field is determined using either the AutoIncrement property, or a code algorithm as the following:
IF NextEntryNo = 0 THEN BEGIN ExLedgEntry.LOCKTABLE; IF ExLedgEntry.FINDLAST THEN NextEntryNo := ExLedgEntry."Entry No."; NextEntryNo := NextEntryNo ...