Added missing no_*_list fields in initial sql files
[fa-stable.git] / CHANGELOG.txt
1 /**
2 * @version $Id$
3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2007 FrontAccounting
5 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
6 * FrontAccounting is Free Software
7 */
8
9 1. Changelog
10 ------------
11 This is a changelog for FrontAccounting All releases.
12
13 Legend:
14
15 # -> Bug Fix
16 + -> Addition
17 ! -> Change
18 - -> Removed
19 ! -> Note
20 $ -> Affected files
21
22 21-Mar-2008 Janusz Dobrowolski
23  # Added missing no_*_list fields in initial sql files
24
25 07-Mar-2008 Janusz Dobrowolski
26  # Fixed bug selecting allocated transactions as overdue
27  $ /sales/inquiry/customer_inquiry.php
28
29 31-Jan-2008 Janusz Dobrowolski
30  # Minor bugfix in db_import()
31  $ /admin/db/maintenance_db.inc
32  
33 30-Jan-2008 Janusz Dobrowolski
34  # Minor display fix in tax_types.php
35  $ /taxes/tax_types.php
36  ! Format cleanup on some files.
37  $ /gl/includes/gl_db.inc
38    /gl/includes/gl_ui.inc
39    /applications/application.php
40    frontaccounting.php
41    index.php
42    
43 -------------------- 1.16 Stable Released ----------------------
44 28-Jan-2008 Joe Hunt
45  + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
46    The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list 
47    and $no_supplier_list. Default is the normal behavior for all listboxes.
48  $ /includes/ui/ui_lists.inc
49    /sales/includes/ui/sales_orders_ui.inc
50    /purchases/includes/ui/po_ui.inc
51    /themes/default/images/locate.png (New file)
52    config.php
53
54  + Added ALTER TABLE possibility in db_import. For future releases.
55  $ /admin/db/maintenence_db.inc  
56
57  # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
58  # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
59  $ /includes/db/connect_db.inc
60    /includes/ui/ui_lists.inc
61    /includes/page/header.inc
62    /access/login.php
63    
64 16-Jan-2008 Joe Hunt
65  # When login screen is displayed after session timeout page content is broken. It
66    is because of NOT using absolute paths in href attribute theme elements.
67  $ /access/login.php
68  
69 30-Dec-2007 Joe Hunt
70  # Minor adjustments in function db_export on line 325
71  $ /admin/db/maintenance_db.inc
72  
73 29-Dec-2007 Joe Hunt
74  + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
75  $ config.php
76  
77  # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
78    Also fixed a unneccessary str_replace when importing sql scripts.
79  ! Changed the PDF presentation to deleting the Javascript cache before presentation.
80  $ /admin/db/maintenance_db.inc
81    /reporting/includes/pdf_report.inc
82    
83 13-Dec-2007 Joe Hunt
84  # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
85  $ /gl/inquiry/gl_trial_balance.php
86    /gl/inquiry/gl_account_inquiry.php
87
88 13-Dec-2007 Joe Hunt
89  # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
90  $ /admin/db/voiding_db.inc
91  
92 06-Dec-2007 Joe Hunt
93  # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
94  $ /gl/gl_payment.php
95    /gl/includes/ui/gl_payment_ui.inc
96    
97  ! Changed $loc_notification to be set to 0 instead of 1.
98  $ config.php
99  
100 -------------------- 1.15 Stable Released ----------------------
101 05-Dec-2007 Joe Hunt
102  + Added email notification to stock location when available stock is below reorder level
103  $ config.php
104    /sales/includes/db/sales_order_db.inc
105    
106  # Fixed bugs in Open balances when account is not a balance account
107  $ /gl/inquiry/gl_trial_balance.php
108    /gl/inquiry/gl_account_inquiry.php
109    /reporting/rep704.php
110    /reporting/rep708.php
111    
112 -------------------- 1.14 Stable Released ----------------------
113 01-Oct-2007 Joe Hunt
114  ! Major change in the installation of modules to also accept an SQL-file for upload.
115  $ config.php
116    /admin/inst_module.php
117    /admin/db/maintenance_db.inc
118    
119 30-Sep-2007 Joe Hunt
120  # The following files were still vulnerable. Fixed
121  $ /access/login.php
122    /includes/lang/language.php
123
124 -------------------- 1.13 Stable Released ----------------------
125 14-Sep-2007 Joe Hunt
126  + Added optional link for electronic payment on invoices (PayPal). 
127  ! Better support for install/update languages.  
128  ! Minor adjustments
129  # Fixed a vulnerable item in config.php
130  $ config.php
131
132 14-Sep-2007 Joe Hunt
133  # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
134  # config.php has been vulnerable. Fixed.
135  $ /admin/inst_lang.php
136  $ config.php
137  
138 10-Sep-2007 Joe Hunt
139  ! Changed Bank Address field from text to textarea (multirows)
140  $ /gl/manage/bank_accounts.php
141  
142 06-Sep-2007 Joe Hunt
143  + Added optional link for electronic payment on invoices (PayPal)
144  $ /reporting/reports_main.php
145    /reporting/rep107.php
146    /reporting/includes/report_classes.inc
147    /reporting/includes/pdf_report.inc
148    /reporting/includes/doc_text.inc
149    /reporting/includes/doc_text2.inc
150    
151 23-Aug-2007 Joe Hunt
152  # Unnecessary parameter ($db) in check_for_recursive_bom
153  $ /manufacturing/manage/bom_edit.php
154  
155 21-Aug-2007 Joe Hunt
156  # Bug in /includes/lang/gettext.php (249) affecting changing language!
157  $ /includes/lang/gettext.php
158  
159 08-Aug-2007 Joe Hunt
160  # Minor adjustments
161  $ config.php
162    /access/login.php
163    /admin/create_coy.php
164    /reporting/includes/pdf_report.inc
165    
166 04-Aug-2007 Joe Hunt
167  + Added a default fiscal year in the en_US-new.sql and start references.
168  $ /sql/en_US-new.sql
169  ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
170  $ /lang/en_US/LC_MESSAGES/en_US.mo
171  
172 03-Aug-2007 Joe Hunt
173  # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
174  $ /sales/includes/db/sales_order_db.inc
175  
176 23-Jul-2007 Joe Hunt
177  # Changed <? in front of 2 files to <?php.
178  $ /purchasing/includes/purchasing_ui.inc
179    /reporting/includes/class.mail.inc
180    
181 -------------------- 1.12 Stable Released ----------------------
182 21-Jul-2007 Joe Hunt
183  + Added option to handle Jalali and Islamic Calendars
184  ! Minor adjustments
185  $ config.php
186    /gl/includes/db/gl_db_trans.inc
187    /includes/date_functions.inc
188    /includes/ui/ui_input.inc
189    /includes/ui/ui_lists.inc
190    /includes/ui/ui_view.inc
191    /purchasing/po_receive_items.php
192    /purchasing/includes/ui/invoice_ui.inc
193    /purchasing/includes/ui/po_ui.inc
194    /reporting/rep705.php
195    /sales/includes/db/sales_order_db.inc
196    /sales/includes/ui/sales_order_ui.inc
197    
198 20-Jul-2007 Joe Hunt
199  ! Changed parameters on report Sales Order. Option to print as Quote.
200  $ /reporting/reports_main.php
201    /reporting/rep109.php
202    /reporting/includes/pdf_report.inc
203    /reporting/includes/doctext.inc
204    /reporting/includes/doctext2.inc
205  
206 19-Jul-2007 Joe Hunt
207  + Added Budget Entry in General Ledger. Includes Dimensions.
208  $ config.php
209    /applications/generalledger.php
210    /gl/gl_budget.php (New File!)
211    /gl/includes/db/gl_db_trans.inc
212    /includes/date_functions.inc
213    /reporting/report_classes.inc
214    
215 -------------------- 1.11 Stable Released ----------------------
216 04-Jul-2007 Joe Hunt
217  ! Option for using alpha numeric chart of accounts.
218  $ config.php
219    /gl/manage/gl_accounts.php
220    /gl/includes/db/gl_db_accounts.inc
221    /gl/includes/db/gl_db_bank_trans.inc
222    /gl/includes/db/gl_db_trans.inc
223    /gl/inquiry/gl_trial_balance.inc
224    /admin/db/company_db.inc
225    /inventory/includes/db/items_db.inc
226    /sales/manage/customer_branches.inc
227
228 04-Jul-2007 Joe Hunt
229  # Problems retrieving language texts for poEdit in long javascripts
230  $ /includes/ui/ui_view.inc
231  
232 04-May-2007 Joe Hunt
233  # Database error when updating more than one item row in Sales Orders.
234  $ /sales/includes/db/sales_order_db.inc
235  # Database error when inserting work order issues. Fixed.
236  $ /manufacturing/includes/db/work_order_issues_db.inc
237  
238 03-May-2007 Joe Hunt
239  # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
240  $ /includes/db/manufacturing_db.inc
241    /manufacturing/includes/db/work_order_requirements_db.inc
242
243 02-May-2007 Joe Hunt
244  # Missing details on Purchase Order when emailing and printing
245  $ /reporting/rep209.php
246  
247 -------------------- 1.1 Stable Released ----------------------
248 02-May-2007 Joe Hunt
249  + Enabled module addons and all the below bugfixes. No changes in database structure.
250  - Removed /sql/basic.sql (included in the other sql files)
251  - Removed /themes/default/images/left.gif and /themes/default/images/right.gif 
252    (not needed anymore).
253  + Addition of update.html  
254  $ /admin/inst_module.php (New file!)
255    /applications/customers.php
256    /applications/dimensions.php
257    /applications/generalledger.php
258    /applications/inventory.php
259    /applications/manufacturing.php
260    /applications/setup.php
261    /applications/suppliers.php
262    /install/index.php
263    /install/save.php
264    /modules/inst_modules.php (New folder and new file!)
265    /modules/index.php (New file!)
266    /sql/en_US-demo.sql
267    /sql/en_US-new.sql
268    install.html
269    update.html (New file!)
270    
271 01-May-2007 Joe Hunt
272  # Missing measure of units when printing sales orders
273  # Update of Sales People caused a database error
274  $ /sales/manage/sales_people.php
275    /reporting/rep109.php
276  
277 30-Apr-2007 Joe Hunt
278  + The selected menu tab is now shown with same background as hover color.
279  $ config.php (default tab line 77. Change if you want)
280    /includes/page/header.inc
281    
282 28-Apr-2007 Joe Hunt
283  # When saving work order entries a lot of debug boxes appeared. Fixed
284  # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
285  # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
286  $ /includes/db/manufacturing_db.inc
287    /manufacturing/work_order_entry.php
288    /manufacturing/includes/work_order_issue_ui.inc
289    /manufacturing/includes/db/work_order_requirements_db.inc
290    /manufacturing/includes/db/work_orders_quick_db.inc
291    /manufacturing/inquiry/where_used_inquiry.php
292    
293 25-Apr-2007 Joe Hunt
294  # Missing Date Picker
295  $ /sales/customer_invoice.php
296  # No JS popup window
297  $ /sales/view/view_invoice.php
298  
299 24-Apr-2007 Joe Hunt
300  ! New and better Date Picker, better cool theme.
301  $ /includes/ui/ui_input.inc
302    /includes/ui/ui_view.inc
303    /reporting/includes/reports_classes.inc
304    /themes/cool/default.css
305
306 -------------------- 1.0.1 Stable Released ----------------------
307 23-Apr-2007 Joe Hunt
308  ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
309    the changes for selection lists customers/suppliers and the Audit Trail.
310
311 22-Apr-2007 Joe Hunt
312  ! Changed the two selection lists for customers/suppliers in reports to a single one with
313    No Filter
314  ! Changed the sort order in these selection lists from id to name.
315  + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
316  $ /reporting/reports_main.php
317    /reporting/rep101.php
318    /reporting/rep102.php
319    /reporting/rep201.php
320    /reporting/rep202.php
321    /reporting/rep203.php
322    /reporting/rep204.php
323    /reporting/includes/reports_classes.inc
324    /includes/ui/ui_lists.inc
325    /gl/includes/db/gl_db_trans.inc
326    config.php
327    
328 22-Apr-2007 Joe Hunt
329  + Date Picker for all date fields.
330  $ config.php
331    /admin/fiscalyears.php
332    /admin/void_transaction.php
333    /includes/ui/ui_view.inc
334    /includes/ui/ui_input.inc
335    /dimensions/dimension_entry.php
336    /dimensions/inquiry/search_dimensions.php
337    /gl/gl_journal.php
338    /gl/gl_deposit.php
339    /gl/gl_payment.php
340    /gl/bank_transfer.php
341    /gl/inquiry/bank_inquiry.php
342    /gl/inquiry/gl_account_inquiry.php
343    /gl/inquiry/gl_trial_balance.php
344    /gl/manage/exchange_rates.php
345    /inventory/adjustments.php
346    /inventory/transfers.php
347    /inventory/inquiry/stock_movements.php
348    /inventory/manage/items.php
349    /manufacturing/work_order_add_finished.php
350    /manufacturing/work_order_entry.php
351    /manufacturing/work_order_issue.php
352    /manufacturing/work_order_release.php
353    /purchasing/supplier_payment.php
354    /purchasing/po_entry_items.php
355    /purchasing/po_receive_items.php
356    /purchasing/supplier_credit.php
357    /purchasing/supplier_credit_grns.php
358    /purchasing/supplier_invoice.php
359    /purchasing/supplier_invoice_grns.php
360    /purchasing/supplier_trans_gl.php
361    /purchasing/includes/ui/po_ui.inc
362    /purchasing/inquity/po_search.php
363    /purchasing/inquiry/po_search_completed.php
364    /purchasing/inquiry/supplier_allocation_inquiry.php
365    /purchasing/inquiry/supplier_inquiry.php
366    /reporting/reports_main.php
367    /reporting/includes/reports_classes.inc
368    /sales/credit_note_entry.php
369    /sales/customer_credit_invoice.php
370    /sales/customer_payments.php
371    /sales/sales_order_entry.php
372    /sales/includes/ui/sales_order_ui.inc
373    /sales/inquiry/customer_allocation_inquiry.php
374    /sales/inquiry/customer_inquiry.php
375    /sales/inquiry/sales_orders_view.php
376    New image files:
377    /themes/default/images/cal.gif
378    /themes/default/images/next.gif
379    /themes/default/images/prev.gif
380
381 19-Apr-2007 Joe Hunt
382  # Bug no 1703895, Account numbers are varchars, need quotes, fixed
383  # Bug no 1703891, Reserved MySQL words used as column names, fixed
384  $ /taxes/db/tax_types_db.inc
385
386  # Bug no 1703888, Apostrophes and other unescaped characters, fixed
387  $ /gl/manage/gl_accounts.php
388    /gl/includes/db/gl_db_accounts.inc
389    /includes/ui/ui_input.inc
390
391 18-Apr-2007 Joe Hunt
392  # Bug no 1702594, Logon Loop, fixed
393  $ config.php
394
395 -------------------- 1.0a Stable Released ----------------------
396 10-Apr-2007 Joe Hunt
397  ! Release 1.0a established on SourceForge, fixing the bugs.
398
399 11-Apr-2007 Joe Hunt
400  # Bug No 1698214, Creating Items, fixed
401  $ /includes/ui/ui_lists.inc
402  # Bug no 1698216, Item Movements, fixed
403  $ /inventory/manage/items.php
404
405 -------------------- 1.0 Stable Released ----------------------
406 10-Apr-2007 Joe Hunt
407  ! Release 1.0 established on SourceForge.
408
409 2. Copyright and disclaimer
410 ---------------------------
411 This application is opensource software released under the GPL.  Please
412 see source code and the LICENSE file