Bank Balance Not Updating

xchild

The bank balance field on the Bank Account Card is not updating to sum up the Bank Account Ledger Entries that have been posted.

The field is a flowfield that sums up bank account ledger entries filtered by Bank Account No. and the two Global Dimension filters.

When I drill down on the bank account card, I find the newer entries exist, but on the card the balance does not add up to the balance of the ledger entries when I drill down.

None of the entries are using dimensions and the objects are base Navision 3.7 objects.

Alex_Chow

Do you have any flowfilters setup on the bank card?

themave

It does that same thing with our 4.0 database, the explanation is that the balance on the card is calculated when you open the form, so if entries post after you have opened the card, the balance won't change, but if you drill down you will see the new entries. the balance on the card will change when you move off the record and move back to it.

If your is doing something different, I would look at the flowfilters as suggested above.

xchild

Well, there is no filter applied on the bank card.

I also made sure that the balance was checked after closing and reopening the form.

I've even setup the objects on another database and the balance does work on the test, but not on the live.

Could there be something wrong with the SQL database?