Work Date Security

pmcampos

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

NaviTools.com

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.

pmcampos

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

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

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.

ranian92

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

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

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

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

I have NAV 2009 and tried the above but it stopped me from editing any date. Where exactly would the code need to go?