Hi guys, I have a small question (1 Viewer)

amjedakrem

New member
Local time
Today, 19:40
Joined
May 19, 2020
Messages
4
is it possible to add a status "Return Item" in this database, which means this action will return the item in inventory plus the customer order will become zero. (as if he returns the item to the shop)
 

Attachments

  • Northwind2010Client.accdb
    4.4 MB · Views: 153

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 16:40
Joined
Jul 9, 2003
Messages
16,244
is it possible to add a status "Return Item" in this database, which means this action will return the item in inventory plus the customer order will become zero. (as if he returns the item to the shop)

You are playing with fire if you start adding things back into the inventory. It could very easily get out of control and you end up with corrupt data, as in you don't have a true representation of the stock numbers.

These sort of problems existed way before computers and databases. The original solution was an accountancy system. The Northwind example database demonstrates an order, with line items, basically imitating an accountancy process.

When you return something to a company they issue a credit note. This records the fact that you have returned the item and allows the processing of a refund. With regard to the inventory, you just look at the items listed in the credit note table and this tells you what items have been added back into inventory without messing around with the inventory quantities.

Caveat:- I'm not an accountant, I know there's at least one accountant here who might be able to advise you on how to handle accounting procedures in an MS Access database.
 

Minty

AWF VIP
Local time
Today, 16:40
Joined
Jul 26, 2013
Messages
10,354
To reinforce what Uncle has said, this is handled as a separate transaction. So the original order stays put and you have an audit trail of the original order and the return(credit note) as a negative transaction, which at the same time "returns" an item into the stock.
 

amjedakrem

New member
Local time
Today, 19:40
Joined
May 19, 2020
Messages
4
That's true , that was useful , thank you so much Uncle Gizmo and Minty
 

Users who are viewing this thread

Top Bottom