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.
22 25-Jun-2008 Janusz Dobrowolski
23 # Fixed bug 0000004, removed nested forms in supplier invoice/credit
24 $ /purchasing/includes/ui/invoice_ui.inc
27 # Fixed bug when updating/saving Tax Group Items
28 $ /includes/ui/ui_lists.inc
31 # Fixed inconsistencies in customer and supplier aging
32 $ /sales/includes/db/customers_db.inc
33 /sales/inquiry/customer_inquiry.php
34 /purchasing/includes/db/suppliers_db.inc
37 # Fixed a bug when trying to back the inv.date and due date in Direct Invoicing.
38 $ /sales/sales_order_entry.php
41 23-Jun-2008 Janusz Dobrowolski
42 + Ajax additions to sales and purchasing modules
43 $ /purchasing/po_receive_items.php
44 /purchasing/supplier_credit.php
45 /purchasing/supplier_credit_grns.php
46 /purchasing/supplier_invoice.php
47 /purchasing/supplier_invoice_grns.php
48 /purchasing/supplier_trans_gl.php
49 /purchasing/allocations/supplier_allocate.php
50 /purchasing/includes/ui/invoice_ui.inc
51 /sales/customer_credit_invoice.php
52 /sales/allocations/customer_allocate.php
53 # Fixed edition of purchase order (bug #0000001)
54 $ /purchasing/includes/ui/po_ui.inc
55 ! Improved client side allocation functions
57 + Optional coloured price_format()
60 ! Async update of locations selector
61 $ /includes/ui/ui_lists.inc
62 # Fixed warning on pages without default focus.
63 $ /includes/ui/ui_controls.inc
64 # Fixed initial display for numeric inputs with dec=0.
65 $ /includes/ui/ui_input.inc
67 21-Jun-2008 Janusz Dobrowolski
68 + Ajax additions to sales and purchasing modules
69 $ /purchasing/po_entry_items.php
70 /purchasing/supplier_payment.php
71 /purchasing/allocations/supplier_allocate.php
72 /purchasing/includes/ui/po_ui.inc
73 /purchasing/inquiry/po_search.php
74 /purchasing/inquiry/po_search_completed.php
75 /purchasing/inquiry/supplier_allocation_inquiry.php
76 /purchasing/inquiry/supplier_inquiry.php
77 /purchasing/manage/suppliers.php
78 /sales/manage/customers.php
81 + Added upload functionality to company logo. Better names on lists search.
82 $ /admin/company_preferences.php
83 ! Better layout on company logo print-out
84 $ /reporting/includes/header2.inc
86 ---------------------------------------Release Candidate 2-------------------------------
88 ! 2.0 Release Candidate 2
93 ! In reorder_level.php the heading gets updated as well
94 $ /inventory/reorder_level.php
95 ! Changes the -1 to 'User Quantiry Decimals' in the table for units.
96 $ /inventory/manage/item_units.php
98 20-Jun-2008 Janusz Dobrowolski
99 # Proper error handling even after exit() call.
100 $ /includes/errors.inc
102 /includes/session.inc
103 # Fixed initial combo selection.
104 /includes/ui/ui_lists.inc
105 # Layout fixes to customer edition.
106 /sales/manage/customers.php
107 # Added order table reload after template option change
108 /sales/inquiry/sales_orders_view.php
110 19-Jun-2008 Janusz Dobrowolski
111 + Added ajax improvements
112 $ /purchasing/allocations/supplier_allocation_main.php
113 /sales/customer_delivery.php
114 /sales/customer_invoice.php
115 /sales/allocations/customer_allocation_main.php
116 /sales/manage/customers.php
117 + Ajax added to check helper function
118 $ /includes/ui/ui_input.inc
119 # Fixing database error in branch exist check on empty customer_id
120 $ /includes/data_checks.inc
121 # Layout fix for hyperlink_params_td()
122 $ /includes/ui/ui_controls.inc
123 # Fix for initial combo position
124 $ /includes/ui/ui_lists.inc
125 # Fix to select onchange extension
129 ! changed so the due date is updated when changing customer in direct invoice.
130 $ /sales/includes/ui/sales_order_ui.inc
133 # Minor layout bug at Credit Shipping Costs in customer_credit_invoice.php
134 $ /sales/customer_credit_invoice.php
136 18-Jun-2008 Janusz Dobrowolski
137 + Added ajax improvements
138 $ /sales/credit_note_entry.php
139 /sales/customer_payments.php
140 /sales/sales_order_entry.php
141 /sales/includes/ui/sales_credit_ui.inc
142 /sales/includes/ui/sales_order_ui.inc
143 /sales/inquiry/customer_allocation_inquiry.php
144 /sales/inquiry/customer_inquiry.php
145 + Added optional trigger parameter to div_start()
146 $ /includes/ui/ui_controls.inc
147 + Added dec attribute ajax update for amount fields
148 $ /includes/ui/ui_input.inc
149 + Ajaxified stock item types and credit types lists
150 $ /includes/ui/ui_lists.inc
151 # Fixed onblur for amount fields, extended onchange event handling for selects
153 # Fixed addAssign() js handler for nonstandard attributes
155 # Fixed bug in stock item image upload
156 $ /inventory/manage/items.php
159 ! More files with Quantity routines needed fix due to php4 related issue.
160 $ /includes/current_user.inc
161 /manufacturing/work_order_entry.php
162 /manufacturing/inquiry/where_used_inquiry.php
163 /manufacturing/manage/bom_edit.php
164 /purchasing/po_receive_items.php
165 /purchasing/supplier_credit_grns.php
166 /purchasing/supplier_invoice_grns.php
167 /sales/customer_credit_invoice.php
168 /sales/includes/ui/sales_order_ui.inc
171 ! Changed so Customer's Reference is printed on all sales documents (you can f.i. enter PO number here).
172 $ /reporting/includes/header2.inc
173 /reporting/doctext.inc
174 /reporting/doctext2.inc
177 ! Changed the Quantity routines to use the Item Units decimals if any. A lot of files.
178 $ /includes/current_user.inc
179 /includes/ui/ui_input.inc
180 /includes/ui/ui_lists.inc
181 /inventory/reorder_level.inc
182 /inventory/includes/item_adjustments_ui.inc
183 /inventory/includes/stock_transfers_ui.inc
184 /inventory/includes/db/items_units_db.inc
185 /inventory/inquiry/stock_movements.php
186 /inventory/inquiry/stock_status.php
187 /inventory/manage/item_units.php
188 /inventory/view/view_adjustment.php
189 /inventory/view/view_transfer.php
190 /manufacturing/search_work_orders.php
191 /manufacturing/work_order_entry.php
192 /manufacturing/includes/manufacturing_ui.inc
193 /manufacturing/includes/work_order_issue_ui.inc
194 /manufacturing/inquiry/where_used_inquiry.php
195 /manufacturing/manage/bom_edit.php
196 /manufacturing/view/wo_issue_view.php
197 /manufacturing/view/wo_production_view.php
198 /purchasing/po_receive_items.php
199 /purchasing/supplier_credit_grns.php
200 /purchasing/supplier_invoice_grns.php
201 /purchasing/includes/ui/invoice_ui.inc
202 /purchasing/includes/ui/po_ui.inc
203 /purchasing/view/view_grn.php
204 /purchasing/view/view_po.php
205 /reporting/rep105.php
206 /reporting/rep107.php
207 /reporting/rep108.php
208 /reporting/rep109.php
209 /reporting/rep110.php
210 /reporting/rep204.php
211 /reporting/rep209.php
212 /reporting/rep301.php
213 /reporting/rep302.php
214 /reporting/rep303.php
215 /reporting/rep401.php
216 /sales/customer_credit_invoice.php
217 /sales/customer_delivery.php
218 /sales/customer_invoice.php
219 /sales/includes/ui/sales_credit_ui.inc
220 /sales/includes/ui/sales_order_ui.inc
221 /sales/view/view_credit.php
222 /sales/view/view_dispatch.php
223 /sales/view/view_invoice.php
224 /sales/view/view_sales_order.php
226 15-Jun-2008 Janusz Dobrowolski
227 + Ajax driven delivery and order queries.
228 $ /sales/inquiry/sales_deliveries_view.php
229 /sales/inquiry/sales_orders_view.php
230 + Added searchbox class selector for text inputs with onchange event handlers.
231 ! Added text selection after focus.
234 + Added submit_on_change option to ref input functions, fixed data picker
235 $ /includes/ui/ui_input.inc
236 # Fixed bug in non-js mode for combos type 0 (stock_items_lists).
237 $ /includes/ui/ui_lists.inc
240 # Changed so Invoice Template gets the current day instead of original day.
241 $ /sales/sales_order_entry.php
244 # Bug in tax_types_list (spec_id)
245 $ /includes/ui/ui_lists.inc
248 # Minor annoying layout bug in stock movements.
249 $ /inventory/inquiry/stock_movements.php
252 ! The Customer Branch Sales Account now overrides the Item Sales Accounts if a Sales Account is here.
253 Can now be set to 'Use Item Sales Accounts', which is the first choice in list and default.
254 ! If setting the Customer Branch AR Account to a Bank Account (and hereby also Cash Account) the
255 transactions from Direct Invoice and Credit Note will be allocated immediately when placing.
256 $ /includes/ui/ui_lists.inc
257 /sales/includes/db/sales_invoice_db.inc
258 /sales/includes/db/sales_credit_db.inc
259 /sales/manage/customer_branches.php
262 + New inventory sales report. Shows total sales - costs - contribution per category, location, detailed/summary and period.
263 $ /reporting/reports_main.php
264 /reporting/rep304.php (new file)
266 ---------------------------------------Release Candidate 1-------------------------------
267 10-Jun-2008 Janusz Dobrowolski
268 # Some more fixes related to ajax combos usage
269 $ /includes/ui/ui_lists.inc
270 /inventory/cost_update.php
271 /inventory/prices.php
272 /inventory/purchasing_data.php
273 /inventory/reorder_level.php
274 /inventory/includes/item_adjustments_ui.inc
275 /inventory/inquiry/stock_status.php
276 /manufacturing/inquiry/where_used_inquiry.php
277 /manufacturing/manage/bom_edit.php
278 /purchasing/includes/ui/po_ui.inc
285 09-Jun-2008 Janusz Dobrowolski
286 # Some additional fixes related to last big committment
291 /includes/reserved.inc
292 /includes/ui/ui_lists.inc
293 /includes/ui/ui_view.inc
296 /sales/includes/ui/sales_order_ui.inc
297 /themes/default/default.css
298 /themes/aqua/default.css
299 /themes/cool/default.css
302 ! Preparing for release candidate 1
306 ! Set 'max_execution_time' to 60 seconds by ini_set.
310 # Fixed a layout bug in footer.inc
311 $ /includes/page/footer.inc
314 ! Changed install.html and update.html
317 + New files, change_current_user_password.php and alter2.sql
318 $ /admin/change_current_user_password.php
320 ! Changed some files for layout
321 $ /lang/en_US/stylesheet.css
322 /themes/aqua/default.css
323 /themes/aqua/renderer.php
324 /themes/cool/default.css
325 /themes/cool/renderer.php
326 /themes/default/default.css
327 /themes/default/renderer.php
328 ! Changed install sql scripts
329 $ /sql/en_US-demo.sql
332 07-Jun-2008 Janusz Dobrowolski
333 + Added ajax functionality and ui hints to sales form entry pages.
334 $ /sales/sales_order_entry.php
335 /sales/includes/ui/sales_order_ui.inc
336 + Added option for hints display, changed input/lists functions API
337 $ /admin/display_prefs.php
338 /admin/db/users_db.inc
339 /includes/current_user.inc
340 /includes/prefs/userprefs.inc
341 /includes/ui/ui_input.inc
342 /themes/default/renderer.php
344 + List functions rewrite. Added ajax functionality, universal combo_input().
345 $ /includes/ui/ui_lists.inc
346 + Ajaxified exchange_rate_display()
347 $ /includes/ui/ui_view.inc
348 + Added methods for setting focus and page reload to $Ajax class
351 + Added comma separated css element selectors
353 ! Searchable select js changes related to new ui_lists.inc changes
356 + Additional style definitions for various ajax controls
357 $ /themes/default/default.css
358 ! Fixes related to changed input/lists API and ajax extensions
359 $ /admin/company_preferences.php
360 /admin/fiscalyears.php
361 /admin/forms_setup.php
363 /dimensions/dimension_entry.php
364 /dimensions/inquiry/search_dimensions.php
365 /gl/bank_transfer.php
366 /gl/includes/ui/gl_deposit_ui.inc
367 /gl/includes/ui/gl_journal_ui.inc
368 /gl/includes/ui/gl_payment_ui.inc
369 /gl/inquiry/bank_inquiry.php
370 /gl/inquiry/gl_account_inquiry.php
371 /gl/inquiry/gl_trial_balance.php
372 /gl/manage/gl_account_types.php
373 /gl/manage/gl_accounts.php
374 /includes/ui/ui_controls.inc
375 /inventory/includes/item_adjustments_ui.inc
376 /inventory/includes/stock_transfers_ui.inc
377 /inventory/inquiry/stock_movements.php
378 /manufacturing/search_work_orders.php
379 /manufacturing/work_order_add_finished.php
380 /manufacturing/work_order_entry.php
381 /manufacturing/includes/work_order_issue_ui.inc
382 /manufacturing/manage/bom_edit.php
383 /purchasing/supplier_payment.php
384 /purchasing/includes/ui/grn_ui.inc
385 /purchasing/includes/ui/invoice_ui.inc
386 /purchasing/includes/ui/po_ui.inc
387 /purchasing/inquiry/po_search.php
388 /purchasing/inquiry/po_search_completed.php
389 /purchasing/inquiry/supplier_allocation_inquiry.php
390 /purchasing/inquiry/supplier_inquiry.php
391 /sales/customer_credit_invoice.php
392 /sales/customer_delivery.php
393 /sales/customer_invoice.php
394 /sales/includes/ui/sales_credit_ui.inc
395 /sales/inquiry/customer_allocation_inquiry.php
396 /sales/inquiry/customer_inquiry.php
397 /sales/inquiry/sales_deliveries_view.php
398 /sales/inquiry/sales_orders_view.php
399 /taxes/tax_groups.php
402 # Final fixes in html layout
403 $ /admin/create_coy.php
406 /gl/manage/exchange_rates.php
407 /inventory/prices.php
408 /inventory/purchasing_date.php
409 /inventory/reorder_level.php
410 /inventory/inquiry/stock_status.php
411 /manufacturing/inquiry/where_used_inquiry.php
412 /manufacturing/manage/bom_edit.php
415 ! Made an improment to the date picker. Shows the week number as well. Many delivery systems are week number based.
416 $ /includes/ui/ui_view.inc
417 # Fixed a html layout bug
418 $ /includes/page/header.inc
421 # A lot of annoying layout bugs taken. Mostly from views and inquiries. A couple of files are critical, ui_view and ui_lists!
422 $ /gl/view/gl_deposit_view.php
423 /gl/view/gl_payment_view.php
424 /includes/ui/ui_controls.inc
425 /includes/ui/ui_lists.inc
426 /includes/ui/ui_view.inc
427 /manufacturing/work_order_add_finished.php
428 /manufacturing/includes/manufacturing_ui.inc
429 /manufacturing/view/work_order_view.php
430 /manufacturing/view/wo_issue_view.php
431 /sales/inquiry/customer_allocation_inquiry.php
432 /sales/inquiry/customer_inquiry.php
435 # Fixed bug in 2 files regarding stock movements. Moved from Invoice to Delivery.
436 $ /inventory/inquiry/stock_movements.php
437 /reporting/rep302.php
440 # More bugs related to debtor_trans changes (positive amounts)
441 $ /gl/includes/db/gl_db_banking.inc
442 /sales/allocations/customer_allocate.php
443 /sales/includes/db/custalloc_db.inc
444 /sales/inquiry/customer_allocation_inquiry.php
447 # Changed more files with new html/css.
448 $ /includes/page/header.inc
449 /purchasing/inquiry/supplier_allocation_inquiry.php
450 /sales/credit_note_entry.php
453 # Fixed many minor bugs, new ones as well as debtor_trans related.
454 ! Changed to use DOCTYPE html 4.01 transitionel. Some files/css needed change.
456 /admin/create_coy.php
458 /admin/inst_module.php
459 /gl/manage/exchange_rates.php
460 /includes/session.inc
461 /includes/page/header.inc
462 /includes/ui/ui_controls.inc
463 /includes/ui/ui_input.inc
464 /includes/ui/ui_lists.inc
465 /includes/ui/ui_view.inc
466 /purchasing/allocations/supplier_allocate.php
467 /sales/allocations/customer_allocate.php
468 /sales/includes/db/sales_credit_db.inc
469 /sales/inquiry/customer_allocation_inquiry.php
470 /themes/aqua/default.css
471 /themes/cool/default.css
472 /themes/default/default.css
475 # Minor bug in dimensions.php (Outstanding Dimensions)
476 $ /applications/dimensions.php
477 /dimensions/inquiry/search_dimensions.php
479 23-May-2008 Janusz Dobrowolski
480 ! Include file order / error handling order fixed once again.
482 /includes/session.inc
485 ! Moved menu-system from header.inc/footer.inc to renderer.php for relevant theme. Fixed frontaccounting.php to get the
486 correct renderer.php.
487 $ frontaccounting.php
488 /includes/page/header.inc
489 /includes/page/footer.inc
490 /themes/default/renderer.php
491 /themes/cool/renderer.php
492 /themes/aqua/renderer.php
494 22-May-2008 Janusz Dobrowolski
495 ! Error handler switching moved to session.inc for early error catching
497 /includes/session.inc
501 18-May-2008 Janusz Dobrowolski
502 # Added explicit ob_end_flush() on shutdown needed for php5
504 # Fixed for www servers on nonstandard listening ports.
505 $ /js/JsHttpRequest.js
508 # Bug when inserting new records in debtor_trans.
509 $ /sales/includes/db/cust_trans_db.inc
511 16-May-2008 Janusz Dobrowolski
512 + Rewritten errors/messages handling, unified for ajax/user/php errors
513 $ /includes/errors.inc
515 /includes/ui/ui_msgs.inc
516 + Framework extended for ajax functionality, javascript code organization improvements.
518 /includes/JsHttpRequest.php (new file)
519 /includes/ajax.inc (new file)
520 /includes/current_user.inc
521 /includes/session.inc
522 /includes/lang/language.php
523 /includes/page/footer.inc
524 /includes/page/header.inc
525 /includes/ui/ui_controls.inc
526 /includes/ui/ui_input.inc
527 /includes/ui/ui_view.inc
528 /js/JsHttpRequest.js (new file)
529 /js/allocate.js (new file)
530 /js/utils.js (new file)
533 /themes/aqua/images (new dir)
534 /themes/aqua/images/button_ok.png (new file)
535 /themes/aqua/images/locate.png (new file)
536 /themes/cool/images (new dir)
537 /themes/coll/images/button_ok.png (new file)
538 /themes/coll/images/locate.png (new file)
539 /themes/default/images/button_ok.png (new file)
540 /themes/default/images/progressbar.gif (new file)
541 /themes/default/images/progressbar1.gif (new file)
542 /themes/default/images/progressbar2.gif (new file)
543 /themes/default/default.css
544 /themes/aqua/default.css
545 /themes/cool/default.css
546 ! Payment allocation js functions moved to allocate.js
547 $ /purchasing/allocations/supplier_allocate.php
548 /sales/allocations/customer_allocate.php
549 ! Some initializations moved from sales_order_ui.inc
550 $ /sales/includes/cart_class.inc
551 + Added javascript compression routine
555 # Minor bugs in the former fixing.
556 $ /includes/ui/ui_lists.inc
559 # When no_item_list or no_customer_list or no_supplier_list was checked in company setup the listboxes were filled with all
560 the records when there were no search values.
561 $ /includes/ui/ui_lists.inc
564 ! Due to differences in Javascript the script update_db.php had to be changed.
565 ! New fields, base_sales in 0_company and factor in 0_sales_types affects the default chart of accounts.
570 09-May-2008 Janusz Dobrowolski
571 # Automatic calculation of not set item prices from home currency and base sales type settings.
572 $ /admin/company_preferences.php
573 /admin/db/company_db.inc
574 /includes/ui/ui_lists.inc
575 /sales/includes/cart_class.inc
576 /sales/includes/sales_db.inc
577 /sales/includes/db/sales_order_db.inc
578 /sales/includes/db/sales_types_db.inc
579 /sales/includes/ui/sales_credit_ui.inc
580 /sales/includes/ui/sales_order_ui.inc
581 /sales/manage/sales_types.php
583 # Fixed dev bug blocking change of price on order entry.
584 $ /sales/includes/ui/sales_order_ui.inc
586 $ /sales/manage/sales_people.php
589 # Fixed price update also in purchase order
590 $ /purchasing/includes/ui/po_ui.inc
592 30-Apr-2008 Janusz Dobrowolski
593 # Fixed price update when changing item in sales order.
594 $ /includes/ui/ui_lists.inc
596 /sales/includes/ui/sales_order_ui.inc
598 24-Apr-2008 Janusz Dobrowolski
599 + Added new per company directory for customized versions of report definition files repXXX.php, checked before using system default file.
600 $ /company/0/reporting (added new directory)
601 /company/0/reporting/index.php
602 /admin/create_coy.php
603 /reporting/includes/reports_classes.inc
604 # Warnings turned off in case of charset not supported by htmlspecialchars().
605 $ /includes/db/connect_db.inc
606 # Added content type encoding header
607 $ /includes/page/header.inc
610 # Wrong include file path in /includes/ui/items_cart.inc changed /inventory/includes/prefs/sysprefs.inc to
611 /includes/prefs/sysprefs.inc
612 $ /includes/ui/items_cart.inc
613 # Wrong include file in /reporting/includes/pdf_report.inc. Changed header2a.inc to header2.inc
614 $ /reporting/includes/pdf_report.inc
617 ! Removed the content of function header2 in pdf_report.inc to a separate file, header2.inc.
618 It will make it easier to design your own document layouts.
619 $ /reporting/includes/pdf_report.inc
620 /reporting/includes/header2.inc (new file)
622 20-Apr-2008 Janusz Dobrowolski
623 # Checking uniqueness of company settings, fixed creating database with prefix 0 when none was selected.
624 $ /admin/create_coy.php
625 ! Added missing include_once directives.
626 $ /includes/ui/items_cart.inc
627 /includes/ui/ui_lists.inc
628 /includes/ui/ui_view.inc
629 + Added ini default_charset unnecessary for planned ajax calls.
630 $ /includes/lang/language.inc
633 # Bug (right to left text was done if price decimals were 3). A test sentense from a while
635 $ /reporting/includes/pdf_report.inc
637 18-Apr-2008 Janusz Dobrowolski
638 # Additional checks on provisions and break point entry.
639 $ /sales/manage/sales_people.php
640 ! Modules purchasing, sales and taxes sealed against XSS attacks
642 /admin/db/maintenance_db.inc
643 /purchasing/includes/db/grn_db.inc
644 /purchasing/includes/db/invoice_items_db.inc
645 /purchasing/includes/db/po_db.inc
646 /purchasing/includes/db/supp_trans_db.inc
647 /purchasing/manage/suppliers.php
648 /sales/includes/db/credit_status_db.inc
649 /sales/includes/db/cust_trans_db.inc
650 /sales/includes/db/cust_trans_details_db.inc
651 /sales/includes/db/sales_order_db.inc
652 /sales/includes/db/sales_types_db.inc
653 /sales/manage/customer_branches.php
654 /sales/manage/customers.php
655 /sales/manage/sales_areas.php
656 /sales/manage/sales_people.php
657 /taxes/db/item_tax_types_db.inc
658 /taxes/db/tax_groups_db.inc
659 /taxes/db/tax_types_db.inc
662 ! Module gl sealed against XSS Attacks
663 $ /gl/includes/db/gl_db_accounts.inc
664 /gl/includes/db/gl_db_account_types.inc
665 /gl/includes/db/gl_db_bank_accounts.inc
666 /gl/includes/db/gl_db_bank_trans.inc
667 /gl/includes/db/gl_db_bank_trans_types.inc
668 /gl/includes/db/gl_db_currencies.inc
669 /gl/includes/db/gl_db_trans.inc
671 18-Apr-2008 Janusz Dobrowolski
672 ! Modules admin and dimensions sealed against XSS attacks
673 $ /admin/payment_terms.php
674 /admin/shipping_companies.php
675 /admin/db/company_db.inc
676 /admin/db/maintenance_db.inc
677 /admin/db/users_db.inc
678 /admin/db/voiding_db.inc
679 /dimensions/includes/dimensions_db.inc
682 ! Modules includes, inventory and manufacturing sealed against XSS attacks
683 $ /includes/db/comments_db.inc
684 /includes/db/inventory_db.inc
685 /includes/db/references_db.inc
686 /inventory/includes/db/items_category_db.inc
687 /inventory/includes/db/items_db.inc
688 /inventory/includes/db/items_locations_db.inc
689 /inventory/includes/db/items_units_db.inc
690 /inventory/includes/db/movement_types_db.inc
691 /manufacturing/includes/db/work_centres_db.inc
692 /manufacturing/includes/db/work_orders_db.inc
693 /manufacturing/includes/db/work_orders_quick_db.inc
694 /manufacturing/includes/db/work_order_issues_db.inc
695 /manufacturing/includes/db/work_order_produce_items_db.inc
697 18-Apr-2008 Janusz Dobrowolski
698 ! Changed db_escape function to avoid XSS attacks via js db injection
699 $ /includes/db/connect_db.inc
700 # Database inserts/updates secured against js injection
701 $ /admin/db/maintenance_db.inc
702 /gl/includes/db/gl_db_accounts.inc
703 /purchasing/includes/db/po_db.inc
704 /sales/sales_order_entry.php
705 /sales/includes/db/sales_order_db.inc
708 # Bug in /includes/ui/ui_lists.inc:914. Sql clause was cut.
709 $ /includes/ui/ui_lists.inc
711 09-Apr-2008 Janusz Dobrowolski
712 # Fixed number formatting bug in standard cost update.
713 $ /inventory/cost_update.php
715 -------------------- 2,0 Beta - released ----------------------------
718 ! Changed install.html and update.html to fit the new unstable release 2.0
719 ! Changed demo sql script to fit the 2.0 unstable.
724 06-Apr-2008 Janusz Dobrowolski
725 # Sales invoice edition denied for documents created in FA 1.xx because of nonportable differences in gl posting/db schema.
726 /sales/customer_invoice.php
727 # Fixed typo causing error while adding new tax type.
731 # Fixed a bug when creating subfolder for new companies. Should be company id and not the table pref counter.
732 $ /admin/create_coy.php
735 # Removed annoying warnings in several reports.
737 /reporting/rep102.php
738 /reporting/rep104.php
739 /reporting/rep201.php
740 /reporting/rep203.php
741 /reporting/rep705.php
742 /reporting/rep706.php
743 /reporting/rep707.php
744 /reporting/rep709.php
745 /reporting/reports_main.php
746 /reporting/includes/pdf_report.inc
748 04-Apr-2008 Janusz Dobrowolski
749 # Javascript bugfix in selecting orders for template.
750 $ /sales/inquiry/sales_orders_view.php
753 ! Updated chart of accounts for release 2.0 unstable. Set the status to 2.0 Beta in config.php. Minor changes in update.html
754 + Preparing for download of release 2.0b on SourceForge.
760 02-Apr-2008 Janusz Dobrowolski
761 # Removed selector expansion on space key for multi-line selectors
763 ! Hiding search button in combo selectors for javascript enabled browsers
764 $ /includes/ui/ui_lists.inc
766 + Focus set to invalid form field after submit check fail
767 $ /admin/company_preferences.php
768 /admin/fiscalyears.php
770 /admin/payment_terms.php
771 /admin/shipping_companies.php
773 /admin/void_transaction.php
774 /dimensions/dimension_entry.php
775 /gl/bank_transfer.php
779 /gl/manage/bank_accounts.php
780 /gl/manage/bank_trans_types.php
781 /gl/manage/currencies.php
782 /gl/manage/exchange_rates.php
783 /gl/manage/gl_account_classes.php
784 /gl/manage/gl_account_types.php
785 /gl/manage/gl_accounts.php
786 /inventory/adjustments.php
787 /inventory/cost_update.php
788 /inventory/prices.php
789 /inventory/purchasing_data.php
790 /inventory/transfers.php
791 /inventory/manage/item_categories.php
792 /inventory/manage/item_units.php
793 /inventory/manage/items.php
794 /inventory/manage/locations.php
795 /inventory/manage/movement_types.php
796 /manufacturing/work_order_add_finished.php
797 /manufacturing/work_order_entry.php
798 /manufacturing/work_order_issue.php
799 /manufacturing/work_order_release.php
800 /manufacturing/manage/bom_edit.php
801 /manufacturing/manage/work_centres.php
802 /purchasing/po_entry_items.php
803 /purchasing/po_receive_items.php
804 /purchasing/supplier_credit.php
805 /purchasing/supplier_credit_grns.php
806 /purchasing/supplier_invoice.php
807 /purchasing/supplier_invoice_grns.php
808 /purchasing/supplier_payment.php
809 /purchasing/supplier_trans_gl.php
810 /purchasing/allocations/supplier_allocate.php
811 /purchasing/manage/suppliers.php
812 /sales/credit_note_entry.php
813 /sales/customer_credit_invoice.php
814 /sales/customer_delivery.php
815 /sales/customer_invoice.php
816 /sales/customer_payments.php
817 /sales/sales_order_entry.php
818 /sales/allocations/customer_allocate.php
819 /taxes/item_tax_types.php
820 /taxes/tax_groups.php
822 # Set default focus in update_db.php
825 29-Mar-2008 Janusz Dobrowolski
826 # Changed gl_all_accounts_list() API
827 $ /includes/ui/ui_lists.inc
828 + Enhanced list accessability in kbd usage via space key
831 28-Mar-2008 Janusz Dobrowolski
832 # Fixed headers for various display mode
833 $ /sales/inquiry/sales_orders_view.php
836 + Added print document options in inquiries.
837 $ /sales/inquiry/customer_inquiry.php
838 /sales/inquiry/sales_orders_view.php
839 /sales/inquiry/sales_deliveries_view.php
840 /purchasing/inquiry/po_search.php
841 /purchasing/inquiry/po_search_completed.php
844 # Fixed a minor bug in customers_db.inc (should include type == 2 - Bank Deposits)
845 $ /sales/includes/db/customers_db.inc
846 # Fixed a PHP vers. 5.xx bug. No need for & operator in function calls, only in declaration. Gives a warning.
847 $ /sales/includes/db/sales_credit_db.inc
848 # Fixed a wrong variabel declaration doc_Document_no to doc_Invoice_no
849 $ /reporting/includes/doctext.inc
850 /reporting/includes/doctext2.inc
851 # Fixed so Customer Balances and Aged Customer Analysis reports presents correct sign.
852 $ /reporting/rep101.php
853 /reporting/rep102.php
855 28-Mar-2008 Janusz Dobrowolski
856 # Layout/focus fixes for no_[customer/supplier/item]_list option on
857 $ /includes/ui/ui_lists.inc
858 /purchasing/includes/ui/po_ui.inc
859 /sales/credit_note_entry.php
860 /sales/sales_order_entry.php
861 /sales/includes/ui/sales_credit_ui.inc
862 /sales/includes/ui/sales_order_ui.inc
864 27-Mar-2008 Janusz Dobrowolski
865 + Automatic first field focus on page start, focus order preserved between form updates
866 $ /gl/inquiry/gl_account_inquiry.php
867 /includes/page/footer.inc
868 /includes/ui/ui_controls.inc
869 /includes/ui/ui_input.inc
870 /includes/ui/ui_lists.inc
871 /includes/ui/ui_view.inc
873 /sales/sales_order_entry.php
874 /sales/credit_note_entry.php
875 /sales/includes/ui/sales_credit_ui.inc
876 /sales/includes/ui/sales_order_ui.inc
877 + Data picker omitted in keyboard tabbing sequence (FF,IE, not old mozilla)
878 $ /includes/ui/ui_input.inc
879 ! Javascript recalcAccount() superseded by class='combo' behaviour binding
883 /gl/includes/ui/gl_deposit_ui.inc
884 /gl/includes/ui/gl_journal_ui.inc
885 /gl/includes/ui/gl_payment_ui.inc
886 /includes/ui/ui_view.inc
887 /purchasing/po_entry_items.php
888 /purchasing/includes/ui/po_ui.inc
889 /sales/sales_order_entry.php
890 /sales/includes/ui/sales_credit_ui.inc
891 /sales/includes/ui/sales_order_ui.inc
893 ! get_js_set_focus moved from ui_view (this is only standalone form).
895 # Fixed debit/credit entry check
897 # Restored GET/POST security check on path_to_root
900 26-Mar-2008 Janusz Dobrowolski
901 # Bug fixes in purchase module related to tax structure changes.
902 $ /purchasing/includes/supp_trans_class.inc
903 /purchasing/includes/db/invoice_db.inc
904 /purchasing/includes/db/invoice_items_db.inc
905 /purchasing/includes/ui/invoice_ui.inc
906 /reporting/rep105.php
908 25-Mar-2008 Janusz Dobrowolski
909 ! Per company pdf, backup and graphics directories in 'company' dir.
912 /company/0/images/ (new dir)
913 /company/0/images/102.jpg (moved from inventory/manage/image)
914 /company/0/images/103.jpg (moved from inventory/manage/image)
915 /company/0/images/104.jpg (moved from inventory/manage/image)
916 /company/0/images/logo_frontaccounting.jpg (moved from themes/default/images)
917 /company/0/images/logo_frontaccounting.png (moved from themes/default/images)
919 /admin/create_coy.php
920 /admin/db/maintenance_db.inc
922 /reporting/rep102.php
923 /reporting/rep104.php
924 /reporting/rep202.php
925 /reporting/rep303.php
926 /reporting/rep706.php
927 /reporting/rep707.php
928 /reporting/includes/pdf_report.inc
929 /inventory/manage/items.php
931 + jscript component caching (enables browser caching and future compression)
932 $ /includes/session.inc
934 /includes/page/header.inc
935 /includes/ui/ui_view.inc
936 /admin/display_prefs.php
939 - Removed obsolete file
940 $ /sales/includes/ui/print_invoice.inc
942 21-Mar-2008 Janusz Dobrowolski
943 ! Total Allocation/Left to Allocate update without page submit.
944 $ /includes/ui/ui_view.inc
945 /purchasing/allocations/supplier_allocate.php
946 /sales/allocations/customer_allocate.php
947 # Fixed unvisable under IE editbutton
948 $ /themes/aqua/default.css
949 /themes/cool/default.css
950 /themes/default/default.css
952 20-Mar-2008 Janusz Dobrowolski
953 # Excluding delivery notes from Customer Balances, removed warnings.
954 $ /reporting/rep101.php
955 # Divide by zero fix on order_price==0 in new supplier invoice
956 $ /purchasing/supplier_invoice_grns.php
957 # Database bug fix in new customer entry
958 $ /sales/manage/customers.php
959 # Small bug fix (warnings) in is_date() function.
960 $ /includes/date_functions.inc
962 18-Mar-2008 Janusz Dobrowolski
963 # Line items editor uses POST method - no disappearing shippment info.
964 $ /sales/credit_note_entry.php
965 /sales/sales_order_entry.php
966 /sales/includes/ui/sales_credit_ui.inc
967 /sales/includes/ui/sales_order_ui.inc
968 + Added edit_button_cell() function
969 $ /includes/ui/ui_controls.inc
970 + Helper function for finding indexed submit $_POST vars.
971 $ /includes/ui/ui_input.inc
972 + New class .editbutton for buttons. Default view is link alike.
973 $ /themes/aqua/default.css
974 /themes/cool/default.css
975 /themes/default/default.css
977 17-Mar-2008 Janusz Dobrowolski
978 # Added rounding when needed to avoid document non cosistent documents.
979 $ /includes/banking.inc
980 /purchasing/supplier_credit_grns.php
981 /purchasing/supplier_invoice_grns.php
982 /purchasing/includes/supp_trans_class.inc
983 /purchasing/includes/ui/invoice_ui.inc
984 /purchasing/includes/ui/po_ui.inc
985 /reporting/rep107.php
986 /reporting/rep109.php
987 /reporting/rep110.php
988 /reporting/rep209.php
989 /sales/includes/cart_class.inc
990 /sales/includes/ui/sales_credit_ui.inc
991 /sales/includes/ui/sales_order_ui.inc
992 /sales/view/view_credit.php
993 /sales/view/view_dispatch.php
994 /sales/view/view_invoice.php
995 /sales/view/view_sales_order.php
997 # Sign bug for customer transactions
998 $ /reporting/rep709.php
999 # Include file conflict fix
1000 $ /purchasing/includes/ui/invoice_ui.inc
1001 /gl/manage/bank_accounts.php
1002 /manufacturing/inquiry/where_used_inquiry.php
1003 /purchasing/manage/suppliers.php
1005 16-Mar-2008 Janusz Dobrowolski
1006 + Added javascript add-on for unobtrusive apply javascript handlers to html elements.
1009 + Added javascript source collecting functions
1010 $ /includes/main.inc
1011 ! Moved check_page_security(); for safe start in case of broken wa_current_user var.
1012 + Added global js code collecting arrays $js_lib, $js_static
1013 $ /includes/session.inc
1014 ! Changed get_js_user num to add_js_user_num; extended for percent/qty/price formatting
1015 $ /includes/ui/ui_view.inc
1016 + Added including javascript source colections from $js_lib, $js_static; conditional display for ajax calls
1017 $ /includes/page/footer.inc
1018 /includes/page/header.inc
1019 ! Added including of data_checks.inc
1021 + User side percent/exrate/qty/price input formatting via onblur handler.
1022 $ /admin/gl_setup.php
1024 /gl/manage/exchange_rates.php
1025 /includes/ui/ui_input.inc
1026 /inventory/purchasing_data.php
1027 /inventory/reorder_level.php
1028 /inventory/includes/item_adjustments_ui.inc
1029 /inventory/includes/stock_transfers_ui.inc
1030 /manufacturing/work_order_entry.php
1031 /manufacturing/manage/bom_edit.php
1032 /purchasing/po_entry_items.php
1033 /purchasing/po_receive_items.php
1034 /purchasing/supplier_credit.php
1035 /purchasing/supplier_credit_grns.php
1036 /purchasing/supplier_invoice_grns.php
1037 /purchasing/supplier_trans_gl.php
1038 /purchasing/allocations/supplier_allocate.php
1039 /purchasing/includes/ui/po_ui.inc
1040 /sales/customer_delivery.php
1041 /sales/customer_invoice.php
1042 /sales/allocations/customer_allocate.php
1043 /sales/includes/ui/sales_credit_ui.inc
1044 /sales/includes/ui/sales_order_ui.inc
1045 /taxes/tax_groups.php
1046 /taxes/tax_types.php
1048 14-Mar-2008 Janusz Dobrowolski
1049 + All forms fixed to accept user native numeric format.
1050 $ /admin/gl_setup.php
1051 /gl/bank_transfer.php
1056 /gl/includes/db/gl_db_banking.inc
1057 /gl/includes/ui/gl_deposit_ui.inc
1058 /gl/includes/ui/gl_journal_ui.inc
1059 /gl/includes/ui/gl_payment_ui.inc
1060 /gl/manage/exchange_rates.php
1061 /inventory/adjustments.php
1062 /inventory/cost_update.php
1063 /inventory/prices.php
1064 /inventory/purchasing_data.php
1065 /inventory/reorder_level.php
1066 /inventory/transfers.php
1067 /inventory/includes/item_adjustments_ui.inc
1068 /inventory/includes/stock_transfers_ui.inc
1069 /inventory/manage/item_units.php
1070 /manufacturing/work_order_entry.php
1071 /manufacturing/inquiry/where_used_inquiry.php
1072 /manufacturing/manage/bom_edit.php
1073 /purchasing/po_entry_items.php
1074 /purchasing/po_receive_items.php
1075 /purchasing/supplier_credit_grns.php
1076 /purchasing/supplier_invoice_grns.php
1077 /purchasing/supplier_payment.php
1078 /purchasing/supplier_trans_gl.php
1079 /purchasing/allocations/supplier_allocate.php
1080 /purchasing/includes/ui/po_ui.inc
1081 /purchasing/inquiry/po_search.php
1082 /sales/credit_note_entry.php
1083 /sales/customer_credit_invoice.php
1084 /sales/customer_delivery.php
1085 /sales/customer_invoice.php
1086 /sales/customer_payments.php
1087 /sales/sales_order_entry.php
1088 /sales/allocations/customer_allocate.php
1089 /sales/includes/ui/sales_credit_ui.inc
1090 /sales/includes/ui/sales_order_ui.inc
1091 /sales/manage/customers.php
1092 /sales/manage/sales_people.php
1093 /sales/view/view_credit.php
1094 /sales/view/view_dispatch.php
1095 /sales/view/view_invoice.php
1096 /sales/view/view_receipt.php
1097 /sales/view/view_sales_order.php
1098 /taxes/item_tax_types.php
1099 /taxes/tax_groups.php
1100 /taxes/tax_types.php
1101 + User format functions for percent/price/exrate amounts display.
1102 $ /includes/current_user.inc
1103 + Input checking functions for numeric input fields in user native format
1104 $ /includes/data_checks.inc
1105 + Numeric input fields in user native format
1106 $ /includes/ui/ui_input.inc
1107 + Javascript function for conversion to/from user native numeric format.
1108 $ /includes/ui/ui_view.inc
1109 + New class amount for numeric input
1110 $ /themes/aqua/default.css
1111 /themes/cool/default.css
1112 /themes/default/default.css
1113 # Removed warning on adding component
1114 /manufacturing/manage/bom_edit.php
1115 # Quantity display correction
1116 /manufacturing/inquiry/where_used_inquiry.php
1117 # Fixed add_customer_trans() call
1118 /gl/includes/db/gl_db_banking.inc
1120 12-Mar-2008 Joe Hung
1121 + Added update of Units of Measure and converting of deptor_trans records from release 1.XX
1122 - Removed default insertion of Units of Measure. Not neccessary.
1124 /admin/db/maintenance_db.inc (added support for update)
1126 11-Mar-2008 Janusz Dobrowolski
1127 + Table of measure moved into new table item_units
1128 ! Removed $themes[] from config.php, theme list based on directory structure
1130 /includes/ui/ui_lists.inc
1131 /applications/inventory.php
1132 /inventory/includes/inventory_db.inc
1133 /inventory/includes/db/items_units_db.inc
1134 /inventory/manage/item_units.php
1135 /inventory/manage/items.php
1138 11-Mar-2008 Joe Hunt
1139 # Small fix for alignment of date and due date label fields in customer_invoice.php and customer_delivery.php
1140 $ /sales/customer_invoice.php
1141 /sales/customer_delivery.php
1143 10-Mar-2008 Joe Hunt
1144 # Small fix for Template Invoice in sales_order_entry.php on line 363 (duedate for Invoice).
1145 $ /sales/sales_order_entry.php
1147 10-Mar-2008 Janusz Dobrowolski
1148 + Added price list selector to sales entry (debtor_master gives only default one)
1149 + Added optional submit_on_change parameter to sales ui lists
1150 $ /includes/ui/ui_lists.inc
1151 /sales/sales_order_entry.php
1152 /sales/includes/ui/sales_credit_ui.inc
1153 /sales/includes/ui/sales_order_ui.inc
1154 # Additional PHP5 fixes, do_clone superseded by local ? : constructs
1155 $ /sales/includes/cart_class.inc
1156 /includes/ui/ui_view.inc
1157 /sales/includes/sales_db.inc
1158 # Fixed bogus sales_type lists in edition mode
1159 $ /sales/customer_delivery.php
1160 /sales/customer_invoice.php
1161 # Smaller fixes, cart_class.sales_type name change
1162 $ /sales/includes/ui/sales_credit_db.inc
1163 /sales/credit_note_entry.php
1164 /sales/customer_credit_invoice.php
1165 /sales/includes/cart_class.inc
1166 /sales/includes/db/sales_credit_db.inc
1167 /sales/includes/db/sales_delivery_db.inc
1168 /sales/includes/db/sales_invoice_db.inc
1169 /sales/includes/db/sales_order_db.inc
1170 /sales/includes/ui/sales_credit_ui.inc
1171 # One another pmWiki name conflict removed
1172 $ /admin/display_prefs.php
1174 09-Mar-2008 Joe Hunt
1175 - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
1176 $ /dimensions/includes/dimensions_db.inc
1177 /gl/includes/db/gl_db_banking.inc
1179 /inventory/includes/db/items_adjust_db.inc
1180 /manufacturing/includes/db/work_order_issues_db.inc
1181 /manufacturing/includes/db/work_order_produce_items_db.inc
1182 /manufacturing/includes/db/work_orders_db.inc
1183 /manufacturing/includes/db/work_orders_quick_db.inc
1184 /purchasing/includes/db/grn_db.inc
1185 /purchasing/includes/db/po_db.inc
1186 /purchasing/includes/db/supp_payment_db.inc
1187 /reporting/includes/form_types.inc (File removed)
1188 /sales/includes/db/sales_delivery_db.inc
1189 /sales/includes/db/sales_invoice_db.inc
1190 /sales/includes/db/sales_order_db.inc
1192 # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
1193 $ /reporting/rep101.php
1194 /reporting/rep201.php
1195 # clone replacement do_clone() for both PHP 4 and PHP 5.
1196 $ /includes/ui/ui_view.inc (at the very bottom)
1197 /sales/includes/cart_class.inc
1199 07-Mar-2008 Janusz Dobrowolski
1200 ! Changed name tax type uniqueness constraint to (name, rate)
1201 $ /includes/ui/ui_lists.inc
1202 /taxes/items_tax_types.php
1203 ! Tax included option moved from tax_group to sales_types table
1204 $ includes/ui/ui_view.inc
1205 /purchasing/includes/ui/invoice_ui.inc
1207 /taxes/tax_groups.php
1208 /taxes/db/tax_groups_db.inc
1210 # Final rewriting of sales module, a lot of bugfixes.
1211 + Template delivery/invoicing
1212 + Concurrent document editing control on sql level
1213 + Most of sales documents are now editable
1214 + Some links to print documents after entry
1215 ! Changed javascript helper function for customer allocations
1216 $ /applications/customers.php
1217 /includes/ui/ui_input.inc
1218 /reporting/rep107.php
1219 /reporting/rep109.php
1220 /reporting/rep110.php
1221 /sales/credit_note_entry.php
1222 /sales/customer_credit_invoice.php
1223 /sales/customer_delivery.php
1224 /sales/customer_invoice.php
1225 /sales/customer_payments.php
1226 /sales/sales_order_entry.php
1227 /sales/allocations/customer_allocate.php
1228 /sales/allocations/customer_allocation_main.php
1229 /sales/includes/cart_class.inc
1230 /sales/includes/sales_db.inc
1231 /sales/includes/sales_ui.inc
1232 /sales/includes/db/cust_trans_db.inc
1233 /sales/includes/db/cust_trans_details_db.inc
1234 /sales/includes/db/custalloc_db.inc
1235 /sales/includes/db/customers_db.inc
1236 /sales/includes/db/payment_db.inc
1237 /sales/includes/db/sales_credit_db.inc
1238 /sales/includes/db/sales_delivery_db.inc
1239 /sales/includes/db/sales_invoice_db.inc
1240 /sales/includes/db/sales_order_db.inc
1241 /sales/includes/db/sales_types_db.inc
1242 /sales/includes/ui/print_invoice.inc
1243 /sales/includes/ui/sales_credit_ui.inc
1244 /sales/includes/ui/sales_order_ui.inc
1245 /sales/inquiry/customer_allocation_inquiry.php
1246 /sales/inquiry/customer_inquiry.php
1247 /sales/inquiry/sales_deliveries_view.php
1248 /sales/inquiry/sales_orders_view.php
1249 /sales/manage/credit_status.php
1250 /sales/manage/sales_types.php
1251 /sales/view/view_credit.php
1252 /sales/view/view_dispatch.php
1253 /sales/view/view_invoice.php
1254 /sales/view/view_receipt.php
1255 /sales/view/view_sales_order.php
1256 # Removed function name conflict with wiki help system
1257 /includes/lang/language.php
1259 06-Mar-2008 Janusz Dobrowolski
1260 + Wiki help links integration
1262 /includes/page/header.inc
1263 /includes/lang/language.php
1264 + Optional debuging with xdebug module
1266 /includes/db/connect_db.inc
1267 ! Concurrent edition fix
1268 $ /includes/systypes.inc
1270 $ /manufacturing/manage/bom_edit.php
1272 $ /themes/aqua/renderer.php
1273 /themes/cool/renderer.php
1274 /themes/default/renderer.php
1275 # Removed warning about nonexistent $_GET variable
1276 $ /dimensions/inquiry/search_dimensions.php
1277 # MySQL 3.xx CAST bug fix
1278 $ /includes/db/manufacturing_db.inc
1279 /manufacturing/includes/db/work_order_requirements_db.inc
1280 /manufacturing/inquiry/where_used_inquiry.php
1282 04-Mar-2008 Joe Hunt
1283 ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
1284 Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
1285 $ /inventory/cost_update.php
1286 /purchasing/includes/db/grn_db.inc and
1287 /manufacturing/manage/bom_edit.php.
1288 /manufacturing/includes/db/work_orders_db.inc
1289 /manufacturing/includes/db/work_orders_quick_db.inc
1290 /manufacturing/work_order_entry.php
1292 21-Feb-2008 Joe Hunt
1293 + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
1294 $ /admin/view_print_transaction.php
1295 /applications/setup.php
1297 17-Feb-2008 Joe Hunt
1298 ! Minor change in menu and function in view_print_transaction.php
1299 $ /admin/view_print_transaction.php
1300 /application/setup.php
1301 + Preparing for print of single documents
1302 $ /reporting/includes/reporting.inc
1303 ! Removing 'out' field in table tax_types
1305 /taxes/tax_types.php
1306 /taxes/db/tax_types_db.inc
1307 + Added 2 functions in ui_input.inc, button and button_cell
1308 /includes/ui/ui_input.inc
1310 11-Feb-2008 Joe Hunt
1311 + Added file, update_db.php, for updating company databases from an SQL script.
1312 $ update_db.php (New file)
1315 06-Fef-2008 Joe Hunt
1316 + Added Report, Salesman Listing, rep106.php.
1317 $ /reporting/reports_main.php
1318 /reporting/rep106.php
1320 06-Feb-2008 Janusz Dobrowolski
1321 + Separation of customer invoice issue and goods delivery.
1322 + Batch invoicing for more than one delivery
1323 # Corrected inadequate shipping tax calculations.
1324 ! Default debugging status changed to off.
1325 $ /taxes/tax_calc.inc
1326 /taxes/db/tax_groups_db.inc
1327 /admin/db/voiding_db.inc
1328 /applications/customers.php
1329 /includes/systypes.inc
1331 /includes/ui/ui_controls.inc
1332 /includes/ui/ui_lists.inc
1333 /includes/ui/ui_view.inc
1334 /inventory/inquiry/stock_status.php
1335 /reporting/rep105.php
1336 /reporting/rep107.php
1337 /reporting/rep109.php
1338 /reporting/rep110.php
1339 /reporting/rep209.php
1340 /reporting/reports_main.php
1341 /reporting/includes/doctext.inc
1342 /reporting/includes/doctext2.inc
1343 /reporting/includes/form_types.inc
1344 /reporting/includes/pdf_report.inc
1345 /reporting/includes/reports_classes.inc
1346 /sales/customer_credit_invoice.php
1347 /sales/customer_invoice.php
1348 /sales/sales_order_entry.php
1349 /sales/customer_delivery.php
1350 /sales/includes/db/sales_delivery_db.inc
1351 /sales/includes/ui/print_invoice.inc
1352 /sales/includes/cart_class.inc
1353 /sales/includes/sales_db.inc
1354 /sales/includes/db/cust_trans_db.inc
1355 /sales/includes/db/cust_trans_details_db.inc
1356 /sales/includes/db/sales_credit_db.inc
1357 /sales/includes/db/sales_invoice_db.inc
1358 /sales/includes/db/sales_order_db.inc
1359 /sales/includes/ui/sales_order_ui.inc
1360 /sales/inquiry/customer_allocation_inquiry.php
1361 /sales/inquiry/customer_inquiry.php
1362 /sales/inquiry/sales_orders_view.php
1363 /sales/inquiry/sales_deliveries_view.php
1364 /sales/view/view_dispatch.php
1365 /sales/view/view_invoice.php
1366 /sales/view/view_sales_order.php
1370 01-Feb-2008 Joe Hunt
1371 ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
1372 $ /sales/includes/cart_class.inc
1373 /sales/includes/db/sales_credit_db.inc
1374 /sales/includes/db/sales_invoice_db.inc
1375 /sales/includes/db/sales_order_db.inc
1376 /sales/includes/db/cust_trans_details_db.inc
1377 /sales/includes/ui/sales_order_ui.inc
1378 /sales/includes/ui/sales_credit_ui.inc
1379 /sales/credit_note_entry.php
1380 /sales/customer_credit_invoice.php
1381 /sales/sales_order_entry.php
1382 /sales/customer_invoice.php
1384 31-Jan-2008 Joe Hunt
1385 ! New Release 2.0 Pre Alpha
1387 # Fixed a release 2 related bug in create_coy.php
1388 $ /admin/create_coy.php
1389 + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
1390 and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
1391 with these databases changes without any new files. They are coming as soon as possible.
1392 $ /sql/alter.sql (New file)
1393 # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
1395 $ /purchasing/supplier_trans_gl.php
1396 /purchasing/includes/db/invoice_items_db.inc
1397 ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
1398 $ /includes/ui/ui_lists.inc
1399 /purchasing/includes/ui/po_ui.inc
1400 /sales/includes/ui/sales_order_ui.inc
1401 /admin/company_preferences.php
1402 /admin/db/company_db.inc
1404 + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql.
1405 Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
1406 $ /sales/manage/sales_people.php
1407 /includes/ui/ui_input.inc
1409 -------------------- 2,0 Pre Alpha - above ----------------------------
1410 31-Jan-2008 Janusz Dobrowolski
1411 # Minor bugfix in db_import()
1412 $ /admin/db/maintenance_db.inc
1414 30-Jan-2008 Janusz Dobrowolski
1415 # Minor display fix in tax_types.php
1416 $ /taxes/tax_types.php
1417 ! Format cleanup on some files.
1418 $ /gl/includes/gl_db.inc
1419 /gl/includes/gl_ui.inc
1420 /applications/application.php
1424 -------------------- 1.16 Stable Released ----------------------
1425 28-Jan-2008 Joe Hunt
1426 + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
1427 The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list
1428 and $no_supplier_list. Default is the normal behavior for all listboxes.
1429 $ /includes/ui/ui_lists.inc
1430 /sales/includes/ui/sales_orders_ui.inc
1431 /purchases/includes/ui/po_ui.inc
1432 /themes/default/images/locate.png (New file)
1435 + Added ALTER TABLE possibility in db_import. For future releases.
1436 $ /admin/db/maintenence_db.inc
1438 # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
1439 # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
1440 $ /includes/db/connect_db.inc
1441 /includes/ui/ui_lists.inc
1442 /includes/page/header.inc
1445 16-Jan-2008 Joe Hunt
1446 # When login screen is displayed after session timeout page content is broken. It
1447 is because of NOT using absolute paths in href attribute theme elements.
1450 30-Dec-2007 Joe Hunt
1451 # Minor adjustments in function db_export on line 325
1452 $ /admin/db/maintenance_db.inc
1454 29-Dec-2007 Joe Hunt
1455 + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
1458 # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
1459 Also fixed a unneccessary str_replace when importing sql scripts.
1460 ! Changed the PDF presentation to deleting the Javascript cache before presentation.
1461 $ /admin/db/maintenance_db.inc
1462 /reporting/includes/pdf_report.inc
1464 13-Dec-2007 Joe Hunt
1465 # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
1466 $ /gl/inquiry/gl_trial_balance.php
1467 /gl/inquiry/gl_account_inquiry.php
1469 13-Dec-2007 Joe Hunt
1470 # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
1471 $ /admin/db/voiding_db.inc
1473 06-Dec-2007 Joe Hunt
1474 # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
1475 $ /gl/gl_payment.php
1476 /gl/includes/ui/gl_payment_ui.inc
1478 ! Changed $loc_notification to be set to 0 instead of 1.
1481 -------------------- 1.15 Stable Released ----------------------
1482 05-Dec-2007 Joe Hunt
1483 + Added email notification to stock location when available stock is below reorder level
1485 /sales/includes/db/sales_order_db.inc
1487 # Fixed bugs in Open balances when account is not a balance account
1488 $ /gl/inquiry/gl_trial_balance.php
1489 /gl/inquiry/gl_account_inquiry.php
1490 /reporting/rep704.php
1491 /reporting/rep708.php
1493 -------------------- 1.14 Stable Released ----------------------
1494 01-Oct-2007 Joe Hunt
1495 ! Major change in the installation of modules to also accept an SQL-file for upload.
1497 /admin/inst_module.php
1498 /admin/db/maintenance_db.inc
1500 30-Sep-2007 Joe Hunt
1501 # The following files were still vulnerable. Fixed
1503 /includes/lang/language.php
1505 -------------------- 1.13 Stable Released ----------------------
1506 14-Sep-2007 Joe Hunt
1507 + Added optional link for electronic payment on invoices (PayPal).
1508 ! Better support for install/update languages.
1510 # Fixed a vulnerable item in config.php
1513 14-Sep-2007 Joe Hunt
1514 # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
1515 # config.php has been vulnerable. Fixed.
1516 $ /admin/inst_lang.php
1519 10-Sep-2007 Joe Hunt
1520 ! Changed Bank Address field from text to textarea (multirows)
1521 $ /gl/manage/bank_accounts.php
1523 06-Sep-2007 Joe Hunt
1524 + Added optional link for electronic payment on invoices (PayPal)
1525 $ /reporting/reports_main.php
1526 /reporting/rep107.php
1527 /reporting/includes/report_classes.inc
1528 /reporting/includes/pdf_report.inc
1529 /reporting/includes/doc_text.inc
1530 /reporting/includes/doc_text2.inc
1532 23-Aug-2007 Joe Hunt
1533 # Unnecessary parameter ($db) in check_for_recursive_bom
1534 $ /manufacturing/manage/bom_edit.php
1536 21-Aug-2007 Joe Hunt
1537 # Bug in /includes/lang/gettext.php (249) affecting changing language!
1538 $ /includes/lang/gettext.php
1540 08-Aug-2007 Joe Hunt
1544 /admin/create_coy.php
1545 /reporting/includes/pdf_report.inc
1547 04-Aug-2007 Joe Hunt
1548 + Added a default fiscal year in the en_US-new.sql and start references.
1549 $ /sql/en_US-new.sql
1550 ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
1551 $ /lang/en_US/LC_MESSAGES/en_US.mo
1553 03-Aug-2007 Joe Hunt
1554 # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
1555 $ /sales/includes/db/sales_order_db.inc
1557 23-Jul-2007 Joe Hunt
1558 # Changed <? in front of 2 files to <?php.
1559 $ /purchasing/includes/purchasing_ui.inc
1560 /reporting/includes/class.mail.inc
1562 -------------------- 1.12 Stable Released ----------------------
1563 21-Jul-2007 Joe Hunt
1564 + Added option to handle Jalali and Islamic Calendars
1567 /gl/includes/db/gl_db_trans.inc
1568 /includes/date_functions.inc
1569 /includes/ui/ui_input.inc
1570 /includes/ui/ui_lists.inc
1571 /includes/ui/ui_view.inc
1572 /purchasing/po_receive_items.php
1573 /purchasing/includes/ui/invoice_ui.inc
1574 /purchasing/includes/ui/po_ui.inc
1575 /reporting/rep705.php
1576 /sales/includes/db/sales_order_db.inc
1577 /sales/includes/ui/sales_order_ui.inc
1579 20-Jul-2007 Joe Hunt
1580 ! Changed parameters on report Sales Order. Option to print as Quote.
1581 $ /reporting/reports_main.php
1582 /reporting/rep109.php
1583 /reporting/includes/pdf_report.inc
1584 /reporting/includes/doctext.inc
1585 /reporting/includes/doctext2.inc
1587 19-Jul-2007 Joe Hunt
1588 + Added Budget Entry in General Ledger. Includes Dimensions.
1590 /applications/generalledger.php
1591 /gl/gl_budget.php (New File!)
1592 /gl/includes/db/gl_db_trans.inc
1593 /includes/date_functions.inc
1594 /reporting/report_classes.inc
1596 -------------------- 1.11 Stable Released ----------------------
1597 04-Jul-2007 Joe Hunt
1598 ! Option for using alpha numeric chart of accounts.
1600 /gl/manage/gl_accounts.php
1601 /gl/includes/db/gl_db_accounts.inc
1602 /gl/includes/db/gl_db_bank_trans.inc
1603 /gl/includes/db/gl_db_trans.inc
1604 /gl/inquiry/gl_trial_balance.inc
1605 /admin/db/company_db.inc
1606 /inventory/includes/db/items_db.inc
1607 /sales/manage/customer_branches.inc
1609 04-Jul-2007 Joe Hunt
1610 # Problems retrieving language texts for poEdit in long javascripts
1611 $ /includes/ui/ui_view.inc
1613 04-May-2007 Joe Hunt
1614 # Database error when updating more than one item row in Sales Orders.
1615 $ /sales/includes/db/sales_order_db.inc
1616 # Database error when inserting work order issues. Fixed.
1617 $ /manufacturing/includes/db/work_order_issues_db.inc
1619 03-May-2007 Joe Hunt
1620 # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
1621 $ /includes/db/manufacturing_db.inc
1622 /manufacturing/includes/db/work_order_requirements_db.inc
1624 02-May-2007 Joe Hunt
1625 # Missing details on Purchase Order when emailing and printing
1626 $ /reporting/rep209.php
1628 -------------------- 1.1 Stable Released ----------------------
1629 02-May-2007 Joe Hunt
1630 + Enabled module addons and all the below bugfixes. No changes in database structure.
1631 - Removed /sql/basic.sql (included in the other sql files)
1632 - Removed /themes/default/images/left.gif and /themes/default/images/right.gif
1633 (not needed anymore).
1634 + Addition of update.html
1635 $ /admin/inst_module.php (New file!)
1636 /applications/customers.php
1637 /applications/dimensions.php
1638 /applications/generalledger.php
1639 /applications/inventory.php
1640 /applications/manufacturing.php
1641 /applications/setup.php
1642 /applications/suppliers.php
1645 /modules/inst_modules.php (New folder and new file!)
1646 /modules/index.php (New file!)
1650 update.html (New file!)
1652 01-May-2007 Joe Hunt
1653 # Missing measure of units when printing sales orders
1654 # Update of Sales People caused a database error
1655 $ /sales/manage/sales_people.php
1656 /reporting/rep109.php
1658 30-Apr-2007 Joe Hunt
1659 + The selected menu tab is now shown with same background as hover color.
1660 $ config.php (default tab line 77. Change if you want)
1661 /includes/page/header.inc
1663 28-Apr-2007 Joe Hunt
1664 # When saving work order entries a lot of debug boxes appeared. Fixed
1665 # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
1666 # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
1667 $ /includes/db/manufacturing_db.inc
1668 /manufacturing/work_order_entry.php
1669 /manufacturing/includes/work_order_issue_ui.inc
1670 /manufacturing/includes/db/work_order_requirements_db.inc
1671 /manufacturing/includes/db/work_orders_quick_db.inc
1672 /manufacturing/inquiry/where_used_inquiry.php
1674 25-Apr-2007 Joe Hunt
1675 # Missing Date Picker
1676 $ /sales/customer_invoice.php
1677 # No JS popup window
1678 $ /sales/view/view_invoice.php
1680 24-Apr-2007 Joe Hunt
1681 ! New and better Date Picker, better cool theme.
1682 $ /includes/ui/ui_input.inc
1683 /includes/ui/ui_view.inc
1684 /reporting/includes/reports_classes.inc
1685 /themes/cool/default.css
1687 -------------------- 1.0.1 Stable Released ----------------------
1688 23-Apr-2007 Joe Hunt
1689 ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
1690 the changes for selection lists customers/suppliers and the Audit Trail.
1692 22-Apr-2007 Joe Hunt
1693 ! Changed the two selection lists for customers/suppliers in reports to a single one with
1695 ! Changed the sort order in these selection lists from id to name.
1696 + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
1697 $ /reporting/reports_main.php
1698 /reporting/rep101.php
1699 /reporting/rep102.php
1700 /reporting/rep201.php
1701 /reporting/rep202.php
1702 /reporting/rep203.php
1703 /reporting/rep204.php
1704 /reporting/includes/reports_classes.inc
1705 /includes/ui/ui_lists.inc
1706 /gl/includes/db/gl_db_trans.inc
1709 22-Apr-2007 Joe Hunt
1710 + Date Picker for all date fields.
1712 /admin/fiscalyears.php
1713 /admin/void_transaction.php
1714 /includes/ui/ui_view.inc
1715 /includes/ui/ui_input.inc
1716 /dimensions/dimension_entry.php
1717 /dimensions/inquiry/search_dimensions.php
1721 /gl/bank_transfer.php
1722 /gl/inquiry/bank_inquiry.php
1723 /gl/inquiry/gl_account_inquiry.php
1724 /gl/inquiry/gl_trial_balance.php
1725 /gl/manage/exchange_rates.php
1726 /inventory/adjustments.php
1727 /inventory/transfers.php
1728 /inventory/inquiry/stock_movements.php
1729 /inventory/manage/items.php
1730 /manufacturing/work_order_add_finished.php
1731 /manufacturing/work_order_entry.php
1732 /manufacturing/work_order_issue.php
1733 /manufacturing/work_order_release.php
1734 /purchasing/supplier_payment.php
1735 /purchasing/po_entry_items.php
1736 /purchasing/po_receive_items.php
1737 /purchasing/supplier_credit.php
1738 /purchasing/supplier_credit_grns.php
1739 /purchasing/supplier_invoice.php
1740 /purchasing/supplier_invoice_grns.php
1741 /purchasing/supplier_trans_gl.php
1742 /purchasing/includes/ui/po_ui.inc
1743 /purchasing/inquity/po_search.php
1744 /purchasing/inquiry/po_search_completed.php
1745 /purchasing/inquiry/supplier_allocation_inquiry.php
1746 /purchasing/inquiry/supplier_inquiry.php
1747 /reporting/reports_main.php
1748 /reporting/includes/reports_classes.inc
1749 /sales/credit_note_entry.php
1750 /sales/customer_credit_invoice.php
1751 /sales/customer_payments.php
1752 /sales/sales_order_entry.php
1753 /sales/includes/ui/sales_order_ui.inc
1754 /sales/inquiry/customer_allocation_inquiry.php
1755 /sales/inquiry/customer_inquiry.php
1756 /sales/inquiry/sales_orders_view.php
1758 /themes/default/images/cal.gif
1759 /themes/default/images/next.gif
1760 /themes/default/images/prev.gif
1762 19-Apr-2007 Joe Hunt
1763 # Bug no 1703895, Account numbers are varchars, need quotes, fixed
1764 # Bug no 1703891, Reserved MySQL words used as column names, fixed
1765 $ /taxes/db/tax_types_db.inc
1767 # Bug no 1703888, Apostrophes and other unescaped characters, fixed
1768 $ /gl/manage/gl_accounts.php
1769 /gl/includes/db/gl_db_accounts.inc
1770 /includes/ui/ui_input.inc
1772 18-Apr-2007 Joe Hunt
1773 # Bug no 1702594, Logon Loop, fixed
1776 -------------------- 1.0a Stable Released ----------------------
1777 10-Apr-2007 Joe Hunt
1778 ! Release 1.0a established on SourceForge, fixing the bugs.
1780 11-Apr-2007 Joe Hunt
1781 # Bug No 1698214, Creating Items, fixed
1782 $ /includes/ui/ui_lists.inc
1783 # Bug no 1698216, Item Movements, fixed
1784 $ /inventory/manage/items.php
1786 -------------------- 1.0 Stable Released ----------------------
1787 10-Apr-2007 Joe Hunt
1788 ! Release 1.0 established on SourceForge.
1790 2. Copyright and disclaimer
1791 ---------------------------
1792 This application is opensource software released under the GPL. Please
1793 see source code and the LICENSE file