Hi
This may sound a little stupid, but I have to ask. I have upgraded a customer from NF 2.60 to NAV 4.00 SP3 and now all their sales orders are gone except for the one that were open before upgrade.
And I have also seen now that when a Sales Order is delivered and invoiced it is removed from Sales Header.
Is this supposed to happen? I mean there is a function to copy document that can copy from sales orders.
I know that you can get the same information from the invoice lines, but still it's more complicated than looking on the original order.
So, my question is, why do the sales orders disappear?
They don't seem to be deleted when using combined shipment though... #-o
0
Comments
when posted move to
Sales Invoice Header & Sales Invoice Line
see table ranges 110 ~ 125
there is a copy document function available.
http://www.BiloBeauty.com
http://www.autismspeaks.org
And yes, when you use combine shipment, the completed sales order will not be deleted. You will need to manually purge it using the Data Deletion under IT Administration.
The reason why completed orders are removed from the sales order section is so the user doesn't need to search through completed orders when they push F5.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
OK, I guess that makes sence. Although in my customers case it introduces some problems. They had a report in the previous version that calculated the percentage of delivered order according to promised delivery date. It was simply a check in Sales Line for all lines shipped versus not shipped.
Now when the orders disappear from the table when completely shipped I must make some combination of Sales Line and Sales Invoice Line to get the complete picture over all order lines.
But I guess it's just a matter of doing it... Shouldn't take so much time.
One problem though since some lines will appear in both Sales Line and Sales Invoice Line. Then I must filter out those so I get the information only once.
Or is there another solution to see the quality of order delivery?
Of course, you'll need to keep track of the original ordered quantity. For some reason, standard Navision doesn't have a field for that.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book