update account prices after order placed

[davie_ne1]

I have a situation

A trade account holder has placed an order 231 different lines.

Over 100 of the products that they have ordered are due to be reduced today.

I have changed the prices for their customer group 'trade' but the prices on the order are the original prices quoted.

As this order is not paid for until dispatch I need to change the prices that they will pay to the new discounted ones.

Is there anyway to get actinic to do this for me or am I going to have to work it out manually and just put an adjustmet on the order

Any help would be appreciated

David

[davie_ne1]

in which table in the actinic database is the produtc prices loacted when you create a cutom price for each product. ?