X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=CHANGELOG.txt;h=96e3805612cced9466bf2a7267cc8235e2460644;hb=7d9fe15f85c15572535c5fa4555b9a72e9d93f04;hp=426d90f76e61c774238d6abee411c92aa70f7c57;hpb=83e9c286c92b366b482a0bffc6de8fe0fa5b390e;p=fa-stable.git diff --git a/CHANGELOG.txt b/CHANGELOG.txt index 426d90f7..96e38056 100644 --- a/CHANGELOG.txt +++ b/CHANGELOG.txt @@ -19,6 +19,440 @@ Legend: ! -> Note $ -> Affected files +15-Oct-2009 Janusz Dobrowolski +! Added html_entity_decode() in db_escape() for correct INSERT>SELECT>INSERT sequences. +$ /includes/db/connect_db.inc +# Fixed warnings on first page display +$ /admin/company_preferences.php +# Fixed erroneous message +$ /gl/manage/gl_account_types.php +# Security sql statements update against sql injection attacks. +$ /admin/attachments.php + /admin/payment_terms.php + /admin/print_profiles.php + /admin/printers.php + /admin/shipping_companies.php + /admin/view_print_transaction.php + /admin/db/company_db.inc + /admin/db/printers_db.inc + /admin/db/voiding_db.inc + /admin/db/users_db.inc + /dimensions/includes/dimensions_db.inc + /dimensions/inquiry/search_dimensions.php + /gl/bank_account_reconcile.php + /gl/gl_budget.php + /gl/includes/db/gl_db_account_types.inc + /gl/includes/db/gl_db_accounts.inc + /gl/includes/db/gl_db_bank_accounts.inc + /gl/includes/db/gl_db_bank_trans.inc + /gl/includes/db/gl_db_banking.inc + /gl/includes/db/gl_db_currencies.inc + /gl/includes/db/gl_db_rates.inc + /gl/includes/db/gl_db_trans.inc + /gl/inquiry/bank_inquiry.php + /gl/view/bank_transfer_view.php + /gl/view/gl_trans_view.php + /inventory/cost_update.php + /inventory/purchasing_data.php + /inventory/includes/db/items_category_db.inc + /inventory/includes/db/items_codes_db.inc + /inventory/includes/db/items_db.inc + /inventory/includes/db/items_locations_db.inc + /inventory/includes/db/items_prices_db.inc + /inventory/includes/db/items_trans_db.inc + /inventory/includes/db/items_units_db.inc + /inventory/includes/db/movement_types_db.inc + /inventory/inquiry/stock_movements.php + /inventory/manage/item_categories.php + /inventory/manage/item_units.php + /inventory/manage/items.php + /inventory/manage/locations.php + /inventory/manage/movement_types.php + /manufacturing/search_work_orders.php + /manufacturing/includes/db/work_centres_db.inc + /manufacturing/includes/db/work_order_issues_db.inc + /manufacturing/includes/db/work_order_produce_items_db.inc + /manufacturing/includes/db/work_order_requirements_db.inc + /manufacturing/includes/db/work_orders_db.inc + /manufacturing/includes/db/work_orders_quick_db.inc + /manufacturing/inquiry/where_used_inquiry.php + /manufacturing/manage/bom_edit.php + /manufacturing/manage/work_centres.php + /purchasing/po_entry_items.php + /purchasing/po_receive_items.php + /purchasing/supplier_credit.php + /purchasing/supplier_invoice.php + /purchasing/includes/purchasing_db.inc + /purchasing/includes/db/grn_db.inc + /purchasing/includes/db/invoice_db.inc + /purchasing/includes/db/invoice_items_db.inc + /purchasing/includes/db/po_db.inc + /purchasing/includes/db/supp_trans_db.inc + /purchasing/includes/db/suppalloc_db.inc + /purchasing/includes/db/suppliers_db.inc + /purchasing/inquiry/po_search.php + /purchasing/inquiry/po_search_completed.php + /purchasing/inquiry/supplier_allocation_inquiry.php + /purchasing/inquiry/supplier_inquiry.php + /purchasing/manage/suppliers.php + +12-Oct-2009 Janusz Dobrowolski +# Fixed sql injection vulnerability on some php/mysql configurations +$ /admin/db/users_db.inc +! Single quotes also encoded before database data insert +$ /admin/db/maintenance_db.inc + /includes/db/connect_db.inc + /reporting/includes/tcpdf.php + /sales/includes/cart_class.inc + +------------------------------- Release 2.1.6 ---------------------------------- +! Final Final release of the 2.1. series. +$ config.php + +16-Sep-2009 Joe Hunt +# Missing freight tax in Customer Balances Report +$ /reporting/rep101.php + +14-Sep-2009 Joe Hunt +# A couple of minor bugs in tax report when displaying supplier credit notes +$ /purchasing/includes/db/invoice_db.inc + +05-Sep-2009 Joe Hunt +# Changed Class Type to Class Name in GL Account groups +$ /gl/manage/gl_account_types.php +# Changed so total in bank payments/deposits shows correctly if negative amount are entered. +$ /gl/includes/ui/gl_bank_ui.inc + +30-Aug-2009 Janusz Dobrowolski +# Fixed sql error during sales order line update with line cancelation. +$ /sales/includes/db/sales_order_db.inc + +------------------------------- Release 2.1.5 ---------------------------------- +26-Aug-2009 Joe Hunt +! Release 2.1.5 +$ config.php +# If no dimensions in system, then there were 2 destination selectors in report Balance Sheet +$ /reporting/reports_main.php +! Code cleanup +$ /taxes/tax_calc.inc + /lang/new_language_template/LC_MESSAGES/empty.po (new extraction) + +24-Aug-2009 Joe Hunt +# A Purchasing Price of 12.34 with a conversion factor of 100,0000 caused a false internal rounding error of 12.00. +! The Purchasing Price, price can now have up to 6 decimals (fractions of hundredth's) and are presented correctly. + If you need to increase the decimals in a current value, then you have to delete it and create it again with new values. + This is for safety reasons. +$ /includes/current_user.inc + /includes/ui/ui_input.inc + /inventory/purchasing_data.php + /purchasing/po_receive_items.php + /purchasing/includes/ui/invoice_ui.inc + /purchasing/includes/ui/po_ui.inc + /purchasing/view/view_grn.php + /purchasing/view/view_po.php + /reporting/rep209.php + +21-Aut-2009 Joe Hunt +# [0000162] Deleting a GL account may cause problems with quick entries +$ /gl/manage/gl_accounts.php + +20-Aug-2009 Joe Hunt +# If account code2 is used in the accounts the report Chart of Accounts gave a bad index and didn't print the code. +$ /gl/includes/gl_db_accounts.inc +# If setting the delivered items in PO Receive Items to 0 the value is not updated +$ /purchasing/po_receive_items.php + +19-Aug-2009 Joe Hunt +! Change of Quick Entries to use the Tax Types instead, due to complexity using the Tax Groups in EU. + If you for need more than one Tax Type row in a Quick Entry, please keep the rows together and use the same action type. +$ /gl/includes/db/gl_db_bank_accounts.inc + /gl/manage/gl_quick_entries.php + /includes/ui/ui_view.inc + +18-Aug-2009 Joe Hunt +! When using Quick Entries in Supplier Invoices/credit notes the tax sum now shows correctly. +$ /purchasing/includes/db/invoice_db.inc + /purchasing/includes/ui/invoice_ui.inc + /purchasing/includes/supp_trans_class.inc + +18-Aug-2009 Joe Hunt +! Quick Entries uses Tax Groups instead of Item Tax Types for calculating taxes (Please change the item lines for tax). + Quick Entry Lines of type Supplier Invoice. When using, the Supplier Tax Group Id overrides the The Tax Group set on the line. +$ /gl/includes/db/gl_db_bank_accounts.inc + /gl/manage/gl_quick_entries.php + /includes/ui/ui_view.inc + /taxes/tax_calc.inc + +17-Aug-2009 Janusz Dobrowolski +# [0000158] Added missing check for POS usage before deletion. +$ /sales/manage/sales_points.php + +17-Aug-2009 Joe Hunt +# [0000160] Customer payments in different currencies (bank account exchange error). Fixed so diff bank_curr/home_curr and cust/supp curr is readonly. +$ /gl/includes/db/gl_db_bank_trans.inc + /purchasing/supplier_payment.php + /sales/customer_payments.php + /sales/includes/db/payments_db.inc + +14-Aug-2009 Janusz Dobrowolski +# [0000161] Fixed reference edition on sales invoice/deliery/credit. +$ /sales/customer_credit_invoice.php + /sales/customer_delivery.php + /sales/customer_invoice.php + +12-Aug-2009 Joe Hunt +# [0000159] Memo field's GL entries are not saved (gl_trans) in supplier invoice +$ /purchasing/includes/purchasing_db.inc + /purchasing/includes/db/invoice_db.inc +# memo field was not written in list of journal entries. +$ /reporting/rep702.php + +08-Aug-2009 Janusz Dobrowolski +# Fixed bug in calculation of taxes for quick entries using multiply tax rates +$ /includes/ui/ui_view.inc + +08-Aug-2009 Janusz Dobrowolski +# [0000152] Config_db.php changed after failed company database creation +$ /install/save.php + +08-Aug-2009 Joe Hunt +# [0000153] not possible to make a new balance sheet GL account cl (old style) +$ /gl/manage/gl_account_classes.php + +04-Aug-2009 Joe Hunt +# [0000150] Logo on printed papers is placed on top of the adress rule nr 1 +$ /reporting/includes/header2.inc +# [0000145] Email sales order doesn't work if no email on branch but on customer +$ /sales/includes/db/sales_order_db.inc + /reporting/rep109.php +! Changed so $use_oldstyle_convert=1 variable in config.php (line 78) gives fully backwards compatibility in + Balance Sheet, PL Statements and Monthly Bread Down reports. +$ /gl/manage/gl_account_classes.php. + +------------------------------- Release 2.1.4 ---------------------------------- +30-Jul-2009 Joe Hunt +! Release 2.1.4 +$ config.php +# Bad right margin on Tax Report (papersize A4) +$ /reporting/rep709.php +# [0000146] Purch data description with a ' (apostrophe) fails +$ /inventory/purchasing_data.php + /purchasing/includes/purchasing_db.inc + +28-Jul-2009 Joe Hunt +# Bugs in sending documents as email. Seems to land in the spam filter due to bad text and scrambled name on attached documents +$ /reporting/rep109.php + /reporting/includes/doctext.inc + /reporting/includes/doctext2.inc + /reporting/includes/header2.inc + /reporting/includes/pdf_report.inc + +18-Jul-2009 Joe Hunt +# When saving a Payment to a Customer in Bank Payments (normally payment to suppliers) it was saved with wrong sign in debtor_trans (very rare). +$ /sales/includes/db/cust_trans_db.inc +# Wrong presentation in customer/supplier balance if using bank payments for customers and bank deposits for suppliers (very rare) +$ /reporting/rep101.php + /reporting/rep201.php + +13-Jul-2009 Joe Hunt +# Bug in Tax Inquiry and Tax Report when entering in Journal Entry +$ /gl/includes/db/gl_db_banking.inc + /gl/includes/db/gl_db_trans.inc + /reporting/rep709.php +! Comments should follow templates and recurrent invoices. +$ /sales/create_recurrent_invoices.php + /sales/sales_order_entry.php + +12-Jul-2009 Joe Hunt +# Wrong presentation of left to allocate if discount was given +$ /sales/view/view_receipt.php + /purchasing/view/view_supp_payment.php + +11-Jul-2009 Joe Hunt +! Improved Inventory Sales Report. Now by Customer and quantities as well. +$ /reporting/rep304.php + /reporting/reports_main.php + +10-Jul-2009 Joe Hunt +# [0000142] Purchase Order use the same header as Sales Order +$ /reporting/includes/doctext.inc + /reporting/includes/doctext2.inc +# Bug in demand qty +$ /includes/db/manufacturing.inc + +10-Jul-2009 Janusz Dobrowolski +# [0000141] Attachment view/download bug. +$ /admin/attachments.php +# [0000140] Numeric format bug in credit limit input. +$ /purchasing/manage/suppliers.php +# [0000143] Bad format of PO popup window (Softechmatrix). +$ /purchasing/view/view_grn.php + +09-Jul-2009 Janusz Dobrowolski +# [0000139] Change of bank account type after creation should not be allowed. +$ /gl/manage/bank_accounts.php + +01-Jul-2009 Joe Hunt +# Guess what :) [0000137] Material Cost Averaging Problem (again again again) when voiding. +$ /purchasing/includes/db/invoice_db.inc + +26-Jun-2009 Joe Hunt +# [0000137] Material Cost Averaging Problem (again again) when voiding. +$ /purchasing/includes/db/invoice_db.inc + +------------------------------- 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 @@ -31,6 +465,10 @@ $ /reporting/rep302.php # 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.