The Initial Entry No. in Loc. table is used to set up location dependant number ranges for several
tables. These tables are:
G/L Entry,
Item Ledger Entry,
G/L Register,
Item Register,
VAT Entry,
Check Ledger Entry,
Phys. Inventory Ledger Entry,
Item Application Entry,
Transaction Header,
Value Entry,
Detailed Cust. Ledg. Entry and
Detailed Vendor Ledg. Entry.
Normally, when posting takes place, the entry tables listed above receive entry numbers starting from 1. When data is replicated between head office and stores and statements are posted in the stores themselves and the result replicated to head office, there needs to be a different number series for each entry table that is replicated to head office. Otherwise, the stores' entry records overwrite each other.
In this table, you can set up initial numbers for all tables that you replicate from stores to head office for each distribution location, thereby preventing overwriting between locations.
Both store locations and head office need to have entry number ranges for tables replicated from stores to head office.
If there are no number ranges set up for a table/location combination, the program will return to the last entry number. The program displays an error message when Ending No. has been reached no other number ranges are available for the table/location combination. You can use the batch job to create a specific number of entries for a specific table with a fixed increment-by number as initial entry number. Then you can assign a Location to each entry created.
If you are replicating between head office and stores, you most likely post statements in the stores and replicate the results back to head office. Therefore, transactions and ledger entries cannot start on number 1 in all stores. Each store needs to have its own number range that does not overlap the range of another store. The head office must also have its own numbering range, because ordering and purchasing of goods is often carried out in the head office and replicated to the relevant stores.
You can select initial entry number for the following tables, if you are not replicating a specific table, you should not set up a numbering range for that table.
You can either insert the numbering series manually for each location, or use a batch job to speed up the setup by creating numbering ranges for a table.
When you are replicating from store to store through head office, you cannot replicate the tables you set up initial entry numbers for from head office to store, since the entry number in the head office would be too high for the number range in the store.