problem with order nummering

Philippe

"Table Sales Header already exists"

We get this message approx 3 times a day. The order input blocks, and i have to change the last used nummer manually (add 1).

We did not yet find the reason for this blocking, neither could out nsc.

Any suggestions ?

We use WinNT server with Win98 clients.

jp

It is probably because someone has manually entered an order number.

It is an unfortunate shortcoming of the number series generating code. If a user manually enters an order number in the series, and the order has not been posted, the number series management code will generate that number and try to assign it to an order. That causes the "already exists" error.

You should set the numbering series to disallow manual numbering.
Or track down the user that is entering the numbers manually and educate them.

-jp

Philippe

Manual numbering was never allowed, so this can't be the reason for our problems.

I think it is a bug in NF, but our consultant disagrees.

Nevertheles, no solution was found !

regards

jp

When the error happens again, find the existing Sales Header record. It may provide some useful information as to the cause of the problem.

Has anyone modified the Sales Header table or Sales Order form? If so, they may have introduced a bug.

-jp

db

This can happen then old header No is deleted & filled. In this case numbers table not refreshed & if since last new No this user inserted another user inserts new this couse this error. Header must be all deleted then new inserted. In this case table refreshed corectly.