3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2008 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 + Added print document options in inquiries.
24 $ /sales/inquiry/customer_inquiry.php
25 /sales/inquiry/sales_orders_view.php
26 /sales/inquiry/sales_deliveries_view.php
27 /purchasing/inquiry/po_search.php
28 /purchasing/inquiry/po_search_completed.php
31 # Fixed a minor bug in customers_db.inc (should include type == 2 - Bank Deposits)
32 $ /sales/includes/db/customers_db.inc
33 # Fixed a PHP vers. 5.xx bug. No need for & operator in function calls, only in declaration. Gives a warning.
34 $ /sales/includes/db/sales_credit_db.inc
35 # Fixed a wrong variabel declaration doc_Document_no to doc_Invoice_no
36 $ /reporting/includes/doctext.inc
37 /reporting/includes/doctext2.inc
38 # Fixed so Customer Balances and Aged Customer Analysis reports presents correct sign.
39 $ /reporting/rep101.php
42 28-Mar-2008 Janusz Dobrowolski
43 # Layout/focus fixes for no_[customer/supplier/item]_list option on
44 /includes/ui/ui_lists.inc
45 /purchasing/includes/ui/po_ui.inc
46 /sales/credit_note_entry.php
47 /sales/sales_order_entry.php
48 /sales/includes/ui/sales_credit_ui.inc
49 /sales/includes/ui/sales_order_ui.inc
51 27-Mar-2008 Janusz Dobrowolski
52 + Automatic first field focus on page start, focus order preserved between form updates
53 $ /gl/inquiry/gl_account_inquiry.php
54 /includes/page/footer.inc
55 /includes/ui/ui_controls.inc
56 /includes/ui/ui_input.inc
57 /includes/ui/ui_lists.inc
58 /includes/ui/ui_view.inc
60 /sales/sales_order_entry.php
61 /sales/credit_note_entry.php
62 /sales/includes/ui/sales_credit_ui.inc
63 /sales/includes/ui/sales_order_ui.inc
64 + Data picker omitted in keyboard tabbing sequence (FF,IE, not old mozilla)
65 $ /includes/ui/ui_input.inc
66 ! Javascript recalcAccount() superseded by class='combo' behaviour binding
70 /gl/includes/ui/gl_deposit_ui.inc
71 /gl/includes/ui/gl_journal_ui.inc
72 /gl/includes/ui/gl_payment_ui.inc
73 /includes/ui/ui_view.inc
74 /purchasing/po_entry_items.php
75 /purchasing/includes/ui/po_ui.inc
76 /sales/sales_order_entry.php
77 /sales/includes/ui/sales_credit_ui.inc
78 /sales/includes/ui/sales_order_ui.inc
80 ! get_js_set_focus moved from ui_view (this is only standalone form).
82 # Fixed debit/credit entry check
84 # Restored GET/POST security check on path_to_root
87 26-Mar-2008 Janusz Dobrowolski
88 # Bug fixes in purchase module related to tax structure changes.
89 $ /purchasing/includes/supp_trans_class.inc
90 /purchasing/includes/db/invoice_db.inc
91 /purchasing/includes/db/invoice_items_db.inc
92 /purchasing/includes/ui/invoice_ui.inc
95 25-Mar-2008 Janusz Dobrowolski
96 ! Per company pdf, backup and graphics directories in 'company' dir.
99 /company/0/images/ (new dir)
100 /company/0/images/102.jpg (moved from inventory/manage/image)
101 /company/0/images/103.jpg (moved from inventory/manage/image)
102 /company/0/images/104.jpg (moved from inventory/manage/image)
103 /company/0/images/logo_frontaccounting.jpg (moved from themes/default/images)
104 /company/0/images/logo_frontaccounting.png (moved from themes/default/images)
106 /admin/create_coy.php
107 /admin/db/maintenance_db.inc
109 /reporting/rep102.php
110 /reporting/rep104.php
111 /reporting/rep202.php
112 /reporting/rep303.php
113 /reporting/rep706.php
114 /reporting/rep707.php
115 /reporting/includes/pdf_report.inc
116 /inventory/manage/items.php
118 + jscript component caching (enables browser caching and future compression)
119 $ /includes/session.inc
121 /includes/page/header.inc
122 /includes/ui/ui_view.inc
123 /admin/display_prefs.php
126 - Removed obsolete file
127 $ /sales/includes/ui/print_invoice.inc
129 21-Mar-2008 Janusz Dobrowolski
130 ! Total Allocation/Left to Allocate update without page submit.
131 $ /includes/ui/ui_view.inc
132 /purchasing/allocations/supplier_allocate.php
133 /sales/allocations/customer_allocate.php
134 # Fixed unvisable under IE editbutton
135 $ /themes/aqua/default.css
136 /themes/cool/default.css
137 /themes/default/default.css
139 20-Mar-2008 Janusz Dobrowolski
140 # Excluding delivery notes from Customer Balances, removed warnings.
141 $ /reporting/rep101.php
142 # Divide by zero fix on order_price==0 in new supplier invoice
143 $ /purchasing/supplier_invoice_grns.php
144 # Database bug fix in new customer entry
145 $ /sales/manage/customers.php
146 # Small bug fix (warnings) in is_date() function.
147 $ /includes/date_functions.inc
149 18-Mar-2008 Janusz Dobrowolski
150 # Line items editor uses POST method - no disappearing shippment info.
151 $ /sales/credit_note_entry.php
152 /sales/sales_order_entry.php
153 /sales/includes/ui/sales_credit_ui.inc
154 /sales/includes/ui/sales_order_ui.inc
155 + Added edit_button_cell() function
156 $ /includes/ui/ui_controls.inc
157 + Helper function for finding indexed submit $_POST vars.
158 $ /includes/ui/ui_input.inc
159 + New class .editbutton for buttons. Default view is link alike.
160 $ /themes/aqua/default.css
161 /themes/cool/default.css
162 /themes/default/default.css
164 17-Mar-2008 Janusz Dobrowolski
165 # Added rounding when needed to avoid document non cosistent documents.
166 $ /includes/banking.inc
167 /purchasing/supplier_credit_grns.php
168 /purchasing/supplier_invoice_grns.php
169 /purchasing/includes/supp_trans_class.inc
170 /purchasing/includes/ui/invoice_ui.inc
171 /purchasing/includes/ui/po_ui.inc
172 /reporting/rep107.php
173 /reporting/rep109.php
174 /reporting/rep110.php
175 /reporting/rep209.php
176 /sales/includes/cart_class.inc
177 /sales/includes/ui/sales_credit_ui.inc
178 /sales/includes/ui/sales_order_ui.inc
179 /sales/view/view_credit.php
180 /sales/view/view_dispatch.php
181 /sales/view/view_invoice.php
182 /sales/view/view_sales_order.php
184 # Sign bug for customer transactions
185 $ /reporting/rep709.php
186 # Include file conflict fix
187 $ /purchasing/includes/ui/invoice_ui.inc
188 /gl/manage/bank_accounts.php
189 /manufacturing/inquiry/where_used_inquiry.php
190 /purchasing/manage/suppliers.php
192 16-Mar-2008 Janusz Dobrowolski
193 + Added javascript add-on for unobtrusive apply javascript handlers to html elements.
196 + Added javascript source collecting functions
198 ! Moved check_page_security(); for safe start in case of broken wa_current_user var.
199 + Added global js code collecting arrays $js_lib, $js_static
200 $ /includes/session.inc
201 ! Changed get_js_user num to add_js_user_num; extended for percent/qty/price formatting
202 $ /includes/ui/ui_view.inc
203 + Added including javascript source colections from $js_lib, $js_static; conditional display for ajax calls
204 $ /includes/page/footer.inc
205 /includes/page/header.inc
206 ! Added including of data_checks.inc
208 + User side percent/exrate/qty/price input formatting via onblur handler.
209 $ /admin/gl_setup.php
211 /gl/manage/exchange_rates.php
212 /includes/ui/ui_input.inc
213 /inventory/purchasing_data.php
214 /inventory/reorder_level.php
215 /inventory/includes/item_adjustments_ui.inc
216 /inventory/includes/stock_transfers_ui.inc
217 /manufacturing/work_order_entry.php
218 /manufacturing/manage/bom_edit.php
219 /purchasing/po_entry_items.php
220 /purchasing/po_receive_items.php
221 /purchasing/supplier_credit.php
222 /purchasing/supplier_credit_grns.php
223 /purchasing/supplier_invoice_grns.php
224 /purchasing/supplier_trans_gl.php
225 /purchasing/allocations/supplier_allocate.php
226 /purchasing/includes/ui/po_ui.inc
227 /sales/customer_delivery.php
228 /sales/customer_invoice.php
229 /sales/allocations/customer_allocate.php
230 /sales/includes/ui/sales_credit_ui.inc
231 /sales/includes/ui/sales_order_ui.inc
232 /taxes/tax_groups.php
235 14-Mar-2008 Janusz Dobrowolski
236 + All forms fixed to accept user native numeric format.
237 $ /admin/gl_setup.php
238 /gl/bank_transfer.php
243 /gl/includes/db/gl_db_banking.inc
244 /gl/includes/ui/gl_deposit_ui.inc
245 /gl/includes/ui/gl_journal_ui.inc
246 /gl/includes/ui/gl_payment_ui.inc
247 /gl/manage/exchange_rates.php
248 /inventory/adjustments.php
249 /inventory/cost_update.php
250 /inventory/prices.php
251 /inventory/purchasing_data.php
252 /inventory/reorder_level.php
253 /inventory/transfers.php
254 /inventory/includes/item_adjustments_ui.inc
255 /inventory/includes/stock_transfers_ui.inc
256 /inventory/manage/item_units.php
257 /manufacturing/work_order_entry.php
258 /manufacturing/inquiry/where_used_inquiry.php
259 /manufacturing/manage/bom_edit.php
260 /purchasing/po_entry_items.php
261 /purchasing/po_receive_items.php
262 /purchasing/supplier_credit_grns.php
263 /purchasing/supplier_invoice_grns.php
264 /purchasing/supplier_payment.php
265 /purchasing/supplier_trans_gl.php
266 /purchasing/allocations/supplier_allocate.php
267 /purchasing/includes/ui/po_ui.inc
268 /purchasing/inquiry/po_search.php
269 /sales/credit_note_entry.php
270 /sales/customer_credit_invoice.php
271 /sales/customer_delivery.php
272 /sales/customer_invoice.php
273 /sales/customer_payments.php
274 /sales/sales_order_entry.php
275 /sales/allocations/customer_allocate.php
276 /sales/includes/ui/sales_credit_ui.inc
277 /sales/includes/ui/sales_order_ui.inc
278 /sales/manage/customers.php
279 /sales/manage/sales_people.php
280 /sales/view/view_credit.php
281 /sales/view/view_dispatch.php
282 /sales/view/view_invoice.php
283 /sales/view/view_receipt.php
284 /sales/view/view_sales_order.php
285 /taxes/item_tax_types.php
286 /taxes/tax_groups.php
288 + User format functions for percent/price/exrate amounts display.
289 $ /includes/current_user.inc
290 + Input checking functions for numeric input fields in user native format
291 $ /includes/data_checks.inc
292 + Numeric input fields in user native format
293 $ /includes/ui/ui_input.inc
294 + Javascript function for conversion to/from user native numeric format.
295 $ /includes/ui/ui_view.inc
296 + New class amount for numeric input
297 $ /themes/aqua/default.css
298 /themes/cool/default.css
299 /themes/default/default.css
300 # Removed warning on adding component
301 /manufacturing/manage/bom_edit.php
302 # Quantity display correction
303 /manufacturing/inquiry/where_used_inquiry.php
304 # Fixed add_customer_trans() call
305 /gl/includes/db/gl_db_banking.inc
308 + Added update of Units of Measure and converting of deptor_trans records from release 1.XX
309 - Removed default insertion of Units of Measure. Not neccessary.
311 /admin/db/maintenance_db.inc (added support for update)
313 11-Mar-2008 Janusz Dobrowolski
314 + Table of measure moved into new table item_units
315 ! Removed $themes[] from config.php, theme list based on directory structure
317 /includes/ui/ui_lists.inc
318 /applications/inventory.php
319 /inventory/includes/inventory_db.inc
320 /inventory/includes/db/items_units_db.inc
321 /inventory/manage/item_units.php
322 /inventory/manage/items.php
326 # Small fix for alignment of date and due date label fields in customer_invoice.php and customer_delivery.php
327 $ /sales/customer_invoice.php
328 /sales/customer_delivery.php
331 # Small fix for Template Invoice in sales_order_entry.php on line 363 (duedate for Invoice).
332 $ /sales/sales_order_entry.php
334 10-Mar-2008 Janusz Dobrowolski
335 + Added price list selector to sales entry (debtor_master gives only default one)
336 + Added optional submit_on_change parameter to sales ui lists
337 $ /includes/ui/ui_lists.inc
338 /sales/sales_order_entry.php
339 /sales/includes/ui/sales_credit_ui.inc
340 /sales/includes/ui/sales_order_ui.inc
341 # Additional PHP5 fixes, do_clone superseded by local ? : constructs
342 $ /sales/includes/cart_class.inc
343 /includes/ui/ui_view.inc
344 /sales/includes/sales_db.inc
345 # Fixed bogus sales_type lists in edition mode
346 $ /sales/customer_delivery.php
347 /sales/customer_invoice.php
348 # Smaller fixes, cart_class.sales_type name change
349 $ /sales/includes/ui/sales_credit_db.inc
350 /sales/credit_note_entry.php
351 /sales/customer_credit_invoice.php
352 /sales/includes/cart_class.inc
353 /sales/includes/db/sales_credit_db.inc
354 /sales/includes/db/sales_delivery_db.inc
355 /sales/includes/db/sales_invoice_db.inc
356 /sales/includes/db/sales_order_db.inc
357 /sales/includes/ui/sales_credit_ui.inc
358 # One another pmWiki name conflict removed
359 $ /admin/display_prefs.php
362 - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
363 $ /dimensions/includes/dimensions_db.inc
364 /gl/includes/db/gl_db_banking.inc
366 /inventory/includes/db/items_adjust_db.inc
367 /manufacturing/includes/db/work_order_issues_db.inc
368 /manufacturing/includes/db/work_order_produce_items_db.inc
369 /manufacturing/includes/db/work_orders_db.inc
370 /manufacturing/includes/db/work_orders_quick_db.inc
371 /purchasing/includes/db/grn_db.inc
372 /purchasing/includes/db/po_db.inc
373 /purchasing/includes/db/supp_payment_db.inc
374 /reporting/includes/form_types.inc (File removed)
375 /sales/includes/db/sales_delivery_db.inc
376 /sales/includes/db/sales_invoice_db.inc
377 /sales/includes/db/sales_order_db.inc
379 # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
380 $ /reporting/rep101.php
381 /reporting/rep201.php
382 # clone replacement do_clone() for both PHP 4 and PHP 5.
383 $ /includes/ui/ui_view.inc (at the very bottom)
384 /sales/includes/cart_class.inc
386 07-Mar-2008 Janusz Dobrowolski
387 ! Changed name tax type uniqueness constraint to (name, rate)
388 $ /includes/ui/ui_lists.inc
389 /taxes/items_tax_types.php
390 ! Tax included option moved from tax_group to sales_types table
391 $ includes/ui/ui_view.inc
392 /purchasing/includes/ui/invoice_ui.inc
394 /taxes/tax_groups.php
395 /taxes/db/tax_groups_db.inc
397 # Final rewriting of sales module, a lot of bugfixes.
398 + Template delivery/invoicing
399 + Concurrent document editing control on sql level
400 + Most of sales documents are now editable
401 + Some links to print documents after entry
402 ! Changed javascript helper function for customer allocations
403 $ /applications/customers.php
404 /includes/ui/ui_input.inc
405 /reporting/rep107.php
406 /reporting/rep109.php
407 /reporting/rep110.php
408 /sales/credit_note_entry.php
409 /sales/customer_credit_invoice.php
410 /sales/customer_delivery.php
411 /sales/customer_invoice.php
412 /sales/customer_payments.php
413 /sales/sales_order_entry.php
414 /sales/allocations/customer_allocate.php
415 /sales/allocations/customer_allocation_main.php
416 /sales/includes/cart_class.inc
417 /sales/includes/sales_db.inc
418 /sales/includes/sales_ui.inc
419 /sales/includes/db/cust_trans_db.inc
420 /sales/includes/db/cust_trans_details_db.inc
421 /sales/includes/db/custalloc_db.inc
422 /sales/includes/db/customers_db.inc
423 /sales/includes/db/payment_db.inc
424 /sales/includes/db/sales_credit_db.inc
425 /sales/includes/db/sales_delivery_db.inc
426 /sales/includes/db/sales_invoice_db.inc
427 /sales/includes/db/sales_order_db.inc
428 /sales/includes/db/sales_types_db.inc
429 /sales/includes/ui/print_invoice.inc
430 /sales/includes/ui/sales_credit_ui.inc
431 /sales/includes/ui/sales_order_ui.inc
432 /sales/inquiry/customer_allocation_inquiry.php
433 /sales/inquiry/customer_inquiry.php
434 /sales/inquiry/sales_deliveries_view.php
435 /sales/inquiry/sales_orders_view.php
436 /sales/manage/credit_status.php
437 /sales/manage/sales_types.php
438 /sales/view/view_credit.php
439 /sales/view/view_dispatch.php
440 /sales/view/view_invoice.php
441 /sales/view/view_receipt.php
442 /sales/view/view_sales_order.php
443 # Removed function name conflict with wiki help system
444 /includes/lang/language.php
446 06-Mar-2008 Janusz Dobrowolski
447 + Wiki help links integration
449 /includes/page/header.inc
450 /includes/lang/language.php
451 + Optional debuging with xdebug module
453 /includes/db/connect_db.inc
454 ! Concurrent edition fix
455 $ /includes/systypes.inc
457 $ /manufacturing/manage/bom_edit.php
459 $ /themes/aqua/renderer.php
460 /themes/cool/renderer.php
461 /themes/default/renderer.php
462 # Removed warning about nonexistent $_GET variable
463 $ /dimensions/inquiry/search_dimensions.php
464 # MySQL 3.xx CAST bug fix
465 $ /includes/db/manufacturing_db.inc
466 /manufacturing/includes/db/work_order_requirements_db.inc
467 /manufacturing/inquiry/where_used_inquiry.php
470 ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
471 Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
472 $ /inventory/cost_update.php
473 /purchasing/includes/db/grn_db.inc and
474 /manufacturing/manage/bom_edit.php.
475 /manufacturing/includes/db/work_orders_db.inc
476 /manufacturing/includes/db/work_orders_quick_db.inc
477 /manufacturing/work_order_entry.php
480 + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
481 $ /admin/view_print_transaction.php
482 /applications/setup.php
485 ! Minor change in menu and function in view_print_transaction.php
486 $ /admin/view_print_transaction.php
487 /application/setup.php
488 + Preparing for print of single documents
489 $ /reporting/includes/reporting.inc
490 ! Removing 'out' field in table tax_types
493 /taxes/db/tax_types_db.inc
494 + Added 2 functions in ui_input.inc, button and button_cell
495 /includes/ui/ui_input.inc
498 + Added file, update_db.php, for updating company databases from an SQL script.
499 $ update_db.php (New file)
503 + Added Report, Salesman Listing, rep106.php.
504 $ /reporting/reports_main.php
505 /reporting/rep106.php
507 06-Feb-2008 Janusz Dobrowolski
508 + Separation of customer invoice issue and goods delivery.
509 + Batch invoicing for more than one delivery
510 # Corrected inadequate shipping tax calculations.
511 ! Default debugging status changed to off.
512 $ /taxes/tax_calc.inc
513 /taxes/db/tax_groups_db.inc
514 /admin/db/voiding_db.inc
515 /applications/customers.php
516 /includes/systypes.inc
518 /includes/ui/ui_controls.inc
519 /includes/ui/ui_lists.inc
520 /includes/ui/ui_view.inc
521 /inventory/inquiry/stock_status.php
522 /reporting/rep105.php
523 /reporting/rep107.php
524 /reporting/rep109.php
525 /reporting/rep110.php
526 /reporting/rep209.php
527 /reporting/reports_main.php
528 /reporting/includes/doctext.inc
529 /reporting/includes/doctext2.inc
530 /reporting/includes/form_types.inc
531 /reporting/includes/pdf_report.inc
532 /reporting/includes/reports_classes.inc
533 /sales/customer_credit_invoice.php
534 /sales/customer_invoice.php
535 /sales/sales_order_entry.php
536 /sales/customer_delivery.php
537 /sales/includes/db/sales_delivery_db.inc
538 /sales/includes/ui/print_invoice.inc
539 /sales/includes/cart_class.inc
540 /sales/includes/sales_db.inc
541 /sales/includes/db/cust_trans_db.inc
542 /sales/includes/db/cust_trans_details_db.inc
543 /sales/includes/db/sales_credit_db.inc
544 /sales/includes/db/sales_invoice_db.inc
545 /sales/includes/db/sales_order_db.inc
546 /sales/includes/ui/sales_order_ui.inc
547 /sales/inquiry/customer_allocation_inquiry.php
548 /sales/inquiry/customer_inquiry.php
549 /sales/inquiry/sales_orders_view.php
550 /sales/inquiry/sales_deliveries_view.php
551 /sales/view/view_dispatch.php
552 /sales/view/view_invoice.php
553 /sales/view/view_sales_order.php
558 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
559 $ /sales/includes/cart_class.inc
560 /sales/includes/db/sales_credit_db.inc
561 /sales/includes/db/sales_invoice_db.inc
562 /sales/includes/db/sales_order_db.inc
563 /sales/includes/db/cust_trans_details_db.inc
564 /sales/includes/ui/sales_order_ui.inc
565 /sales/includes/ui/sales_credit_ui.inc
566 /sales/credit_note_entry.php
567 /sales/customer_credit_invoice.php
568 /sales/sales_order_entry.php
569 /sales/customer_invoice.php
572 ! New Release 2.0 Pre Alpha
574 # Fixed a release 2 related bug in create_coy.php
575 $ /admin/create_coy.php
576 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
577 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
578 with these databases changes without any new files. They are coming as soon as possible.
579 $ /sql/alter.sql (New file)
580 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
582 $ /purchasing/supplier_trans_gl.php
583 /purchasing/includes/db/invoice_items_db.inc
584 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
585 $ /includes/ui/ui_lists.inc
586 /purchasing/includes/ui/po_ui.inc
587 /sales/includes/ui/sales_order_ui.inc
588 /admin/company_preferences.php
589 /admin/db/company_db.inc
591 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
592 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
593 $ /sales/manage/sales_people.php
594 /includes/ui/ui_input.inc
596 -------------------- 2,0 Pre Alpha - above ----------------------------
597 31-Jan-2008 Janusz Dobrowolski
598 # Minor bugfix in db_import()
599 $ /admin/db/maintenance_db.inc
601 30-Jan-2008 Janusz Dobrowolski
602 # Minor display fix in tax_types.php
603 $ /taxes/tax_types.php
604 ! Format cleanup on some files.
605 $ /gl/includes/gl_db.inc
606 /gl/includes/gl_ui.inc
607 /applications/application.php
611 -------------------- 1.16 Stable Released ----------------------
613 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
614 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
615 and $no_supplier_list. Default is the normal behavior for all listboxes.
616 $ /includes/ui/ui_lists.inc
617 /sales/includes/ui/sales_orders_ui.inc
618 /purchases/includes/ui/po_ui.inc
619 /themes/default/images/locate.png (New file)
622 + Added ALTER TABLE possibility in db_import. For future releases.
623 $ /admin/db/maintenence_db.inc
625 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
626 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
627 $ /includes/db/connect_db.inc
628 /includes/ui/ui_lists.inc
629 /includes/page/header.inc
633 # When login screen is displayed after session timeout page content is broken. It
634 is because of NOT using absolute paths in href attribute theme elements.
638 # Minor adjustments in function db_export on line 325
639 $ /admin/db/maintenance_db.inc
642 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
645 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
646 Also fixed a unneccessary str_replace when importing sql scripts.
647 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
648 $ /admin/db/maintenance_db.inc
649 /reporting/includes/pdf_report.inc
652 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
653 $ /gl/inquiry/gl_trial_balance.php
654 /gl/inquiry/gl_account_inquiry.php
657 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
658 $ /admin/db/voiding_db.inc
661 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
663 /gl/includes/ui/gl_payment_ui.inc
665 ! Changed $loc_notification to be set to 0 instead of 1.
668 -------------------- 1.15 Stable Released ----------------------
670 + Added email notification to stock location when available stock is below reorder level
672 /sales/includes/db/sales_order_db.inc
674 # Fixed bugs in Open balances when account is not a balance account
675 $ /gl/inquiry/gl_trial_balance.php
676 /gl/inquiry/gl_account_inquiry.php
677 /reporting/rep704.php
678 /reporting/rep708.php
680 -------------------- 1.14 Stable Released ----------------------
682 ! Major change in the installation of modules to also accept an SQL-file for upload.
684 /admin/inst_module.php
685 /admin/db/maintenance_db.inc
688 # The following files were still vulnerable. Fixed
690 /includes/lang/language.php
692 -------------------- 1.13 Stable Released ----------------------
694 + Added optional link for electronic payment on invoices (PayPal).
695 ! Better support for install/update languages.
697 # Fixed a vulnerable item in config.php
701 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
702 # config.php has been vulnerable. Fixed.
703 $ /admin/inst_lang.php
707 ! Changed Bank Address field from text to textarea (multirows)
708 $ /gl/manage/bank_accounts.php
711 + Added optional link for electronic payment on invoices (PayPal)
712 $ /reporting/reports_main.php
713 /reporting/rep107.php
714 /reporting/includes/report_classes.inc
715 /reporting/includes/pdf_report.inc
716 /reporting/includes/doc_text.inc
717 /reporting/includes/doc_text2.inc
720 # Unnecessary parameter ($db) in check_for_recursive_bom
721 $ /manufacturing/manage/bom_edit.php
724 # Bug in /includes/lang/gettext.php (249) affecting changing language!
725 $ /includes/lang/gettext.php
731 /admin/create_coy.php
732 /reporting/includes/pdf_report.inc
735 + Added a default fiscal year in the en_US-new.sql and start references.
737 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
738 $ /lang/en_US/LC_MESSAGES/en_US.mo
741 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
742 $ /sales/includes/db/sales_order_db.inc
745 # Changed <? in front of 2 files to <?php.
746 $ /purchasing/includes/purchasing_ui.inc
747 /reporting/includes/class.mail.inc
749 -------------------- 1.12 Stable Released ----------------------
751 + Added option to handle Jalali and Islamic Calendars
754 /gl/includes/db/gl_db_trans.inc
755 /includes/date_functions.inc
756 /includes/ui/ui_input.inc
757 /includes/ui/ui_lists.inc
758 /includes/ui/ui_view.inc
759 /purchasing/po_receive_items.php
760 /purchasing/includes/ui/invoice_ui.inc
761 /purchasing/includes/ui/po_ui.inc
762 /reporting/rep705.php
763 /sales/includes/db/sales_order_db.inc
764 /sales/includes/ui/sales_order_ui.inc
767 ! Changed parameters on report Sales Order. Option to print as Quote.
768 $ /reporting/reports_main.php
769 /reporting/rep109.php
770 /reporting/includes/pdf_report.inc
771 /reporting/includes/doctext.inc
772 /reporting/includes/doctext2.inc
775 + Added Budget Entry in General Ledger. Includes Dimensions.
777 /applications/generalledger.php
778 /gl/gl_budget.php (New File!)
779 /gl/includes/db/gl_db_trans.inc
780 /includes/date_functions.inc
781 /reporting/report_classes.inc
783 -------------------- 1.11 Stable Released ----------------------
785 ! Option for using alpha numeric chart of accounts.
787 /gl/manage/gl_accounts.php
788 /gl/includes/db/gl_db_accounts.inc
789 /gl/includes/db/gl_db_bank_trans.inc
790 /gl/includes/db/gl_db_trans.inc
791 /gl/inquiry/gl_trial_balance.inc
792 /admin/db/company_db.inc
793 /inventory/includes/db/items_db.inc
794 /sales/manage/customer_branches.inc
797 # Problems retrieving language texts for poEdit in long javascripts
798 $ /includes/ui/ui_view.inc
801 # Database error when updating more than one item row in Sales Orders.
802 $ /sales/includes/db/sales_order_db.inc
803 # Database error when inserting work order issues. Fixed.
804 $ /manufacturing/includes/db/work_order_issues_db.inc
807 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
808 $ /includes/db/manufacturing_db.inc
809 /manufacturing/includes/db/work_order_requirements_db.inc
812 # Missing details on Purchase Order when emailing and printing
813 $ /reporting/rep209.php
815 -------------------- 1.1 Stable Released ----------------------
817 + Enabled module addons and all the below bugfixes. No changes in database structure.
818 - Removed /sql/basic.sql (included in the other sql files)
819 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
820 (not needed anymore).
821 + Addition of update.html
822 $ /admin/inst_module.php (New file!)
823 /applications/customers.php
824 /applications/dimensions.php
825 /applications/generalledger.php
826 /applications/inventory.php
827 /applications/manufacturing.php
828 /applications/setup.php
829 /applications/suppliers.php
832 /modules/inst_modules.php (New folder and new file!)
833 /modules/index.php (New file!)
837 update.html (New file!)
840 # Missing measure of units when printing sales orders
841 # Update of Sales People caused a database error
842 $ /sales/manage/sales_people.php
843 /reporting/rep109.php
846 + The selected menu tab is now shown with same background as hover color.
847 $ config.php (default tab line 77. Change if you want)
848 /includes/page/header.inc
851 # When saving work order entries a lot of debug boxes appeared. Fixed
852 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
853 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
854 $ /includes/db/manufacturing_db.inc
855 /manufacturing/work_order_entry.php
856 /manufacturing/includes/work_order_issue_ui.inc
857 /manufacturing/includes/db/work_order_requirements_db.inc
858 /manufacturing/includes/db/work_orders_quick_db.inc
859 /manufacturing/inquiry/where_used_inquiry.php
862 # Missing Date Picker
863 $ /sales/customer_invoice.php
865 $ /sales/view/view_invoice.php
868 ! New and better Date Picker, better cool theme.
869 $ /includes/ui/ui_input.inc
870 /includes/ui/ui_view.inc
871 /reporting/includes/reports_classes.inc
872 /themes/cool/default.css
874 -------------------- 1.0.1 Stable Released ----------------------
876 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
877 the changes for selection lists customers/suppliers and the Audit Trail.
880 ! Changed the two selection lists for customers/suppliers in reports to a single one with
882 ! Changed the sort order in these selection lists from id to name.
883 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
884 $ /reporting/reports_main.php
885 /reporting/rep101.php
886 /reporting/rep102.php
887 /reporting/rep201.php
888 /reporting/rep202.php
889 /reporting/rep203.php
890 /reporting/rep204.php
891 /reporting/includes/reports_classes.inc
892 /includes/ui/ui_lists.inc
893 /gl/includes/db/gl_db_trans.inc
897 + Date Picker for all date fields.
899 /admin/fiscalyears.php
900 /admin/void_transaction.php
901 /includes/ui/ui_view.inc
902 /includes/ui/ui_input.inc
903 /dimensions/dimension_entry.php
904 /dimensions/inquiry/search_dimensions.php
908 /gl/bank_transfer.php
909 /gl/inquiry/bank_inquiry.php
910 /gl/inquiry/gl_account_inquiry.php
911 /gl/inquiry/gl_trial_balance.php
912 /gl/manage/exchange_rates.php
913 /inventory/adjustments.php
914 /inventory/transfers.php
915 /inventory/inquiry/stock_movements.php
916 /inventory/manage/items.php
917 /manufacturing/work_order_add_finished.php
918 /manufacturing/work_order_entry.php
919 /manufacturing/work_order_issue.php
920 /manufacturing/work_order_release.php
921 /purchasing/supplier_payment.php
922 /purchasing/po_entry_items.php
923 /purchasing/po_receive_items.php
924 /purchasing/supplier_credit.php
925 /purchasing/supplier_credit_grns.php
926 /purchasing/supplier_invoice.php
927 /purchasing/supplier_invoice_grns.php
928 /purchasing/supplier_trans_gl.php
929 /purchasing/includes/ui/po_ui.inc
930 /purchasing/inquity/po_search.php
931 /purchasing/inquiry/po_search_completed.php
932 /purchasing/inquiry/supplier_allocation_inquiry.php
933 /purchasing/inquiry/supplier_inquiry.php
934 /reporting/reports_main.php
935 /reporting/includes/reports_classes.inc
936 /sales/credit_note_entry.php
937 /sales/customer_credit_invoice.php
938 /sales/customer_payments.php
939 /sales/sales_order_entry.php
940 /sales/includes/ui/sales_order_ui.inc
941 /sales/inquiry/customer_allocation_inquiry.php
942 /sales/inquiry/customer_inquiry.php
943 /sales/inquiry/sales_orders_view.php
945 /themes/default/images/cal.gif
946 /themes/default/images/next.gif
947 /themes/default/images/prev.gif
950 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
951 # Bug no 1703891, Reserved MySQL words used as column names, fixed
952 $ /taxes/db/tax_types_db.inc
954 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
955 $ /gl/manage/gl_accounts.php
956 /gl/includes/db/gl_db_accounts.inc
957 /includes/ui/ui_input.inc
960 # Bug no 1702594, Logon Loop, fixed
963 -------------------- 1.0a Stable Released ----------------------
965 ! Release 1.0a established on SourceForge, fixing the bugs.
968 # Bug No 1698214, Creating Items, fixed
969 $ /includes/ui/ui_lists.inc
970 # Bug no 1698216, Item Movements, fixed
971 $ /inventory/manage/items.php
973 -------------------- 1.0 Stable Released ----------------------
975 ! Release 1.0 established on SourceForge.
977 2. Copyright and disclaimer
978 ---------------------------
979 This application is opensource software released under the GPL. Please
980 see source code and the LICENSE file