summaryrefslogtreecommitdiff
path: root/sql/modules/Payment.sql
AgeCommit message (Collapse)Author
2008-11-21Committing David Mora's single payment interface enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2410 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-19Correcting behavior in threshold handling. Now will select payments at the ↵einhverfr
threshold. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2405 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-03Adding approved check to payment_get_all_contact_invoices. Adding test caseseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2349 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-30Correcting bug with multiple payment posting.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2345 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-29Correcting payment bug: contact total shows 0 when Some radio button is selectedeinhverfr
Also moved the bulk post function to use a temp table to try to get performance gains (if this doesn't work, we will have to go to the one stored proc per invoice approach which I would rather not do). git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2344 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-26Removing some hidden inputs from the payment details screen.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2343 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-12Adding control code and account description to multiple payment interface.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2322 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-16Correcting bug 2006030einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2273 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12 * Correcting discount display discrepancies in multiple payment detail screeneinhverfr
* Merging entity_credit_account mapped functions to SVN main * Adding schema entries for entity_credit_account mappings git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2253 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Undoing svn commit rev 2250einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2251 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Merging fix for bug 1974974einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2250 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-07Setting the select for payment page to order vendors by ascending.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2240 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-31Add the ORDER BY to payment_get_all_contact_invoices, to correctly sort by ↵aurynn_cmd
meta_number/vendor_number. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2227 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-18Corrects bug: vendor filter not applied to vouchers in same batch.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2215 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-09Correcting parse errors on Form.pmeinhverfr
Including David Mora's discount handling patches to single-payment interfaces git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2200 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-09Correctig bug in exchangerate functioneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2199 4979c152-3d1c-0410-bac9-87ea11338e46
2008-07-04Committing David Mora's single payment updateseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2185 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-26Adding customer/vendor search capabilities to multiple payment interface.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2176 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-16Correcting error in Paymnet.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2168 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-10Correcting the join issue when multiple vouchers affect a single payment.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2164 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-17Correcting all load errors for all working scripts on Pg 8.1.x and above.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2150 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-14Correcting vendor save issueseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2146 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-02payments_get_all_contact_invoices now does not use general summary data for ↵einhverfr
determining whether a voucher has been paid. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2123 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-21Correcting comment syntax in Payment.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2111 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-08Correcting ambiguous join in payment_get_all_contact_invoiceseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2102 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-04Adding David Mora's single-payment interface patcheseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2098 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-17Adding new payment posting routine for single payments from David Moraeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2049 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-28Correcting join in payment select for single paymenteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2016 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Commenting out bogus comment for payment_post function.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2006 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-21Correcting header error when creating dataseteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1991 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-21More batch, vendor, and payment reversal fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1987 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-20Voucher and Payment Enhancements and fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1986 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-19Some bulk payment enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1983 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-19More batch enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1982 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-17Batch enhancementseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1980 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-13Added a routine to sanitize the CGI variables. Needed for some CSV exports ↵einhverfr
routines. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1978 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-13More payment fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1976 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-12Basic outline of Job Queue Systemeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1975 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-11More db fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1974 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-08Removing sql/legacy-- will package new download from the files in branches/1.2einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1964 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-07Fixing some payment issues.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1961 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-06Misc fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1955 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-04More Roles fixeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1942 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-02Correcting behavior of session timeout to release locks and create new session.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1928 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-30Separated out multiple payment interface from new payment interface. Still ↵einhverfr
not working, but almost there git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1926 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Removing duplicate drawer openeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1917 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29A narrow shim in the payment logic that needs more review and thought before ↵einhverfr
making permanent git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1915 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-29Correcting more Payment Problemseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1914 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-27Fixing wrong index on location tableeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1911 4979c152-3d1c-0410-bac9-87ea11338e46
2007-11-17Commiting David Mora's payment codeeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1871 4979c152-3d1c-0410-bac9-87ea11338e46