projects
/
Pman.Xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
8561c16
)
pgsql/investigations/ar-debitmemo.sql
author
Edward
<edward@roojs.com>
Tue, 4 Feb 2014 10:10:50 +0000
(18:10 +0800)
committer
Edward
<edward@roojs.com>
Tue, 4 Feb 2014 10:10:50 +0000
(18:10 +0800)
pgsql/investigations/ar-debitmemo.sql
patch
|
blob
|
history
diff --git
a/pgsql/investigations/ar-debitmemo.sql
b/pgsql/investigations/ar-debitmemo.sql
index
7b0c830
..
0c2d510
100644
(file)
--- a/
pgsql/investigations/ar-debitmemo.sql
+++ b/
pgsql/investigations/ar-debitmemo.sql
@@
-67,22
+67,6
@@
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..