database perfection for stock management
Created by: Krishnakant
The current database layout for stock management will be changed to make it perfect.
- delivery chalan table will have Number, date and customer code with godown code.
- invoice table will have number, date, customer code, productcode:quantity (json) and productcode:price (json)
- Stock table will be, dcinvcode, dcinvflag, productcode, quantity and inout flag
- Delivery chalan has mandatory relation to stock table
- invoice table has an optional entry in stock if dc not issued. We are also going to have a dcinv table which will only serve the purpose of many to many relation between dc and invoice.
Imported comments:
By Navin Karkera on 2016-10-03T06:27:23.357Z
Status changed to closed
By Navin Karkera on 2016-10-03T06:27:23.325Z
Task completed