how to stop posting if it is wrong posting date

lally

Hi Experts,

I created a new item and I have received the item - 01/10/2010 ( MM/DD/YY) - Qty - 100.


Actual Posting date - 01/ 25/2010 on this date user is going to issue the material , but by mistake user entered - 01 /05 /2010 ( MM/DD/ YY) - qty - 50 and post .


system will reduce the qty on 01/05/2010.

but my issue is can i spot to issue the material if Actual Posting date < received posting date.

Please suggest me .

ara3n

In GL Setup you have post from and to field that control which date they can post. If you daily change it to today's date so that users can only post for that date.

lally

ara3n wrote:

In GL Setup you have post from and to field that control which date they can post. If you daily change it to today's date so that users can only post for that date.

Thanks Sir,

i know about this G/L setup & user setup.

generally i give the user setup for one month to Each user.

with in this month also i dont want to allow that type of transactions.


Thanks and Regards

ssingla

If you weaken the control of posting date rights provided by NAV, there is very less NAV can do to help you.

lally

ssingla wrote:

there is very less NAV can do to help you.

really this is very strange thing in navision.

This problem is giving the lot of problems regarding the total inventory valuation.

lally

can any expert throw some help about this to stop that type of transactions?

ara3n

lally wrote:

can any expert throw some help about this to stop that type of transactions?

don't give them one month, but rather daily restriction.

lally

Thanks Rashed for your help,


But my question is it possible to stop that type of transactions?

Please let me know then i will go head.

ssingla

Yes, you can stop the user from posting in wrong dates by having proper user setup dates.

lally

ssingla wrote:

Yes, you can stop the user from posting in wrong dates by having proper user setup dates.

Thanks sandeep sir,

if do the user setup dates for everyday obviously it can stop.

But what i am asking with out that also can i stop that type of transactions.

ssingla

AFAIK there is no other standard method.

ssingla

lally wrote:

ssingla wrote:

Yes, you can stop the user from posting in wrong dates by having proper user setup dates.

Thanks sandeep sir,

if do the user setup dates for everyday obviously it can stop.

But what i am asking with out that also can i stop that type of transactions.

You should stick to the standard NAV practices and should make your client to follow the same.

lally

ssingla wrote:

You should stick to the standard NAV practices and should make your client to follow the same.

I think this is not good practice . sure system is doing wrong.

ara3n

Just to clarify.

You do not need to specify on every user the Posting From and To. You specify it at GL Setup table.

User setup is the exception for some users who want to whole month etc.


For all the other users, the User Setup table should be blank. Only GL setup should have the daily restriction.

gsiracusa

you could set in the table no series the "Posted Receipt Nos." the field Date Order = yes; so you cannot be posted before to "Last Dates Used." Eventually that doesn't daily record post you could manually modify the field.

Savatage

We've been using this old trick for years without any issues

Luc Van Dyck wrote:

A simple solution would be to add following lines in the OnAfterGetCurrRecord-trigger of the Sales Order form:

IF "Posting Date" <> TODAY THEN
  "Posting Date" := TODAY;

viewtopic.php?f=23&t=7844

or you could test the posting date when posting
If Posting Date <> Workdate Then error //something like that.

But by setting the dates as ara3n says no code changes need to be done. Your system, your call.

lally

Thanks all,

Share your thoughts regarding the customization to solve the actual scenrio.

chengalasettyvsrao

Did u discuss with your techical people ?

What you tried to get the solution ?

it is Maximum eight lines coding to stop that type of transactions .

ssingla

lally wrote:

Thanks all,

Share your thoughts regarding the customization to solve the actual scenrio.

What all practical tips you require more than what Savatage has suggested?