Ah, I see. This is the only place where the variable ar_classes is declared as an array.

Your solution will fix this issue elegantly.

Committed.

/Joe

Hello,

This is strange, because this is not a constructor. Will try to examine this.

/Joe

753

(5 replies, posted in Reporting)

Hellog Guys,

I guess this is a strong candidate for an Extension. Not many countries has this legal demand.

/Joe

754

(37 replies, posted in Installation)

@apmuthu

I am having a meeting with Janusz next weekend.

If you mail me the issues that I should discuss with Janusz, please email me them.

This issue here, can be fixed as you describe, but is it good enough?

/Joe

755

(37 replies, posted in Installation)

Which versions of php do have this problem?

Joe

Hello,

I have committed the Summation of the Outstanding Open Balances in this report, Customer Balance.

Still investigating the allocation column, although this is not an important column, but anyhow.

/Joe

Haven't heard of this before!

Joe

@boxygen

Please try this change in rep101.php. Rename the rep101.php1 to rep101.php and replace.

Tell me if the outstanding column is correct now when selecting Show Balance to No.

I guess the allocation column still has some discrepancies.

I want this clarified before continuing with the allocation column.

@apmuthu and @boxygen
Maybe we can inplement the Branch selection too. If we write this information above in the report with the other parameter info, I guess we need no more columns. Right?
Sorry Guys. We have no link between the customers and branches in Report Selections, so it will be a major change here. So be patient, maybe in the next major.

/Joe

If we first look at the Customer Balance Report with the Show Balance set to Yes.

Then the sum of all credits and debits and balance are shown correctly for closing and opening balances. The discrepancy in the allocations have something to do with the time of allocations (not really importing for the report. Maybe we should eliminate the summation for the allocations). The balance column is correct and this is very important.

If the report is taken with the Show Balance set to No.

The sum of all credits and debits are shown correctly. Here the lines are calculated on a record base line by line. The total of all outstanding with allocations added gives the total balance (the same result as on the balanced report).

Again the discrepancy in the allocations aare subject to closer investigation from my side. Will do this asap, but I am still rather overloaded with other work.

Of course you are welcome with suggestings regarding the Sql statements.

Joe

760

(5 replies, posted in Reporting)

No plans for including branches in the Customer Balance.

It should be an extension or maybe a company report.

Joe

@notrinos.

You are right. This is the reason why no errors are reported from MySql.

This is a redundant function at the moment. This should be removed. Will discuss this with Janusz.

Joe

This has been committed. Strange that this passed the MySql server without warnings!

Thanks for catching this.

/Joe

@Braath Waate

Thanks for your thoughts. It seems that the way could be to enter these landed costs when the supplier invoice in entered. I guess these costs will first appear when the invoice is received.
And we could make the final adjustments, just like we do now if the prices are different from the PO.

I think Janusz will enter this discussion in a while. I will try to get him active smile

/Joe

@apmuthu

No I guess not.
-----
Regarding the open balances. There should be no differences when you check the 'Show Balance' box. The Sum of all record outstandings before the period should be the same as the Open Balance.
There might be some allocations that are not done that can influence on the period result.

But I cannot reproduce any errors here.

@boxygen
Please be a little more specific regarding your observation.

/Joe

@boxygen

Hello, I am overloaded with other work this week and next week. If you have a suggestion for changing the sql, then I would be extremely glad smile

/Joe

766

(4 replies, posted in Announcements)

Announcement

This is a 2.4.4 release.

This version fixes a couple of serious bugs as well as some minor bugs.

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

Download instructions

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

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

Common

  • Misleading on system diagnostics (MariaDB), fixed.

  • Adapting to google's error when getting exchange rates. Fixed.

  • Backups/Restore: fixed compressed backup view, fixed obsolete ajax indicator during download.

  • Google and Bloomberg Exchange Rate fix.

  • System Diagnostics: fixed set of tested themes directories.

  • Third party extensions installation fixed.

  • Installed Third Party extension version display.

  • Added VARLIB_PATH and VARLOG_PATH defines to simplify packaging.

  • Password field in installer changed to hide text.

  • Company Logo On Reports. Better Logo align.

  • Added deferred income account and prepayment terms in init sql files.

  • Void a Transaction: keeping date unchanged after transaction voiding to allow continuation on date.

  • Reference edit boxes has been extended to show 16 chars instead of 10.

  • New installer translations (Hindi, Tamil, Vietnamese), updated gettext template.

Sales

  • Fixed rounding differences in sales delivery and invoice.

  • Sales Area list, added 'No Area Filter'.

  • Fixed bank account auto-selection on Customer Payments page.

  • Fixed printing sequences of Sales Invoices.

  • Fixed a Shipping bug in Sales Order Report.

  • Fixed redundant $sign in reports Sales Order, Sales Quotation.

  • Added a Total Amount for Sales Orders Report and a Grand Total.

  • Sales Order Entry: initial item selector position points to last ordered item
    (seems to be more useflist than always selecting first item in selector).

  • Added POS name in cash payment memo.

  • Opening Balance bug in rep101.php (Customers Balance).

Purchasing

  • A white screen on Supplier Invoices and Supplier Credit Notes when no supplier defined. Fixed.

  • Fixed redundant $sign in report Purchase Order.

  • Bank Payment: for selected supplier payment set supplier account dimensions.

Items and Inventory

  • New company setting 'Barcodes On Stock' implemented. Rep303 shows barcodes if set.

  • Inventory Valuation Report showing 0 (zero) on Unit Cost and decimal precision fix.

  • New Report: Inventory purchasing transaction based report.

  • Fixed a minor weird bug in QOH in inventory Planning Report.

  • Wrong error message in Save Items.

Manufacturing

  • Stock Status display, Manufacturing Reports: fixed products on WO count.

  • Work Order Entry, Work Order Additional Costs: fixed input data checks.

  • Produce Finished Items: fixed broken document reference (changed input order).

Fixed Assets

  • Better check for fixed assets.

Bank and General Ledger

  • Sort Chart of Accounts by name. Fixed.

  • Account Class/Group drill down added.

  • Subledger list shows inactive records in Journal Entry. Fixed.

  • Fixed get_shipping_tax_as_array() definition (default null as argument).

  • Journal Edition: allow edit reconciliation status for bank related journals.

  • GL Inquiry: search by memo, added journal edition link.

  • Reconcile Bank Account: added memo display, added Reconcile All button.

  • Changed GL Inquiry to also include the Reference Number.

I have never heard of any problems here before. Please be a little more specific. If this is an error the test is very hard to setup, so please be sure that you have observed a problem.

Joe

768

(13 replies, posted in Reporting)

Yes this is right.

/Joe

All Reference Edit Boxes has been extended to show 16 chars instead of 10.

Committed to 2.4 SF Git Repo.

/Joe

Yes we will increase the field a bit.

Joe

771

(7 replies, posted in Report Bugs here)

The former commit of this issue has been rolled back due to the unknown consequences needed by the backwards compatibility to the prior php 5.6 versions.

Janusz will give a short explanation to this.

/Joe.

@apmuthu.

Janusz has explained this in a former post to this topic.

/Joe

773

(7 replies, posted in Report Bugs here)

This has been fixed and committed. Thanks.

/Joe

This has now been fixed and committed to 2.4 Repo.

You can download a copy from here:

Download.

/Joe

Hello,

The Reference number is not the same as the # number. The # number is an internal number. Please use the Reference number as the official number. If you need an ongoing number, use default numbering template (the one with empty prefix) for this purpose.

I will fix the GL Inquiries to also show the Reference number. And I will look if there are more places that this is needed.

/Joe