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