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 ! Removed the content of function header2 in pdf_report.inc to a separate file, header2.inc.
24 It will make it easier to design your own document layouts.
25 $ /reporting/includes/pdf_report.inc
26 /reporting/includes/header2.inc (new file)
28 20-Apr-2008 Janusz Dobrowolski
29 # Checking uniqueness of company settings, fixed creating database with prefix 0 when none was selected.
30 $ /admin/create_coy.php
31 ! Added missing include_once directives.
32 $ /includes/ui/items_cart.inc
33 /includes/ui/ui_lists.inc
34 /includes/ui/ui_view.inc
35 + Added ini default_charset unnecessary for planned ajax calls.
36 $ /includes/lang/language.inc
39 # Bug (right to left text was done if price decimals were 3). A test sentense from a while
41 $ /reporting/includes/pdf_report.inc
43 18-Apr-2008 Janusz Dobrowolski
44 # Additional checks on provisions and break point entry.
45 $ /sales/manage/sales_people.php
46 ! Modules purchasing, sales and taxes sealed against XSS attacks
48 /admin/db/maintenance_db.inc
49 /purchasing/includes/db/grn_db.inc
50 /purchasing/includes/db/invoice_items_db.inc
51 /purchasing/includes/db/po_db.inc
52 /purchasing/includes/db/supp_trans_db.inc
53 /purchasing/manage/suppliers.php
54 /sales/includes/db/credit_status_db.inc
55 /sales/includes/db/cust_trans_db.inc
56 /sales/includes/db/cust_trans_details_db.inc
57 /sales/includes/db/sales_order_db.inc
58 /sales/includes/db/sales_types_db.inc
59 /sales/manage/customer_branches.php
60 /sales/manage/customers.php
61 /sales/manage/sales_areas.php
62 /sales/manage/sales_people.php
63 /taxes/db/item_tax_types_db.inc
64 /taxes/db/tax_groups_db.inc
65 /taxes/db/tax_types_db.inc
68 ! Module gl sealed against XSS Attacks
69 $ /gl/includes/db/gl_db_accounts.inc
70 /gl/includes/db/gl_db_account_types.inc
71 /gl/includes/db/gl_db_bank_accounts.inc
72 /gl/includes/db/gl_db_bank_trans.inc
73 /gl/includes/db/gl_db_bank_trans_types.inc
74 /gl/includes/db/gl_db_currencies.inc
75 /gl/includes/db/gl_db_trans.inc
77 18-Apr-2008 Janusz Dobrowolski
78 ! Modules admin and dimensions sealed against XSS attacks
79 $ /admin/payment_terms.php
80 /admin/shipping_companies.php
81 /admin/db/company_db.inc
82 /admin/db/maintenance_db.inc
83 /admin/db/users_db.inc
84 /admin/db/voiding_db.inc
85 /dimensions/includes/dimensions_db.inc
88 ! Modules includes, inventory and manufacturing sealed against XSS attacks
89 $ /includes/db/comments_db.inc
90 /includes/db/inventory_db.inc
91 /includes/db/references_db.inc
92 /inventory/includes/db/items_category_db.inc
93 /inventory/includes/db/items_db.inc
94 /inventory/includes/db/items_locations_db.inc
95 /inventory/includes/db/items_units_db.inc
96 /inventory/includes/db/movement_types_db.inc
97 /manufacturing/includes/db/work_centres_db.inc
98 /manufacturing/includes/db/work_orders_db.inc
99 /manufacturing/includes/db/work_orders_quick_db.inc
100 /manufacturing/includes/db/work_order_issues_db.inc
101 /manufacturing/includes/db/work_order_produce_items_db.inc
103 18-Apr-2008 Janusz Dobrowolski
104 ! Changed db_escape function to avoid XSS attacks via js db injection
105 $ /includes/db/connect_db.inc
106 # Database inserts/updates secured against js injection
107 $ /admin/db/maintenance_db.inc
108 /gl/includes/db/gl_db_accounts.inc
109 /purchasing/includes/db/po_db.inc
110 /sales/sales_order_entry.php
111 /sales/includes/db/sales_order_db.inc
114 # Bug in /includes/ui/ui_lists.inc:914. Sql clause was cut.
115 $ /includes/ui/ui_lists.inc
117 09-Apr-2008 Janusz Dobrowolski
118 # Fixed number formatting bug in standard cost update.
119 $ /inventory/cost_update.php
121 -------------------- 2,0 Beta - released ----------------------------
124 ! Changed install.html and update.html to fit the new unstable release 2.0
125 ! Changed demo sql script to fit the 2.0 unstable.
130 06-Apr-2008 Janusz Dobrowolski
131 # Sales invoice edition denied for documents created in FA 1.xx because of nonportable differences in gl posting/db schema.
132 /sales/customer_invoice.php
133 # Fixed typo causing error while adding new tax type.
137 # Fixed a bug when creating subfolder for new companies. Should be company id and not the table pref counter.
138 $ /admin/create_coy.php
141 # Removed annoying warnings in several reports.
143 /reporting/rep102.php
144 /reporting/rep104.php
145 /reporting/rep201.php
146 /reporting/rep203.php
147 /reporting/rep705.php
148 /reporting/rep706.php
149 /reporting/rep707.php
150 /reporting/rep709.php
151 /reporting/reports_main.php
152 /reporting/includes/pdf_report.inc
154 04-Apr-2008 Janusz Dobrowolski
155 # Javascript bugfix in selecting orders for template.
156 $ /sales/inquiry/sales_orders_view.php
159 ! Updated chart of accounts for release 2.0 unstable. Set the status to 2.0 Beta in config.php. Minor changes in update.html
160 + Preparing for download of release 2.0b on SourceForge.
166 02-Apr-2008 Janusz Dobrowolski
167 # Removed selector expansion on space key for multi-line selectors
169 ! Hiding search button in combo selectors for javascript enabled browsers
170 $ /includes/ui/ui_lists.inc
172 + Focus set to invalid form field after submit check fail
173 $ /admin/company_preferences.php
174 /admin/fiscalyears.php
176 /admin/payment_terms.php
177 /admin/shipping_companies.php
179 /admin/void_transaction.php
180 /dimensions/dimension_entry.php
181 /gl/bank_transfer.php
185 /gl/manage/bank_accounts.php
186 /gl/manage/bank_trans_types.php
187 /gl/manage/currencies.php
188 /gl/manage/exchange_rates.php
189 /gl/manage/gl_account_classes.php
190 /gl/manage/gl_account_types.php
191 /gl/manage/gl_accounts.php
192 /inventory/adjustments.php
193 /inventory/cost_update.php
194 /inventory/prices.php
195 /inventory/purchasing_data.php
196 /inventory/transfers.php
197 /inventory/manage/item_categories.php
198 /inventory/manage/item_units.php
199 /inventory/manage/items.php
200 /inventory/manage/locations.php
201 /inventory/manage/movement_types.php
202 /manufacturing/work_order_add_finished.php
203 /manufacturing/work_order_entry.php
204 /manufacturing/work_order_issue.php
205 /manufacturing/work_order_release.php
206 /manufacturing/manage/bom_edit.php
207 /manufacturing/manage/work_centres.php
208 /purchasing/po_entry_items.php
209 /purchasing/po_receive_items.php
210 /purchasing/supplier_credit.php
211 /purchasing/supplier_credit_grns.php
212 /purchasing/supplier_invoice.php
213 /purchasing/supplier_invoice_grns.php
214 /purchasing/supplier_payment.php
215 /purchasing/supplier_trans_gl.php
216 /purchasing/allocations/supplier_allocate.php
217 /purchasing/manage/suppliers.php
218 /sales/credit_note_entry.php
219 /sales/customer_credit_invoice.php
220 /sales/customer_delivery.php
221 /sales/customer_invoice.php
222 /sales/customer_payments.php
223 /sales/sales_order_entry.php
224 /sales/allocations/customer_allocate.php
225 /taxes/item_tax_types.php
226 /taxes/tax_groups.php
228 # Set default focus in update_db.php
231 29-Mar-2008 Janusz Dobrowolski
232 # Changed gl_all_accounts_list() API
233 $ /includes/ui/ui_lists.inc
234 + Enhanced list accessability in kbd usage via space key
237 28-Mar-2008 Janusz Dobrowolski
238 # Fixed headers for various display mode
239 $ /sales/inquiry/sales_orders_view.php
242 + Added print document options in inquiries.
243 $ /sales/inquiry/customer_inquiry.php
244 /sales/inquiry/sales_orders_view.php
245 /sales/inquiry/sales_deliveries_view.php
246 /purchasing/inquiry/po_search.php
247 /purchasing/inquiry/po_search_completed.php
250 # Fixed a minor bug in customers_db.inc (should include type == 2 - Bank Deposits)
251 $ /sales/includes/db/customers_db.inc
252 # Fixed a PHP vers. 5.xx bug. No need for & operator in function calls, only in declaration. Gives a warning.
253 $ /sales/includes/db/sales_credit_db.inc
254 # Fixed a wrong variabel declaration doc_Document_no to doc_Invoice_no
255 $ /reporting/includes/doctext.inc
256 /reporting/includes/doctext2.inc
257 # Fixed so Customer Balances and Aged Customer Analysis reports presents correct sign.
258 $ /reporting/rep101.php
259 /reporting/rep102.php
261 28-Mar-2008 Janusz Dobrowolski
262 # Layout/focus fixes for no_[customer/supplier/item]_list option on
263 $ /includes/ui/ui_lists.inc
264 /purchasing/includes/ui/po_ui.inc
265 /sales/credit_note_entry.php
266 /sales/sales_order_entry.php
267 /sales/includes/ui/sales_credit_ui.inc
268 /sales/includes/ui/sales_order_ui.inc
270 27-Mar-2008 Janusz Dobrowolski
271 + Automatic first field focus on page start, focus order preserved between form updates
272 $ /gl/inquiry/gl_account_inquiry.php
273 /includes/page/footer.inc
274 /includes/ui/ui_controls.inc
275 /includes/ui/ui_input.inc
276 /includes/ui/ui_lists.inc
277 /includes/ui/ui_view.inc
279 /sales/sales_order_entry.php
280 /sales/credit_note_entry.php
281 /sales/includes/ui/sales_credit_ui.inc
282 /sales/includes/ui/sales_order_ui.inc
283 + Data picker omitted in keyboard tabbing sequence (FF,IE, not old mozilla)
284 $ /includes/ui/ui_input.inc
285 ! Javascript recalcAccount() superseded by class='combo' behaviour binding
289 /gl/includes/ui/gl_deposit_ui.inc
290 /gl/includes/ui/gl_journal_ui.inc
291 /gl/includes/ui/gl_payment_ui.inc
292 /includes/ui/ui_view.inc
293 /purchasing/po_entry_items.php
294 /purchasing/includes/ui/po_ui.inc
295 /sales/sales_order_entry.php
296 /sales/includes/ui/sales_credit_ui.inc
297 /sales/includes/ui/sales_order_ui.inc
299 ! get_js_set_focus moved from ui_view (this is only standalone form).
301 # Fixed debit/credit entry check
303 # Restored GET/POST security check on path_to_root
306 26-Mar-2008 Janusz Dobrowolski
307 # Bug fixes in purchase module related to tax structure changes.
308 $ /purchasing/includes/supp_trans_class.inc
309 /purchasing/includes/db/invoice_db.inc
310 /purchasing/includes/db/invoice_items_db.inc
311 /purchasing/includes/ui/invoice_ui.inc
312 /reporting/rep105.php
314 25-Mar-2008 Janusz Dobrowolski
315 ! Per company pdf, backup and graphics directories in 'company' dir.
318 /company/0/images/ (new dir)
319 /company/0/images/102.jpg (moved from inventory/manage/image)
320 /company/0/images/103.jpg (moved from inventory/manage/image)
321 /company/0/images/104.jpg (moved from inventory/manage/image)
322 /company/0/images/logo_frontaccounting.jpg (moved from themes/default/images)
323 /company/0/images/logo_frontaccounting.png (moved from themes/default/images)
325 /admin/create_coy.php
326 /admin/db/maintenance_db.inc
328 /reporting/rep102.php
329 /reporting/rep104.php
330 /reporting/rep202.php
331 /reporting/rep303.php
332 /reporting/rep706.php
333 /reporting/rep707.php
334 /reporting/includes/pdf_report.inc
335 /inventory/manage/items.php
337 + jscript component caching (enables browser caching and future compression)
338 $ /includes/session.inc
340 /includes/page/header.inc
341 /includes/ui/ui_view.inc
342 /admin/display_prefs.php
345 - Removed obsolete file
346 $ /sales/includes/ui/print_invoice.inc
348 21-Mar-2008 Janusz Dobrowolski
349 ! Total Allocation/Left to Allocate update without page submit.
350 $ /includes/ui/ui_view.inc
351 /purchasing/allocations/supplier_allocate.php
352 /sales/allocations/customer_allocate.php
353 # Fixed unvisable under IE editbutton
354 $ /themes/aqua/default.css
355 /themes/cool/default.css
356 /themes/default/default.css
358 20-Mar-2008 Janusz Dobrowolski
359 # Excluding delivery notes from Customer Balances, removed warnings.
360 $ /reporting/rep101.php
361 # Divide by zero fix on order_price==0 in new supplier invoice
362 $ /purchasing/supplier_invoice_grns.php
363 # Database bug fix in new customer entry
364 $ /sales/manage/customers.php
365 # Small bug fix (warnings) in is_date() function.
366 $ /includes/date_functions.inc
368 18-Mar-2008 Janusz Dobrowolski
369 # Line items editor uses POST method - no disappearing shippment info.
370 $ /sales/credit_note_entry.php
371 /sales/sales_order_entry.php
372 /sales/includes/ui/sales_credit_ui.inc
373 /sales/includes/ui/sales_order_ui.inc
374 + Added edit_button_cell() function
375 $ /includes/ui/ui_controls.inc
376 + Helper function for finding indexed submit $_POST vars.
377 $ /includes/ui/ui_input.inc
378 + New class .editbutton for buttons. Default view is link alike.
379 $ /themes/aqua/default.css
380 /themes/cool/default.css
381 /themes/default/default.css
383 17-Mar-2008 Janusz Dobrowolski
384 # Added rounding when needed to avoid document non cosistent documents.
385 $ /includes/banking.inc
386 /purchasing/supplier_credit_grns.php
387 /purchasing/supplier_invoice_grns.php
388 /purchasing/includes/supp_trans_class.inc
389 /purchasing/includes/ui/invoice_ui.inc
390 /purchasing/includes/ui/po_ui.inc
391 /reporting/rep107.php
392 /reporting/rep109.php
393 /reporting/rep110.php
394 /reporting/rep209.php
395 /sales/includes/cart_class.inc
396 /sales/includes/ui/sales_credit_ui.inc
397 /sales/includes/ui/sales_order_ui.inc
398 /sales/view/view_credit.php
399 /sales/view/view_dispatch.php
400 /sales/view/view_invoice.php
401 /sales/view/view_sales_order.php
403 # Sign bug for customer transactions
404 $ /reporting/rep709.php
405 # Include file conflict fix
406 $ /purchasing/includes/ui/invoice_ui.inc
407 /gl/manage/bank_accounts.php
408 /manufacturing/inquiry/where_used_inquiry.php
409 /purchasing/manage/suppliers.php
411 16-Mar-2008 Janusz Dobrowolski
412 + Added javascript add-on for unobtrusive apply javascript handlers to html elements.
415 + Added javascript source collecting functions
417 ! Moved check_page_security(); for safe start in case of broken wa_current_user var.
418 + Added global js code collecting arrays $js_lib, $js_static
419 $ /includes/session.inc
420 ! Changed get_js_user num to add_js_user_num; extended for percent/qty/price formatting
421 $ /includes/ui/ui_view.inc
422 + Added including javascript source colections from $js_lib, $js_static; conditional display for ajax calls
423 $ /includes/page/footer.inc
424 /includes/page/header.inc
425 ! Added including of data_checks.inc
427 + User side percent/exrate/qty/price input formatting via onblur handler.
428 $ /admin/gl_setup.php
430 /gl/manage/exchange_rates.php
431 /includes/ui/ui_input.inc
432 /inventory/purchasing_data.php
433 /inventory/reorder_level.php
434 /inventory/includes/item_adjustments_ui.inc
435 /inventory/includes/stock_transfers_ui.inc
436 /manufacturing/work_order_entry.php
437 /manufacturing/manage/bom_edit.php
438 /purchasing/po_entry_items.php
439 /purchasing/po_receive_items.php
440 /purchasing/supplier_credit.php
441 /purchasing/supplier_credit_grns.php
442 /purchasing/supplier_invoice_grns.php
443 /purchasing/supplier_trans_gl.php
444 /purchasing/allocations/supplier_allocate.php
445 /purchasing/includes/ui/po_ui.inc
446 /sales/customer_delivery.php
447 /sales/customer_invoice.php
448 /sales/allocations/customer_allocate.php
449 /sales/includes/ui/sales_credit_ui.inc
450 /sales/includes/ui/sales_order_ui.inc
451 /taxes/tax_groups.php
454 14-Mar-2008 Janusz Dobrowolski
455 + All forms fixed to accept user native numeric format.
456 $ /admin/gl_setup.php
457 /gl/bank_transfer.php
462 /gl/includes/db/gl_db_banking.inc
463 /gl/includes/ui/gl_deposit_ui.inc
464 /gl/includes/ui/gl_journal_ui.inc
465 /gl/includes/ui/gl_payment_ui.inc
466 /gl/manage/exchange_rates.php
467 /inventory/adjustments.php
468 /inventory/cost_update.php
469 /inventory/prices.php
470 /inventory/purchasing_data.php
471 /inventory/reorder_level.php
472 /inventory/transfers.php
473 /inventory/includes/item_adjustments_ui.inc
474 /inventory/includes/stock_transfers_ui.inc
475 /inventory/manage/item_units.php
476 /manufacturing/work_order_entry.php
477 /manufacturing/inquiry/where_used_inquiry.php
478 /manufacturing/manage/bom_edit.php
479 /purchasing/po_entry_items.php
480 /purchasing/po_receive_items.php
481 /purchasing/supplier_credit_grns.php
482 /purchasing/supplier_invoice_grns.php
483 /purchasing/supplier_payment.php
484 /purchasing/supplier_trans_gl.php
485 /purchasing/allocations/supplier_allocate.php
486 /purchasing/includes/ui/po_ui.inc
487 /purchasing/inquiry/po_search.php
488 /sales/credit_note_entry.php
489 /sales/customer_credit_invoice.php
490 /sales/customer_delivery.php
491 /sales/customer_invoice.php
492 /sales/customer_payments.php
493 /sales/sales_order_entry.php
494 /sales/allocations/customer_allocate.php
495 /sales/includes/ui/sales_credit_ui.inc
496 /sales/includes/ui/sales_order_ui.inc
497 /sales/manage/customers.php
498 /sales/manage/sales_people.php
499 /sales/view/view_credit.php
500 /sales/view/view_dispatch.php
501 /sales/view/view_invoice.php
502 /sales/view/view_receipt.php
503 /sales/view/view_sales_order.php
504 /taxes/item_tax_types.php
505 /taxes/tax_groups.php
507 + User format functions for percent/price/exrate amounts display.
508 $ /includes/current_user.inc
509 + Input checking functions for numeric input fields in user native format
510 $ /includes/data_checks.inc
511 + Numeric input fields in user native format
512 $ /includes/ui/ui_input.inc
513 + Javascript function for conversion to/from user native numeric format.
514 $ /includes/ui/ui_view.inc
515 + New class amount for numeric input
516 $ /themes/aqua/default.css
517 /themes/cool/default.css
518 /themes/default/default.css
519 # Removed warning on adding component
520 /manufacturing/manage/bom_edit.php
521 # Quantity display correction
522 /manufacturing/inquiry/where_used_inquiry.php
523 # Fixed add_customer_trans() call
524 /gl/includes/db/gl_db_banking.inc
527 + Added update of Units of Measure and converting of deptor_trans records from release 1.XX
528 - Removed default insertion of Units of Measure. Not neccessary.
530 /admin/db/maintenance_db.inc (added support for update)
532 11-Mar-2008 Janusz Dobrowolski
533 + Table of measure moved into new table item_units
534 ! Removed $themes[] from config.php, theme list based on directory structure
536 /includes/ui/ui_lists.inc
537 /applications/inventory.php
538 /inventory/includes/inventory_db.inc
539 /inventory/includes/db/items_units_db.inc
540 /inventory/manage/item_units.php
541 /inventory/manage/items.php
545 # Small fix for alignment of date and due date label fields in customer_invoice.php and customer_delivery.php
546 $ /sales/customer_invoice.php
547 /sales/customer_delivery.php
550 # Small fix for Template Invoice in sales_order_entry.php on line 363 (duedate for Invoice).
551 $ /sales/sales_order_entry.php
553 10-Mar-2008 Janusz Dobrowolski
554 + Added price list selector to sales entry (debtor_master gives only default one)
555 + Added optional submit_on_change parameter to sales ui lists
556 $ /includes/ui/ui_lists.inc
557 /sales/sales_order_entry.php
558 /sales/includes/ui/sales_credit_ui.inc
559 /sales/includes/ui/sales_order_ui.inc
560 # Additional PHP5 fixes, do_clone superseded by local ? : constructs
561 $ /sales/includes/cart_class.inc
562 /includes/ui/ui_view.inc
563 /sales/includes/sales_db.inc
564 # Fixed bogus sales_type lists in edition mode
565 $ /sales/customer_delivery.php
566 /sales/customer_invoice.php
567 # Smaller fixes, cart_class.sales_type name change
568 $ /sales/includes/ui/sales_credit_db.inc
569 /sales/credit_note_entry.php
570 /sales/customer_credit_invoice.php
571 /sales/includes/cart_class.inc
572 /sales/includes/db/sales_credit_db.inc
573 /sales/includes/db/sales_delivery_db.inc
574 /sales/includes/db/sales_invoice_db.inc
575 /sales/includes/db/sales_order_db.inc
576 /sales/includes/ui/sales_credit_ui.inc
577 # One another pmWiki name conflict removed
578 $ /admin/display_prefs.php
581 - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
582 $ /dimensions/includes/dimensions_db.inc
583 /gl/includes/db/gl_db_banking.inc
585 /inventory/includes/db/items_adjust_db.inc
586 /manufacturing/includes/db/work_order_issues_db.inc
587 /manufacturing/includes/db/work_order_produce_items_db.inc
588 /manufacturing/includes/db/work_orders_db.inc
589 /manufacturing/includes/db/work_orders_quick_db.inc
590 /purchasing/includes/db/grn_db.inc
591 /purchasing/includes/db/po_db.inc
592 /purchasing/includes/db/supp_payment_db.inc
593 /reporting/includes/form_types.inc (File removed)
594 /sales/includes/db/sales_delivery_db.inc
595 /sales/includes/db/sales_invoice_db.inc
596 /sales/includes/db/sales_order_db.inc
598 # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
599 $ /reporting/rep101.php
600 /reporting/rep201.php
601 # clone replacement do_clone() for both PHP 4 and PHP 5.
602 $ /includes/ui/ui_view.inc (at the very bottom)
603 /sales/includes/cart_class.inc
605 07-Mar-2008 Janusz Dobrowolski
606 ! Changed name tax type uniqueness constraint to (name, rate)
607 $ /includes/ui/ui_lists.inc
608 /taxes/items_tax_types.php
609 ! Tax included option moved from tax_group to sales_types table
610 $ includes/ui/ui_view.inc
611 /purchasing/includes/ui/invoice_ui.inc
613 /taxes/tax_groups.php
614 /taxes/db/tax_groups_db.inc
616 # Final rewriting of sales module, a lot of bugfixes.
617 + Template delivery/invoicing
618 + Concurrent document editing control on sql level
619 + Most of sales documents are now editable
620 + Some links to print documents after entry
621 ! Changed javascript helper function for customer allocations
622 $ /applications/customers.php
623 /includes/ui/ui_input.inc
624 /reporting/rep107.php
625 /reporting/rep109.php
626 /reporting/rep110.php
627 /sales/credit_note_entry.php
628 /sales/customer_credit_invoice.php
629 /sales/customer_delivery.php
630 /sales/customer_invoice.php
631 /sales/customer_payments.php
632 /sales/sales_order_entry.php
633 /sales/allocations/customer_allocate.php
634 /sales/allocations/customer_allocation_main.php
635 /sales/includes/cart_class.inc
636 /sales/includes/sales_db.inc
637 /sales/includes/sales_ui.inc
638 /sales/includes/db/cust_trans_db.inc
639 /sales/includes/db/cust_trans_details_db.inc
640 /sales/includes/db/custalloc_db.inc
641 /sales/includes/db/customers_db.inc
642 /sales/includes/db/payment_db.inc
643 /sales/includes/db/sales_credit_db.inc
644 /sales/includes/db/sales_delivery_db.inc
645 /sales/includes/db/sales_invoice_db.inc
646 /sales/includes/db/sales_order_db.inc
647 /sales/includes/db/sales_types_db.inc
648 /sales/includes/ui/print_invoice.inc
649 /sales/includes/ui/sales_credit_ui.inc
650 /sales/includes/ui/sales_order_ui.inc
651 /sales/inquiry/customer_allocation_inquiry.php
652 /sales/inquiry/customer_inquiry.php
653 /sales/inquiry/sales_deliveries_view.php
654 /sales/inquiry/sales_orders_view.php
655 /sales/manage/credit_status.php
656 /sales/manage/sales_types.php
657 /sales/view/view_credit.php
658 /sales/view/view_dispatch.php
659 /sales/view/view_invoice.php
660 /sales/view/view_receipt.php
661 /sales/view/view_sales_order.php
662 # Removed function name conflict with wiki help system
663 /includes/lang/language.php
665 06-Mar-2008 Janusz Dobrowolski
666 + Wiki help links integration
668 /includes/page/header.inc
669 /includes/lang/language.php
670 + Optional debuging with xdebug module
672 /includes/db/connect_db.inc
673 ! Concurrent edition fix
674 $ /includes/systypes.inc
676 $ /manufacturing/manage/bom_edit.php
678 $ /themes/aqua/renderer.php
679 /themes/cool/renderer.php
680 /themes/default/renderer.php
681 # Removed warning about nonexistent $_GET variable
682 $ /dimensions/inquiry/search_dimensions.php
683 # MySQL 3.xx CAST bug fix
684 $ /includes/db/manufacturing_db.inc
685 /manufacturing/includes/db/work_order_requirements_db.inc
686 /manufacturing/inquiry/where_used_inquiry.php
689 ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
690 Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
691 $ /inventory/cost_update.php
692 /purchasing/includes/db/grn_db.inc and
693 /manufacturing/manage/bom_edit.php.
694 /manufacturing/includes/db/work_orders_db.inc
695 /manufacturing/includes/db/work_orders_quick_db.inc
696 /manufacturing/work_order_entry.php
699 + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
700 $ /admin/view_print_transaction.php
701 /applications/setup.php
704 ! Minor change in menu and function in view_print_transaction.php
705 $ /admin/view_print_transaction.php
706 /application/setup.php
707 + Preparing for print of single documents
708 $ /reporting/includes/reporting.inc
709 ! Removing 'out' field in table tax_types
712 /taxes/db/tax_types_db.inc
713 + Added 2 functions in ui_input.inc, button and button_cell
714 /includes/ui/ui_input.inc
717 + Added file, update_db.php, for updating company databases from an SQL script.
718 $ update_db.php (New file)
722 + Added Report, Salesman Listing, rep106.php.
723 $ /reporting/reports_main.php
724 /reporting/rep106.php
726 06-Feb-2008 Janusz Dobrowolski
727 + Separation of customer invoice issue and goods delivery.
728 + Batch invoicing for more than one delivery
729 # Corrected inadequate shipping tax calculations.
730 ! Default debugging status changed to off.
731 $ /taxes/tax_calc.inc
732 /taxes/db/tax_groups_db.inc
733 /admin/db/voiding_db.inc
734 /applications/customers.php
735 /includes/systypes.inc
737 /includes/ui/ui_controls.inc
738 /includes/ui/ui_lists.inc
739 /includes/ui/ui_view.inc
740 /inventory/inquiry/stock_status.php
741 /reporting/rep105.php
742 /reporting/rep107.php
743 /reporting/rep109.php
744 /reporting/rep110.php
745 /reporting/rep209.php
746 /reporting/reports_main.php
747 /reporting/includes/doctext.inc
748 /reporting/includes/doctext2.inc
749 /reporting/includes/form_types.inc
750 /reporting/includes/pdf_report.inc
751 /reporting/includes/reports_classes.inc
752 /sales/customer_credit_invoice.php
753 /sales/customer_invoice.php
754 /sales/sales_order_entry.php
755 /sales/customer_delivery.php
756 /sales/includes/db/sales_delivery_db.inc
757 /sales/includes/ui/print_invoice.inc
758 /sales/includes/cart_class.inc
759 /sales/includes/sales_db.inc
760 /sales/includes/db/cust_trans_db.inc
761 /sales/includes/db/cust_trans_details_db.inc
762 /sales/includes/db/sales_credit_db.inc
763 /sales/includes/db/sales_invoice_db.inc
764 /sales/includes/db/sales_order_db.inc
765 /sales/includes/ui/sales_order_ui.inc
766 /sales/inquiry/customer_allocation_inquiry.php
767 /sales/inquiry/customer_inquiry.php
768 /sales/inquiry/sales_orders_view.php
769 /sales/inquiry/sales_deliveries_view.php
770 /sales/view/view_dispatch.php
771 /sales/view/view_invoice.php
772 /sales/view/view_sales_order.php
777 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
778 $ /sales/includes/cart_class.inc
779 /sales/includes/db/sales_credit_db.inc
780 /sales/includes/db/sales_invoice_db.inc
781 /sales/includes/db/sales_order_db.inc
782 /sales/includes/db/cust_trans_details_db.inc
783 /sales/includes/ui/sales_order_ui.inc
784 /sales/includes/ui/sales_credit_ui.inc
785 /sales/credit_note_entry.php
786 /sales/customer_credit_invoice.php
787 /sales/sales_order_entry.php
788 /sales/customer_invoice.php
791 ! New Release 2.0 Pre Alpha
793 # Fixed a release 2 related bug in create_coy.php
794 $ /admin/create_coy.php
795 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
796 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
797 with these databases changes without any new files. They are coming as soon as possible.
798 $ /sql/alter.sql (New file)
799 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
801 $ /purchasing/supplier_trans_gl.php
802 /purchasing/includes/db/invoice_items_db.inc
803 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
804 $ /includes/ui/ui_lists.inc
805 /purchasing/includes/ui/po_ui.inc
806 /sales/includes/ui/sales_order_ui.inc
807 /admin/company_preferences.php
808 /admin/db/company_db.inc
810 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
811 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
812 $ /sales/manage/sales_people.php
813 /includes/ui/ui_input.inc
815 -------------------- 2,0 Pre Alpha - above ----------------------------
816 31-Jan-2008 Janusz Dobrowolski
817 # Minor bugfix in db_import()
818 $ /admin/db/maintenance_db.inc
820 30-Jan-2008 Janusz Dobrowolski
821 # Minor display fix in tax_types.php
822 $ /taxes/tax_types.php
823 ! Format cleanup on some files.
824 $ /gl/includes/gl_db.inc
825 /gl/includes/gl_ui.inc
826 /applications/application.php
830 -------------------- 1.16 Stable Released ----------------------
832 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
833 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
834 and $no_supplier_list. Default is the normal behavior for all listboxes.
835 $ /includes/ui/ui_lists.inc
836 /sales/includes/ui/sales_orders_ui.inc
837 /purchases/includes/ui/po_ui.inc
838 /themes/default/images/locate.png (New file)
841 + Added ALTER TABLE possibility in db_import. For future releases.
842 $ /admin/db/maintenence_db.inc
844 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
845 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
846 $ /includes/db/connect_db.inc
847 /includes/ui/ui_lists.inc
848 /includes/page/header.inc
852 # When login screen is displayed after session timeout page content is broken. It
853 is because of NOT using absolute paths in href attribute theme elements.
857 # Minor adjustments in function db_export on line 325
858 $ /admin/db/maintenance_db.inc
861 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
864 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
865 Also fixed a unneccessary str_replace when importing sql scripts.
866 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
867 $ /admin/db/maintenance_db.inc
868 /reporting/includes/pdf_report.inc
871 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
872 $ /gl/inquiry/gl_trial_balance.php
873 /gl/inquiry/gl_account_inquiry.php
876 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
877 $ /admin/db/voiding_db.inc
880 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
882 /gl/includes/ui/gl_payment_ui.inc
884 ! Changed $loc_notification to be set to 0 instead of 1.
887 -------------------- 1.15 Stable Released ----------------------
889 + Added email notification to stock location when available stock is below reorder level
891 /sales/includes/db/sales_order_db.inc
893 # Fixed bugs in Open balances when account is not a balance account
894 $ /gl/inquiry/gl_trial_balance.php
895 /gl/inquiry/gl_account_inquiry.php
896 /reporting/rep704.php
897 /reporting/rep708.php
899 -------------------- 1.14 Stable Released ----------------------
901 ! Major change in the installation of modules to also accept an SQL-file for upload.
903 /admin/inst_module.php
904 /admin/db/maintenance_db.inc
907 # The following files were still vulnerable. Fixed
909 /includes/lang/language.php
911 -------------------- 1.13 Stable Released ----------------------
913 + Added optional link for electronic payment on invoices (PayPal).
914 ! Better support for install/update languages.
916 # Fixed a vulnerable item in config.php
920 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
921 # config.php has been vulnerable. Fixed.
922 $ /admin/inst_lang.php
926 ! Changed Bank Address field from text to textarea (multirows)
927 $ /gl/manage/bank_accounts.php
930 + Added optional link for electronic payment on invoices (PayPal)
931 $ /reporting/reports_main.php
932 /reporting/rep107.php
933 /reporting/includes/report_classes.inc
934 /reporting/includes/pdf_report.inc
935 /reporting/includes/doc_text.inc
936 /reporting/includes/doc_text2.inc
939 # Unnecessary parameter ($db) in check_for_recursive_bom
940 $ /manufacturing/manage/bom_edit.php
943 # Bug in /includes/lang/gettext.php (249) affecting changing language!
944 $ /includes/lang/gettext.php
950 /admin/create_coy.php
951 /reporting/includes/pdf_report.inc
954 + Added a default fiscal year in the en_US-new.sql and start references.
956 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
957 $ /lang/en_US/LC_MESSAGES/en_US.mo
960 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
961 $ /sales/includes/db/sales_order_db.inc
964 # Changed <? in front of 2 files to <?php.
965 $ /purchasing/includes/purchasing_ui.inc
966 /reporting/includes/class.mail.inc
968 -------------------- 1.12 Stable Released ----------------------
970 + Added option to handle Jalali and Islamic Calendars
973 /gl/includes/db/gl_db_trans.inc
974 /includes/date_functions.inc
975 /includes/ui/ui_input.inc
976 /includes/ui/ui_lists.inc
977 /includes/ui/ui_view.inc
978 /purchasing/po_receive_items.php
979 /purchasing/includes/ui/invoice_ui.inc
980 /purchasing/includes/ui/po_ui.inc
981 /reporting/rep705.php
982 /sales/includes/db/sales_order_db.inc
983 /sales/includes/ui/sales_order_ui.inc
986 ! Changed parameters on report Sales Order. Option to print as Quote.
987 $ /reporting/reports_main.php
988 /reporting/rep109.php
989 /reporting/includes/pdf_report.inc
990 /reporting/includes/doctext.inc
991 /reporting/includes/doctext2.inc
994 + Added Budget Entry in General Ledger. Includes Dimensions.
996 /applications/generalledger.php
997 /gl/gl_budget.php (New File!)
998 /gl/includes/db/gl_db_trans.inc
999 /includes/date_functions.inc
1000 /reporting/report_classes.inc
1002 -------------------- 1.11 Stable Released ----------------------
1003 04-Jul-2007 Joe Hunt
1004 ! Option for using alpha numeric chart of accounts.
1006 /gl/manage/gl_accounts.php
1007 /gl/includes/db/gl_db_accounts.inc
1008 /gl/includes/db/gl_db_bank_trans.inc
1009 /gl/includes/db/gl_db_trans.inc
1010 /gl/inquiry/gl_trial_balance.inc
1011 /admin/db/company_db.inc
1012 /inventory/includes/db/items_db.inc
1013 /sales/manage/customer_branches.inc
1015 04-Jul-2007 Joe Hunt
1016 # Problems retrieving language texts for poEdit in long javascripts
1017 $ /includes/ui/ui_view.inc
1019 04-May-2007 Joe Hunt
1020 # Database error when updating more than one item row in Sales Orders.
1021 $ /sales/includes/db/sales_order_db.inc
1022 # Database error when inserting work order issues. Fixed.
1023 $ /manufacturing/includes/db/work_order_issues_db.inc
1025 03-May-2007 Joe Hunt
1026 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
1027 $ /includes/db/manufacturing_db.inc
1028 /manufacturing/includes/db/work_order_requirements_db.inc
1030 02-May-2007 Joe Hunt
1031 # Missing details on Purchase Order when emailing and printing
1032 $ /reporting/rep209.php
1034 -------------------- 1.1 Stable Released ----------------------
1035 02-May-2007 Joe Hunt
1036 + Enabled module addons and all the below bugfixes. No changes in database structure.
1037 - Removed /sql/basic.sql (included in the other sql files)
1038 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
1039 (not needed anymore).
1040 + Addition of update.html
1041 $ /admin/inst_module.php (New file!)
1042 /applications/customers.php
1043 /applications/dimensions.php
1044 /applications/generalledger.php
1045 /applications/inventory.php
1046 /applications/manufacturing.php
1047 /applications/setup.php
1048 /applications/suppliers.php
1051 /modules/inst_modules.php (New folder and new file!)
1052 /modules/index.php (New file!)
1056 update.html (New file!)
1058 01-May-2007 Joe Hunt
1059 # Missing measure of units when printing sales orders
1060 # Update of Sales People caused a database error
1061 $ /sales/manage/sales_people.php
1062 /reporting/rep109.php
1064 30-Apr-2007 Joe Hunt
1065 + The selected menu tab is now shown with same background as hover color.
1066 $ config.php (default tab line 77. Change if you want)
1067 /includes/page/header.inc
1069 28-Apr-2007 Joe Hunt
1070 # When saving work order entries a lot of debug boxes appeared. Fixed
1071 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
1072 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
1073 $ /includes/db/manufacturing_db.inc
1074 /manufacturing/work_order_entry.php
1075 /manufacturing/includes/work_order_issue_ui.inc
1076 /manufacturing/includes/db/work_order_requirements_db.inc
1077 /manufacturing/includes/db/work_orders_quick_db.inc
1078 /manufacturing/inquiry/where_used_inquiry.php
1080 25-Apr-2007 Joe Hunt
1081 # Missing Date Picker
1082 $ /sales/customer_invoice.php
1083 # No JS popup window
1084 $ /sales/view/view_invoice.php
1086 24-Apr-2007 Joe Hunt
1087 ! New and better Date Picker, better cool theme.
1088 $ /includes/ui/ui_input.inc
1089 /includes/ui/ui_view.inc
1090 /reporting/includes/reports_classes.inc
1091 /themes/cool/default.css
1093 -------------------- 1.0.1 Stable Released ----------------------
1094 23-Apr-2007 Joe Hunt
1095 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
1096 the changes for selection lists customers/suppliers and the Audit Trail.
1098 22-Apr-2007 Joe Hunt
1099 ! Changed the two selection lists for customers/suppliers in reports to a single one with
1101 ! Changed the sort order in these selection lists from id to name.
1102 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
1103 $ /reporting/reports_main.php
1104 /reporting/rep101.php
1105 /reporting/rep102.php
1106 /reporting/rep201.php
1107 /reporting/rep202.php
1108 /reporting/rep203.php
1109 /reporting/rep204.php
1110 /reporting/includes/reports_classes.inc
1111 /includes/ui/ui_lists.inc
1112 /gl/includes/db/gl_db_trans.inc
1115 22-Apr-2007 Joe Hunt
1116 + Date Picker for all date fields.
1118 /admin/fiscalyears.php
1119 /admin/void_transaction.php
1120 /includes/ui/ui_view.inc
1121 /includes/ui/ui_input.inc
1122 /dimensions/dimension_entry.php
1123 /dimensions/inquiry/search_dimensions.php
1127 /gl/bank_transfer.php
1128 /gl/inquiry/bank_inquiry.php
1129 /gl/inquiry/gl_account_inquiry.php
1130 /gl/inquiry/gl_trial_balance.php
1131 /gl/manage/exchange_rates.php
1132 /inventory/adjustments.php
1133 /inventory/transfers.php
1134 /inventory/inquiry/stock_movements.php
1135 /inventory/manage/items.php
1136 /manufacturing/work_order_add_finished.php
1137 /manufacturing/work_order_entry.php
1138 /manufacturing/work_order_issue.php
1139 /manufacturing/work_order_release.php
1140 /purchasing/supplier_payment.php
1141 /purchasing/po_entry_items.php
1142 /purchasing/po_receive_items.php
1143 /purchasing/supplier_credit.php
1144 /purchasing/supplier_credit_grns.php
1145 /purchasing/supplier_invoice.php
1146 /purchasing/supplier_invoice_grns.php
1147 /purchasing/supplier_trans_gl.php
1148 /purchasing/includes/ui/po_ui.inc
1149 /purchasing/inquity/po_search.php
1150 /purchasing/inquiry/po_search_completed.php
1151 /purchasing/inquiry/supplier_allocation_inquiry.php
1152 /purchasing/inquiry/supplier_inquiry.php
1153 /reporting/reports_main.php
1154 /reporting/includes/reports_classes.inc
1155 /sales/credit_note_entry.php
1156 /sales/customer_credit_invoice.php
1157 /sales/customer_payments.php
1158 /sales/sales_order_entry.php
1159 /sales/includes/ui/sales_order_ui.inc
1160 /sales/inquiry/customer_allocation_inquiry.php
1161 /sales/inquiry/customer_inquiry.php
1162 /sales/inquiry/sales_orders_view.php
1164 /themes/default/images/cal.gif
1165 /themes/default/images/next.gif
1166 /themes/default/images/prev.gif
1168 19-Apr-2007 Joe Hunt
1169 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
1170 # Bug no 1703891, Reserved MySQL words used as column names, fixed
1171 $ /taxes/db/tax_types_db.inc
1173 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
1174 $ /gl/manage/gl_accounts.php
1175 /gl/includes/db/gl_db_accounts.inc
1176 /includes/ui/ui_input.inc
1178 18-Apr-2007 Joe Hunt
1179 # Bug no 1702594, Logon Loop, fixed
1182 -------------------- 1.0a Stable Released ----------------------
1183 10-Apr-2007 Joe Hunt
1184 ! Release 1.0a established on SourceForge, fixing the bugs.
1186 11-Apr-2007 Joe Hunt
1187 # Bug No 1698214, Creating Items, fixed
1188 $ /includes/ui/ui_lists.inc
1189 # Bug no 1698216, Item Movements, fixed
1190 $ /inventory/manage/items.php
1192 -------------------- 1.0 Stable Released ----------------------
1193 10-Apr-2007 Joe Hunt
1194 ! Release 1.0 established on SourceForge.
1196 2. Copyright and disclaimer
1197 ---------------------------
1198 This application is opensource software released under the GPL. Please
1199 see source code and the LICENSE file