locked
handle refund RRS feed

  • Question

  • hi how to handle refund in POS.

    If a customer refund 2 items which is already in bad condition, where should i store those items? 

    if it is still in good condition, then i can add back to the inventory table. But if it is spoilt? Should i create a warehouse which everytime when i create a new product, i will assign it to a warehouse. If the product is spoilt, then i shall store it in a different warehouse? 

    How do i handle the scenario when i want list out that product which i want to show all good condition and bad condition one? is this thing important?


    Change
    Wednesday, December 15, 2010 2:50 PM

Answers

  • I think those questions are more related to gthe businees people and DBA will behavie accordlinly to create logical/physical design
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Thursday, December 16, 2010 6:48 AM

All replies

  • --if it is still in good condition, then i can add back to the inventory table. But if it is spoilt? Should i --create a warehouse which everytime when i create a new product, i will assign it to a -----warehouse. If the product is spoilt, then i shall store it in a different warehouse? 

    It depneds on your business requirements..

    --- is this thing important?

    Are  you asking us?


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, December 15, 2010 3:14 PM
  • yes that is the question.  so where should that product be allocated if the product is not functioning anymore.

    yes of course it is important so that admin wil know the how many good condition product left.


    Change
    Wednesday, December 15, 2010 8:45 PM
  • I think those questions are more related to gthe businees people and DBA will behavie accordlinly to create logical/physical design
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Thursday, December 16, 2010 6:48 AM
  • Hi  kkkJoe,

     I think your concern is more of business related, rather than a database issue. If my guessing is right, your concern lies in the accounting treatment for a sales return, based on GAAP, inventory quantity and unit cost should be properly adjusted when a customer return a previous purchase. The treatment of a damage stock is a separate issue, or rather depends on the business manager discretion. They may choose to resell, return to supplier or simply scrapping it off the shelves. All these optional treatment would have different accounting treatment.

    accountingdes.com

     

     

    Tuesday, January 4, 2011 3:30 AM