Warning 907 Help

Hi Brutus1214 - deleting the discount scheme will not remove it from the item properties; run this query to view your current discount schemes and items that have a discount scheme that is no longer active (or in your case has been deleted)

select * from quantitydiscount

select itemlookupcode, description, quantitydiscountid from item where quantitydiscountid not in (select id from quantitydiscount) and quantitydiscountid 0;

The first query will show you your current (active) list of discount schemes; the second will show you a list of items that have a discountID that is NOT in your current list of discount schemes.

You can use an update query to set their discountIDs to zero -

update item set quantitydiscountid = 0 where quantitydiscountid not in (select id from quantitydiscount) and quantitydiscountid 0;

This should remove the warning as you are "resetting" their quantitydiscountIDs to "zero" (as in "none") - Hope this helps......

"Brutus1214" wrote:

Thanks Bunch. It worked and fixed problem right away.

Brutus1214