Removed some warnings and madeAudit Trail report MySql 3.23 compatible.
[fa-stable.git] / CHANGELOG.txt
index faa44470b15d3fb873b6f58c165f306e23ec60a1..48bc5722cb4c2692e42d2591d0953457eb4a04ef 100644 (file)
@@ -18,7 +18,498 @@ Legend:
 - -> Removed
 ! -> Note
 $ -> Affected files
-       
+
+15-Jul-2009 Joe Hunt
+! Replaced sys_types names from table to systypes::name in reports
+  Now the English names in table are never used in inquiries or reports
+$ /reporting/rep101.php
+  /reporting/rep102.php
+  /reporting/rep108.php
+  /reporting/rep201.php
+  /reporting/rep202.php
+  /reporting/rep203.php
+  /reporting/rep709.php
+  /sql/alter2.2.sql
+! Audit-Trail report (systypes selector should include all systypes, extra parameter to function dup_systypes_list.
+$ /reporting/rep710.php
+  /reporting/reports_main.php
+  /reporting/includes/reports_classes.inc
+# Removed warning from COA report
+$ /gl/includes/db/gl_db_accounts.inc
+  /includes/date_functions.inc
+  /reporting/rep701.php
+  
+13-Jul-2009 Joe Hunt
++ Added Audit Trail Report
+$ /reporting/rep710.php (new file)
+$ /reporting/reports_main.php
+! Changed so $page_security works with reports (displays an error message on top)
+$ /reporting/includes/pdf_report.inc
+  /reporting/includes/excel_report.inc
+  
+10-Jul-2009 Janusz Dobrowolski
++ Added direct allocations in payments.
+$ /purchasing/supplier_payment.php
+  /sales/customer_payments.php
+! Allocations related code reuse.
+$ /includes/ui/allocation_cart.inc
+  /purchasing/allocations/supplier_allocate.php
+  /sales/allocations/customer_allocate.php
+
+02-Jul-2009 Joe Hunt
+! Always show 0.00 in debit column when using display_debit_or_credit
+$ /includes/ui/ui_view.inc
+
+01-Jul-2009 Joe Hunt
+! Small adjustment in /inventory/prices.php to see the calculated prices if they are set.
+$ /inventory/prices.php
+# Small bug/layout fixes
+$ /inventory/manage/item_categories.php
+  /inventory/manage/locations.php
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+
+30-Jun-2009 Joe Hunt
+# Small annoying bug-fixes in items.php and items_trans_db.inc
+$ /inventory/manage/items.php
+  /inventory/includes/db/items_trans_db.inc
+  
+30-Jun-2009 Joe Hunt
++ Implemented automatic price calculation of items from std. cost.
+$ /admin/company_preferences.php
+  /admin/db/company_db.inc
+  /doc/calculate_price.txt (new file)
+  /sales/includes/sales_db.inc
+  /sql/alter2.2.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  
+29-Jun-2009 Joe Hunt
+! Small layout improments in Customer Payments
+$ /sales/customer_payments.php
+
+28-Jun-2009 Joe Hunt
+# Fixed link bugs in sales order entry and optimized a couple of functions in ui_controls.inc
+$ /includes/ui/ui_controls.inc
+  /sales/sales_order_entry.php
+  
+27-Jun-2009 Joe Hunt
+# Corrections to default COAs.
+$ /sql/alter2.2.sql
+  /sql/en_US-new.sql
+  /sql/en_US-demo.sql
+  
+26-Jun-2009 Joe Hunt
++ Added Print of Work Order and GRN Valuation Report
+# Small bug in company preferences
+$ /admin/company_preferences.php
+  /manufacturing/includes/db/work_orders_db.inc
+  /manufacturing/work_order_entry.php
+  /reporting/rep305.php (new file)
+  /reporting/rep409.php (new file)
+  /reporting/reports_main.php
+  /reporting/includes/doctext.inc
+  /reporting/includes/doctext2.inc
+  /reporting/includes/header2.inc
+  /reporting/includes/pdf_report.inc
+  /reporting/includes/reports_classes.inc
+  
+26-Jun-2009 Joe Hunt
++ Added Bank Charge field to Customer Payment, Supplier Payment and Bank Transfer and a new default bank charge account in gl_setup.
+$ /admin/gl_setup.php
+  /admin/db/company_db.inc
+  /gl/bank_transfer.php
+  /gl/includes/db/gl_db_banking.inc
+  /purchasing/supplier_payment.php
+  /purchasing/includes/db/supp_payment_db.inc
+  /sales/customer_payment.php
+  /sales/includes/db/payment_db.inc
+  /sql/alter2.2.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  
+25-Jun-2009 Joe Hunt
+! Changed balance_sheet field in account class to ctype and fixed class editing.
+# Parse error in ui_lists.inc. Masked include_once(/validation.inc) in main.inc.
+$ /admin/fiscalyears.php
+  /gl/includes/db/gl_db_accounts.inc
+  /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_trans.inc
+  /gl/manage/gl_account_classes.php
+  /includes/main.inc
+  /includes/ui/ui_lists.inc
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  /sql/alter2.2.sql
+  
+25-Jun-2009 Janusz Dobrowolski
+! Merged changes from main trunk  2.1.2-2.1.3 (see below)
+$ /admin/backups.php
+  /admin/company_preferences.php
+  /admin/view_print_transaction.php
+  /applications/setup.php
+  /config.php
+  /dimensions/inquiry/search_dimensions.php
+  /gl/gl_journal.php
+  /gl/includes/db/gl_db_accounts.inc
+  /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_trans.inc
+  /gl/includes/ui/gl_bank_ui.inc
+  /gl/inquiry/gl_trial_balance.php
+  /gl/inquiry/tax_inquiry.php
+  /gl/manage/gl_account_classes.php
+  /includes/data_checks.inc
+  /includes/db/manufacturing_db.inc
+  /includes/errors.inc
+  /includes/main.inc
+  /includes/references.inc
+  /includes/session.inc
+  /includes/types.inc
+  /includes/ui/db_pager_view.inc
+  /includes/ui/ui_lists.inc
+  /includes/ui/ui_view.inc
+  /inventory/inquiry/stock_status.php
+  /inventory/manage/items.php
+  /inventory/manage/locations.php
+  /inventory/manage/sales_kits.php
+  /inventory/prices.php
+  /inventory/purchasing_data.php
+  /lang/new_language_template/LC_MESSAGES/empty.po
+  /manufacturing/includes/db/work_orders_db.inc
+  /manufacturing/includes/db/work_orders_produce_items_db.inc
+  /manufacturing/includes/db/work_orders_quick_db.inc
+  /manufacturing/includes/manufacturing_ui.inc
+  /manufacturing/inquiry/bom_cost_inquiry.php
+  /manufacturing/manage/bom_edit.php
+  /manufacturing/search_work_orders.php
+  /manufacturing/view/work_order_view.php
+  /manufacturing/work_order_add_finished.php
+  /manufacturing/work_order_costs.php (new file)
+  /manufacturing/work_order_entry.php
+  /manufacturing/work_order_issue.php
+  /manufacturing/work_order_release.php
+  /purchase/po_receive_items.php
+  /purchasing/allocations/supplier_allocation_main.php
+  /purchasing/includes/db/grn_db.inc
+  /purchasing/includes/db/invoice_db.inc
+  /purchasing/includes/db/po_db.inc
+  /purchasing/includes/purchasing_db.inc
+  /purchasing/includes/ui/po_ui.inc
+  /purchasing/inquiry/po_search_completed.php
+  /purchasing/inquiry/supplier_inquiry.php
+  /purchasing/supplier_credit.php
+  /purchasing/supplier_invoice.php
+  /reporting/includes/class.mail.inc
+  /reporting/includes/pdf.report.inc
+  /reporting/includes/reports_classes.inc
+  /reporting/rep109.php
+  /reporting/rep209.php
+  /reporting/rep302.php
+  /reporting/rep302.php
+  /reporting/rep303.php
+  /reporting/rep303.php
+  /reporting/rep701.php
+  /reporting/rep705.php
+  /reporting/rep706.php
+  /reporting/rep707.php
+  /reporting/rep708.php
+  /reporting/reports_main.php
+  /sales/create_recurrent_invoices.php
+  /sales/customer_delivery.php
+  /sales/includes/db/sales_order_db.inc
+  /sales/includessales_order_ui.inc
+  /sales/inquiry/sales_orders_view.php
+  /sales/manage/customer_branches.php
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  /taxes/db/tax_types_db.inc
+  /taxes/tax_types.php
+
+17-Jun-2009 Janusz Dobrowolski
+# Fixed supplier payment view link
+$ /includes/ui/ui_view.inc
+
+03-Jun-2009 Janusz Dobrowolski
+! Delete buttons prepared for js confirmation.
+$ /admin/fiscalyears.php
+
+02-Jun-2009 Joe Hunt
+! Fiscal Year delete . now removes all transactions and convert into relevant open balances.
+$ /admin/fiscalyear.php
+! Created a function db_backup in /admin/db/maintenence_db.inc
+$ /admin/db/maintenance_db.inc
+  /admin/backups.php
+  /admin/inst_upgrade.php
+  
+22-May-2009 Janusz Dobrowolski
+# Defualt hyperlink href set to PHP_SELF
+$ /includes/ui/ui_controls.inc
+
+21-May-2009 Janusz Dobrowolski
++ Added reset_focus helper function.
+$ /includes/ui/ui_view.inc
+# Fixed link on and focus on final page.
+$ /gl/gl_journal.php
+
+19-May-2009 Janusz Dobrowolski
++ Automatic update currency option added.
+$ /gl/includes/db/gl_db_currencies.inc
+  /includes/ui/ui_view.inc
+  /gl/manage/currencies.php
+  /sql/alter2.2.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
++ Added hook support for localized functions
+$ /gl/includes/db/gl_db_rates.inc
+  /gl/manage/exchange_rates.php
+  /includes/session.inc
+! Fixed hook for optional TaxFunction
+$ /reporting/rep709.php
+! Removed obsolete has_locale helper.
+$ /includes/lang/language.php
+
+17-May-2009 Janusz Dobrowolski
++ Added excluding item/category from sales.
+$ /includes/ui/ui_lists.inc
+  /inventory/includes/db/items_category_db.inc
+  /inventory/includes/db/items_db.inc
+  /inventory/manage/item_categories.php
+  /inventory/manage/items.php
+  /sql/alter2.2.sql
+  /sql/alter2.2.php
+
+15-May-2009 Joe Hunt
+# Bad link to view dimension
+$ /includes/ui/ui_view.inc
+! Improved layout.
+$ /purchasing/includes/ui/invoice_ui.inc
+
+14-May-2009 Joe Hunt
++ Added user_id to Journal Inquiry
+$ /gl/inquiry/journal_inquiry.php
+
+13-May-2009 Janusz Dobrowolski
+# Excluding closed transactions from edition/voiding.
+$ /includes/db/audit_trail_db.inc  
+  /admin/void_transaction.php
+  /sales/inquiry/customer_inquiry.php
+  /gl/inquiry/journal_inquiry.php
+# Fixed error during category adding.
+$ /inventory/includes/db/items_category_db.inc
++ Units and item type is editable until item not used.
+$ /inventory/includes/db/items_db.inc
+  /inventory/manage/items.php
+
+11-May-2009 Joe Hunt
+! Changed creating of fiscal year so gap is not allowed. Cannot close year if open years before.
+$ /admin/fiscalyers.php
+
+10-May-2009 Janusz Dobrowolski
+! Support for periodic journal trans closing/indexing
+$ /includes/db/audit_trail_db.inc
+  /admin/fiscalyears.php
+  /gl/includes/db/gl_db_trans.inc
+  /gl/inquiry/journal_inquiry.php
+
+! Restored support for reversed transactions
+$ /gl/gl_journal.php
+  /gl/includes/ui/gl_journal_ui.inc
+
+08-May-2009 Janusz Dobrowolski
++ Added journal entry edition, removed reverse transaction option.
+$ /gl/includes/ui/gl_journal_ui.inc
+  /gl/includes/db/gl_db_trans.inc
++ Added journal entry transaction edition/view
+$ /gl/gl_journal.php
+  /includes/ui/ui_view.inc
++ Added journal inquiry
+$ /gl/inquiry/journal_inquiry.php (new)
+  /includes/ui/ui_lists.inc
+  /applications/generalledger.php
+! Document references saved also in refs table for easy access.
+$ /dimensions/includes/dimensions_db.inc
+  /includes/references.inc
+  /gl/includes/db/gl_db_banking.inc
+  /inventory/includes/db/items_adjust_db.inc
+  /inventory/includes/db/items_transfer_db.inc
+  /manufacturing/includes/db/work_order_issues_db.inc
+  /manufacturing/includes/db/work_order_produce_items_db.inc
+  /manufacturing/includes/db/work_orders_db.inc
+  /manufacturing/includes/db/work_orders_quick_db.inc
+  /purchasing/includes/db/grn_db.inc
+  /purchasing/includes/db/invoice_db.inc
+  /purchasing/includes/db/po_db.inc
+  /purchasing/includes/db/supp_payment_db.inc
+  /sales/includes/db/payment_db.inc
+  /sales/includes/db/sales_credit_db.inc
+  /sales/includes/db/sales_delivery_db.inc
+  /sales/includes/db/sales_invoice_db.inc
+  /sql/alter2.2.php
+! Small fixes needed for pending client-side validation support
+$ /includes/current_user.inc
+  /includes/main.inc
+  /includes/session.inc
+  /includes/page/header.inc
+  /includes/page/footer.inc
+  /includes/errors.inc
+  /js/inserts.js
+  /js/utils.js
+  /themes/aqua/default.css
+  /themes/cool/default.css
+  /themes/default/default.css
+  /themes/aqua/renderer.php
+  /themes/cool/renderer.php
+  /themes/default/renderer.php
+! Function get_reference return string instead of mysql resource.
+$ /includes/db/references_db.inc
+! Added reference var
+$ /includes/ui/items_cart.inc
+# Small bugfix in invoice view
+$ /sales/includes/db/sales_invoice_db.inc
+# Last document date bug fixed
+$ /sales/customer_delivery.php
+# Fixed false warning during upgrade process in debug mode.
+$ /admin/inst_upgrade.php
+
+03-May-2009 Janusz Dobrowolski
++ Audit trail added.
+$ /includes/db/audit_trail_db.inc (new)
+  /admin/db/voiding_db.inc
+  /gl/includes/db/gl_db_banking.inc
+  /gl/includes/db/gl_db_trans.inc
+  /includes/main.inc
+  /inventory/includes/db/items_adjust_db.inc
+  /inventory/includes/db/items_trans_db.inc
+  /inventory/includes/db/items_transfer_db.inc
+  /manufacturing/includes/db/work_order_issues_db.inc
+  /manufacturing/includes/db/work_order_produce_items_db.inc
+  /manufacturing/includes/db/work_orders_db.inc
+  /manufacturing/includes/db/work_orders_quick_db.inc
+  /purchasing/includes/db/grn_db.inc
+  /purchasing/includes/db/po_db.inc
+  /purchasing/includes/db/supp_trans_db.inc
+  /sales/includes/db/cust_trans_db.inc
+  /sales/includes/db/sales_order_db.inc
+  /sql/alter2.2.php
+  /sql/alter2.2.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+! Changed primary key in users table
+$ /admin/change_current_user_password.php
+  /admin/inst_upgrade.php
+  /admin/users.php
+  /admin/db/users_db.inc
+  /includes/current_user.inc
+! Enabled drop table queries during non-forced upgrade
+$ /admin/db/maintenance_db.inc
+# Small optimization
+  /sales/includes/sales_db.inc
+# Fixed default date handling.
+$ /sales/customer_invoice.php
+# Fixed error handling in debug mode
+$ /includes/errors.inc
+  /includes/db/connect_db.inc
+
+02-May-2009 Joe Hunt
+# Minor bug Profit & Loss Statement
+$ /reporting/rep707.php
+
+02-May-2009 Joe Hunt
+! Company setup option for printing server Time Zone on Reports Print-Out.
+! Company setup version_id for stamping the version id. Can be used for check for update.
+$ /admin/company_preferences.php
+  /admin/db/company_db.inc
+  /reporting/includes/pdf_report.inc
+  /sql/alter2.2.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  
+01-May-2009 Joe Hunt
+! Changed Customer Balance and Supplier Balance to period select with Open Balance
+$ /reporting/reports_main.php
+  /reporting/rep101.php
+  /reporting/rep201.php
+  
+30-Apr-2009 Janusz Dobrowolski
+! Merged changes from main trunk  2.1.1-2.1.2 (see below)
+
+30-Apr-2009 Janusz Dobrowolski
+# Small layout fixes 
+$ /includes/errors.inc
+  /themes/aqua/renderer.php
+  /themes/cool/renderer.php
+  /themes/default/renderer.php
+
+29-Apr-2009 Janusz Dobrowolski
+! Messages styles moved default.css
+$ /includes/errors.inc
+  /themes/aqua/default.css
+  /themes/cool/default.css
+  /themes/default/default.css
+
+28-Apr-2009 Joe Hunt
+! Changed so the close of fiscal years also closes the balances and brings forward retained earnings.
+$ /admin/gl_setup.ph
+  /admin/fiscalyears.php
+  /admin/db/company_db.inc
+  /sql/en_US-new.sql
+  /sql/en_US-demo.sql
+  /sql/alter2.2.sql
+  
+25-Apr-2009 Janusz Dobrowolski
+# Fixed ambigous sql
+$ /inventory/manage/item_categories.php
+
+25-Apr-2009 Joe Hunt
+! Removed obsolete field 'included_in_price' from table 'Tax_group_items' in en_US-demo.sql.
+$ /sql/en_US-demo.sql
+  /sql/alter2.2.sql
+
+24-Apr-2009 Janusz Dobrowolski
++ Added inactive records support.
+$ /admin/payment_terms.php
+  /admin/shipping_companies.php
+  /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_currencies.inc
+  /gl/manage/bank_accounts.php
+  /gl/manage/currencies.php
+  /gl/manage/gl_account_classes.php
+  /gl/manage/gl_account_types.php
+  /gl/manage/gl_accounts.php
+  /includes/ui/ui_lists.inc
+  /inventory/includes/db/items_units_db.inc
+  /inventory/includes/db/movement_types_db.inc
+  /inventory/manage/item_categories.php
+  /inventory/manage/item_units.php
+  /inventory/manage/items.php
+  /inventory/manage/locations.php
+  /inventory/manage/movement_types.php
+  /manufacturing/includes/db/work_centres_db.inc
+  /manufacturing/manage/work_centres.php
+  /purchasing/manage/suppliers.php
+  /sales/includes/db/sales_points_db.inc
+  /sales/manage/sales_points.php
+  /sql/alter2.2.sql
+  /sql/en_US-demo.sql
+  /sql/en_US-new.sql
+  /taxes/item_tax_types.php
+  /taxes/tax_groups.php
+  /taxes/tax_types.php
+  /taxes/db/tax_groups_db.inc
+  /taxes/db/tax_types_db.inc
+# Edit buttons center alignment.
+$ /includes/ui/ui_input.inc
+# Fixed ajax request using element name on multi-part forms.
+$ /js/utils.js
+
+24-Apr-2009 Joe Hunt
+! Added option to select how to present Balance Sheet and P&L Statement
+$ /gl/manage/gl_account_classes.php
+  /gl/includes/db/gl_db_account_types.inc
+  /reporting/rep706.php
+  /reporting/rep707.php
+  /sql/alter2.2.sql
+
 22-Apr-2009 Janusz Dobrowolski
 + Added inactive records support.
 $ /sales/includes/db/credit_status_db.inc
@@ -44,18 +535,18 @@ $ /applications/application.php
 
 21-Apr-2009 Janusz Dobrowolski
 + Support for inactive records.
-  /includes/ui/ui_lists.inc
+$ /includes/ui/ui_lists.inc
   /includes/ui/ui_input.inc
   /includes/db/sql_functions.inc
   /themes/aqua/default.css
   /themes/cool/default.css
   /themes/default/default.css
 + Added inactive field in cust_branches
-  /sql/alter2.2.sql
+$ /sql/alter2.2.sql
   /sql/en_US-demo.sql
   /sql/en_US-new.sql
 + Added inactive records edition.
-  /sales/manage/customers.php
+$ /sales/manage/customers.php
   /sales/manage/sales_areas.php
   
 08-Apr-2009 Janusz Dobrowolski
@@ -278,6 +769,345 @@ $ /.htaccess
   /sales/inquiry/sales_deliveries_view.php
   /sales/inquiry/sales_orders_view.php
 
+------------------------------- Release 2.1.3 ----------------------------------
+25-Jun-2009 Joe Hunt
+! Release 2.1.3
+$ config.php
+  /sql/en_US-new.sql
+  /sql/en_US-demo.sql
+! Suppressed menu on access denied in view popup windows.
+$ /includes/session.inc
+  /includes/main.inc
+! New empty.po file
+  /lang/new_language_template/LC_MESSAGES/empty.po
+
+23-Jun-2009 Janusz Dobrowolski
+! Added edition link in Purchase Order Inquiry
+$ /purchasing/includes/ui/po_ui.inc
+  /purchasing/inquiry/po_search_completed.php
+
+23-Jun-2009 Joe Hunt
+# [0000137] Material Cost Averaging Problem (again) when voiding.
+$ /purchasing/includes/db/invoice_db.inc
+
+21-Jun-2009 Joe Hunt
+# If no additional costs (overhead/labour) it should reduce the average additional costs.
+$ /manufacturing/includes/db/work_orders_quick_db.inc
+
+20-Jun-2009 Janusz Dobrowolski
+! Php notices removed from logging to avoid flood from @ constructs.
+$ /includes/errors.inc
+# [0000135] Direct posting to gl accounts with more than one related tax type forbidden.
+$ /gl/gl_journal.php
+  /includes/ui/ui_view.inc
+  /purchasing/supplier_credit.php
+  /purchasing/supplier_invoice.php
+  /taxes/tax_types.php
+  /taxes/db/tax_types_db.inc
+
+20-Jun-2009 Joe Hunt/Tu Nguyen
+# [0000137] Material Cost Averaging Problem when voiding Supp Inv and qoh reaches 0.
+$ /purchasing/includes/db/grn_db.inc
+
+18-Jun-2009 Joe Hunt
+! Better support for conversion_factor in Purchasing Pricing. Instruction on Sticky Inventory Forum.
+$ /inventory/purchasing_data.php
+  /purchasing/includes/purchasing_db.inc
+  /purchasing/includes/db/po_db.inc
+  /purchasing/includes/ui/po_ui.inc
+  
+17-Jun-2009 Janusz Dobrowolski
+# Fixed form reset after error, allowed png logo files.
+$ /admin/company_preferences.php
+! Removed unneeded submit_on_change in uom selector.
+$ /includes/ui/ui_lists.inc
+# Allowed reuse of supplier references from voided invoices.
+$ /purchasing/supplier_invoice.php
+# Total payment/credit sign fix.  
+$ /purchasing/allocations/supplier_allocation_main.php
+# Voided documents should not be displayed.
+$ /purchasing/inquiry/supplier_inquiry.php
+
+17-Jun-2009 Joe Hunt/Tu Nguyen
+# [0000136] view_po on invoices and credits shows transactions from other suppliers
+$ /purchasing/includes/db/invoice_db.inc
+
+16-Jun-2009 Janusz Dobrowolski
+! Added error logging to file or syslog.
+$ /config.php
+  /includes/errors.inc
+# Cleaned output buffering notices.
+$ /includes/errors.inc
+  /includes/session.inc
+
+15-Jun-2009 Joe Hunt
+! Added Item Code Entry in Work Order Entry and quantity decimals now follows the item
+! Clean-up in ui_list codes.
+$ /includes/ui/ui_lists.inc
+  /manufacturing/work_order_entry.php
+  /manufacturing/search_work_orders.php
+  /manufacturing/manage/bom_edit.php
+  /manufacturing/inquiry/bom_cost_inquiry.php
+  
+14-Jun-2009 Joe Hunt
+! Much better presentation of new Balance Sheet, P&L Statement and Monthly Breakdown.
+$ /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_accounts.inc
+  /includes/types.inc
+  /reporting/rep705.php
+  /reporting/rep706.php
+  /reporting/rep707.php
+! New variable in config.php, $use_oldstyle_convert, if set to 1, same convert as in old versions.  
+$ config.php
+  
+13-Jun-2009 Joe Hunt/Pete/Tom Moulton
+! Changed next reference method to also include partly alpha characters in front, fi. WA036 increments to WA037
+$ /includes/references.inc
+! Improved email sending of documents. With help of Tom Moulton
+$ /reporting/rep109.php
+  /reporting/rep209.php
+  /reporting/includes/class.mail.inc
+  /reporting/includes/pdf.report.inc
+  
+12-Jun-2009 Joe Hunt
+! Code clean-up
+$ /gl/includes/db/gl_db_trans.inc
+  /gl/inquiry/gl_trial_balance.php
+  /includes/ui/ui_view.inc
+  /reporting/rep708.php
+  
+11-Jun-2009 Joe Hunt
+! Changed balance_sheet operation in class table to class type for sign convert in Balance Sheet, Profit and Loss Statement and Monthly Breakdown
+$ /gl/manage/gl_account_classes.php
+  /gl/includes/db/gl_db_account_types.inc
+  /gl/includes/db/gl_db_accounts.inc
+  /gl/inquiry/gl_trial_balance.php
+  /includes/types.inc
+  /includes/ui/ui_lists.inc
+  /reporting/rep705.php
+  /reporting/rep706.php
+  /reporting/rep707.php
+  /reporting/rep708.php
+  
+09-Jun-2009 Joe Hunt
+# Bad format in due date column in search dimensions
+$ /dimensions/inquiry/search_dimensions.php
+
+08-Jun-2009 Joe Hunt
+! Changed Advanced Manufacturing payments to be more flexible and simpler. Removed from Payment.
+$ /gl/includes/db/gl_db_trans.inc
+  /gl/includes/ui/gl_bank_ui.inc
+  /includes/types.inc
+  /includes/ui/ui_lists.inc
+  /manufacturing/search_work_orders.php
+  /manufacturing/work_order_costs.php (new file)
+  /manufacturing/work_order_entry.php
+# Overhead costs in Manufacturing/Assembling wasn't added to stock overhead cost
+$ /manufacturing/work_order_add_finished.php
+  /manufacturing/work_order_issue.php
+  /manufacturing/work_order_release.php
+  /manufacturing/includes/manufacturing_ui.inc
+  /manufacturing/includes/db/work_orders_db.inc
+  /manufacturing/includes/db/work_orders_quick_db.inc
+  /manufacturing/includes/db/work_orders_produce_items_db.inc
+  /manufacturing/view/work_order_view.php
+  
+05-Jun-2009 Joe Hunt
+# Missing underscore in gettext string
+$ /sales/create_recurrent_invoices.php
+# Broken gettext string over 2 lines
+$ /sales/customer_delivery.php
+
+04-Jun-2009 Joe Hunt
+# [0000134] Voiding a supplier credit note didn't activate the PO Receivals and void the stock moves.
+$ /purchasing/includes/db/invoice_db.inc
+
+03-Jun-2009 Joe Hunt
+! Changed to present reference number in Print Invoices/Credit Notes if global $print_invoice_no = 0
+$ /reporting/includes/reports_classes.inc
+# Deleting of Locations was too easy. Implemented much more checks
+$ /inventory/manage/locations.php
+! Report Stock Check Sheet and 'Inventory Item Status' was wrong when Locations were selected.
+$ /reporting/rep302.php
+  /reporting/rep303.php
+  /includes/db/manufacturing_db.inc
+# When producing advanced manufacture there should be errors when insuffient qoh in items (if 'Allow Negative Stock' is not marked).
+$ /manufacturing/work_order_issue.php
+  /manufacturing/work_order_add_finished.php
+# Missing decimal calculation in BOM edit.
+$ /manufacturing/manage/bom_edit.php
+# Wrong toottip text on Process button in Purchase Order, Receive Items.
+$ /purchase/po_receive_items.php
+  
+27-May-2009 Joe Hunt
+# After heavy testing a new set of nested subtypes in COA, Monthly Breakdown, Balance Sheet and P&L Statement.
+$ /gl/includes/db/gl_db_accounts.inc
+  /gl/includes/db/gl_db_account_types.inc
+  /reporting/rep701.php
+  /reporting/rep705.php
+  /reporting/rep706.php
+  /reporting/rep707.php
+
+26-May-2009 Joe Hunt
+# Again fixed nested subtypes in account types correctly in COA, Monthly Breakdown, Balance Sheet and P&L Statement
+$ /gl/includes/db/gl_db_accounts.inc
+  /gl/includes/db/gl_db_account_types.inc
+  /reporting/rep701.php
+  /reporting/rep705.php
+  /reporting/rep706.php
+  /reporting/rep707.php
+# fixed wider combobox for backup-files in company backup
+$ /admin/backups.php
+
+25-May-2009 Joe Hunt
+# Fixed Supplier Credit so Purchase Order Outstanding is decreased too.
+$ /purchasing/includes/db/grn_db.inc
+# Fixed so nested subtypes in account types are nested correctly in Balance Sheet and P&L Statement
+$ /gl/includes/db/gl_db_accounts.inc
+  /reporting/rep706.php
+  /reporting/rep707.php
+! Extra column in Stock Check Sheet, On Order and option for selecting Only Shortage.
+$ /reporting/rep303.php
+  /reporting/reports_main.php
+
+23-May-2009 Janusz Dobrowolski
+# Fixed transaction table search update.
+$ /admin/view_print_transaction.php
+# Fixed initial select for array_selector()
+$ /includes/ui/ui_lists.inc
+
+22-May-2009 Janusz Dobrowolski
+# Fixed buggy reference instead of id in report dimension selectors.
+$ /reporting/includes/reports_classes.inc
+# Fixed typo in setup menu
+$ /applications/setup.php
+
+21-May-2009 Joe Hunt/Tom Moulton
+# Recursion fix in manufacturing_db.inc by Tom Moulton
+$ /includes/db/manufacturing_db.inc
+
+20-May-2009 Janusz Dobrowolski
+# Small cleanup
+$ /inventory/prices.php
+# Fixed select buttons icon.
+$ /sales/manage/customer_branches.php
+
+20-May-2009 Joe Hunt
+# Fixed and optimized On Order in Inventory Items Status and reports
+$ /includes/db/manufacturing_db.inc
+  /inventory/inquiry/stock_status.php
+  /reporting/rep302.php
+  /reporting/rep303.php
+  /sales/includes/db/sales_order_db.inc
+  
+18-May-2009 Joe Hunt
+# html header shown in backup downloads.
+$ /admin/backups.php
+! Reinserted the link to GL in Work Order Inquiry.
+$ /manufacturing/search_work_orders.php
+# Added non closed work order requirements on On Order in Inventory Items Status
+$ /inventory/inquiry/stock_status.php
+! Added mb_flag 'M' in demand checks
+$ /sales/includes/db/sales_order_db.inc
+  /reporting/rep302.php
+  /reporting/rep303.php
+  
+17-May-2009 Joe Hunt
+! Changed service items to use cogs account instead of inventory account.
+$ /inventory/manage/items.php
+
+16-May-2009 Joe Hunt
+# [0000133] Removed buggy & obsolete hotkey support in pager_link()
+$ /includes/ui/db_pager_view.inc
+! Removed obsolete 'K' mb_flag checks.
+$ /includes/data_checks.inc
+  /includes/ui/ui_lists.inc
+
+13-May-2009 Joe Hunt
+# Bug in demensions_list. If dimensions are closed they shall NOT show up in the lists.
+$ /includes/ui/ui_lists.inc
+
+10-May-2009 Joe Hunt
+# Period presentation bug in tax report/inquiry
+$ /gl/inquiry/tax_inquiry.php
+  /reporting/includes/reports_classes.inc
+  
+07-May-2009 Joe Hunt
+# Layout bug in exchange rate display
+$ /includes/ui/ui_view.inc
+# Layout bug in sales_order_view. Column Comments renamed to Cust Order Ref
+$ /sales/inquiry/sales_orders_view.php
+# Layout bug in sales_order_ui. Bad presentation of customer if not editable
+$ /sales/includessales_order_ui.inc
+
+05-May-2009 Janusz Dobrowolski
+# Fixed check if code for new sales kit is not used.
+$ /inventory/manage/sales_kits.php
+
+04-May-2009 Joe Hunt
+# Purchase Order document shows wrong purch data conversion if purch data
+$ /reporting/rep209.php
+
+
+------------------------------- Release 2.1.2 ----------------------------------
+30-Apr-2009 Joe Hunt
+! Release 2.1.2
+$ config.php
+
+22-Apr-2009 Joe Hunt
+! Changed the text 'Supplier Account No' to 'Our Customer No' in Supplier form
+$ /purchasing/manage/suppliers.php
+
+20-Apr-2009 Janusz Dobrowolski
+# Rewritten backup manager, fixed progressbar bug.
+$ /admin/backups.php
+# Fixed bug in zipped sql file restore.
+$ /admin/db/maintenance_db.inc
+! JsHttpRequest class updated to latest version.
+$ /includes/JsHttpRequest.php
+  /js/JsHttpRequest.js
+! Added optional parameter in vertical_space()
+$ /includes/ui/ui_controls.inc
++ Helper for javascript confirm dialogs added.
+$ /includes/ui/ui_input.inc
+! Client side confirm dialog added for destructive submits.
+$ /purchasing/supplier_invoice.php
+  /purchasing/includes/ui/invoice_ui.inc
+  /sales/sales_order_entry.php
++ Added retry after timeout on unreliable ajax connections. Preparation for client-side javascript checks.
+$ /includes/current_user.inc
+  /includes/page/footer.inc
+  /includes/page/header.inc
+  /includes/ui/ui_view.inc
+  /access/login.php
+  /js/inserts.js
+  /js/utils.js
+  /themes/aqua/images/progressbar.gif
+  /themes/cool/images/progressbar.gif
+  /themes/default/images/progressbar.gif
+  /themes/default/images/ajax-loader2.gif (new)
+  /themes/default/images/warning.png (new)
+  /themes/aqua/images/ajax-loader2.gif (new)
+  /themes/aqua/images/warning.png (new)
+  /themes/cool/images/ajax-loader2.gif (new)
+  /themes/cool/images/warning.png (new)
+# Fixed supplier uom retrieval.
+$ /purchasing/includes/db/po_db.inc
+
+04-Apr-2009 Janusz Dobrowolski
+# Paper format defaults to A4 for unknown specifiers.
+$ /reporting/includes/pdf_report.inc
+# Sealing sql statements.
+$ /sales/manage/customers.php
+
+01-Apr-2009 Janusz Dobrowolski
+# Fixed document mailing.
+$ /reporting/includes/pdf_report.inc
+# Fixed focus javascript error on lists.
+$ /includes/ui/ui_lists.inc
+# Fixed report links hotkey selection
+$ /js/inserts.js
+
 ------------------------------- Release 2.1.1 ----------------------------------
 30-Mar-2009 Janusz Dobrowolski
 # Fixed display of unsufficient quantities in sales docs.