entry no. sequence in customer and vendor ledger

richtsang

I have checked the navision 3.7 database. I notice something interesting. When I checked the sequence of customer and vendor ledger. The entry no. is not in sequence. I always think the sequence of customer and vendor ledger is starting from 1 and incremental add by 1.

However, I checked with sample database for 3.70B and 4.00 SP1. I found that both customer and vendor ledger are not in sequence.

More precisely, will the customer and vendor ledger be in sequence?

mjrogers

The entry no. of all ledger entries should be complete without gaps. This is slightly different to 'in sequence' which simply depends on how you have sorted the table.

Basically by changing the sort to entry no. you should see the entry numbers in sequence, and there should be no gaps.

kriki

Actually, for customer and vendor Ledger entries, this is not the case. They take the "Entry No." from T17.
Every time a customer or vendor ledger entry is posted, also a T17:"G/L Entry" is created. The "Entry No." of both tables are the same.

mjrogers

Doh!... learn something everyday I guess. #-o

kriki

Same for me. Today I learned about the 4.00 SP1 SQL-performance bug!