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