Can we Print a flow feild in a report?

raj2000_be
Member Posts: 10
In a report we want to get the value of inventory feild from stockkeeping unit table based on few conditions. In stock keeping unit table ,the inventory feild is a flow feild.
when we get the inventory value based on few condition like item no in item card,and some specified location, the value of inventory is not printing in the report but if we print any other feild like Standard cost feild in stockkeeping unit table based on those condition ,the value is printed in the report.
Is this problem due to the inventory feild as flowfield?if so how do we access the flowfeild value in a report.
for eg::
"Stockkeeping unit".SETRANGE("Stockkeeping unit"."Item No.",Item."No.");
"Stockkeeping unit".SETRANGE("Stockkeeping unit"."Location Code",'FACT SHEAR');
"Stockkeeping unit"."Standard Cost" := "Stockkeeping unit"."Standard Cost";
Here we are able to get the standard cost value in the report but if it is
"Stockkeeping unit".Inventory := "Stockkeeping unit".Inventory;
the value is not printing in the report.
The differance between the two feild is only the flowfield.
when we get the inventory value based on few condition like item no in item card,and some specified location, the value of inventory is not printing in the report but if we print any other feild like Standard cost feild in stockkeeping unit table based on those condition ,the value is printed in the report.
Is this problem due to the inventory feild as flowfield?if so how do we access the flowfeild value in a report.
for eg::
"Stockkeeping unit".SETRANGE("Stockkeeping unit"."Item No.",Item."No.");
"Stockkeeping unit".SETRANGE("Stockkeeping unit"."Location Code",'FACT SHEAR');
"Stockkeeping unit"."Standard Cost" := "Stockkeeping unit"."Standard Cost";
Here we are able to get the standard cost value in the report but if it is
"Stockkeeping unit".Inventory := "Stockkeeping unit".Inventory;
the value is not printing in the report.
The differance between the two feild is only the flowfield.
0
Comments
-
I don't understand all, but do you have tried with :
"Stockkepping Unit".CALCFIELDS(Inventory) ?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions