Hi there,
I want to keep sales order list as reference after posting sales invoice from sales order screen. Please advise where in navision i could disable function "delete sales order" upon posting invoice.
Thanks all.
*This post is locked for comments
If you can't change the code unit, you can write a SQL query with multiple SELECT statements and UNION to combine sales order data from sales order, sales shipment and sales order archive tables.
This will produce output with sales order entries from each one of the 3 source tables (where entries exist) as a separate row.
Next, PIVOT the output into a single distinct row, converting each order quantity value into its respective source table column (columns labeled as "Sales Order", "Sales Shipment" and "Sales Order Archive").
And last, add a fourth, calculated column to insert MAX order quantity value from the 3 source columns. This will list your quantity ordered, regardless of the current state of the order so that you can at least report on it.
IMHO, deleting a sales order after it is fully invoiced is a really bad idea. I wish I could some day understand why anyone would design a system in such way.
Archive before deleting the sales order so that you will have only one version of archive. You can customize that part.
if i make archive, then sales order data will be stored in two places and one sales order can be archived many times --> replicate data.....
For you scenario the best option is to use the archive function not to change the standard process of deleting the sales order. Why are you not using the archive function ?
Thanks Mohana Yadav. It works now
Agree with other members that you need to change in CU 80
As Mohana suggested, simply navigate to Codeunit 80 and change EverythingInvoiced to FALSE, it will solve your case, but yoy need to take care certain things like the calculations on the factbox on the sales order screen
Hi,
To keep a copy of your orders, You can activate the archive function.
Regards,
L
Order will be deleted if EverythingInvoiced variable in Codeunit 80 is true.
so you need to change codeunit 80 with EverythingInvoiced := FALSE;
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,307
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
