Need Help using FlowField

Iqbal_Febriano
Member Posts: 66
My client needs to see their item sales and purchases according to specific salesperson and principal. So we made Global Dimension 1 Code as Principal Code and Global Dimension 2 Code as Salesperson Code.
Then, I made a form with Table 27 (Item) as Source Table and put Global Dimension 1 Filter, Global Dimension 2 Filter, and Date Filter controls. I hoped when I change the value in those controls, the Purchase (Qty.) and other fields that alike will also change accordingly.
It works fine when I typed in Date Filter control
, but when I put a value in Global Dimension 1 Filter or Global Dimension 2 Filter control, this error message showed up

I know that Item Ledger Entry table has Keys containing Global Dimension 1 Code, Item No., and Entry Type. I just couldn't find out where should I put a code to activate the key. I tried to put
in OpenForm, OnGetCurrRecord, OnAfterGetCurrRecord triggers, also in Control -Validate and AfterValidate, but it didn't work
Help me please
Then, I made a form with Table 27 (Item) as Source Table and put Global Dimension 1 Filter, Global Dimension 2 Filter, and Date Filter controls. I hoped when I change the value in those controls, the Purchase (Qty.) and other fields that alike will also change accordingly.
It works fine when I typed in Date Filter control

[color=blue]The FlowField value cannot be calculated You must define and activate a key that contains the key fields that appear below and then associate the specified SumIndexFiled with it Key Fields : Global Dimension 1 Code, Item No., Entry Type SumIndexField : Invoiced Quantity Table : Item Ledger Entry[/color]

I know that Item Ledger Entry table has Keys containing Global Dimension 1 Code, Item No., and Entry Type. I just couldn't find out where should I put a code to activate the key. I tried to put
ItemLedgEntry.SETCURRENTKEY("Global Dimension 1 Code",...)
in OpenForm, OnGetCurrRecord, OnAfterGetCurrRecord triggers, also in Control -Validate and AfterValidate, but it didn't work
Help me please

Be fast, be straight, be quiet
0
Comments
-
Navision automatically selects which key to use when calculating flowfields, so you can't solve it by adding code.
The problem must be in the key you have created.
When the error msg say you should "activate it", it simply means it should be enabled by having a checkmark in the keys window.
I have always been able to use this error msg very detailed. So if you have created the key as specified and remembered to set Invoiced Quantity as SumIndexField I can only find two issue left. Is MaintainSIFTIndex and MaintainSQLIndex set to yes? Is SIFTLevelsToMaintain set to maintain all levels?
Otherwise I'm blankRegards
Peter0 -
Thanx Peter, you're right. Apparently I have enabled a wrong keyBe fast, be straight, be quiet0
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