Closing Month End
marialorena
Member Posts: 62
Hi,
Need your help. The following message appeared when I entered OK while trying to Close the Income Statement. Please advise what does it mean and how to proceed?
Thanks.
The sum of the values in the Amount field cannot be calculated because the current key does not contain all the fields being filtered.
You must select a key that contains all the fields in the filter. The order of the fields is unimportant.
Filter:Business Unit Code:",Global Dimension1 Code: ELECTRONIC, Global Dimension 2 Code: ACER, Posting
Key fields: G/L Account No., Business Unit Code, Global Dimension 1 Code, Global Dimension 2 Code, Posting Date
Need your help. The following message appeared when I entered OK while trying to Close the Income Statement. Please advise what does it mean and how to proceed?
Thanks.
The sum of the values in the Amount field cannot be calculated because the current key does not contain all the fields being filtered.
You must select a key that contains all the fields in the filter. The order of the fields is unimportant.
Filter:Business Unit Code:",Global Dimension1 Code: ELECTRONIC, Global Dimension 2 Code: ACER, Posting
Key fields: G/L Account No., Business Unit Code, Global Dimension 1 Code, Global Dimension 2 Code, Posting Date
0
Comments
-
I think you MUST have this Key:
G/L Account No., Business Unit Code, Global Dimension 1 Code, Global Dimension 2 Code, Posting Date
ENABLED in Table 17 - G/L Entry
with SumIndexFields: Amount,Debit Amount,Credit Amount
NIEM THAI0 -
Hi,
Thanks. I did this already. Still receiving the same message.
What else do I need to do so I can proceed.
Thanks.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
- 322 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