summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
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-25Saving locations and contacts to a user now works as expected.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2342 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-23Lots of fixes for editing users. Minor changes to Person.sql, specifically ↵aurynn_cmd
person__save_contact. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2339 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-22Fixes to user managementeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2332 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-22Major changes to the Admin interface for Edit User. Minor tweaks to Person, ↵aurynn_cmd
Location and Employee.sql as needed. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2331 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-18Making test roll back rather than commit for safetyeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2329 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-18Adding unit tests to Session.sql and correcting logic that causes it to fail.einhverfr
Adding a 90 min timeout to the sessions by default git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2328 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-17Further fixes to Reconciliation, the new Admin interface, and a small change ↵aurynn_cmd
to Company.sql git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2327 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-13Adding description and control code fields to vendor/customer searcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2324 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-12Adding drop down box to set primary entity class for companies.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2323 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-09-12Added description field to customer/vendor generation.einhverfr
Corrected entity credit account autogenerated number sequences. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2321 4979c152-3d1c-0410-bac9-87ea11338e46
2008-09-08Correcting issue with saving discount rateseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2316 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-30Correcting 2081966einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2306 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-30Removing load test for removed CT.pm.einhverfr
Correcting bug 2082026 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2305 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-22Correcting load issues with Pg-database.sqleinhverfr
Also adding NOT NULL constraints to ar.entity_credit_account and ap.entity_credit_account git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2299 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-21Further fixes to Recon and Admin. In testing.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2296 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-21 * Minor fixes to customer/vendor entryeinhverfr
* Fixes to customer search functionality git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2295 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-20Correcting issues with editing contact infoeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2287 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-20Making account numbers clickable on customer/vendor screen, correcting ↵einhverfr
contact editing population (needs a little more work there), and adding control code search git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2285 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-19Copious Admin and Reconciliation changes.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2283 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-19Enhancements to notes and entity management:einhverfr
* Default workflow only allows addresses connected to entity_credit_accounts * Default workflow only allows contact info conntected to entity_credit_accounts * Notes now display the Pgsql user that created them * Notes are now displayed with linebreaks properly showing up. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2282 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-19Adding eca to bank account linkeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2281 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-19Updated Roles.sql to reflect permissions to eca_linkseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2280 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-18Correcting argument mismatch issue in eca__list_locationseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2279 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-16Correcting 2006193einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2274 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-13Addressing report 2006202 by Jeffkeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2260 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-13Merging patch 1906081einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2258 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Correcting more load errorseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2255 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-12Correcting load errorseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2254 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-08Adding meta_number to company_billing_info return seteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2242 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-07Correcting get_billing_info functioneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2241 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-08-06Adding script to drop location typeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2239 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-06Correcting location saving issueseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2238 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-06Adding entity_credit_account note typeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2237 4979c152-3d1c-0410-bac9-87ea11338e46
2008-08-06Adding script to drop company data types.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2236 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-22Added format option to LedgerSMB::format_amounteinhverfr
Added batch information options for check template Added batch default_date field Corrected issues with payment batches not preserving post dates when adding vouchers to existing batch. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2219 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-10Correcting the last errors for the draft approval on secondary test instanceeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2203 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-07Correcting all check printing issues on my secondary testing instanceeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2190 4979c152-3d1c-0410-bac9-87ea11338e46