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