Flow field Problem

vikram7_dabasvikram7_dabas Member Posts: 611
When I am going to create the Flow field in table filter it shows me two options:
1. OnlyMaxLimit
2. valueisFilter

Anybody can tell me that whats r they?
Vikram Dabas
Navision Technical Consultant

Comments

  • kapamaroukapamarou Member Posts: 1,152
    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...
  • kapamaroukapamarou Member Posts: 1,152
    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...

    Hope it clears things out for you.
  • vikram7_dabasvikram7_dabas Member Posts: 611
    Dear concern
    Can we do it by coding?
    Vikram Dabas
    Navision Technical Consultant
  • kapamaroukapamarou Member Posts: 1,152
    What exactly do you want to do by coding?

    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...
Sign In or Register to comment.