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