[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
SF.net SVN: ledger-smb:[2823] trunk
- Subject: SF.net SVN: ledger-smb:[2823] trunk
- From: ..hidden..
- Date: Sun, 13 Dec 2009 19:55:09 +0000
Revision: 2823
http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2823&view=rev
Author: einhverfr
Date: 2009-12-13 19:55:09 +0000 (Sun, 13 Dec 2009)
Log Message:
-----------
Merging fix in for tax rounding issue
Merging change log in from 1.2
Updating BUGS file
Modified Paths:
--------------
trunk/BUGS
trunk/Changelog
trunk/bin/io.pl
trunk/sql/modules/Account.sql
Modified: trunk/BUGS
===================================================================
--- trunk/BUGS 2009-12-13 19:36:50 UTC (rev 2822)
+++ trunk/BUGS 2009-12-13 19:55:09 UTC (rev 2823)
@@ -1,19 +1,7 @@
-Known issues in LedgerSMB 1.2, Beta 1:
+CURRENT KNOWN BUGS:
-Installation/upgrade is not automated yet.
+1) Checks don't print from single check printing interface
-Changes since last Beta:
+BUGS FIXED SINCE LAST BETA:
-Currencies not showing up on orders and invoices
-
-Internal server error on login screen when can't connect to db.
-
-A couple of dataset creation issues.
-
-A few documentation fixes
-
-Updates RPM Spec file
-
-Better error handling in Admin.pl
-
-Database scripts now run as transactions.
+Not applicable
Modified: trunk/Changelog
===================================================================
--- trunk/Changelog 2009-12-13 19:36:50 UTC (rev 2822)
+++ trunk/Changelog 2009-12-13 19:55:09 UTC (rev 2823)
@@ -23,7 +23,7 @@
* GL reference now populated by default in the initial screen (Chris T).
Reconciliation:
-* Reconciliation is no new codebase!
+* Reconciliation is on new codebase!
* Redesigned workflow (Chris T and Aurynn)
* Optimized for high volumes (1000 transactions or more per run, Chris T)
* Plug in model for bank import scripts (Chris T and Aurynn)
@@ -65,6 +65,234 @@
* Redesigned database schema for reconciliation (Aurynn and Chris T)
* Redesigned database schema for payments (David M)
+Changelog for 1.2.18
+* Corrected httpd configuration bit. (Roderick Anderson)
+* COGS fix for return handling (Sadashiva and Chris T)
+* Cumulative tax handling fix for Quebec users (Jerome Oufella)
+
+Changelog for 1.2.17
+* Corrected "Attempt to free unreferenced scalar" error (oe.pl, 5.10.0, Chris T)
+* Corrected order consolidation item notes replaced with qty (Chris T)
+* Corrected "Access Denied" when deleting user (Sadashiva)
+* Corrected defaults not saving properly when not already in db (Sadashiva)
+* Corrected undefined dbh when generating sales orders (Sadashiva)
+
+Changelog for 1.2.16
+* Correcting "Attempt to free unreferenced scalar" error on 5.10.0 (Chris T)
+* Correcting "Access Denied" when searching for timecards (Seneca)
+
+Changelog for 1.2.15
+* Uppercasing some SQL statements (Chris T)
+* Fixed for AR allocation corner case (Victor Q, 1881199)
+* Fixed for warehouse transfer error (Jeffk, 1877860)
+* Fixed error pulling transactions by department (Chris T, 1954974)
+* Fixed UTF-8 encoding for Czech COA (Vladamir B, 1906081)
+* Fixed upgrade script creating incorrectly named sequence (Chris T, 1987545)
+* Corrected POS transactions report (JeffK and Chris T, 2025931)
+* Added a max_post_size directive to the ledgersmb.conf (Chris M)
+* Fixed Price Matrix logic (Chris T, 1897245)
+* Fixed errors in the backported triggers for transaction table (Jeffk, 1928336)
+* Corrected corner case on ar_ap_summary_fix_1.2.14.sql (Chris T)
+
+Changelog for 1.2.14
+* Build.PL now requires Test::Trap (Chris T, 1872529)
+* Fixed double escaping of tex under some circumstances (Seneca)
+* Added fix for bad summary information in AR/AP transactions (1800065,
+1800069, Chris T)
+* Fixed posting issue behind AR/AP transaction report anomilies (Chris T)
+* Fixed taxes added twice when viewing existing transaction (Chris T)
+* Fixed erroneous discount lines in POS invoice (Chris T)
+
+Changelog for 1.2.13
+* Fixed all known implicit cast issues with PostgreSQL 8.3 (Chris T)
+* Fixed Vendor Info Incorrectly Escaped in Check Printing Module(1844159,
+Chris T)
+* Fixed Serial numbers not preserved on order consolidation(1849585, Chris T)
+* Adding fix for double-incrementing id sequence(Chris T)
+* Fixed: DBD::Pg Error Searching for PO by description (1876963, Chris T)
+* fixed syntax error in COMMENT ON INDEX statement (Seneca)
+* Fixed the display of taxes with '%' in PDF invoices (Seneca)
+* Fixed broken substitution in update_defaults (Seneca)
+
+
+Changelog for 1.2.12
+* Committed Tony Brummett's fix for last/avg costs updates (Chris T)
+* Committing fix for User.pm error handling (1860699, Chris T)
+* Some revisions in spec files (Chris M)
+* Changed LICENSE directive in rpm to the more descriptive gpl v2+ (Chris T)
+* Fixed bug 1835463, cannot transfer to warehouses (Chris T)
+* Adding fix for 1771834, inventory lost converting order to invoice (Chris T)
+* Fixed 1812792, (discount box blank after part lookup (Chris T)
+* Fixed bug 1839776-- reposting sales invoice causes duplication.(Chris T)
+
+
+Changelog for 1.2.11
+* Simplified obtaining years with transactions (Chris T)
+* Fixed dataset creation (Chris T)
+* Tax display fixes for AR/AP transactions (Chris T, 1794077, 1790768)
+* Fixed encoding errors in numeral to text conversion (Seneca)
+* Fixed the displayed number format for AP invoice taxes (Seneca)
+* Fixed the selection of taxes when validto is involved (Seneca, anarcat's
+ addtion to 1818792)
+
+
+
+Changelog for 1.2.10
+* Fixed bug 1765161, post button duplicates invoices.(Chris T)
+* Adding a minor fixes to COGS edge cases for reversed invoices. (Chris T)
+* Fixed bug 1811022. Closedto date problems (Seneca)
+* Fixing error on parts cost display, bug 1811470 (Chris T)
+* fixed oversight with required_debs.txt name (Joshua D)
+* Removing stray quote from button label, bug 1814444 (Seneca)
+* Increasing min DBI version (Seneca)
+* Apply db_parse_numeric to the correct hashref, fixes 1815081(Seneca)
+* Fixed 1815075, Subject of email improperly encoded) (Seneca)
+* Set template file output to UTF8 (Seneca)
+* Body encoding fixes (Seneca)
+* Fixing message-id setting (Seneca)
+* Drawer opening now uses correct printer designation (Chris T)
+* Change issued is now entered with correct memo field. (Chris T)
+* Closing tell report works as advertised (Chris T)
+* Fixed 1814437, Multiple paths set causing errors (Seneca)
+* Add the ampersand to the HTML escape list for parse_template (Seneca)
+* fixed 1815329, $ not escaped properly for LaTeX (Seneca)
+* updated Hungarian translation from PongrÃcz IstvÃn (patch 1814156, Seneca)
+* Properly handle invoice-type quantities from customer search (Seneca)
+* Correcting improper redirect when reposting POS invoices.(Chris T)
+* Fixing issues relating to database queries and POS-module redirects (Seneca)
+* Fixing bug which hides discount input in POS screen. (Chris T)
+* Fixing bug: Obsolete items show on short parts report(Chris T)
+* Fixed bugs handling floats as numbers from the database (Seneca)
+* Fixing POS screen opening drawer when print/post triggers update (Chris T)
+* Add missing $parts_id to query in add_items_required (Seneca)
+* Fix purchase order generation screen display (Seneca)
+* Shift the extraction of invnumber down a few lines (fixes 1820572, Seneca)
+* Fixing bug 1831246, doubleparsing in RC.pm (Seneca)
+* Fixing bug 1831410, double parsing in recurring transactions (Seneca)
+* Fixed bug 1820698, DBI error: value too long (Seneca)
+* Adding db fix script for 1819483 (Chris T)
+* Removing duplicate drawer open (Chris T)
+* Adding db fix script for primary key in recurring table (Seneca)
+* Fix for bug 1831402, session expired re: recurring emails (Seneca)
+* More number formatting fixes (Seneca)
+* Encoding fixes for the backup routines (Seneca)
+
+
+
+
+Cangelog for 1.2.9
+* Removed GNUisms from find arguments (Seneca)
+* Corrected SQL errors in Belgium, and other COAs (Seneca, 1804712)
+* Added COA load test script (Seneca)
+* Rewritten COGS system (Chris T)
+* Scoping issues fixed (Seneca, 1809384)
+
+Changelog for 1.2.8
+* Fix SQL errors saving customer price lists (Chris T, 1754172)
+* Fixed AR/AP reversal issues (Victor S, 1752439, 1753358)
+* Fixed various scoping errors (Chris T, 1703347, 1753360)
+* Fixed: Timecards ignore price matrix (Chris T, 1754099)
+* Fixed scoping issues in IS.pm (Chris T, 1754576, 1754579, 1768678)
+* Fixed bugs with reversing invoices (Victor S, 1756387, 1755928, 1755355)
+* Cause the GL report amount boxes to respect number format (Chrish T, 1754976)
+* Corrected cumulative tax display issues (Chris T, 1745757)
+* Fixed the display of non-all GL and GIFI reports (Seneca, 1758251)
+* Fixed SQL errors in project deletion (Seneca, 1760722)
+* Fixed error that caused order to invoice conversion to fail (Seneca)
+* Fixed SQL errors in customer search (Chris T, 1761615)
+* Fixed SQL errors (Chris T)
+* Correct display issues with number format '1.000,00' (Seneca)
+* Prevent AR Transaction screen from calculating sales tax (Chris T)
+* Populate quantities during purchase order generation (Chris T, 1750895)
+* Fixing COGS posts to closed dates when books closed (Chris T, 1753372)
+* Fix database errors in processing recurring actions (Seneca, 1773591)
+* Keep the closedto date in a known form (Chris T, 1763928, 1755145)
+* Fixed memo search bug (Seneca)
+* Fixed minor bug in till account selection (Chris T)
+* Fixed number formatting in the Inventory Activity report (Seneca)
+* Fixed: Add new language error in 1.2.7 (Pongracz I, 1793331)
+* Correct display issues with number format '1 000.00' (Seneca, 1795858)
+* Fixed minor documentation errors (Seneca)
+* Adding more NaN checks to transaction posting (Seneca, 1789169)
+
+Changelog for 1.2.7
+* Fixed ..hidden.. logins (Chris T)
+* Fixed closed books detection (Chris T)
+* Fixed AR/AP print and post endless loop (Chris T)
+* Fixed subtotal not working on AR/AP Transaction Report (Seneca)
+* Fixing incorrect tax account selection issues in POS screen (Chris T)
+* Fixed: Titlebar does not show user info (Seneca)
+* Fixing error searching for parts with sales invoice links (Chris T)
+* Fixed a number of COGS bugs on invoice reversal (Victor S)
+* Fixing bareword error with pos.conf.pl (Chris T)
+* Fixing SQL error when creating assembly (Seneca)
+* Fixing Template use check in user deletion (Seneca)
+* Fixing bug partial transaction commit bug wrt invoices (Chris T)
+* Fixed line items were dropped on order consolidation (Chris T)
+* Correcting errors on transaction list after posting (Chris T)
+* Updated ebuild files (Chris T)
+* Backporting POD and tests for Menu.pm from trunk (Seneca)
+* Fixing constraint issue deleting part (Chris T)
+* fixing vendor taxes displaying improperly when printing PO (Seneca)
+* Corrected security bypass in login.pl (Seneca)
+
+Changelog for 1.2.6
+* More date tests added (Seneca)
+* Fixed customer_id error in AP transactions (Chris T)
+* Added meta tags to set to utf-8 by default (Chris T)
+* Fixed the alias inconsistancy for the ledgersmb-httpd.conf (Chris T).
+* Fixed invalid html in ca.pl (reported by Donna Robinson) (Chris T)
+* Fixed error searching for customer by address (Chris T)
+* Fixed error db error saving items with custom fields (Chris T)
+* Fixed db error saving project with NULL customer id (Chris T)
+* Improved upgrade_templates' tag handling (Seneca)
+
+Changelog for 1.2.5
+* Partsgroup handling corrected on POS and Sales invoice screens (Chris T)
+* Closed books handling is corrected (Chris T)
+* Corrected intermediate rounding issues involving sales tax (Chris T)
+* Fixed FX issue with posting cash transfers (Chris T)
+* Corrected multibyte handling in form generation (Seneca)
+* Corrected NaN issues in invoice printing (Seneca)
+* Corrected PO and order number searches not working (Chris T).
+* Corrected Exchange Rate display issue (CHris T).
+* Corrected number parsing issues with 1.000,00 formats (Chris T).
+* Corrected a number of date handling issues and added tests (Seneca).
+* Applied invoice performance patch from Ashley Gittins (Chris T)
+* Applide performance improvements to lastname_used (Chris T)
+
+Changelog for 1.2.4
+* Fixed internal functions avgcost() and lastcost() to not use float (Joshua D)
+* Fixed error posting vendor invoice with fraction costs. (Chris M)
+* Fixed sales tax display issue on invoice/order entry screen (Chris T)
+* Fixed inconsistant error when setting to recur 0 times (Chris T)
+* Fixed Access Denied when sending email (CHris T)
+* Added Makefile.PL as optional means of dependency checking (experimental, Chris T)
+* Updated INSTALL file to use correct globaldbh syntax (Chris T)
+* Updated UNGRADE file to recommend reading INSTALL first (Chris T)
+
+
+Changelog for 1.2.3
+* Corrected per-user locale selection (Seneca)
+* Corrected partial commits for invoices and orders (Chris T)
+* Corrected data types for invoice.qty and invoice.allocated in new dbs (CHris T)
+* Corrected suffix error in 1.2.1 to use .sqlc for backups (Joshua D)
+
+Changelog for 1.2.2
+* Corrected sales tax display bug in order entry screen (Chris T)
+* Corrected database update unable to connect (Seneca)
+* Corrected login problems on 1.2.1
+* Corrected INSTALL for [GlobalDBH] (Joshua Drake)
+
+Changelog for LedgerSMB 1.2.1
+* Modifed AM.pm to correctly use globals from ledgersmb.conf (Joshua Drake)
+* Simplified backup functions in AM.pm (Joshua Drake)
+* Corrected serious sales tax posting bug (Chris Travers)
+* Corrected two sales tax display bugs (Chris Travers)
+* Corrected configure_apache.sh not rewriting WORKING_DIR (Chris Travers)
+* Corrected documentation about tax entry (Chris Travers)
+* Corrected logos not printing on PDF/PS invoices (Chris Travers)
+
Changelog for LedgerSMB 1.2.0
Database:
Modified: trunk/bin/io.pl
===================================================================
--- trunk/bin/io.pl 2009-12-13 19:36:50 UTC (rev 2822)
+++ trunk/bin/io.pl 2009-12-13 19:55:09 UTC (rev 2823)
@@ -262,12 +262,9 @@
}
}
- $discount =
- $form->round_amount(
- $form->{"sellprice_$i"} * $form->{"discount_$i"} / 100,
- $decimalplaces );
- $linetotal = $form->round_amount( $form->{"sellprice_$i"} - $discount,
- $decimalplaces );
+ $linetotal = $form->round_amount( $form->{"sellprice_$i"}
+ * (1 - ($form->{"discount_$i"} / 100),
+ $decimalplaces);
$linetotal = $form->round_amount( $linetotal * $form->{"qty_$i"}, 2 );
if (
Modified: trunk/sql/modules/Account.sql
===================================================================
--- trunk/sql/modules/Account.sql 2009-12-13 19:36:50 UTC (rev 2822)
+++ trunk/sql/modules/Account.sql 2009-12-13 19:55:09 UTC (rev 2823)
@@ -91,6 +91,12 @@
END;
$$ language plpgsql;
+CREATE OR REPLACE FUNCTION account_heading_list()
+RETURNS SETOF account_heading AS
+$$
+SELECT * FROM account_heading order by accno;
+$$ language sql;
+
CREATE OR REPLACE FUNCTION account_heading_save
(in_id int, in_accno text, in_description text, in_parent int)
RETURNS int AS
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.