diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-11-19 18:45:36 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2008-11-19 18:45:36 +0000 |
| commit | 5a00285539a34d8ff8d7656e3e0bd4ff8e1f9e1a (patch) | |
| tree | 9055d3d6412829fcbc3443fa38837d722f30b81d /sql/modules/Payment.sql | |
| parent | 548354b84e8ae7f4e38372830b3ef7f1ef4bb298 (diff) | |
Correcting behavior in threshold handling. Now will select payments at the threshold.
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2405 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/modules/Payment.sql')
| -rw-r--r-- | sql/modules/Payment.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/modules/Payment.sql b/sql/modules/Payment.sql index 34d506cc..6e7ddc4d 100644 --- a/sql/modules/Payment.sql +++ b/sql/modules/Payment.sql @@ -279,7 +279,7 @@ BEGIN e.control_code, c.description HAVING (in_meta_number IS NULL OR in_meta_number = c.meta_number) AND - (sum(p.due) > c.threshold + (sum(p.due) >= c.threshold OR sum(case when a.batch_id = in_batch_id then 1 else 0 END) > 0) ORDER BY c.meta_number ASC |