Flowfield strange problem

tullio

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? ](*,) ](*,) ](*,)

vaprog

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.

lvanvugt

Some questions:

1. Can you give the flowfield definition, i.e. CalcFormula?
2. What is the DrilDownFromID (or DrillDownPageID) on the custom table?