How to optimise this? - Count Flow Field

mariussw

I use a flow field in a table to count the no. of records from G/L Entry table,
based on Global Dimension Code 1 and 2 values.

Opening the corresponding form is slow.

From the window that open "Searching / Counting G/L Enrty ..." it is is evident that the key used in the G/L Entry table is Entry No., rather than a key that contain Global Dimensione Code 1 and 2.

Is there a way I can change the bahaviour?

Luc_VanDyck

mariussw wrote:

Is there a way I can change the bahaviour?

Add a key to the G/L Entry table, that starts with "Global Dimension 1 Code, Global Dimension 2 Code" (if you want to count the number of records regardless of the G/L Account No. that is).