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 - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
24 $ /dimensions/includes/dimensions_db.inc
25 /gl/includes/db/gl_db_banking.inc
27 /inventory/includes/db/items_adjust_db.inc
28 /manufacturing/includes/db/work_order_issues_db.inc
29 /manufacturing/includes/db/work_order_produce_items_db.inc
30 /manufacturing/includes/db/work_orders_db.inc
31 /manufacturing/includes/db/work_orders_quick_db.inc
32 /purchasing/includes/db/grn_db.inc
33 /purchasing/includes/db/po_db.inc
34 /purchasing/includes/db/supp_payment_db.inc
35 /reporting/includes/form_types.inc (File removed)
36 /sales/includes/db/sales_delivery_db.inc
37 /sales/includes/db/sales_invoice_db.inc
38 /sales/includes/db/sales_order_db.inc
40 # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
41 $ /reporting/rep101.php
43 # clone replacement do_clone() for both PHP 4 and PHP 5.
44 $ /includes/ui/ui_view.inc (at the very bottom)
45 /sales/includes/cart_class.inc
47 07-Mar-2008 Janusz Dobrowolski
48 ! Changed name tax type uniqueness constraint to (name, rate)
49 $ /includes/ui/ui_lists.inc
50 /taxes/items_tax_types.php
51 ! Tax included option moved from tax_group to sales_types table
52 $ includes/ui/ui_view.inc
53 /purchasing/includes/ui/invoice_ui.inc
56 /taxes/db/tax_groups_db.inc
58 # Final rewriting of sales module, a lot of bugfixes.
59 + Template delivery/invoicing
60 + Concurrent document editing control on sql level
61 + Most of sales documents are now editable
62 + Some links to print documents after entry
63 ! Changed javascript helper function for customer allocations
64 $ /applications/customers.php
65 /includes/ui/ui_input.inc
69 /sales/credit_note_entry.php
70 /sales/customer_credit_invoice.php
71 /sales/customer_delivery.php
72 /sales/customer_invoice.php
73 /sales/customer_payments.php
74 /sales/sales_order_entry.php
75 /sales/allocations/customer_allocate.php
76 /sales/allocations/customer_allocation_main.php
77 /sales/includes/cart_class.inc
78 /sales/includes/sales_db.inc
79 /sales/includes/sales_ui.inc
80 /sales/includes/db/cust_trans_db.inc
81 /sales/includes/db/cust_trans_details_db.inc
82 /sales/includes/db/custalloc_db.inc
83 /sales/includes/db/customers_db.inc
84 /sales/includes/db/payment_db.inc
85 /sales/includes/db/sales_credit_db.inc
86 /sales/includes/db/sales_delivery_db.inc
87 /sales/includes/db/sales_invoice_db.inc
88 /sales/includes/db/sales_order_db.inc
89 /sales/includes/db/sales_types_db.inc
90 /sales/includes/ui/print_invoice.inc
91 /sales/includes/ui/sales_credit_ui.inc
92 /sales/includes/ui/sales_order_ui.inc
93 /sales/inquiry/customer_allocation_inquiry.php
94 /sales/inquiry/customer_inquiry.php
95 /sales/inquiry/sales_deliveries_view.php
96 /sales/inquiry/sales_orders_view.php
97 /sales/manage/credit_status.php
98 /sales/manage/sales_types.php
99 /sales/view/view_credit.php
100 /sales/view/view_dispatch.php
101 /sales/view/view_invoice.php
102 /sales/view/view_receipt.php
103 /sales/view/view_sales_order.php
104 # Removed function name conflict with wiki help system
105 /includes/lang/language.php
107 06-Mar-2008 Janusz Dobrowolski
108 + Wiki help links integration
110 /includes/page/header.inc
111 /includes/lang/language.php
112 + Optional debuging with xdebug module
114 /includes/db/connect_db.inc
115 ! Concurrent edition fix
116 $ /includes/systypes.inc
118 $ /manufacturing/manage/bom_edit.php
120 $ /themes/aqua/renderer.php
121 /themes/cool/renderer.php
122 /themes/default/renderer.php
123 # Removed warning about nonexistent $_GET variable
124 $ /dimensions/inquiry/search_dimensions.php
125 # MySQL 3.xx CAST bug fix
126 $ /includes/db/manufacturing_db.inc
127 /manufacturing/includes/db/work_order_requirements_db.inc
128 /manufacturing/inquiry/where_used_inquiry.php
131 ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
132 Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
133 $ /inventory/cost_update.php
134 /purchasing/includes/db/grn_db.inc and
135 /manufacturing/manage/bom_edit.php.
136 /manufacturing/includes/db/work_orders_db.inc
137 /manufacturing/includes/db/work_orders_quick_db.inc
138 /manufacturing/work_order_entry.php
141 + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
142 $ /admin/view_print_transaction.php
143 /applications/setup.php
146 ! Minor change in menu and function in view_print_transaction.php
147 $ /admin/view_print_transaction.php
148 /application/setup.php
149 + Preparing for print of single documents
150 $ /reporting/includes/reporting.inc
151 ! Removing 'out' field in table tax_types
154 /taxes/db/tax_types_db.inc
155 + Added 2 functions in ui_input.inc, button and button_cell
156 /includes/ui/ui_input.inc
159 + Added file, update_db.php, for updating company databases from an SQL script.
160 $ update_db.php (New file)
164 + Added Report, Salesman Listing, rep106.php.
165 $ /reporting/reports_main.php
166 /reporting/rep106.php
168 06-Feb-2008 Janusz Dobrowolski
169 + Separation of customer invoice issue and goods delivery.
170 + Batch invoicing for more than one delivery
171 # Corrected inadequate shipping tax calculations.
172 ! Default debugging status changed to off.
173 $ /taxes/tax_calc.inc
174 /taxes/db/tax_groups_db.inc
175 /admin/db/voiding_db.inc
176 /applications/customers.php
177 /includes/systypes.inc
179 /includes/ui/ui_controls.inc
180 /includes/ui/ui_lists.inc
181 /includes/ui/ui_view.inc
182 /inventory/inquiry/stock_status.php
183 /reporting/rep105.php
184 /reporting/rep107.php
185 /reporting/rep109.php
186 /reporting/rep110.php
187 /reporting/rep209.php
188 /reporting/reports_main.php
189 /reporting/includes/doctext.inc
190 /reporting/includes/doctext2.inc
191 /reporting/includes/form_types.inc
192 /reporting/includes/pdf_report.inc
193 /reporting/includes/reports_classes.inc
194 /sales/customer_credit_invoice.php
195 /sales/customer_invoice.php
196 /sales/sales_order_entry.php
197 /sales/customer_delivery.php
198 /sales/includes/db/sales_delivery_db.inc
199 /sales/includes/ui/print_invoice.inc
200 /sales/includes/cart_class.inc
201 /sales/includes/sales_db.inc
202 /sales/includes/db/cust_trans_db.inc
203 /sales/includes/db/cust_trans_details_db.inc
204 /sales/includes/db/sales_credit_db.inc
205 /sales/includes/db/sales_invoice_db.inc
206 /sales/includes/db/sales_order_db.inc
207 /sales/includes/ui/sales_order_ui.inc
208 /sales/inquiry/customer_allocation_inquiry.php
209 /sales/inquiry/customer_inquiry.php
210 /sales/inquiry/sales_orders_view.php
211 /sales/inquiry/sales_deliveries_view.php
212 /sales/view/view_dispatch.php
213 /sales/view/view_invoice.php
214 /sales/view/view_sales_order.php
219 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
220 $ /sales/includes/cart_class.inc
221 /sales/includes/db/sales_credit_db.inc
222 /sales/includes/db/sales_invoice_db.inc
223 /sales/includes/db/sales_order_db.inc
224 /sales/includes/db/cust_trans_details_db.inc
225 /sales/includes/ui/sales_order_ui.inc
226 /sales/includes/ui/sales_credit_ui.inc
227 /sales/credit_note_entry.php
228 /sales/customer_credit_invoice.php
229 /sales/sales_order_entry.php
230 /sales/customer_invoice.php
233 ! New Release 2.0 Pre Alpha
235 # Fixed a release 2 related bug in create_coy.php
236 $ /admin/create_coy.php
237 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
238 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
239 with these databases changes without any new files. They are coming as soon as possible.
240 $ /sql/alter.sql (New file)
241 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
243 $ /purchasing/supplier_trans_gl.php
244 /purchasing/includes/db/invoice_items_db.inc
245 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
246 $ /includes/ui/ui_lists.inc
247 /purchasing/includes/ui/po_ui.inc
248 /sales/includes/ui/sales_order_ui.inc
249 /admin/company_preferences.php
250 /admin/db/company_db.inc
252 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
253 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
254 $ /sales/manage/sales_people.php
255 /includes/ui/ui_input.inc
257 -------------------- 2,0 Pre Alpha - above ----------------------------
258 31-Jan-2008 Janusz Dobrowolski
259 # Minor bugfix in db_import()
260 $ /admin/db/maintenance_db.inc
262 30-Jan-2008 Janusz Dobrowolski
263 # Minor display fix in tax_types.php
264 $ /taxes/tax_types.php
265 ! Format cleanup on some files.
266 $ /gl/includes/gl_db.inc
267 /gl/includes/gl_ui.inc
268 /applications/application.php
272 -------------------- 1.16 Stable Released ----------------------
274 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
275 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
276 and $no_supplier_list. Default is the normal behavior for all listboxes.
277 $ /includes/ui/ui_lists.inc
278 /sales/includes/ui/sales_orders_ui.inc
279 /purchases/includes/ui/po_ui.inc
280 /themes/default/images/locate.png (New file)
283 + Added ALTER TABLE possibility in db_import. For future releases.
284 $ /admin/db/maintenence_db.inc
286 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
287 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
288 $ /includes/db/connect_db.inc
289 /includes/ui/ui_lists.inc
290 /includes/page/header.inc
294 # When login screen is displayed after session timeout page content is broken. It
295 is because of NOT using absolute paths in href attribute theme elements.
299 # Minor adjustments in function db_export on line 325
300 $ /admin/db/maintenance_db.inc
303 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
306 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
307 Also fixed a unneccessary str_replace when importing sql scripts.
308 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
309 $ /admin/db/maintenance_db.inc
310 /reporting/includes/pdf_report.inc
313 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
314 $ /gl/inquiry/gl_trial_balance.php
315 /gl/inquiry/gl_account_inquiry.php
318 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
319 $ /admin/db/voiding_db.inc
322 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
324 /gl/includes/ui/gl_payment_ui.inc
326 ! Changed $loc_notification to be set to 0 instead of 1.
329 -------------------- 1.15 Stable Released ----------------------
331 + Added email notification to stock location when available stock is below reorder level
333 /sales/includes/db/sales_order_db.inc
335 # Fixed bugs in Open balances when account is not a balance account
336 $ /gl/inquiry/gl_trial_balance.php
337 /gl/inquiry/gl_account_inquiry.php
338 /reporting/rep704.php
339 /reporting/rep708.php
341 -------------------- 1.14 Stable Released ----------------------
343 ! Major change in the installation of modules to also accept an SQL-file for upload.
345 /admin/inst_module.php
346 /admin/db/maintenance_db.inc
349 # The following files were still vulnerable. Fixed
351 /includes/lang/language.php
353 -------------------- 1.13 Stable Released ----------------------
355 + Added optional link for electronic payment on invoices (PayPal).
356 ! Better support for install/update languages.
358 # Fixed a vulnerable item in config.php
362 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
363 # config.php has been vulnerable. Fixed.
364 $ /admin/inst_lang.php
368 ! Changed Bank Address field from text to textarea (multirows)
369 $ /gl/manage/bank_accounts.php
372 + Added optional link for electronic payment on invoices (PayPal)
373 $ /reporting/reports_main.php
374 /reporting/rep107.php
375 /reporting/includes/report_classes.inc
376 /reporting/includes/pdf_report.inc
377 /reporting/includes/doc_text.inc
378 /reporting/includes/doc_text2.inc
381 # Unnecessary parameter ($db) in check_for_recursive_bom
382 $ /manufacturing/manage/bom_edit.php
385 # Bug in /includes/lang/gettext.php (249) affecting changing language!
386 $ /includes/lang/gettext.php
392 /admin/create_coy.php
393 /reporting/includes/pdf_report.inc
396 + Added a default fiscal year in the en_US-new.sql and start references.
398 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
399 $ /lang/en_US/LC_MESSAGES/en_US.mo
402 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
403 $ /sales/includes/db/sales_order_db.inc
406 # Changed <? in front of 2 files to <?php.
407 $ /purchasing/includes/purchasing_ui.inc
408 /reporting/includes/class.mail.inc
410 -------------------- 1.12 Stable Released ----------------------
412 + Added option to handle Jalali and Islamic Calendars
415 /gl/includes/db/gl_db_trans.inc
416 /includes/date_functions.inc
417 /includes/ui/ui_input.inc
418 /includes/ui/ui_lists.inc
419 /includes/ui/ui_view.inc
420 /purchasing/po_receive_items.php
421 /purchasing/includes/ui/invoice_ui.inc
422 /purchasing/includes/ui/po_ui.inc
423 /reporting/rep705.php
424 /sales/includes/db/sales_order_db.inc
425 /sales/includes/ui/sales_order_ui.inc
428 ! Changed parameters on report Sales Order. Option to print as Quote.
429 $ /reporting/reports_main.php
430 /reporting/rep109.php
431 /reporting/includes/pdf_report.inc
432 /reporting/includes/doctext.inc
433 /reporting/includes/doctext2.inc
436 + Added Budget Entry in General Ledger. Includes Dimensions.
438 /applications/generalledger.php
439 /gl/gl_budget.php (New File!)
440 /gl/includes/db/gl_db_trans.inc
441 /includes/date_functions.inc
442 /reporting/report_classes.inc
444 -------------------- 1.11 Stable Released ----------------------
446 ! Option for using alpha numeric chart of accounts.
448 /gl/manage/gl_accounts.php
449 /gl/includes/db/gl_db_accounts.inc
450 /gl/includes/db/gl_db_bank_trans.inc
451 /gl/includes/db/gl_db_trans.inc
452 /gl/inquiry/gl_trial_balance.inc
453 /admin/db/company_db.inc
454 /inventory/includes/db/items_db.inc
455 /sales/manage/customer_branches.inc
458 # Problems retrieving language texts for poEdit in long javascripts
459 $ /includes/ui/ui_view.inc
462 # Database error when updating more than one item row in Sales Orders.
463 $ /sales/includes/db/sales_order_db.inc
464 # Database error when inserting work order issues. Fixed.
465 $ /manufacturing/includes/db/work_order_issues_db.inc
468 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
469 $ /includes/db/manufacturing_db.inc
470 /manufacturing/includes/db/work_order_requirements_db.inc
473 # Missing details on Purchase Order when emailing and printing
474 $ /reporting/rep209.php
476 -------------------- 1.1 Stable Released ----------------------
478 + Enabled module addons and all the below bugfixes. No changes in database structure.
479 - Removed /sql/basic.sql (included in the other sql files)
480 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
481 (not needed anymore).
482 + Addition of update.html
483 $ /admin/inst_module.php (New file!)
484 /applications/customers.php
485 /applications/dimensions.php
486 /applications/generalledger.php
487 /applications/inventory.php
488 /applications/manufacturing.php
489 /applications/setup.php
490 /applications/suppliers.php
493 /modules/inst_modules.php (New folder and new file!)
494 /modules/index.php (New file!)
498 update.html (New file!)
501 # Missing measure of units when printing sales orders
502 # Update of Sales People caused a database error
503 $ /sales/manage/sales_people.php
504 /reporting/rep109.php
507 + The selected menu tab is now shown with same background as hover color.
508 $ config.php (default tab line 77. Change if you want)
509 /includes/page/header.inc
512 # When saving work order entries a lot of debug boxes appeared. Fixed
513 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
514 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
515 $ /includes/db/manufacturing_db.inc
516 /manufacturing/work_order_entry.php
517 /manufacturing/includes/work_order_issue_ui.inc
518 /manufacturing/includes/db/work_order_requirements_db.inc
519 /manufacturing/includes/db/work_orders_quick_db.inc
520 /manufacturing/inquiry/where_used_inquiry.php
523 # Missing Date Picker
524 $ /sales/customer_invoice.php
526 $ /sales/view/view_invoice.php
529 ! New and better Date Picker, better cool theme.
530 $ /includes/ui/ui_input.inc
531 /includes/ui/ui_view.inc
532 /reporting/includes/reports_classes.inc
533 /themes/cool/default.css
535 -------------------- 1.0.1 Stable Released ----------------------
537 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
538 the changes for selection lists customers/suppliers and the Audit Trail.
541 ! Changed the two selection lists for customers/suppliers in reports to a single one with
543 ! Changed the sort order in these selection lists from id to name.
544 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
545 $ /reporting/reports_main.php
546 /reporting/rep101.php
547 /reporting/rep102.php
548 /reporting/rep201.php
549 /reporting/rep202.php
550 /reporting/rep203.php
551 /reporting/rep204.php
552 /reporting/includes/reports_classes.inc
553 /includes/ui/ui_lists.inc
554 /gl/includes/db/gl_db_trans.inc
558 + Date Picker for all date fields.
560 /admin/fiscalyears.php
561 /admin/void_transaction.php
562 /includes/ui/ui_view.inc
563 /includes/ui/ui_input.inc
564 /dimensions/dimension_entry.php
565 /dimensions/inquiry/search_dimensions.php
569 /gl/bank_transfer.php
570 /gl/inquiry/bank_inquiry.php
571 /gl/inquiry/gl_account_inquiry.php
572 /gl/inquiry/gl_trial_balance.php
573 /gl/manage/exchange_rates.php
574 /inventory/adjustments.php
575 /inventory/transfers.php
576 /inventory/inquiry/stock_movements.php
577 /inventory/manage/items.php
578 /manufacturing/work_order_add_finished.php
579 /manufacturing/work_order_entry.php
580 /manufacturing/work_order_issue.php
581 /manufacturing/work_order_release.php
582 /purchasing/supplier_payment.php
583 /purchasing/po_entry_items.php
584 /purchasing/po_receive_items.php
585 /purchasing/supplier_credit.php
586 /purchasing/supplier_credit_grns.php
587 /purchasing/supplier_invoice.php
588 /purchasing/supplier_invoice_grns.php
589 /purchasing/supplier_trans_gl.php
590 /purchasing/includes/ui/po_ui.inc
591 /purchasing/inquity/po_search.php
592 /purchasing/inquiry/po_search_completed.php
593 /purchasing/inquiry/supplier_allocation_inquiry.php
594 /purchasing/inquiry/supplier_inquiry.php
595 /reporting/reports_main.php
596 /reporting/includes/reports_classes.inc
597 /sales/credit_note_entry.php
598 /sales/customer_credit_invoice.php
599 /sales/customer_payments.php
600 /sales/sales_order_entry.php
601 /sales/includes/ui/sales_order_ui.inc
602 /sales/inquiry/customer_allocation_inquiry.php
603 /sales/inquiry/customer_inquiry.php
604 /sales/inquiry/sales_orders_view.php
606 /themes/default/images/cal.gif
607 /themes/default/images/next.gif
608 /themes/default/images/prev.gif
611 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
612 # Bug no 1703891, Reserved MySQL words used as column names, fixed
613 $ /taxes/db/tax_types_db.inc
615 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
616 $ /gl/manage/gl_accounts.php
617 /gl/includes/db/gl_db_accounts.inc
618 /includes/ui/ui_input.inc
621 # Bug no 1702594, Logon Loop, fixed
624 -------------------- 1.0a Stable Released ----------------------
626 ! Release 1.0a established on SourceForge, fixing the bugs.
629 # Bug No 1698214, Creating Items, fixed
630 $ /includes/ui/ui_lists.inc
631 # Bug no 1698216, Item Movements, fixed
632 $ /inventory/manage/items.php
634 -------------------- 1.0 Stable Released ----------------------
636 ! Release 1.0 established on SourceForge.
638 2. Copyright and disclaimer
639 ---------------------------
640 This application is opensource software released under the GPL. Please
641 see source code and the LICENSE file