Jet Professional Basics - Understanding FlowFields

Almost 90% of spreadsheets have errors.

At an onsite  few weeks ago, I opened up a report built by my client, and within 30 seconds I identified  errors on his balance sheet reports that they had been using for several months!  Jet Reports promises to eliminate these errors by standardising and automation data extraction.  But what happens when you don't understand the data coming out of your system?  Time to learn bout FlowFields (predefined calculated fields in Dynamics NAV).

Key Walkawys:
FlowFields are predefined and precalculated fields in NAV

• Balance on Chart of Accounts = sum(Amount) for G/L Entry
  
• Inventory on Item Card= sum(Quantity) for Item Ledger Entry
• Sales (LCY) on Customer  Card = sum(Amount (LCY) for Detailed Cust. Ledger Entry

FlowFields accept different FlowField Filters which modify the CalcFormula

• Balance does not accept Date Filter while Balance At Date does.
• Net Change accepts a date range while Balance At Date only keeps the highest date value.
• Budget Amount accepts Budget Filter while Credit Amount is unaffected by Budget Filter

Any field ending in "Filter" is a FlowField filter and will modify the FlowField calculations.  It will not directly affect the set of records returned.

• eg. Global Dimension 1 Code will filter a table based on the Default Dimension Value whereas Global Dimension 1 Filter will modify FlowField calculations.

For NAV 2013+ Jet Reports users using a Direct to SQL connector should see table definitions in the Browser.
For NAV2009R2 or earlier, refer to the following video.

That's All Folks

​Like what you saw? 
Share with a friend, and subscribe to our bi-monthly newsletter -- don't miss the rest of our Basic Training series.

​If you require one-on-one training, a mentor for some reports you're struggling with, or have a grip of reports you needed done yesterday, contact us, we can get started today.