Well, this is an annoyance for you. I can understand that.
Maybe someone else can cast some light on this, please.
I cannot see what else could be a factor of this. If the summation of 2 decimal values could not be balanced normally, I can't understand. Please help us here.

/Joe

1,102

(20 replies, posted in Announcements)

Announcement

This is a preliminary FrontAccounting ERP 2.4 RC1 release.

This version provides a couple of new important features (in addition to all the
features merged from latest 2.3.25 release), but main development effort was
focused on internal architecture changes and cleanups to make future FA development
easier. Please keep in mind the application in current Release Candidate 1 stage is only rougly
tested, so installation on production servers is not recommended yet. Until final
2.4.0 version both software API and database scheme are subject to smaller changes.

At the time of release most of optional extension modules available from central
extensions repo has been also ported to 2.4 and should be mostly usable. Most Themes are
updated and many new Themes are available.

Due to deep changes made under the hood, we highly encourage all current FA 2.3 users
to make test upgrades on a copy of your working installation connected to separate database
filled with your real company data. This will allow us find and fix any possible
upgrade issues before final 2.4 release. Please report any bugs/problems found via our
Mantis Bugtracker at http://mantis.frontaccounting.com.

Download instructions

In Sourceforge FrontAccounting (), select Files -> FrontAccounting 2.4 ->2.4.RC1.

For Windows users select the zip file. For all other users select the tar.gz file.

Common

  • Better vertical alignment of date picker icon.

  • Global fixes in SQL queries aimed to make them more readible and easier for maintence.

  • Cleaning of all comments. Small bugfixes.

  • Fixed tabbed dialogs. Removed redundant 'popup' variables.

  • Fixed bug in price_format() helper leading to problems in various entry forms (e.g. Supplier/Customer Allocation)

  • Supplier Invoices, Supplier Credit Notes: fixed edition form bugs, fixed reference to unexisting $invoice_no variable in add_supp_invoice().

  • Fixed faulty escape string in empty.po.

  • Small cleanups in mail class.

  • PDF documents sent by email have now meaningful names.

  • Added undefined function cache_invalidate() in install/isession.inc

  • Fixed wrong url generated by menu_link helper in final transaction entry menus.

  • Changed example user admin email address from adm@adm.com to adm@example.com. Also minor clean up.

  • Fixed delays during access to external urls (e.g. exchange rate services).

  • Fixed Zend OpCache related issues in extension modules installer.

  • Added Fixed Assets Module. Using Straignt Line, Declining Balances and Sum of All Years methods.

  • New Standard Themes, default, canvans and dropdown.

  • Option to hide Manufacturing and/or Fixed Assets tabs in Company Setup.

  • Enabling Popup Search in Customers, Branches, Suppliers, Inventory and GL Accounts. This is optional and can be disabled by setting $use_popup_search to false. This also works together with built in Search Lists.

  • Updated upgrade procedures.

  • New standard dashboard routines to be used by all themes.

Sales

  • Customer Transaction Inquiry, Supplier Inquiry: fixed icons for closed transactions.

  • Print Deliveries: Fixed not working print as packing slip option.

  • Fixed sparse js dialog when canceling sales document entry.

  • Invoice/Quotation Report: fixed option for printing order as quotation.

Purchasing

  • Transaction Inquiry inside Supplier didn't work. Fixed.

  • Fixing check for non supplier reference. Cleanup.

  • Supplier Invoice/Credit Note. Moved Dimensions entry from left section to middle section for better layout.

  • Print Remittances: fixed usage of sys_prefs 'print_invoice_no' option.

  • Receive Purchase Order Items: invalid date was passed to reference number provider.

  • Direct Purchase Invoice: added link to payment entry on final page.

  • Purchase Order Entry: fixed support for editable items description.

  • Fixed warning about non well formed value in purchase pricing.

  • Fixed edit key icon display in Direct Supplier Invoice.

Items and Inventory

  • Rearranging/Changing fields in Stock Master table.

Manufacturing

  • Produce/Unassemble Finished Items from WorkOrder: fixed syntax error.

  • Option to not use the module in Company Setup.

  • A total rewrite of the Manufacturing routines. Better layout and information.

Fixed Assets

  • New module Fixed Assets added.

  • Option to not use the module in Company Setup.

Bank and General Ledger

  • Tax Report: not taxable sales printed in separate summary line.

  • Tax Inquiry: fixed references to non-existing database fields.

  • Void a Transaction: fixed GRN voiding.

  • en_US-demo.sql and en_US-new.sql cleanup

  • Bank Account Inquiry: fixed missing counterparty info for some transactions.

  • Profit & Loss Drill Down fixed regression in reference period selection.

  • Fixed typo in gl_deposit_view.

  • Fixed dependency problem during fiscal year closing.

  • Reconcile Bank Account dhould not show void transactions

  • Fixed bank account balane checking procedure.

/Joe

