June 9th, 2011· An option was added to also show allocated in the aged customer/supplier list.
· Manual revaluation of currency accounts now also inlcudes AR/AP accounts update.
· The backup/restore screen layout displayed in Chrome was fixed.
· The timeout on long processing tasks was enlarged to 10 minutes.
· Much more was done.
April 27th, 2011· Fixed error handling in trace debug mode (go_debug=2).
· Fixed logout error when setting show users online.
· Improved reports: COA, Trial Balance and Tax Report by Chaitanya.
· Changed tax group retrieval functions to return all tax types (with
· filtered tax rates).
· Rewritten tax group editor.
· db_insert_id() returned wrong id when $sql_trail=1.
· Fixed taxes display for multiply tax types included in price.
· Fixed excel report redirection (regresion after customer selector in
· reports improvement).
· Improved search filter in Void Transactions (like View Print Transactions)
· Removed sparse in_ID lang folder (installation).
· Entry into Upgrade Software option triggered automatic config.php changes
· even without starting upgrade.
· [0000619] Fixed javascript related timeout issues.
· Fixed bug in create_coy, resulting in database reset on company seting
· change.
· New report, Sales Summary Report, added under Sales Reports..
· [0000707] Fixed sales transaction edition (invalid max quantities for
· second and next lines).
· Optional printing item codes on purchase order report with config.php
· $show_po_item_codes.
· Removed sparse grn item id from purchase invoice entry form.
· [0000692] Tab characters should be forbidden in item code.
· [0000714] Bug creating GL trans on inventory items in supplier invoice
· when tax included.
· Work Order issue with 0 qty was accepted
· Banking and General Ledger
· Display bank balance in payment forms.
· Cleanup of on screen Trial Balance.
· Added check for duplicate account group code.
April 4th, 2011Common:
· Unique Reference check fixed when running manual Revaluation of Currency
· Converted currencies are now rounded correctly when using Funds transfers
· Searchable customer/supplier selectors in reports options (if set in company prefs).
· Corrected customer/suppliers/... editors popups dimensions to display all needed content.
· Support for nonstandard delimiters in db_import()
· Fixed problem installing in languages other than EN - part II (MS Windows)
· Fixed issue with function is_date_in_fiscalyear
· Credit Invoice report moved to separate file.
· Fixed negative values processing in add_months()
· Language templates updated. Also for Installer.
· Fixed upgrade routines from 2.1.X series and reorganized db_export.
Sales:
· Fixed location changes in Direct Invoice. - Inability to create recurrent invoice fixed.
· Fixed regresion in cash sales invoice.
· Voiding delivery note now works
· Entering written off Credit Note is fixed.
· Error during delivery note read for edition is fixed.
· Error during Credit Note deletion (typo in void_sales_invoice) fixed..
· Fixed tax calculation for tax_included sales invoices to avoid rounding differences.
· Customer invoice inquire displayed also payments.
· Added customer filter in sales order inquiries.
· Warning if line price is below standard cost in sales documents.
Purchasing:
· Fixed invalid costing results due to changes in PO rate
· Fixed over received PO issue
· PO Number disappears on Supplier Invoice when clicked on add. Fixed.
· Fixed Supplier Credit Error,
· Missing restriction on fiscal year in direct GRN and direct Supp Invoice. Fixed.
Items and Inventory:
· When voiding Inventory Adjustment the costs are now adjusted too.
· Dummy/service items removed from inventory status/movements inquires.
· Reversing stock move rather than voiding as it is hazardous to lose stock movement trail with respect to costing
· Improved GRN Evaluation Report by Chaitanya.
· Added missing check for references to item_tax_ype in item_categories.
· Fixed foreign key check on item tax type deletion.
· Better Negative stock prevention checking
· Fixed issue with Inventory Adjustment with 0 cost value
· Service Items - BOM & Cost Update allowed without side-effects
· Changes in void_stock_adjustment.
· Many Improvements in Costing Valuations, Chaitanya.
Manufacturing:
· Fixed Work Order issue form : Unit cost should not be editable
· Work Order entry form now shows qty correctly while editing
· Fixed error updating BOM
Banking and General Ledger:
· Don't allow inactivation of GL Accounts belonging to Bank Accounts
· Minor fix in bank account transfer (currencies).
· Voided gl_trans_view now display properly
· Better Trial Balance Inquiry. Chaitanya.
· Problem with cash balance constraint during payment edition fixed.
February 15th, 2011Common:
· Added warning when user does not supply db credentials in create_coy
· Could not set prefs in setup System and General GL for any other than first company
· Fixed slow sql for po related invoices/credits
· Fixed theme images location
· Child document preparation moved to cart class
· Updated string handling in excel generator (reports were sometimes broken)
· Improved mail error handling
· Added access extensions hook placeholder in hook class.
Sales:
· Sales quotations were presented in inquiry when realized [0000498]
· Fixed bad SO reference display
· Removed obsolete date selectors in Delivery against Order inquiry. Fixed order selection.
· [0000536] Fixed phone/email branch contact retrieval
· Fixed credit processing errors handling
· Fixed bug resulting in invalid pstings when cash payment was selected for invoice against sales delivery
Purchasing:
· Fixed supplier reference allowed length
· Check for qoh for supplier credit was missing
Items and Inventory:
· Fixed inventory status display for items without reorder level set.
Banking and General Ledger:
· Backward compatibility fix in bank account limit check.
· Fixed accruals postings date calculation
· Fixed add_months() result for dates near end of month
· A global variable in config.php $show_voided_gl_trans = 1, shows zero amounts.
January 5th, 2011· Timezone warnings were removed.
· A Georgian installer wizard translation was added.
· Strict warnings in reporting were suppressed.
· Preparations were made for category icons in themes.
· Non-voidable transactions are removed from selection on voiding a page.
· The database host name may be up to 60 chars long during install.
· A lot of minor bugs were fixed.
September 6th, 2010· A new repository for languages, themes, charts of accounts, and extensions.
· Instead of a separate download and install, you can now install these items from FrontAccounting directly from a global repository.
· A new multi-language installer for FrontAccounting.
· Direct GRN and Direct Supplier Invoice.
· Revenue/Cost Accruals are included in the core.
· Much more.
June 29th, 2010· References previously used on voided transactions may now be reused.
· Inaccessible menu options are now displayed as grey text.
· Context help organization was changed to enable the use of central multilanguage wiki.
· The use of externally defined report headers/layouts in PHP and PDF form was enabled.
· "View Attachments" was added if there are any attachments in all popup view windows.
· A date column was added, and the # and View columns were combined in "View / Print Transactions".
· Voiding a transaction was changed to also include a pager.
· The report engine was prepared for handling tags.
· The payment terms editor was reorganized.
June 28th, 2010New features:
· Allow optional non zero values in reports 101,102,201,202,203 and 303.
· Removed constraint on day values in Payment Terms.
Bugs fixed in 2.2.11:
· Bug [0000231] Wrong On Order for Advanced Manufacturing.before final production.
· [0000235],[0000236] db error in sales order view window.
· Small bug on final credit note screen redirection.
· Minor select bug in create recurrent invoices.
May 24th, 2010New features:
· Allowing the Tax Report to be printed to Excel/OO Calc
· Minor changes to balance sheet/profit and loss drilldown
· Print Statements no longer show voided items.
· Sales Order inquiry using reference number.
Bugs fixed:
· Deleting Sales Order with reference to voided delivery caused SQL error
· Incorrect backup of tables with more than 2 digit prefix.
· Supplier Payment Report show paid invoices (rounding problem)
· Fixed ambiguites and typos in report titles.
· Fixed email links to use ajax.
· Payment Over allocation is now forbidden
· Allowing multiple FA instances on the same server.
· Fixed diagnostic checks for javascript cached files.
· Fixed html generation for buttons.
· Fixed a Stock Check Bug on order in report Stock Check Sheet.
March 5th, 2010New features:
· Many layout fixes.
· Allow change of password without script in Create/Update Company.
Bugs fixed in 2.2.7:
· Bug in exchange variation calculation in certain situations.
· Fixed check for language sessions.
· Small fixes in security area codes.
· Tax included calculation problem when more than one tax type in a tax group.
· Fixed bug in quantity input.
· [0000208] Voiding a work order production does not revert raw material.
· [0000209],[0000210] Improper quantity/price handling on supplier change.
· Fixed a non existing voiding of Work Order Advanced and a couple of bugs in the same operation.
· [0000212] Selecting branch from popup was not working.
· [0000213] Date change on journal entry update.
· Bug sending email to a name with commas.
· Removed redundant function get_gl_accounts_all in gl_db_accounts.inc.
· Removed redundant variable $use_new_account_types from config.php.
February 16th, 2010New features:
· Placing a print link in all view windows (without menus)
· Added a Profit/Loss Statement drilldown inquiry in Banking and GL
· Added memo search in Journal Inquiry.
· Changed Balance Sheets/PL Statements to be recursive.
· Added trans_no in bank deposit/payment final link, by Tom Hallman.
· Added a selector for decimal values in Balance Sheet and P/L Statement
· Changed so 'Allow Negative Stock' will update the GL cogs/inventory when the correct values later are obtained.
· CSS style is now implemented in all FA.
· New label style for the themes. Better layout in supp inv/credit
Bugs fixed:
· Exchange rate bug when searching a non existing customer
· [0000200] stock_master material_cost incorrectly updated during GRN when price format uses thousands seperator. A couple of minor errors too.
· Fixed get_standard_cost() for dummy items
· When buying a service item from a supplier, the delivery produced wrong inventory GL transactions. No GL transactions should be here
· Fixed continuation after timeout.
· Prevent saving empty lines in invoices/delivery notes
· Fixed bug resulting in broken line items relations after edition of multiline SO.
· [0000202] Global $path_to_root is missing in function handle_submit() in file admin/create_coy.php
· [0000201] Cannot change item type when item is edited
· [0000204] GRN Valuation Report shows wrong data
· Fixed IE related hotkeys problem with AltTab
· Better check for language session var.
February 2nd, 2010New features:
· New document type, Receipt.
· Added a Balance Sheet drilldown inquiry in Banking and GL
· Up to 4-5 levels of GL accounts groups in COA.
Bugs fixed in 2.2.5:
· Demand was calculated double from Sales Quotations. Should be 0.
· Put a heavy warning on marking the checkbox 'Allow Negative Inventory'
· Small adjustments to Bank Statement and GL Transaction Reports
· Exchange rate doesn't update table when adding new or deleting rate.
· Bug in Sales Price pickup.
· [0000195] Bug not deleting refs record when deleting Sales Order, Quotation
· [0000194] Fixed tax records from journal entry (voiding problem)
· Added purchase tax account in default COAs
· Bug in Quick Entry lines with Tax added.
· [0000197] Bug in closing some special balance sheet levels.
· [0000198] Bug ignoring shipping cost in Direct Invoice (cash).
· Improved error display during Ajax operations.
· Bug in direct invoice when cash sales and no cash account defined in sales pos.
January 18th, 2010· Allow more then 2 dec in Items with conversion factors
· Changed so GL Account Types (Groups) allows up to 10 digits.
· Fixed bug in average material cost when stock goes from negative to positive value.
· Removed a nasty comma bug in sql file en_US-new.sql. Created broken new companies.
· Back link on confirmation only pages removed.
· Restored so that empty amount fields defaulted to 0 value.
· [0000187] Category and description reset after failed check. Fixed.
· Improved error checking in company update/creation.
· Check for deleting sales points
· Fixed error display in ajax mode
January 12th, 2010· The alternative document layout is new for 2.2.3.
December 24th, 2009· Fix of Print Statement layout
· Fixed bug [0000179] Cannot allocate ST_BANKPAYMENT type payments.
· Safer algorithm for company removal, additional prefix check on company add.
· Providing use of alternative providers for exchange rates.
· Report Engine Extensions by Tom Hallman for better report extensions
· Added System Diagnostics page in Setup Tab.
· Implemented search on categories as well in sales_items_list
· Fixed the minimal entry of quantities in PO lines to be depended of UOM decimals.
· Fixed bug {0000184] Bad source document quantities update and invalid qty's during
· derivative document entry.
· Sales Order (Quote) now prints with TOTAL VAT INCL: if this is the fact.
· Replaced all deprecated functions so FA runs in php >= 5.3.0 as well.
December 3rd, 2009· Fixed bug [0000178] data error in supplier allocations
· Fixed so total amount cannot be 0 in Bank Payments/Deposits
· When printing reference numbers instead of internal numbers on documents it should also refer to reference numbers in deliveries and orders.
· Round to nearest value of 0 produced a division by zero error
· Missing ajax trigger in stock_purchasable_items_list_cells. Prices not updated instantly.
· Array helpers moved to current_user. Added array_search_key and array_search_key helpers.
· Fixed change of language in display preferences. Removed sparse $_SESSION['languages'] variable
· Display sql in case of duplicate data error when go_debug=1.
· Removing config.php after error during install. Otherwise misleading message is displayed.
October 16th, 2009· This is a security update.
· Users of version 2.1 are strongly encouraged to update to this release.
October 1st, 2009· Quick entries uses tax types instead of item tax types.
· Support was added for default buttons with Ctrl-Enter/Escape hotkeys.
· Arrow navigation in menus was added.
· There is now the option to use the last document date on subsequent new documents. Inactive records are fully supported.
· Time zone was added on reports.
· There is an audit trail for all operations with a report.
· The bank charge field was added in customer/supplier payment.
· New default fields were added in the company table for bank charge, retained earnings, and profit/loss year.
· Direct allocation of invoices can be done in customer/supplier payments.
· The new access levels/security roles system enables fine tuning of a person's access rights.
September 30th, 2009· Fixed sql error during sales order line update with line cancelation.
· Changed Class Type to Class Name in GL Account groups
· Changed so total in bank payments/deposits shows correctly if negative amount are entered.
· A couple of minor bugs in tax report when displaying supplier credit notes
· Missing freight tax in Customer Balances Report
June 25th, 2009· Layout improvements in sales order and exchange rate forms.
· Closed dimensions showed up in lists.
· Service items now use COGS account instead of Inventory Account.
· Download backup was broken.
· Fixed On Order and demand to also include BOM items (by Tom Moulton)
· Included On Order on Stock Check Sheet, and option to show Shortage
· Nested subaccounts now shown correctly in COA, Monthly Breakdown, Balance Sheet and P&L Statement.
· Changed to present reference number in Print Invoices/Credit Notes if global $print_invoice_no = 0.
· More restrictions on deleting locations.
· More restrictions on Advanced Manufacture Production when out of stock for requirements.
· Changed Advanced Manufacturing payments to be more flexible and simpler. Removed from Payment.
· Changed the Balance Sheet, Profit and Loss Statement and Monthly Breakdown to follow IAS specifications.
· Smart Error logging by switching on a variable.
· Better support for packing of supplier items. Working conversion factor.
· Code clean up.
April 30th, 2009· Fixed a document mailing bug
· Sealing further sql statements.
· Rewrite of backup manager and fixed progressbar bug
· Fixed bug in zipped sql file restore
· JsHttpRequest class updated.
· Preparation for client-side javascript checks.
· Fixed supplier uom retrieval
March 30th, 2009· [0000121] Error during qoh calculations.
· [0000125] Sql error when creating credit note.
· Fixed display of unsufficient quantities in sales docs.
· Fixed quick entry amount update on list change.
[0000120] SQL Error when leaving Default Rate: blank when adding Tax Types. Display/ui fixes:
· [0000126] 'Invoice' words on credit note document.
· Fixed keyboard access issue after AltTab usage.
· Broken currency section after date change.
· Wrong price decimals in Report Salesman Listing.
· Bad thousand/decimal formatting in XLS reports.(OpenOffice).
· [0000124] Cannot add exchange rate
March 18th, 2009· Small layout fix
· Search by item description in item elector fix
· Several errors in gl db banking fixed
· GL line delete bug fixed
· Exchange variances stamped in invoice JE instead of payment JE if invoice date later than payment date (Payment in advance).
· Minor bug in Report List of Journal Entries fixed.
March 9th, 2009· Application startup code cleanup.
· Improved layout in some forms.
· Improved layout in includes themes.
· The calendar style has been moved to the theme default.css.
· Initial prefs for newly created users are now copied from the current admin settings.
· An XLS (Microsoft Excel and OpenOffice calc) engine for alternative report destination.
· The XLS engine is a standalone file and is compatible with the PEAR Excel Writer.
February 3rd, 2009· [0000097] Can't void freehand customer credit note.
· [0000098] Unable issue of credit note for invoice with removed item lines.
· [0000099] New line added to inventory transfer/adjustment sometimes overwrites old one.
· [0000100] Keep getting left allocated weird results (rounding problems).
· [0000102] Credit note was stored without entered shippment cost and comment.
· [0000103] Error during save of modified freehand credit note. Fixed an accounting sync in GL when adding bank account transactions (no customer/supplier trans)
· [0000104] minor language updates in a few sales files Numeric check on class id added.
· [0000111] Accounts on Credit Hold can still process delivery notes on sales order and invoicing
· [0000112] It shows invoices as overdue still (in red), even though its been payed and allocated
December 8th, 2008· Low inventory items were not marked properly.
· Bad computing of tax were fixed.
· Voiding supplier Invoice didn't set to 0 if out of stock Bad rounding of float values in Windows OS was fixed.
· When running undate_db it forgot to create company folders.
November 25th, 2008· The exchange rate can now be opened for editing (without storing) in sales/purchasing module payments.
· A confirm box is now shown when admins are about to remove PO GRNs from Supplier Invoice.
· Voiding a supplier invoice/credit note with GL Postings no longer creates a database error.
· BOM elements are now editable after entry.
· Trial Balance was changed to show all debits and credits (with an option to only show balances).
· The ability to view a transaction before final voiding was added.
· Delivery notes can no longer be edited after they have been voided, and invoices can not be edited if allocated > 0 or invoices have been voided.
· Several minor bugs were fixed.
October 23rd, 2008· Changed design of Supplier Invoice/Credit. Everything is now done in one document form.
· Added Ending Balance in trial balance (also in report)
· Admins can now remove GRNs permanently from Supplier Invoice.
· Minor bugfixes.
October 6th, 2008· correct update after inventory adjust
· credit this immedeately allocates an invoice
· and many more annoying minor bugs.
September 23rd, 2008· Support for cid0 fonts in PDF Engine. Chinese, Japanese, Korean fonts don't have to be embedded. Reduces file size enormously.
· UI Improvements.
· Fix for exchange variation when allocating payments. re-inserted in System and GL Setup.
· F4 support for direct access to Customer/Supplier register from documents.
· Bank Statement Report
September 7th, 2008· This is a bugfix release.