Recalc Order Header weight

[wwwedward]

We have need to run a process at night to recalculate the weight for an order and post this to the order header weight field. Macola does this each time you enter the order detail screen. Hwoever, I was wondering if their is a report or something to trigger this event also.. we do not own flex. Sql 200 ver 7.6.200.5

Thanks

 

[dgillz]

The order header weight is for the total weight of the order, assuming there are no backorders whatsoever. Is this what you want?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.srhconsulting.com

 

[wwwedward]

Yes, this is the field. However, we have a process writing in that does not update this field for orders

 

[crystalreporting]

I'm not sure why you want to do this, but whatever the reason you should be able to do this easily with a SQL stored procedure. Assuming you have someone that is familiar with the database and SQL, you can then schedule the procedure to run periodically, or use a trigger to initiate it.

Peter Shirley

http://www.linkcorp.com