summaryrefslogtreecommitdiff
path: root/sql/modules
AgeCommit message (Collapse)Author
2008-10-10Renaming broken Account.sql function (currently unused by app)einhverfr
All Account.sql tests now pass. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2364 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-10More unit tests for stored procseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2363 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-10merging in fix for OE generationeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2361 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-08Correcting function change-related error in Company.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2359 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-08Added test cases, verified data structure matches older structureeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2358 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-08Correcting bad data type in location_resulteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2357 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-08Correcting bad data type in location_resulteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2356 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-06Correcting error in Location.sql due to COMMENT ON not referencing the right ↵einhverfr
arguments for a function git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2352 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-05Correcting load issue with Person.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2351 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-05Correcting load issue on Location.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2350 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-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-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-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-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-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-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