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
- 297 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
Sales Analysis Dimension rounding qty error
paddypower
Member Posts: 98
NAV VERSION 4.03
Please help! [-o<
When comparing Sales Analysis Dimension report (By Item) and then comparing the qty sold total with the Item Card turnover ther are differences.
This difference occurs because there is an extra sales line displayed in the Dimension report. This transaction type is called "Rounding". The transaction was created to deal wth foreign currency rounding and the actual value is only 0.01. But the qty value is very high (in this case it is -1750)
Why is the qty field on the rounding not '0'?
Is there any way you can exclude rounding qty's in the dimension report.
Thanks for your help. =D>
Regards,
Please help! [-o<
When comparing Sales Analysis Dimension report (By Item) and then comparing the qty sold total with the Item Card turnover ther are differences.
This difference occurs because there is an extra sales line displayed in the Dimension report. This transaction type is called "Rounding". The transaction was created to deal wth foreign currency rounding and the actual value is only 0.01. But the qty value is very high (in this case it is -1750)
Why is the qty field on the rounding not '0'?
Is there any way you can exclude rounding qty's in the dimension report.
Thanks for your help. =D>
Regards,
0
Comments
A rounding line in Dynamics NAV should have a "Quantity (Base)" of 1 along with an "Invoiced Qty. (Base)" of 1 as well.
Was this entry from a prior version of Dynamics NAV? Was there an upgrade? Usually, this is the culprit and requires data changes to be made by your local solution center.
- Scott
Vice President, Deployment Operations
Symbiant Technologies, Inc.
http://www.symbiantsolutions.com