TAB1
ITEMDESC TYPE QTY VALUE
ITEM1 RECEIPT 100 1000
ITEM1 RECEIPT 100 1100
ITEM1 ISSUE 50
ITEM1 RECEIPT 100 1200
ITEM1 ISSUE 50
ITEM1 ISSUE 50
HERE WHEN I RECEIVE THE ITEM I CAN RECEIVE WITH VALUE.
WHEN IT HAS TO BE ISSUED IT SHOULD BE CALCULATED BASED ON THE PREVIOUS CLOSING BALANCE.
WHENEVER WE MAKE AN ISSUE QTY AND VALUE SHOULD GET REDUCED AND WHENEVER WE MAKE AN RECEIPT QTY AND VALUE SHOULD GET ADDED
i.e.,
my result table should be as follows
ITEMDESC TYPE QTY VALUE RATE CLQTY CLBAL
ITEM1 RECEIPT 100 1000 10.0 100 1000
ITEM1 RECEIPT 100 1100 11.0 200 2100
ITEM1 ISSUE 50 275 5.5 150 1825
ITEM1 RECEIPT 100 1200 12.0 250 3025
ITEM1 ISSUE 50 605 12.1 200 2420
ITEM1 ISSUE 50 605 12.1 150 1851
RATE IS CALCULATED BASED ON THE PREVIOUS CLBAL AND CLQTY I.E., CLBAL/CLQTY
AND ISSUE VALUE IS RATE*QTY
IS IT POSSIBLE TO ACHIEVE THIS THROUGH SQL
[EDITED by LF: applied [pre] tags]
[Updated on: Sun, 07 June 2009 03:13] by Moderator
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
