J Livingston SQL (4/10/2013)
just to clarify....you say "voucherPRETSRET doesnt contain any data but needs to be checked"...but there is a PURCHASE RETURN in the sample data for voucher table.....???maybe sensible to test with a SALES RETURN at this stage as well......
also I asked that you please provide expected results for the sample data........
regards
As you asked about sample output, If needed.
ITEMNAME HSN OPENING INCOMING OUTGOING CLOSING VALUE
HSN will be null
VALUE will be calculated as I showed it in my tested query.
Rest is all same as you gave me in your previous solution
GODOWN can be ommitted at this stage