COUNT Function Returns Incorrect Results

OK, it seems that I panic too much. It would appear that the problem doesn't lie with my code, but with Navision's COUNT function.

On further investigation I found a link between the tables regarding the records that weren't updated... all of these records were at the end of the tables. Therefore the update was getting so far through the table, and then stopping.

Again, looking through this further, I ran a SQL query against one of the tables to get a record count, then I ran a COUNT against the table in Navision.... BINGO!!! Different results for some bizarre reason.

Sticking within Navision I then found the following:

1) The following code does not return the correct record count:

rBACSLedg.RESET;
MESSAGE('Records: ' + FORMAT(rBACSLedg.COUNT));

2) The following code does return the correct record count:

rBACSLedg.SETRANGE(rBACSLedg."Entry No.",0,9999999);
MESSAGE('Records: ' + FORMAT(rBACSLedg.COUNT));

So, in actual fact an unfiltered table has less records than a filtered table!

Am I alone in thinking that this is a tiny bit unusual?

Has anyone come across this before?
Do you know what causes this?

This does not appear to be an issue with every table in every database. Other tables within this database were fully updated. Also, my local database updated every table successfully.

Any further help would be greatly appreciated.

Thanks,
Simon