IF you go to table 15 G/L Account you'll see field "Balance at Date"
1) OnlyMax for the posting date. The system will apply the maximum value of the filter, for example 010108..311208 will filter 0D..311208
2)Value is Fitler. The field is a filter. So since the G/L entries are mostly created for the last level of the account, the previous levels will show the same total even though no entries may exist for the first level...
To see what the system does do the following: Go to table 15. Apply a date filter. Lookup column Balance at date. In the ledger entries form that opens look at the filters that are applied...
You can do almost anything... You can call CALCSUMS or you can re-invent the wheel by applying filters and looping the record and calculating the SUM through your code.
Let us know what exactly you want to do so we can help...
Comments
1) OnlyMax for the posting date. The system will apply the maximum value of the filter, for example 010108..311208 will filter 0D..311208
2)Value is Fitler. The field is a filter. So since the G/L entries are mostly created for the last level of the account, the previous levels will show the same total even though no entries may exist for the first level...
Hope it clears things out for you.
Can we do it by coding?
Navision Technical Consultant
You can do almost anything... You can call CALCSUMS or you can re-invent the wheel by applying filters and looping the record and calculating the SUM through your code.
Let us know what exactly you want to do so we can help...