Automatically update document date when opening SO page

Louis
Louis Member Posts: 78
edited 2014-11-05 in NAV Three Tier
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

Comments

  • tinoruijs
    tinoruijs Member Posts: 1,226
    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?
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Louis
    Louis Member Posts: 78
    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
    tinoruijs Member Posts: 1,226
    In OnAfterGetCurrRecord you can put 
    "Document Date" := WORKDATE;
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Louis
    Louis Member Posts: 78
    Tx
    Yes, when life was easy in Classic NAV but 'OnAfterGetCurrRecord' is not a page trigger in 3-Tier

    What'else ?

    Regards,
    L
  • tinoruijs
    tinoruijs Member Posts: 1,226
    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.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • Louis
    Louis Member Posts: 78
    Tx Tino
    I'm looking for a solution in NAV2009R2.
    Regards,
    L
  • tinoruijs
    tinoruijs Member Posts: 1,226
    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.
    Tino Ruijs
    Microsoft Dynamics NAV specialist

Categories