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
The expected result is same as you gave in your previous solution.
We just need to connect these 2 tables more.
SO incoming will be PURCAHSE+SALES RETURN
Outgoing will be PURCHASE RETURN+CASH MEMO + SALES
Let me give you data with purchase return and sales return entry in relative tables.
I am giving you details about voucherPRETSRET,voucher tables as we have data about other tables.