Help developing Refund Method on Existing Orders

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Am using Access2K

I am trying to develop a method for issuing a Refund on an existing order.

I have an orders table with ORDER_ID as Prim Key AutoNum.

I have a form set up for NEW orders.

I have another form set up for finding/viewing Existing Orders.

Can someone give me some advice on how I go about issuing a refund on an
existing order? My business acumen is lacking and I don't know the proper
procedure for this.

I don't think I should allow editing of the Existing Order, because there
would be no record of the original. My concern is that I have queries and
reports based on the Orders Table that obviously have to reflect any Refunds
that might have been issued.



Thanks for any help.
 
I would add a new record to the orders detail table with the same order
number as the original order. But instad of a credit it would be a debit for
the actual ammount of the refund (by detail line being refunded). When your
reports run, they will list both the order and the refund. And add up the
difference. This is helpfull specially if you have multiple detail lines per
order and only some of the detail lines are being refunded.

Hopefully you do have an orders detail table. If you don't, short of adding
fields to the orders table (which means changing reports/queries, etc) Im
not to sure how you can do it.

Rodrigo.
 
Back
Top