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
11 This is a changelog for FrontAccounting All releases.
23 + Added file, update_db.php, for updating company databases from an SQL script.
24 $ update_db.php (New file)
28 + Added Report, Salesman Listing, rep106.php.
29 $ /reporting/reports_main.php
32 06-Feb-2008 Janusz Dobrowolski
33 + Separation of customer invoice issue and goods delivery.
34 + Batch invoicing for more than one delivery
35 # Corrected inadequate shipping tax calculations.
36 ! Default debugging status changed to off.
38 /taxes/db/tax_groups_db.inc
39 /admin/db/voiding_db.inc
40 /applications/customers.php
41 /includes/systypes.inc
43 /includes/ui/ui_controls.inc
44 /includes/ui/ui_lists.inc
45 /includes/ui/ui_view.inc
46 /inventory/inquiry/stock_status.php
52 /reporting/reports_main.php
53 /reporting/includes/doctext.inc
54 /reporting/includes/doctext2.inc
55 /reporting/includes/form_types.inc
56 /reporting/includes/pdf_report.inc
57 /reporting/includes/reports_classes.inc
58 /sales/customer_credit_invoice.php
59 /sales/customer_invoice.php
60 /sales/sales_order_entry.php
61 /sales/customer_delivery.php
62 /sales/includes/db/sales_delivery_db.inc
63 /sales/includes/ui/print_invoice.inc
64 /sales/includes/cart_class.inc
65 /sales/includes/sales_db.inc
66 /sales/includes/db/cust_trans_db.inc
67 /sales/includes/db/cust_trans_details_db.inc
68 /sales/includes/db/sales_credit_db.inc
69 /sales/includes/db/sales_invoice_db.inc
70 /sales/includes/db/sales_order_db.inc
71 /sales/includes/ui/sales_order_ui.inc
72 /sales/inquiry/customer_allocation_inquiry.php
73 /sales/inquiry/customer_inquiry.php
74 /sales/inquiry/sales_orders_view.php
75 /sales/inquiry/sales_deliveries_view.php
76 /sales/view/view_dispatch.php
77 /sales/view/view_invoice.php
78 /sales/view/view_sales_order.php
83 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
84 $ /sales/includes/cart_class.inc
85 /sales/includes/db/sales_credit_db.inc
86 /sales/includes/db/sales_invoice_db.inc
87 /sales/includes/db/sales_order_db.inc
88 /sales/includes/db/cust_trans_details_db.inc
89 /sales/includes/ui/sales_order_ui.inc
90 /sales/includes/ui/sales_credit_ui.inc
91 /sales/credit_note_entry.php
92 /sales/customer_credit_invoice.php
93 /sales/sales_order_entry.php
94 /sales/customer_invoice.php
97 ! New Release 2.0 Pre Alpha
99 # Fixed a release 2 related bug in create_coy.php
100 $ /admin/create_coy.php
101 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
102 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
103 with these databases changes without any new files. They are coming as soon as possible.
104 $ /sql/alter.sql (New file)
105 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
107 $ /purchasing/supplier_trans_gl.php
108 /purchasing/includes/db/invoice_items_db.inc
109 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
110 $ /includes/ui/ui_lists.inc
111 /purchasing/includes/ui/po_ui.inc
112 /sales/includes/ui/sales_order_ui.inc
113 /admin/company_preferences.php
114 /admin/db/company_db.inc
116 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
117 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
118 $ /sales/manage/sales_people.php
119 /includes/ui/ui_input.inc
121 -------------------- 2,0 Pre Alpha - above ----------------------------
122 31-Jan-2008 Janusz Dobrowolski
123 # Minor bugfix in db_import()
124 $ /admin/db/maintenance_db.inc
126 30-Jan-2008 Janusz Dobrowolski
127 # Minor display fix in tax_types.php
128 $ /taxes/tax_types.php
129 ! Format cleanup on some files.
130 $ /gl/includes/gl_db.inc
131 /gl/includes/gl_ui.inc
132 /applications/application.php
136 -------------------- 1.16 Stable Released ----------------------
138 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
139 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
140 and $no_supplier_list. Default is the normal behavior for all listboxes.
141 $ /includes/ui/ui_lists.inc
142 /sales/includes/ui/sales_orders_ui.inc
143 /purchases/includes/ui/po_ui.inc
144 /themes/default/images/locate.png (New file)
147 + Added ALTER TABLE possibility in db_import. For future releases.
148 $ /admin/db/maintenence_db.inc
150 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
151 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
152 $ /includes/db/connect_db.inc
153 /includes/ui/ui_lists.inc
154 /includes/page/header.inc
158 # When login screen is displayed after session timeout page content is broken. It
159 is because of NOT using absolute paths in href attribute theme elements.
163 # Minor adjustments in function db_export on line 325
164 $ /admin/db/maintenance_db.inc
167 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
170 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
171 Also fixed a unneccessary str_replace when importing sql scripts.
172 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
173 $ /admin/db/maintenance_db.inc
174 /reporting/includes/pdf_report.inc
177 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
178 $ /gl/inquiry/gl_trial_balance.php
179 /gl/inquiry/gl_account_inquiry.php
182 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
183 $ /admin/db/voiding_db.inc
186 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
188 /gl/includes/ui/gl_payment_ui.inc
190 ! Changed $loc_notification to be set to 0 instead of 1.
193 -------------------- 1.15 Stable Released ----------------------
195 + Added email notification to stock location when available stock is below reorder level
197 /sales/includes/db/sales_order_db.inc
199 # Fixed bugs in Open balances when account is not a balance account
200 $ /gl/inquiry/gl_trial_balance.php
201 /gl/inquiry/gl_account_inquiry.php
202 /reporting/rep704.php
203 /reporting/rep708.php
205 -------------------- 1.14 Stable Released ----------------------
207 ! Major change in the installation of modules to also accept an SQL-file for upload.
209 /admin/inst_module.php
210 /admin/db/maintenance_db.inc
213 # The following files were still vulnerable. Fixed
215 /includes/lang/language.php
217 -------------------- 1.13 Stable Released ----------------------
219 + Added optional link for electronic payment on invoices (PayPal).
220 ! Better support for install/update languages.
222 # Fixed a vulnerable item in config.php
226 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
227 # config.php has been vulnerable. Fixed.
228 $ /admin/inst_lang.php
232 ! Changed Bank Address field from text to textarea (multirows)
233 $ /gl/manage/bank_accounts.php
236 + Added optional link for electronic payment on invoices (PayPal)
237 $ /reporting/reports_main.php
238 /reporting/rep107.php
239 /reporting/includes/report_classes.inc
240 /reporting/includes/pdf_report.inc
241 /reporting/includes/doc_text.inc
242 /reporting/includes/doc_text2.inc
245 # Unnecessary parameter ($db) in check_for_recursive_bom
246 $ /manufacturing/manage/bom_edit.php
249 # Bug in /includes/lang/gettext.php (249) affecting changing language!
250 $ /includes/lang/gettext.php
256 /admin/create_coy.php
257 /reporting/includes/pdf_report.inc
260 + Added a default fiscal year in the en_US-new.sql and start references.
262 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
263 $ /lang/en_US/LC_MESSAGES/en_US.mo
266 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
267 $ /sales/includes/db/sales_order_db.inc
270 # Changed <? in front of 2 files to <?php.
271 $ /purchasing/includes/purchasing_ui.inc
272 /reporting/includes/class.mail.inc
274 -------------------- 1.12 Stable Released ----------------------
276 + Added option to handle Jalali and Islamic Calendars
279 /gl/includes/db/gl_db_trans.inc
280 /includes/date_functions.inc
281 /includes/ui/ui_input.inc
282 /includes/ui/ui_lists.inc
283 /includes/ui/ui_view.inc
284 /purchasing/po_receive_items.php
285 /purchasing/includes/ui/invoice_ui.inc
286 /purchasing/includes/ui/po_ui.inc
287 /reporting/rep705.php
288 /sales/includes/db/sales_order_db.inc
289 /sales/includes/ui/sales_order_ui.inc
292 ! Changed parameters on report Sales Order. Option to print as Quote.
293 $ /reporting/reports_main.php
294 /reporting/rep109.php
295 /reporting/includes/pdf_report.inc
296 /reporting/includes/doctext.inc
297 /reporting/includes/doctext2.inc
300 + Added Budget Entry in General Ledger. Includes Dimensions.
302 /applications/generalledger.php
303 /gl/gl_budget.php (New File!)
304 /gl/includes/db/gl_db_trans.inc
305 /includes/date_functions.inc
306 /reporting/report_classes.inc
308 -------------------- 1.11 Stable Released ----------------------
310 ! Option for using alpha numeric chart of accounts.
312 /gl/manage/gl_accounts.php
313 /gl/includes/db/gl_db_accounts.inc
314 /gl/includes/db/gl_db_bank_trans.inc
315 /gl/includes/db/gl_db_trans.inc
316 /gl/inquiry/gl_trial_balance.inc
317 /admin/db/company_db.inc
318 /inventory/includes/db/items_db.inc
319 /sales/manage/customer_branches.inc
322 # Problems retrieving language texts for poEdit in long javascripts
323 $ /includes/ui/ui_view.inc
326 # Database error when updating more than one item row in Sales Orders.
327 $ /sales/includes/db/sales_order_db.inc
328 # Database error when inserting work order issues. Fixed.
329 $ /manufacturing/includes/db/work_order_issues_db.inc
332 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
333 $ /includes/db/manufacturing_db.inc
334 /manufacturing/includes/db/work_order_requirements_db.inc
337 # Missing details on Purchase Order when emailing and printing
338 $ /reporting/rep209.php
340 -------------------- 1.1 Stable Released ----------------------
342 + Enabled module addons and all the below bugfixes. No changes in database structure.
343 - Removed /sql/basic.sql (included in the other sql files)
344 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
345 (not needed anymore).
346 + Addition of update.html
347 $ /admin/inst_module.php (New file!)
348 /applications/customers.php
349 /applications/dimensions.php
350 /applications/generalledger.php
351 /applications/inventory.php
352 /applications/manufacturing.php
353 /applications/setup.php
354 /applications/suppliers.php
357 /modules/inst_modules.php (New folder and new file!)
358 /modules/index.php (New file!)
362 update.html (New file!)
365 # Missing measure of units when printing sales orders
366 # Update of Sales People caused a database error
367 $ /sales/manage/sales_people.php
368 /reporting/rep109.php
371 + The selected menu tab is now shown with same background as hover color.
372 $ config.php (default tab line 77. Change if you want)
373 /includes/page/header.inc
376 # When saving work order entries a lot of debug boxes appeared. Fixed
377 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
378 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
379 $ /includes/db/manufacturing_db.inc
380 /manufacturing/work_order_entry.php
381 /manufacturing/includes/work_order_issue_ui.inc
382 /manufacturing/includes/db/work_order_requirements_db.inc
383 /manufacturing/includes/db/work_orders_quick_db.inc
384 /manufacturing/inquiry/where_used_inquiry.php
387 # Missing Date Picker
388 $ /sales/customer_invoice.php
390 $ /sales/view/view_invoice.php
393 ! New and better Date Picker, better cool theme.
394 $ /includes/ui/ui_input.inc
395 /includes/ui/ui_view.inc
396 /reporting/includes/reports_classes.inc
397 /themes/cool/default.css
399 -------------------- 1.0.1 Stable Released ----------------------
401 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
402 the changes for selection lists customers/suppliers and the Audit Trail.
405 ! Changed the two selection lists for customers/suppliers in reports to a single one with
407 ! Changed the sort order in these selection lists from id to name.
408 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
409 $ /reporting/reports_main.php
410 /reporting/rep101.php
411 /reporting/rep102.php
412 /reporting/rep201.php
413 /reporting/rep202.php
414 /reporting/rep203.php
415 /reporting/rep204.php
416 /reporting/includes/reports_classes.inc
417 /includes/ui/ui_lists.inc
418 /gl/includes/db/gl_db_trans.inc
422 + Date Picker for all date fields.
424 /admin/fiscalyears.php
425 /admin/void_transaction.php
426 /includes/ui/ui_view.inc
427 /includes/ui/ui_input.inc
428 /dimensions/dimension_entry.php
429 /dimensions/inquiry/search_dimensions.php
433 /gl/bank_transfer.php
434 /gl/inquiry/bank_inquiry.php
435 /gl/inquiry/gl_account_inquiry.php
436 /gl/inquiry/gl_trial_balance.php
437 /gl/manage/exchange_rates.php
438 /inventory/adjustments.php
439 /inventory/transfers.php
440 /inventory/inquiry/stock_movements.php
441 /inventory/manage/items.php
442 /manufacturing/work_order_add_finished.php
443 /manufacturing/work_order_entry.php
444 /manufacturing/work_order_issue.php
445 /manufacturing/work_order_release.php
446 /purchasing/supplier_payment.php
447 /purchasing/po_entry_items.php
448 /purchasing/po_receive_items.php
449 /purchasing/supplier_credit.php
450 /purchasing/supplier_credit_grns.php
451 /purchasing/supplier_invoice.php
452 /purchasing/supplier_invoice_grns.php
453 /purchasing/supplier_trans_gl.php
454 /purchasing/includes/ui/po_ui.inc
455 /purchasing/inquity/po_search.php
456 /purchasing/inquiry/po_search_completed.php
457 /purchasing/inquiry/supplier_allocation_inquiry.php
458 /purchasing/inquiry/supplier_inquiry.php
459 /reporting/reports_main.php
460 /reporting/includes/reports_classes.inc
461 /sales/credit_note_entry.php
462 /sales/customer_credit_invoice.php
463 /sales/customer_payments.php
464 /sales/sales_order_entry.php
465 /sales/includes/ui/sales_order_ui.inc
466 /sales/inquiry/customer_allocation_inquiry.php
467 /sales/inquiry/customer_inquiry.php
468 /sales/inquiry/sales_orders_view.php
470 /themes/default/images/cal.gif
471 /themes/default/images/next.gif
472 /themes/default/images/prev.gif
475 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
476 # Bug no 1703891, Reserved MySQL words used as column names, fixed
477 $ /taxes/db/tax_types_db.inc
479 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
480 $ /gl/manage/gl_accounts.php
481 /gl/includes/db/gl_db_accounts.inc
482 /includes/ui/ui_input.inc
485 # Bug no 1702594, Logon Loop, fixed
488 -------------------- 1.0a Stable Released ----------------------
490 ! Release 1.0a established on SourceForge, fixing the bugs.
493 # Bug No 1698214, Creating Items, fixed
494 $ /includes/ui/ui_lists.inc
495 # Bug no 1698216, Item Movements, fixed
496 $ /inventory/manage/items.php
498 -------------------- 1.0 Stable Released ----------------------
500 ! Release 1.0 established on SourceForge.
502 2. Copyright and disclaimer
503 ---------------------------
504 This application is opensource software released under the GPL. Please
505 see source code and the LICENSE file