AnsweredAssumed Answered

Auto deduct when the status is canceled.

Question asked by mayor on Feb 9, 2009
Latest reply on Feb 15, 2009 by mayor

Title

Auto deduct when the status is canceled.

Post

Hello,

 

I got I table as below;

 

vot21(po_no, status, po_amount, po_total, po_cancel_total)

 

The scenario: I want the system to deduct the amount (po_amount for that particular user) automatically when the status is canceled. 

 

example:

 

po_no      status       po_amount

123          accept        100

456          accept          50

789          cancel         200

 

po_total = 150

po_cancel_total = 200

 

What we need to do is just change the status from "accept" to "cancel" and the system will calculate the value automatically.

 

Please advice me.

 

TQ

 

 

Outcomes