summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2008-05-18Adding Drafts.sql to sql/modules/READMEeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2151 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-05-12Merging in fix for 1870069einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2137 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-09Adding ability to force closed transactions (via db only) to prevent them ↵einhverfr
from showing up on the outstanding report. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2131 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-09Correcting issues saving/retriving tax id for vendors/customers, and ↵einhverfr
retrieving the cash id. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2130 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-07Correcting issue with loading Session.pmeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2129 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-07Correcting several loading errors with Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2128 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-04form_check is now called form_closeeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2127 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-04form_check now deletes the row, allowing for real enforcement.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2126 4979c152-3d1c-0410-bac9-87ea11338e46
2008-04-04Adding infrastructure for form trackingeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2125 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-29Correcting misspelled sequence in Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2121 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-21Correcting more missing quotes on Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2113 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-21Updating Roles.sql to allow hyphens in db nameseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2112 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-21Correcting problem with batch posts only posting some payments.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2110 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-11Correcting two issues with Voucher.sql which prevent loading.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2108 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-11Updating READMEeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2107 4979c152-3d1c-0410-bac9-87ea11338e46
2008-03-11Adding roles for voucher/batch deletion. Moving functions to SECURITY ↵einhverfr
DEFINER to allow for more granular delete permissions. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2106 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-03-03Correcting all voucher/ batch reporting discrepencieseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2097 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-28Moving Setting.sql to standard (if hard to read) escaping syntaxeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2096 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-28Updating README to mention that Setting.sql needs to be loaded.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2095 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-27Committing customer/vendor address save fixeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2093 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-27Removing notes saving from initial credit account insert routine.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2089 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-27Adding role grant to note_id_seqeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2088 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-24Adding explicit cast to md5() so it will work on Pg 8.3einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2085 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-24Updating the Candian GST ratetetragon
Switching away from the use of backslashes to quote quotes git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2083 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-22Adding index on acc_trans(voucher_id)einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2077 4979c152-3d1c-0410-bac9-87ea11338e46
2008-02-20Changing batch search to handle null created_by valueseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2074 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-21Attaching Jeff Kowalzic's SQL cleanup patcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2058 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
2008-01-12Fixing (in Pg-database) 1771834, inventory lost when converting order to invoiceeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2040 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-10Menu fixes to Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2034 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-09Correcting trial balance and gl report not to pull unapproved transactionseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2031 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-08Including missing Session.sql in Readmeeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2030 4979c152-3d1c-0410-bac9-87ea11338e46
2008-01-04New tables by David Mora for payment trackingeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2027 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-30Moving Isvan's basic Hungarian chart to Minimaleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2022 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-30Adding Istvan's Hungarian chartseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2021 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-29Adding inventory adjustment stored procedureseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2018 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-28Adding description field to batcheinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2010 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-27Adding missing voucher_id field to Pg-database.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2008 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-27Correcting typo in Roles.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2007 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-26Fixing broken Account.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2005 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Fixing broken Account.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2004 4979c152-3d1c-0410-bac9-87ea11338e46
2007-12-26Removing as_array and compound_array since they are part of Pg-databaseeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2003 4979c152-3d1c-0410-bac9-87ea11338e46