Hello, Can someone tell me the significance of the Entry No. field of Ledger Entry tables matching the Entry No. of the G/L Entry table? Thanks.
It historic, going way back, and it was for performance reasons. Logically there will always be more G/L entes than Customer Vendor etc. So Basically doing a find onthe GL entry gives you the number to start on, and then just count up. In earlier versions of Navision the link was very strict, and you could even put table relations on Cust Ledg Entryno to the Gl. Now performance in finding is not an issue (there are plenty of other things to worry about), and Navigate over comes all the linking issues, so it is sort of redundant now a days. Though it still helps in registers. Still if you are writing an add-on that uses entries, then follow this procedure.
The Entry No. has an auditing purpose as well. The Entry No. is the proof that no entries are missing, which could indicate that the accounting has been manipulated. Regards,