Document Level Discount

[#1]

Hello Experts,

what is discprcnt field in ORDR table ?

How come sometimes Null and sometimes Zero is getting inserted ?

From where can we assign document level discount on sales order ?

Please help.

Thanking You

Malhaar

[Former Member]

It is highly possible the problem caused by you SP.

[Former Member]

Hi Malhaar,

If there is no discount, this field should be 0. How many orders have you found the value Null?

Thanks,

Gordon

[Former Member]

Hi Gordon,

There are two such rows.

I tried to replicate the scenario in the test DB. But, could not replicate.

Thanking You

Malhaar

[Former Member]

If only 2 rows has this trouble, it could be caused by SP. Check what is in your SP that may affect db updating.

[Former Member]

Hello Gordon,

In my SPTN, I'm checking stock ,  pending purchase orders and pending sales orders for the running month.

(If stock + pending purchase order) - pending sales orders < quantity entered by user then SPTN fires saying order overbooking.

Thanking you

Malhaar

[KennedyT21]

Hi Malhaar,

I think there is no document level setting for discount.

We can make Set max Discount Limit for  Sales ,Purchase & general in the User Authorization.

Regards

Kennedy

[Former Member]

Hi Kennedy,

Yes I know that.

But the field discprcnt field present at the document level in the order screen contains null value and zero value at random.

We never enter anything there.

We have discount schemes which operate at line level.

Because this field at random contains zero and null one of our report is giving us wrong result.

So, is there a way so that this will always contain zero by default ?

Thanking you

Malhaar

[KennedyT21]

If you want you can Write TN SP If it is null. But in report level required means you can use the Isnull Option In the Sql while you write the Report.

Regards

Kennedy