summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2008-11-25Changes to UI when invoices locked, changes to source numbering behavior in ↵einhverfr
bulk payments, test cases added, minor code cleanup for readability git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2420 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-22Correcting bad join which caused payable batches not to show up in batch detailseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2416 4979c152-3d1c-0410-bac9-87ea11338e46
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-19Re-adding rollback on to test case, fine tuning payment tests slightly. All ↵einhverfr
tests still pass properly. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2407 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-19Test case for threshold now passeseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2406 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-11-15Test case additions, and a few correctionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2401 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-13Correcting issues with draft editing.einhverfr
Moving AA::post_transaction to use strict. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2392 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-12Updating the billing info functioneinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2391 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-11Test case for billing infoeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2389 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-10Test commit, given suspicion of missing test cases.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2386 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-07Changing primary key for eca_to_location to make this testable.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2383 4979c152-3d1c-0410-bac9-87ea11338e46
2008-11-07Adding edit_drafts permissioneinhverfr
Correcting logic in location_save Correcting data type contact_list Correcting some logic regarding how addresses are stored when they are modified. Adding relevant test cases. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2382 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-28Allowing multiple payment vouchers per batch per invoice. Test cases addedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2380 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-22Corrected missing commit on draft deletioneinhverfr
Corrected inadequate cleanup on draft deletion git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2377 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-17Draft search type is now case insensitive, test cases addedeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2373 4979c152-3d1c-0410-bac9-87ea11338e46
2008-10-10Adding draft menu itemeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2365 4979c152-3d1c-0410-bac9-87ea11338e46
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-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