Hi
i am developing inventory project. i am having doubt on that is to calculate stock function.
if i add the purchase quantity it will be added in purchase table (p_qty) and stock table(stk_qty)
then if i sales(invoice) the item quantity will be reduced in sales table(s_qty) and stock table(stk_qty)
suppose if i need to update the sales form , how to do it .
please help me out.
i am developing inventory project. i am having doubt on that is to calculate stock function.
if i add the purchase quantity it will be added in purchase table (p_qty) and stock table(stk_qty)
then if i sales(invoice) the item quantity will be reduced in sales table(s_qty) and stock table(stk_qty)
suppose if i need to update the sales form , how to do it .
please help me out.