As discussed earlier, screens in Microsoft Dynamics NAV are built directly on one table. These table definitions contain all fields including the totals. However, these totals are not real database fields.
WHERE (G/L Account No.=FIELD(No.),
G/L Account No.=FIELD(FILTER(Totaling)),
Business Unit Code=FIELD(Business Unit Filter),
Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),
Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),
Posting Date=FIELD(UPPERLIMIT(Date Filter))))
This creates the sum of the field amount in the G/L Entry table (17) filtering on G/L Account, G/L Account No., Business Unit Code, Global Dimension 1 & 2 Code, and Posting Date.
We will use and discuss more of these flow filters and flow fields later in this book.