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