It seems that the original account have some records with some decimal left over.
I would make a backup of your company to an sql file.
By an editor you could look up your transactions for the original account and fix the decimals to your normal ones.
Be careful, though. Maybe you should spare an extra copy of your backup, should yo do some mistakes.
When you are ready, then restore the corrected sql file on your company.

Hopefully it should not show up now.

/Joe

1,104

(2 replies, posted in Announcements)

Announcement

This is a 2.3.25 bugfix release.

Common

  • Fixed vertical alignment on date picker icon

  • Fixed deactivate_extension hook execution on extension deactivation.

  • Improved safety handling of bad PHP interpretor releases.

  • Fixed es_MX installer translation file.

Sales

  • No display of shipping costs if there are no shipping costs on sales documents or views.

Purchasing

  • Fixed net value calculations for GRN leading to unbalanced clearing account.

  • Fixed hardcoded amout_row fixed 2 decimals. Removed and the default user_price_dec() is used.

Manufacturing

  • Fixed wrong calculaiton of standard cost during Advanced Manufacturing.

  • Fixed correct calculation of stock_moves standard_cost when producing an Advanced Assembly.

  • Fixed Material cost calculations for quantity = 0.

Banking and General Ledger

  • Accounts entry. We only accept 0-9 and a dot if $accounts_alpha = 0 (default).

  • Tax Report: duplicated lines were listed for edited transactions.

You need this reference number if you are negotiating with your supplier.

Joe

1,106

(1 replies, posted in Installation)

There are several bugs in the 2.4 beta. If you wait a while the 2.4 RC1 will be released. We have been working hard on this release and I hope it will ship shortly.

/Joe

1,107

(4 replies, posted in Misc. Charts of Accounts)

Check to see if your account COA has been updated in the repo. You can do that by selecting Install / Update chart of accounts in the Setup tab from inside 2.4. Look if your COA is there.

Joe

I have contacted Janusz again for a reminder.

Joe

1,109

(2 replies, posted in Accounts Receivable)

This can be changed in the POS setup under Setup tab. This is a per user setup.

Joe

you must first create a GL account to be used for the Bank Account.

/Joe

1,111

(2 replies, posted in Setup)

Hello, glad you like FA.

This font can be downloaded from our website, https://frontaccounting.com. Look after the fonts download. I am out of office right now, so I am not sure where this font is.

Copy the zip file to the /reporting/fonts folder and unpack it. Then delete the zip file.

Now try to print again. It should work now.

Joe

We have reversed a wrong commit in the manufacturing gl transactions when the stock is negative.
Just wait for the nezt minor to get updated.

Joe

1,113

(10 replies, posted in Report Bugs here)

The problem is due to missing

require_once($path_to_root."/includes/ui/items_cart.inc);

line at the top of /admin/db/fiscalyears_db.inc.

You can insert it yourself and thank you for detecting this bug.

It will be fixed asap in the repository to go to release candidate 1 shortly.

/Joe

Please set the variable, $go_debug, in config.php to either 1 or 2 to trap errors.

And report back. This is not a known error.

Joe

1,115

(10 replies, posted in Report Bugs here)

Please, set the variable, $go_debug, in config.php to either 1 or 2 to trap any errors.
I suspect a missing default account for profit and loss current year.it might also be another error.

Also pleaße tell us the release number of FrontAccounting and other os

Joe

1,116

(3 replies, posted in Accounts Payable)

The issue is the allocations that are done during the balances. You can set the parametre flag, Show Balance, to true for better syncronization.

Joe

If you want to report a 0 tax sales/purchases amount, then you should create a 0% tax type and include that into a group.

There are more explanation in the wiki regarding this.

Joe

Do you mean release 2.3.24 or 2.4 Beta? And Maybe som more details please, if you can.

/Joe

Hello,
Yes it is possible. Please have a look into Search not invoiced deliveries in Sales tab.
Here you will se a column with checkboxes for batching the deliveries.
Maybe you can get an idea from here.

Joe

Yes, I guess so. We will have to address Janusz with this.

Joe

@Bogeyman2007

Your code for popup search has been implemented in 2.4. Is has been modified slightly to work with the existing list searck for customer, suppliers and items. It works well and I thank you for your contribution.

Do you want to get credited with a form of a name, please let me know.

The popup search can be disabled for those wanted that.

Joe

1,122

(5 replies, posted in Announcements)

Thanks for sharing this. I have seen similar approaches in various open source db classes.The idea is fine, but I also see some negative effects about this. For seasoned SQL writers, you can loose the overall view of your SQL syntax.
But let this be subject for discussion.

/Joe

This ugly  bastard is now fixed in both 2.3.24 and 2.4 Beta.

/Joe

Well, i would agree that the numbers should be updated automatically, but we have discussed this internally, and there were other problems involved here. I will let Janusz comment on this.

Joe

@apmuthu
Yes the error should be enabled. If there are no customers and/or branches in the system, there should be an error reported before you can proceed. Will have a look.
@seend
In the meantime, please set the $go_debug variable first in the file config.php to 1 or 2, to trap any errors.

Joe