How to update master details data.

Kedar Pawgi

I am developing big application containing accounting , inventory, sales purchase.

I have designed the DB for accounting, sales purchase, Receipt, Payments along with the respective forms.

I have done the data entry form for sales , purchase. The data is getting saved properly, everything is going correct way as required.

Now the question is if i wish to alter any thing from sales or purchase or credit note invoice or debit note invoice(as these involve master and detail tables) then there will be changes in balance, stock, and posting accounts for that customer or supplier. How to manage this. For example if its sales for and i need to update quantity of 2 items and i need to delete 1 item. So please tell how to achieve. Also is it a good idea to keep the stock calculation on the fly or need to be updated in the table.

If any one can plz help me out in this matter i will be very thank full. I have done the receipt part as it require just one table..

Any efficient way to handle these things. I need quick ans as i need to implement it immediately.

Thanks in advance

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naeem Khan12y ago
hello kedar, sorry for late reply dear.. if you want to show the ledger according to customer wise then should be mention purchase details and total amount details also show the quantity details.. so it will be help full for customer and supplier.. hope it will be help full for you dear..
0
Kedar Pawgi12y ago
Hi Naeem
Thanks for your reply and i was busy with the above problem and now i am fine and done it properly.
But i dnt know whether is i should start a new thread or what..is it possible for you to just suggest me a way about how to maintain the opening and closing stock of material and about opening balances of customer and supplier...i will be very thanks full. I am not getting how to show opening balance in ledger or opening stock in stock statement of any material...
so please guide me here else i will start another thread...plz its a bit urgent...
thanks...a lot.in advance...
0
Naeem Khan12y ago
thanks for reply dear,
please send me your Query i will resolve it my side..
0
Kedar Pawgi12y ago
Hi Naeem
Thanks for your reply. But the thing is i have tried the update query also...There is not issue. Just wanted to know is tere any other simpler way for doing this thing.....so can you give me any suggestions plz...I will be thankful.
0
Naeem Khan12y ago
hello friend,
did you putted update Query after changing stock.. if yes then show me your code will rectify on my side..
0