Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Issue w/ Invt. Analysis Views, Invt. Analysis by Dimensions
sreynolds
Member Posts: 4
I am encountering difficulty working with inventory analysis views. I am working in a W1 database, version 6.00, Classic client.
I have set up an inventory analysis view, then run the Update Analysis View batch job. A look to the the Item Analysis View Entry table (7154) indicates that entries have been created for the new inventory analysis view. However, if I use this analysis view when running either the "Item Dimensions - Detail" or "Item Dimensions - Total" reports, the system returns a blank report.
Additionally, when using the Invt. Analysis by Dimensions form (7159), the system only returns data if the Show as Lines and Show as Columns fields are set to user-defined Dimensions. If I set one of these fields to the standard Item, Location, or Period options, the lines/columns remain blank.
I am not encountering these problems when working with the standard Analysis View Codes and Analysis by Dimensions forms; it's only with the ones that have been designed for use with the inventory that these issues occur.
If anyone has encountered similar issues or has advice as to what I'm doing wrong, your assistance would be appreciated.
I have set up an inventory analysis view, then run the Update Analysis View batch job. A look to the the Item Analysis View Entry table (7154) indicates that entries have been created for the new inventory analysis view. However, if I use this analysis view when running either the "Item Dimensions - Detail" or "Item Dimensions - Total" reports, the system returns a blank report.
Additionally, when using the Invt. Analysis by Dimensions form (7159), the system only returns data if the Show as Lines and Show as Columns fields are set to user-defined Dimensions. If I set one of these fields to the standard Item, Location, or Period options, the lines/columns remain blank.
I am not encountering these problems when working with the standard Analysis View Codes and Analysis by Dimensions forms; it's only with the ones that have been designed for use with the inventory that these issues occur.
If anyone has encountered similar issues or has advice as to what I'm doing wrong, your assistance would be appreciated.
0
Answers
The inability to get data when running the ""Item Dimensions - Detail" or "Item Dimensions - Total" reports was due to human error - I was not setting the appropriate filters on the report.
As for the problem with the Invt. Analysis by Dimensions form, this is an error that Microsoft has addressed. To learn more about this, refer to Knowledge Base article 961989, "Nothing is displayed in analysis lines in the Sales Analysis by Dimensions dialog box in Microsoft Dynamics NAV 2009."