351

(4 replies, posted in Announcements)

Announcement

This is a 2.4.9 release, which is mainly bugfix release, but also contains a couple of improvements (see below for details).

Please report any bugs/problems found via our Mantis Bugtracker at http://mantis.frontaccounting.com.

Download instructions

In Sourceforge FrontAccounting (http://sourceforge.net/projects/frontaccounting), select
Files -> FrontAccounting 2.4 ->2.4.9.

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

Common

  • closed.png icon was missing in canvas and Dropdown themes. Fixed

  • Updating standard sql COAs

  • Fixed PHP 7.4 compatibility bug

  • Install/Update Languages: fixed directory traversal issue.

  • Bug 5200: Attach Documents: filename length check added to avoid unexpected error on long names.

  • Bug 5179: Added max parameter to textarea*() helpers, added constraints on all memo/comments input fields.

  • Bug 4756: Amounts in words on documents were printed in user language instead of document contact language. Fixed.

  • Bug 5198: Attach Documents: constrained attachment file types to avoid XSS using javascript in SVG. Thanks to Bobby Lin.

  • Fixed warnings related to empty item/customer/supplier selector in search modes.

  • Bug 5209/5266: Reports: fixed broken reports after session timeout.

  • Bug 5188: Attach Documents: fixed user interface to reset input fields only when needed.

  • Improved login form in layout default theme.

  • Bug 5239: Revaluation of Currency Accounts: removed sparse reference field, fixed comments for generated journal transactions.

Sales

  • Customer Payments: additional checks to avoid data inconsistency possible on weak connections.

  • Issue 5081: Editing a customer payment which is not allocated to an invoice and using the allocation table changes the payment amount. Fixed.

  • Recurring invoices result in no dimensions on gl_trans. Fixed by company flag option.

  • Delivery Against Sales Order Inquiry View, Wrong Remainder Value. Fixed.

  • Print Long Item Description on Invoice. New feature activated by company setup flag.

  • Optimizing Invoice Document (rep107.php).

  • Bug 5220: Delivery Against Sales Order: bug in GL balance for prepaid order delivery to foreign customer. Fixed.

  • Bug 5178: Fixed customer selection via popup after missing inline customer search.

  • After creating Sales Order - sending email: PDF without a name? Fixed.

  • Bug 5194: The company name is not displayed on invoices if the logo is set. Fixed.

Purchasing

  • Payments to Supplier: additional checks to avoid data inconsistency possible on weak connections.

  • Bug in Supplier Credit Note Edit, Fixed.

  • Bug in purchase order delete when invoking hook_db_prevoid () Fixed.

  • Bug 5202: Supplier Payment: Fixed allocation table refresh after change in supplier selector.

  • Bug 5223: Fixed Asset Purchase, Direct Supplier Invoice: fixed invalid cost handling for invoices in foreign currency.

  • Bug 5187: Displaying the list of suppliers in the void part is either wrong or buggy. Fixed. Same bug in View or Print.

  • Bug 5190: Supplier Invoices: Supplier reference field was unnecessary cleared on supplier selection change. Fixed.

  • Bug 5263 Added update button for total on supplier invoice entry when tax is changed.

  • No supplier trans found for given params in Supplier Payment. Fixed.

Items and Inventory

  • Quantity On Hand (QOH) Now Available On Inventory Adjustments

  • Bug 5106: Incorrect field length for inserting a kit. Also in Foreign Item Codes. Fixed.

  • Negative Inventory Adjustments not working anymore (2.4.8). Fixed

  • Bug 5214: Stock Check Sheet: changed option name to less confusing for shortages printout.

  • Bug 5186: The field lengths of item name and description don't match. Temporary fix (final fix postponed to 2.5).

  • Bug 5189, 5211: Items, Company Setup: additional check to ensure uploaded image compatibility with TCPDF report generator. Fixed

Manufacturing

  • Bug 5083: manufacturing creates bank transactions but void does not delete them. Fixed.

Fixed Assets

  • Bug 5170: Fixed Assets Purchase: fixed error on items with long description, removed sparse fields edition in Fixed Assets.

  • Bug 5232: A disposed fixed asset still appears in the fixed assets valuation report with a non-nought price. Fixed.

Dimensions

  • Dimension wise balance sheet items implemented.

Bank and General Ledger

  • GL Account Transactions Report: improved layout when dimension 2 is not used.

  • Annual Expense Breakdown Report: option to print in thousands, added column for annual totals.

  • Deleting a fiscal year problem fixed.

  • Trial Balance - added Group Totals Only checkbox.

  • Journal Inquiry, the Counter Party column is not showing when invoice. Fixed.

  • Bug 4964: Balance Sheet Drilldown, Profit and Loss Drilldown: Fixed invalid navigation via Back links.

  • Report Audit Trail. Added totals when type selected.

352

(7 replies, posted in Dimensions)

The balance on dimensions is already implemented in a commit for 2.4. So it will be available in release 2.4.9 that is about to release soon.

Joe

Committed to stable 2.4.8 repo.

Fixed files can be fetched here and here.

/Joe

Thanks @notrinos.

I will fix this later today.

Joe

355

(7 replies, posted in Reporting)

I would rename the Invoice to Contract or Contract/Invoice. And create a service item as a sub contract. Then either use normal payments/prepayments and allocations.
Then you can send the Statements out to your customers.

/Joe

I cannot reproduce this error. Which version? Environment?

Joe

357

(3 replies, posted in Reporting)

This has been fixed and committed to stable 2.4.8 repo.

The fixed file can be downloaded here.

/Joe

We have a huge amount of sys_prefs fields already. Maybe a candidate . Will have a second thought. I am not sure if all of them have been wikied.

Joe

Hello guys.

Sorry for the delay. Will look into this

Joe

360

(10 replies, posted in Development)

Increase Supplier Item Description in Purchasing Data from 50 characters to 200 characters.

Item fields like minimum price, minimum discounts per salesman/customer.

Joe

This fix has now been committed to stable repo.

The fixed file can be downloaded here.

/joe

@rafat
Yes, you are right. The problem is that the CSS conditions are not easy to implement. In my point of view the Browsers should fix this when we have ordered it to have the dir='rtl'. The Browsers do the best they can, but this is not good enough.

I have got really interested in solving this, and I hope all of you developers will help me. I will also dig further to get better design for the rtl languages. I will also try to fix many of the popular themes to behave both ltr and rtl.
Thanks for testing.

Joe

I don't understand what is achieved with this version of TCPDF. This version is more than half a GB bigger than our current version, that is working perfectly.

Joe

I will send it to your forum email.

/Joe

Hello again,

After being testing and evaluating, I came up with that we will have problems using the JS client-side graphics engine.
We will have problems uploading the locally created graphics to the server for printing in PDF etc., so I ended up with upgrading our own class.graphic.inc file. It can now handle the vector graphics used in various JS client Libraries. But it handle it from the server side. The class.graphic.inc also supports multiple series, not just 2 as before. And of course it handles all the 'old' graphics, like PNG, JPG and GIF too. Everything is updated to handle the modern graphics as Beziers Curves like Spline, Half donuts. Writing text inside donuts and so fort. The reason for keeping these graphic engines is that when printing to PDF we use the PNG variant. If we should print the new SVG routines we would have to update the TCPDF to a newer version and add half a GB to our project, and this is not my cup of tea!
The updated graphic class can also be used to short SVG graphics inside the html using the member class SVG inside the class.graphic.inc file. I have some examples that I will show you later.

Please have a look at it on the site:

http://frontaccounting.co.uk/fa248
user: admin
pass: 98765

The demo will be up for a week.

In the mean time Janusz has been updated several of the Mantis bugs, so we can be up-to-date with the bug-fixing.

We are still planning for 2.5, but it is important to be rather bug-free before we concentrate on that.
This new graphic class can be used in the existing 2.4 version. There are no required database updates for that. So it could be included in the upcoming 2.4.9. Would that be ok?

@rafat.
Please have a look at the RTL version. In my opinion it seems ok, but as you know, I'm not an expert.

/Joe

Fixed and committed to stable repo.

/Joe

I will have a look at this.

Joe

I will ask Janusz to update the coa repo.

Joe

I don't know. Probably. I will have a look tomorrow.

/joe

You don't have to delete it. Just remove the group number from class COGS and point it to an expense class. This way you will not see it in practise. If no groups is using the Cogs class it will not be seen. At least I hope so.

Joe

371

(8 replies, posted in Announcements)

Interesting. Thanks @apmuthu.

Joe

372

(6 replies, posted in Reporting)

Hello, I have been looking at this old commit, and going through the operations as explained, I can find no errors here.

Are you sure, you have the correct tax report dates when you look at the tax inquiries/reports?

Otherwise, please be more detailed so I can dig deaper.

/Joe

373

(6 replies, posted in Reporting)

Strange, I will have a look.

Joe

You can download the latest snapshot from the repo here. This contains the dimension booking on AR and AP and bank.

/joe

Hard to tell. We are waiting for some rewrite of stock code. But we are trying to force the release.
In the meantime you can make a test version on release 2.4.8. Looking forward to see it.

Joe