Options

Flowfield strange problem

tulliotullio Member Posts: 39
I hav a simple flowfield in Item table that sum quantity value (similar table 32) in custom table. So every item display sum quantity in this flowfield.
But for same reason there are items that shows wrong sum.
Example Item ABC shows value 100 but when i drilldown flowfield it's shows an empty table. Also if I filter manually custom table not found record compliance flowfield formula.
What is the problem? ](*,) ](*,) ](*,)

Comments

  • Options
    vaprogvaprog Member Posts: 1,125
    Check by running your custom table directly from the object designer and applying the filters there. If you now see the missing records, there's probably a filter or table view on the record in the form.

    Otherwise I'd try to do the following, one by one, until your issue is solved:
    • Optimize the table from menu file - Database - Information.
    • Run the checks on the database.
    • Remove the sum index field from the database and add it back in (you might simply disable the key, then re-enable it).
    • Create an .fbk backup, and restore it.
    If still not solved, tell us more about you NAV technical version and the database system you're using.
  • Options
    lvanvugtlvanvugt Member Posts: 774
    Some questions:

    1. Can you give the flowfield definition, i.e. CalcFormula?
    2. What is the DrilDownFromID (or DrillDownPageID) on the custom table?
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
Sign In or Register to comment.