Allow posting from/to

tskajaia

Hi guys!

I wonder is there any way to make navision users post only =TODAY ?

it doesn't metter from where it configure. General Ledger, User Setup, or creation Role.

I want an answer, is this possible? is fo, HOW? i think it's a simple functionality that might be in Navision.

thanks ;-)

tinoruijs

You gave the answer yourself!

There are fields "Allow posting from" and "Allow posting to". In the General Ledger Setup and in the User Setup.

The dates in the User Setup has the highest priority.

From the help:
Allow Posting From Field
The User Setup Table

Here you can enter the earliest date on which the user is allowed to post to the company.

After you enter a date, it will be impossible for the user to post to the company before that date. If you have entered a different date for the same user in the General Ledger Setup table, the date here in the Allow Posting From field in the User Setup table takes precedence.

tskajaia

tinoruijs

I understand what you mean. But I meant another:

I can type a date in Allow posting From, for example: 04/9/2008

so what will be on 04/10/008? the users will be able to post using date 04/9/2008. i want a logical values, "TODAY" so , every day it automatically configures general ledger to restrict posting if date FALSE

tinoruijs

All right. :-k

Maybe you could schedule a task to change the dates in the general ledger setup each night.

tskajaia

tinoruijs

can you say HOW ?

need I some development? scripts? tools? or it's very simple?

navuser1

Write the code before any posting or in Codeunit 1

If GeneralLedgeretup.GET THEN
BEGIN
GeneralLedgeretup."Allow Posting From":= TODAY;
GeneralLedgeretup."Allow Posting To" :=TODAY;
GeneralLedgeretup.Modify;
END;

tinoruijs

The simple solution is to let someone modify the dates manually each morning, but I guess that's not what you want.

You will need to do some development. But I don't know yet which is the best solution..

:-k

cernst

In codeunit 1 function LogInStart you can put some code that changes the date in the G/L setup and maybe also change the date in the user setup table.

tskajaia

navuser1

when I try to create new codenuit in Object designer, it says you dont have permission actually im not a developer.

explain me how to make this code work please. can I write it in notepad and then import to Navision as fob? or how?

tinoruijs

Hi tskajaia,

If you're license does not allow the modification, you have to ask your NAV-partner to do the changes.

tskajaia

tinoruijs

Okay

thanks guys

Savatage

We always want the posting date to be TODAY or WORKDATE.

On forms like sales orders or purchase orders we want it to keep updateing everytime you go into the order or anything else we can think of

on the form

OnAfterGetCurrRecord()
//Auto-Update Posting Date
IF "Posting Date" <> TODAY THEN
   "Posting Date" := TODAY;

themave

this is pretty straight forward, if you have access to the report writer (ie, your not a developer)

make a processing only report on table 91 User setup

I did it a while back,

update the allow from and to fields

I used today +1, because I ran it each night in the job scheduler.


User Setup - OnAfterGetRecord()
"Allow Posting From" := today +1;
"Allow Posting To" := today +1;
Modify;

idiot

Typically we don't user the Allow Posting from/to in the G/L Setup as it's a global setting which affects all users, some users might be doing some back dating transactions...
Rather we play with Allow Posting from/to in the User Setup.
From here there's 2 paths, using Job Scheduler + CU, Report, etc to update pre-determined users OR using CU1 to change the date during login, also depending on license


We're in the process of trying to automatically change whatever Posting Date in whatever transactions to TODAY during posting without user intervention but it's a lot of work. Anyone has any solution?

kine

And do not forget that the G/L Setup Allow posting from -to have impact to Adjust Cost batches!