summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/modules/Voucher.sql8
-rw-r--r--sql/modules/test/Voucher.sql3
2 files changed, 9 insertions, 2 deletions
diff --git a/sql/modules/Voucher.sql b/sql/modules/Voucher.sql
index 6ae6a5e2..b6ac7be9 100644
--- a/sql/modules/Voucher.sql
+++ b/sql/modules/Voucher.sql
@@ -57,7 +57,9 @@ BEGIN
a.amount, a.transdate, 'Payable'
FROM voucher v
JOIN ap a ON (v.trans_id = a.id)
- JOIN entity e ON (a.entity_id = e.id)
+ JOIN entity_credit_account eca
+ ON (eca.id = a.entity_credit_account)
+ JOIN entity e ON (eca.entity_id = e.id)
WHERE v.batch_id = in_batch_id
AND v.batch_class = (select id from batch_class
WHERE class = 'ap')
@@ -67,7 +69,9 @@ BEGIN
a.amount, a.transdate, 'Receivable'
FROM voucher v
JOIN ar a ON (v.trans_id = a.id)
- JOIN entity e ON (a.entity_id = e.id)
+ JOIN entity_credit_account eca
+ ON (eca.id = a.entity_credit_account)
+ JOIN entity e ON (eca.entity_id = e.id)
WHERE v.batch_id = in_batch_id
AND v.batch_class = (select id from batch_class
WHERE class = 'ar')
diff --git a/sql/modules/test/Voucher.sql b/sql/modules/test/Voucher.sql
index d749bf09..467d3d38 100644
--- a/sql/modules/test/Voucher.sql
+++ b/sql/modules/test/Voucher.sql
@@ -26,6 +26,9 @@ values (-5, currval('batch_id_seq'), 3);
INSERT INTO voucher (trans_id, batch_id, batch_class)
values (-5, currval('batch_id_seq'), 3);
+INSERT INTO test_result(test_name, success)
+select 'Voucher Seach finds Payable Vouchers', count(*)=1
+from voucher_list( currval('batch_id_seq')::int);
INSERT INTO test_result (test_name, success)
SELECT 'partial payment support', count(*) > 1