You’re offline. This is a read only version of the page.
15
Hi all,
I want to check what the out of the box system does with regards sales quotations and sales orders. At the moment, when I convert a sales quote to an order, the quote disappears off the Sales Quote list. There is no way to find it unless our coordinator has archived it.
In scenario 2 when we close a sales order (ship and invoice all line items ) then then sales order also disappears, unless the coordinator has archived it before all the items are shipped and invoiced.
It seems very weird to me and I have been told by someone else that this is not standard. If it is not, what is/ how should it work and is it difficult to revert to the standard?
The ideal for me would be that the sales quote or sales order status would move to "won" for sales quotes and "completed/fulfilled" for sales orders.
Because they are disappearing off any reports then it is making it impossible to pull out meaningful data in BI.
Thanks for your support.
Hi,
This is offcourse a standard, when you create a Order from Quote, or Post the Order, Quotes disappear and Order disappear after posting. In that case if you want to see them, best solution archive them before disappearing from the system.
Also as you mentioned you required them for some Reporting purposes, please go with the posted data from order.
Thanks.
Hello SNDxb,
Yes, you can get 'Order No.' and 'Quote No.' through Posted Sales Invoice header table.. even if it has disappeared from Sales Order or Quote when you have won the quote and posted the sales order.
Share
Report
All responses (
Answers (
var
SalesInvoiceHeader: Record "Sales Invoice Header";
salesID: Code[20];
if SalesInvoiceHeader.Get(invoiceTransaction.Invoice) then begin
salesID:= SalesInvoiceHdr."Order No.";
end;
People.
Hi
you can also make a small customisation in AL COde on this Sales-Post codeunit event
by setting the variable SkipDelete=TRUE
this allows you to keep any sales document and not delete it in the Sales Header and SAles Lines table
check my answer if it helped you, thanks
DAniele
You can make it automatic using the Sales & Receivables setup.
learn.microsoft.com/.../across-how-to-archive-documents
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,493
Most Valuable Professional
#3
nmaenpaa
101,148