SALES ORDERS LIST

lanemark
Member Posts: 83
We are using V5 of navision.
I would like to see the total value of Sales orders on hand that we have not invoiced.
If I look at the Sales Orders List not all "amount" values are showing, it seems only to orders that have been shipped but not invoiced.
Is there a way I can see all order values.
Alan
I would like to see the total value of Sales orders on hand that we have not invoiced.
If I look at the Sales Orders List not all "amount" values are showing, it seems only to orders that have been shipped but not invoiced.
Is there a way I can see all order values.
Alan
0
Comments
-
The Amount is not calculated if the order is still OPEN. If you Release the order - you will see the Amount field with a value.0
-
You can show the Line Amount field. It'll show you what the amount is before releasing.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0 -
On the Sales Order Card, u can press F9 to see the Order Amount.
If you have some lines shipped and these lines (or only some) invoiced, and you need now the restamount for the invoice u can calculate the field "Shipped Not Invoiced" based on the Sales Lines.Do you make it right, it works too!0 -
All you guys have confirmed my thoughts.
But does anyone know how I can look at total of all orders unshipped, I want to see how many ££'s we have has a total on orders.0 -
The quickest & eaiest way would to create a report.
Total Up the Line Amount on the sales line table0 -
I realise now that we have not been using the release function. We normally raise a sales order and it stays editable right through to shipping and invoice.
As a standard do most companies release a sales order once it has been created? I notice that if we do release it prevents accidental changes to item lines,
Alan0 -
If Warehouse Shipment is required with combined shipments from multiple Sales Orders, there's really no choice...Otherwise
Release:
For every Sales Order, one additional click & hold or two clicks on Function -> Release is required, the same for Reopen.
If amendment is frequent, this becomes tedious, you get users forgetting to reopen until they finish typing & realizing too late.
No Release:
Amendment easy, mistakes & errors also easy
Does the company believe in the concept of Release? How long does the Order remain in the system until fully processed? What are the chances of last minute additions/cancellation/amendments?NAV - Norton Anti Virus
ERP Consultant (not just Navision) & Navision challenger0
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