projects
/
Pman.Xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
26d8162
)
pgsql/investigations/ar-creditmemo.sql
author
Edward
<edward@roojs.com>
Tue, 4 Feb 2014 10:11:06 +0000
(18:11 +0800)
committer
Edward
<edward@roojs.com>
Tue, 4 Feb 2014 10:11:06 +0000
(18:11 +0800)
pgsql/investigations/ar-creditmemo.sql
patch
|
blob
|
history
diff --git
a/pgsql/investigations/ar-creditmemo.sql
b/pgsql/investigations/ar-creditmemo.sql
index
058d600
..
0124e29
100644
(file)
--- a/
pgsql/investigations/ar-creditmemo.sql
+++ b/
pgsql/investigations/ar-creditmemo.sql
@@
-67,23
+67,7
@@
BEGIN
araccnt_id ASC
LIMIT 1;
-
-
- SELECT
- salesaccnt_sales_accnt_id, --135
- salesaccnt_credit_accnt_id -- 121
- -- salesaccnt_cos_accnt_id
- INTO
- v_sales_accnt_id,
- v_credit_accnt_id
- -- v_cos_accnt_id
- FROM
- salesaccnt
- ORDER BY
- salesaccnt_id ASC
- LIMIT 1;
-
-
+
-- we now have the base amount..
--- Bank receipt should be exactly this amount.