Prod. Order Line Quantity negative

navuser1

Hi ALL,

In which condition Released Prod. Order Line Quantity will be
negative???

tinoruijs

Why do you want to know?
Do you have a record that has a negative value? Or do you want that?

If you try to enter a negative value you'll receive the message;
The minimum permitted value is 0.

navuser1

tinoruijs wrote:

Why do you want to know?
Do you have a record that has a negative value? Or do you want that?

If you try to enter a negative value you'll receive the message;
The minimum permitted value is 0.

I have a record that has a negative value.
Where negative value not allowed

tinoruijs

What's the value of the property MinValue of field Quantity in table 5406 Prod. Order Line? This should be 0..

navuser1

tinoruijs wrote:

What's the value of the property MinValue of field Quantity in table 5406 Prod. Order Line? This should be 0..

MinValue is 0;
Is it possible for any body to change qty to negative qty through SQL without facing any error msg???

tinoruijs

Ok.
It is though possible to change quantity to a negative value in code.
So if there's somewhere coded "ProdOrderLine.Quantity := -1;" then quantity will become negative.
Changing through SQL will also be possible without any error message..
I assume you mean by changing in SQL, that changes are being made not directly in the sql-table, but through another application?

navuser1

tinoruijs wrote:

Ok.
It is though possible to change quantity to a negative value in code.
So if there's somewhere coded "ProdOrderLine.Quantity := -1;" then quantity will become negative.
Changing through SQL will also be possible without any error message..
I assume you mean by changing in SQL, that changes are being made not directly in the sql-table, but through another application?

Yes.

tinoruijs

Then you will have to reproduce the negative quantity and see where it goes wrong.
Or take a look in the NAV-code and in the other application's code.

navuser1

tinoruijs wrote:

Then you will have to reproduce the negative quantity and see where it goes wrong.
Or take a look in the NAV-code and in the other application's code.

Assume that no body change the value through SQL then
is it possible in Navision that value may be positive or negative
in Quantity field of the Prod. Order Line table.