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