Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
Options
Trailing Sales Orders in NAV2013
chrisdf
Member Posts: 82
Have just been exploring the standard example of using a query page in NAV2013 - trailing sales orders.
It's surprising to me that MS have used the "Amount" field form the Sales Line table as the cornerstone to this feature (see the query object). If you have a look at this in the standard Cronus database, the Amount field on the sales lines are populated so the query works fine.
However, if you Release->ReOpen an open Sales Order, then the "Amount" fields are cleared. Therefore, if you look at the chart values, then Release an Open Sales Order, then Re-Open the same Sales Order, I would expect the Chart values to remain the same at the end of this operation - but they do not.
Anybody think MS should have used the "Line Amount" field as opposed to the Amount field ?? (Or am I missing something obvious?)
It's surprising to me that MS have used the "Amount" field form the Sales Line table as the cornerstone to this feature (see the query object). If you have a look at this in the standard Cronus database, the Amount field on the sales lines are populated so the query works fine.
However, if you Release->ReOpen an open Sales Order, then the "Amount" fields are cleared. Therefore, if you look at the chart values, then Release an Open Sales Order, then Re-Open the same Sales Order, I would expect the Chart values to remain the same at the end of this operation - but they do not.
Anybody think MS should have used the "Line Amount" field as opposed to the Amount field ?? (Or am I missing something obvious?)
0
Comments