@detkenn

This looks great. Would you mind share the code here? I will then review it and commit it to 2.4.8 repo.

Joe

Have asked Janusz to look into this.

Joe

428

(8 replies, posted in Announcements)

Announcement

This is a 2.4.8 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.8.

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

Common

  • Bug 4980: The field characters size of "Memo" in voiding a transaction doesn't correspond to the field size in the database. Fixed by cutting the text to 60 characters in audit_trail.

  • Bug 4987: In rtl languages, text aligned centered is printed aligned right in PDF documents. Fixed.

  • Voided Documents Still Exist In Drop-down when printing. Fixed.

  • Bug 5009: Page # on invoices counts up across invoices. Fixed for all documents.

  • Count error when printing to Excel. Fixed.

  • Formatting error in dashboard.inc fixed.

  • Bug 4988: Auto Increase of Document References can't be disabled. Fixed.

  • Uninitialized string offset in main.inc Fixed for php >= 7.0.

  • Improved F2, F3 and F4 keys (Customers/Suppliers, Customer Branches and Inventory & Items) in Sales/Purchases forms.

  • Added missing new install translation files, nb_NO and nl_NL.

  • Backup and Restore: Added support for views

  • Updated standard COAs (moved dates forwards).

Sales

  • Credit Note Modification: fixed check whether transaction is editable.

  • Limit editable stock items list in Sales Order, Credit Notes to 50 chars.

  • Paged transaction inquiries optimized for maximum links in Sales and Purchasing. Allocate Customer Payments or Credit Notes: fully allocated payments with discount where still displayed even with settled option off, fixed.

  • Report Sales Listing: fixed duplicate lines in report .

  • Fixed misleading database error message in sales_order_db.inc.

  • Added new attachment types for customer specific documents.

  • Bug 5013: Zero invoices create zero payments and cause db error upon view payment. Fixed.

  • Misspelled parameter in rep115.php, Customer Trial Balance. Fixed.

  • Recurring invoices - improved period covered description.

  • Customer Payment Entry - Scrolling behaviour when clicking All or None. Fixed.

  • Sales Order Inquiry Sort Descending, Fixed.

  • Bug 4904: Customer Credit Note: fixed invalid inventory GL postings for service items.

Purchasing

  • Purchase Order View: fixed dates, added overdue delivery marker.

  • Code cleanup in supplier_invoice.php and supplier_credit.php.

  • Supplier Invoice: on form opening currency was not displayed for foreign supplier.

  • Bug 4946: Inserting a supplier without the short name resets the whole form. Fixed.

  • Bug 4944: The field characters size of Supplier's Reference is too short. Fixed.

  • Supplier Invoice: Wrong alignment in 2 first columns when selecting items to invoice. Fixed.

  • Paged transaction inquiries optimized for maximum links to Sales and Purchasing.

  • Bug 4950: Field for supplier name is too short in the supplier form. Increased from 40 chars to maximum 60 chars in the Suppliers form.

  • Added new attachment types for supplier specific documents.

  • Tax rate displayed twice in rep209 (Purchase orders). Fixed.

Items and Inventory

  • Inventory Adjustment: fixed error in adjustment entry when inventory notifications are switched on.

  • Inventory Adjustment: negative adjustment should always use current average item cost.

  • Bug 4920: Search icon in 'items table' wraps underneath select combo when screen width reduced. Fixed.

  • Inventory Item Movements: Purchase Order Delivery and Credit Note has in reference column trans_no or Return memo presented instead of reference. Fixed.

  • Inventory location transfer from sales kit did not work. Fixed.

Manufacturing

  • Clone Manufactured Item -> Clone BOM.

Fixed Assets

  • Fixed Assets Depreciation: removed invalid and obsolete audit record update.

Bank and General Ledger

  • Audit Trail: regression in audit history (after sql strict mode related changes) fixed.

  • Strict SQL related error when background journal transaction was saved. Fixed.

  • Journal Inquiry Dates should follow the User Preference Transaction Days. Fixed.

  • Show more relevant info in CounterPart Field, Journal Inquiry.

  • Bug 5002: Journal Inquiry: incorrect amounts displayed for journal entries with more than one customer/supplier accounts, fixed.

  • Bank statement report with 'All' Selection of Bank Accounts fixed.

  • Amendment Required in rep601.php (Bank Statements) for voided transactions. Fixed.

I cannot reproduce this error. The function uniqid() is not strong enough for the purpose. However it is up to you.

I have asked Janusz to look at it.

/Joe

I don't know. We have tried to do our best by using the DELTA factor.
We can await @Braath Waate's approach by @paul testing it.

/Joe

This has been optimized and committed to 2.4.7 stable repo. Thanks for helping.

/Joe

If you want to use the Customer Branch field 'Group' for entering the Sales Type too, you must first create the Sales Group. F.i. Wholesale. And then select this on the Customer Branch. The fields Customer Sales Type/Price list and the Branch Sales Group has no key bindings. This is not the same thing.

Doing it this way, there are no problems using it.

Joe

Hello @dearmosin,

I cannot reproduce what you are saying. The Sales Type/Price List is saved on the Customer and not the Branch.
And while testing this, the Sales Type/Price List is updated correctly.

/Joe

Hello,

This has now been fixed. Also for Suppliers (F2 if inside Purchasing). The files have been committed to 2.4.7 stable repo.

However, I have asked Janusz to look at the width of the popup windows. Especially for Items but also for Suppleirs, if a new Supplier is selected.

Thanks @christiart for observing this.

/Joe

I wil fix this during the day.

Joe

I have asked Janusz to look at this.

Joe

437

(6 replies, posted in Reporting)

This has been fixed and committed to 2.4.7 stable repo. A fixed file can be downloaded here.

/Joe

This has been fixed and committed to 2.4.7 stable repo. A fixed file can be downloaded here.

/Joe

You have to be Senior Member to get access to the Developer Forum. You will be a Senior Member when you have posted about 50 posts.

Joe

This has been committed to 2.4.7 stable repo.

/Joe

I will check, but @FreeMan, what is the difference between the current sentence and the fixed one?

Joe

I will have a look at it later.

Joe

Hello Guys.

Yes as @rafat explains there should be no restrictions on booking on open years. But

1. Check in Banking and General Ledger that the period is not closed for further entries.
2. After changing the Access Role, you must logout/login again.

Joe

@boxygen. Thanks for seeing this.
Fixed and commit to 2.4.7 stable repo.
A fixed file can be downloaded here.

Joe

Fixed.

Joe

446

(7 replies, posted in Reporting)

This has now been implemented in 2.4.7 and committed to stable repo.
The fixed files can be downloaded https://sourceforge.net/p/frontaccounti … rep601.php
https://sourceforge.net/p/frontaccounti … s_main.php
https://sourceforge.net/p/frontaccounti … lasses.inc

/Joe

447

(7 replies, posted in Reporting)

The solution mentioned by @apmuthu seems the best one. The routine bank_accounts_list needs an extra parameter to opt. for the 'All' solution.
I will implement this asap.

Joe

448

(7 replies, posted in Reporting)

Yes, maybe a good idea. Will have a look.

Joe

This has been fixed and committed to stable 2.4.7. Thanks for seeing this.
The fixed file can be downloaded here.

/joe

I have no straight solutions. We have been discussing the so called landed costs over the years. You can search the forums for 'landed cost' or something like that.

I found a QuickBook discussion about the subject.

https://quickbooks.intuit.com/learn-sup … /00/261126

Maybe this info can be of interest.

Joe