Thursday, December 31, 2015

FlowField V/S FlowFilter in Dynamics Nav


FlowField V/S FlowFilter in Dynamics Nav

People always ask this question "What is difference between FlowField and FlowFilter ? " in Dynamics Nav.
Lets find out here.

You can find both FlowField And FlowFilter in Fieldclass property of a table's field.

As shown below:

Filedclass Property,Dynamics Nav


FlowField is a type of Fieldclass property in Dynamics Nav table's field,which shows the output of the calculation mentioned in the CalcFormula Property. Eg the Inventory field in the Item table shows the total of the quantity of an item and is calculated as the sum of the Quantity field for all entries in the Item Ledger Entry table for an particular item.



As per MSDN You can use FlowFields to do the following:
  • Calculate the total of a field over a set of records and display the results.
  • Calculate averages.
  • Determine the existence of records in a table.
  • Determine the number of values in a table.
  • Determine the minimum value.
  • Determine the maximum value.
  • Look up a value in another column in another table.


FlowFilter is a also a type of Fieldclass property  in Dynamics Nav table's field, which is use to set ranges on the calculations that are calculated in FlowFields. Eg if the FlowField contains the total inventory of an item, then you can use a FlowFilter to see the total for a period of time slot like month, day etc. 


Note : Both FlowField And FlowFilter are virtual fields. Thats why at the time of data extraction from SQl Server, both will be not extracted.

Enjoyed the topic, Please do subscribe to our newsletter to get updated with every post without a miss.

Thanks for reading

Shubin Dongre

4 comments:

  1. Superb Shubin, it was very useful :)

    ReplyDelete
  2. If you are new user or exiting user of QuickBooks accounting software and looking for the QuickBooks technical support.If yes than you have come to right place as we provide efficient technical support service to customers who show complete faith in us. With our efficient and highly qualified team ,we never disappoint our customers.You can reach us at 1800-961-4623 at any hour of the day. You can also visit our website at https://www.quick.helplinenumber.support/ for the complete knowledge of the QuickBooks products and services.

    The Services we offered are following-

    QuickBooks Technical Support Phone Number
    QuickBooks Technical Support Number
    QuickBooks Tech Support Phone Number
    QuickBooks Tech Support Number
    QuickBooks Customer Support Phone Number
    QuickBooks Customer Support Number

    ReplyDelete
  3. If you are new user or exiting user of QuickBooks accounting software and looking for the QuickBooks technical support.If yes than you have come to right place as we provide efficient technical support service to customers who show complete faith in us. With our efficient and highly qualified team ,we never disappoint our customers.You can reach us at 1800-961-4623 at any hour of the day. You can also visit our website at https://www.quick.helplinenumber.support/ for the complete knowledge of the QuickBooks products and services.

    The Services we offered are following-

    QuickBooks Technical Support Phone Number
    QuickBooks Technical Support Number
    QuickBooks Tech Support Phone Number
    QuickBooks Tech Support Number
    QuickBooks Customer Support Phone Number
    QuickBooks Customer Support Number

    ReplyDelete