22
Hi All,
When a sales order is created from a sales quote, I would like to have the document date updated to "Today's Date"
EG
If i create a sales quote on 12/12/22 and only converted it to a sales order on 12/29/22, i would like the document date to show 12/29/22
How do i go about doing this?
Thanks!
Hi Inge,
Thanks for your help.
This is what i sued and it worked!
[EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Order", 'OnAfterCreateSalesHeader', '', true, true)]
local procedure OnAfterCreateSalesHeader(var SalesOrderHeader: Record "Sales Header"; SalesHeader: Record "Sales Header")
begin
SalesOrderHeader.Validate("Document Date", Today);
SalesOrderHeader.Modify();
end;
Thanks! ill have a go and let you know how i get on!
[/quote]Good, let me know if you need more assistance with it.
Thanks! ill have a go and let you know how i get on!
The code to do this is pretty easy. There is an event you can subscribe to that trigges when a quote is made into a sales order. You can simple set the date to today in that event. I am adding some sample code.
Share
Report
All responses (
Answers (
codeunit 55015 QuoteToSalesOrder
{
[EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Quote to Order (Yes/No)", 'OnAfterSalesQuoteToOrderRun', '', false, false)]
local procedure OnAfterSalesQuoteToOrderRun(var SalesHeader2: Record "Sales Header"; var SalesHeader: Record "Sales Header");
begin
SalesHeader.Validate("Document Date",Today);
SalesHeader.Modify(true);
end;
}
Hey thanks for your response,
Unfortunately the client wants it automatically populate.
Can't wrap my mind around how that code should be...
HI,
Just type and overwrite document date. It's convinient to type "t" instead of typing the date of today.
So far as I researched, no standard feature exist for such requirement..
I hope this helps you.
S.Kawamura
#1
André Arnaud de Cal...
293,278
Super User 2025 Season 1
#2
Martin Dráb
231,983
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
