in my DB for a super market system, i have these tables as part of it, Invoices, Sales and Receipts.
Here are scenarios:
1. A Customer purchased A list of items, and one item is damaged. so he has return that and get new one. But the Supermarket does not have any of those items in their back stock or shelves, therefore they have given the customer two option either to wait
till the next order or to give a refund. In the case of the refund, if its refund of total purchase then i could use the Sales table. But since it's a return of AN ITEM in the purchased goods things complicated. So in items wise returns / refund, how should
modify the DB tables so that ONLY that item will be refunded? Should i generate receipts or invoices for this refund? Are there any table or columns needs to be added to DB or tables?
View Complete Post