Automatically update document date when opening SO page

Louis

Hi Dear,

My Request : How to change the document date to workdate when the user enters the Sales Order Page

I know it's an old post and solution (2005) !
How to manage this in RTC page ?

...and avoid "You cannot make any changes in the database until a transaction has been started. Sales order must close..."

TIA,
L

tinoruijs

I don't understand your problem.
When a workdate is set, you can fill it in document date by using w for workdate. Do you mean that?

Louis

Hi
The end user wants that the document date is changed automatically without entering 'W' in the field.
Just like if he enters 'w' but without typing it...

Any idea ?
Regards,
L

ps : Update should also occur with page P42 opened when navigating to the next/previous order <CTRL PGDN> <CTRL PGUP>.

tinoruijs

In OnAfterGetCurrRecord you can put

"Document Date" := WORKDATE;

Louis

Tx
Yes, when life was easy in Classic NAV but 'OnAfterGetCurrRecord' is not a page trigger in 3-Tier

What'else ?

Regards,
L

tinoruijs

Louis wrote:

Tx
Yes, when life was easy in Classic NAV but 'OnAfterGetCurrRecord' is not a page trigger in 3-Tier

It is in NAV2013R2. And NAV2015. Maybe not in NAV2009? I don't know because I skipped 2009 RTC.

Louis

Tx Tino
I'm looking for a solution in NAV2009R2.
Regards,
L

tinoruijs

Ok.
Maybe you could fill document date before posting the sales order?
So that document date will always be workdate.
Or build in a confirm which lets the user choose if he wants to skip filling the document date with workdate.