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