Work Date Security

pmcampos
pmcampos Member Posts: 12
edited 2014-01-17 in NAV/Navision Classic Client
Hello,

How can i guarantee that my users don't change the work date of the system? For me to be sure that the date in all documents and entries are correct i must limit the access to the work date.

Or just by saying in the Number Series configuration that i must have a "Date Order" is enough?! With only this I have guarantees that all my entries in the system will be sequential?!

Many Thanks to All
Pedro

Comments

  • NaviTools.com
    NaviTools.com Member Posts: 88
    Hi,

    Not only Work Date. You have to block changing computer's system date.

    Have you seen a topic on 'Server Date'?

    http://www.mibuso.com/forum/viewtopic.p ... erver+date

    Anyhow, what are you trying to achieve?

    If you want to block posting for all days but current, you can use 'Allow Posting To' on General Ledger Setup form.
    http://www.NaviTools.com
    Documentation for Microsoft Navision
    E/R diagrams, Workflow diagrams, UML diagrams, process diagrams
  • pmcampos
    pmcampos Member Posts: 12
    Hi,

    what i'm trying to achieve is, using a Navision native db, prevent the user from changing the work date, so all the documents are posted with the correct (today) date on the database.

    I've saw the topic server date, can i do that, add Server Date and Server Time fields on a setup table, to solve my problem in a native navision db?!
  • miguel.tiago
    miguel.tiago Member Posts: 6
    The workdate exists exactly for users change the date of posting of documents. If you want to prevent users to post documents in a certain period you must use de "alow posting from..." "alow posting to..." in GL configuration or in User configuration.
  • RobertMo
    RobertMo Member Posts: 484
    so you should change G/L setup and/or user setup just after midnight and set allow posting from/to both to the "today". (except maybe for some super users)
    you can do this using app.server, etc.
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • ranian92
    ranian92 Member Posts: 10
    Hi...

    I had a same problem.

    I searched for "WORKDARE" on MIBUSO site

    But I do not resolved on MIBUSO

    So I solved myself.

    It is simple.....

    ==============================
    Codeunit 1
    MakeDateText trigger

    declare global or local variable
    PreWorkDate : date

    On first line add below:

    IF (UPPERCASE(USERID) <> 'SA') THEN

    BEGIN

    PreWorkDate := WORKDATE;

    MESSAGE('%1', 'Not Permitted you to change "WORKDATE". WORKDATE is resetted');

    DateText := FORMAT(PreWorkDate);

    WORKDATE := PreWorkDate;

    EXIT(1);

    END;


    ========================

    After Add above Coding, compile codeunit 1, turn off Navision,
    restart Navision


    But one problem exists...
    If user change Client PC's datetime...
  • hery_halim
    hery_halim Member Posts: 53
    hi ranian92,

    i tried your solution. But it doesn't work.

    nothing was triggered in MakeDateText - CodeUnit 1.

    I tried this on Navision 2013.

    May be i miss something ?
  • ta5
    ta5 Member Posts: 1,164
    Some of the functions MakeText, MakeDate etc. are not called since in NAV >= 2009 RTC. At least not in an an C/AL accessible way. See also
    here: viewtopic.php?f=32&t=58200&hilit=maketext

    Hope this helps
    Thomas
  • hery_halim
    hery_halim Member Posts: 53
    hi Thomas,

    Thank you for your information.

    Btw,other member suggest me to look for "OnGlobalInsert", "OnGlobalModify", "OnGlobalDelete", and "OnGlobalRename" on Code Unit 1. But i can't find those function. Are those functions still exist in nav 2013 ?

    Thanks
  • zarahjaysmith
    zarahjaysmith Member Posts: 3
    I have NAV 2009 and tried the above but it stopped me from editing any date. Where exactly would the code need to go?

Categories