NAV Flow Fields in Report Services

Business Central/NAV Technical Forum
1

Hello all,

I am trying to replicate a NAV report in reporting services however Flow FIelds dont seem to appear is it possible to show these fields in reporting services?

2

FlowFields are not actual fields, so no. They are not stored in the database, but calculated on the fly when they are needed. You’ll need to look at the CalcFormula for the flow fields you need and replicate them in SQL.

3

thats correct, depending on your version you have to use views or functions to get access to it.

if you also want a detail how to see here: http://msdynamicsbooks.com/product_info.php?products_id=181

but if you have any detail question how to:

  • which field do you want to use?

  • which version are you running ?

rgds,

rene

4

Thank you both for your reply.

Currently running NAV5.0 and using SQL Report Services 2005 and wanted to use ‘Cost Amount (Actual)’ and ‘Location Code’ fields from the Item Ledger Entry table. Would I need to replicate this in the dataset?

5

Location Code in Item Ledger Entry is not a flow field.

Cost Amount (Actual) is the sum of the Cost Amount (Actual) field from the Value Entry table with matching Item Ledger Entry No.

6

Hi Tazzy,

check out this one (and the releated forum discussion):
http://www.mibuso.com/dlinfo.asp?FileID=1101

This may help you to generate the required sub-queries for NAV FlowFields!

Kind regards,
Jörg

7

Thank you for your reply and thank you Jorg for the link that was very helpful!

8

You are welcome [:)]