summaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2008-07-01Correcting conflict from Aurynn's commiteinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2181 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-30Adding batch_search_mini apieinhverfr
Addressing issue on create batch screen of searching through all batches Adding error message in LedgerSMB::call_procedure if procname is undefined. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2178 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-30Adding the reconciliation SQL stuff. Testing my SVN interface.aurynn_cmd
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2177 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-25Correcting NULL entity_id errors saving vendoreinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2173 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-25Correcting issue on Vendor screen. Displaying wrong account info when ↵einhverfr
selecting entity from vendor report. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2172 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-23Correcting missing files and commitseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2170 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-23Updating customer/vendor saving to be more safe for multiple account entities.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2169 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-16Correcting typos in READMEeinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2167 4979c152-3d1c-0410-bac9-87ea11338e46
2008-06-14Adding missing drafts.sqleinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2166 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-06-10Adding UI support for multiple vendor/customer accounts per company.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2163 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-25Fixes to per-transaction separation of dutieseinhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2155 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-21Correcting more vendor search errors.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2154 4979c152-3d1c-0410-bac9-87ea11338e46
2008-05-21Activating address-based searches and correcting bugs in vendor search.einhverfr
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2153 4979c152-3d1c-0410-bac9-87ea11338e46
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