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