OE 1

[johnny45]

We have MANY orders in accpac for a particular customer that were brough in from EDI. The Items are price by Contract Price List.....Because these orders have a special discount (TRADE SHOW) we must now manually add a 7% discount to all of thses orders.....

Q: Is it possible to use SQL and add this 7% discount to all the order lines for a range of PO#s WITHOUT breaking the accpac business logic ?

 

[Jay Converse]

No, don't even attempt it. But you could do it with a macro. Record one line getting updated, you'll have the core statements you'll need to wrap with a couple loops.

 

[johnny45]

Thank you tuba2007, Well noted your WaRNING!

I will try and record a macro...but accpac is VERY new to me and the VBA generated is very confusing to me....