551

(7 replies, posted in FA Modifications)

Sorry Joe, I may have confused you with my lack of understanding of how the code worked... please ignore last post

552

(7 replies, posted in FA Modifications)

@ Joe, not sure if this is an easier option:-

Leave account types as they are, (as a non-accountant and looking at the code above I'm assuming FA calculates in a different way by type) but when creating trial balance (in program or as a report) and printing COA etc. sort by ID not type? You've probably already considered this..

@apmuthu I think i have the right patch, its the last one in this post FrontAccounting forum - Release 2.4.2

Post #5 by yourself?

I don't have time to test now, but will do later.

ok... good! Shall I enter this in the mantis bug tracker?

555

(7 replies, posted in FA Modifications)

Is there any reason why this cannot be default in FA?
Why? In Colombia expenses is #5 and cost of goods sold #6 so when viewing/ printing COA, trial balance etc we get the order 1,2,3,4,6,5  so therefore have to download to excel and sort from there.

Standard pricing & Inventory Valuation Report showing 50% on manufactured item cost:-

Created item component 'orange' cost and purchased for 100
Created item component 'lemon' cost and purchased for 200
Created item finished goods 'oranges & lemons'

Manufactured 2 oranges & lemons Inventory Valuation Report shows unit cost as 150 total cost 300 (-50%)

standard cost gives a price of 150 (-50%)

However Costed Inventory Movement Report gives a cost of 300 (this is correct)

If I manufacture more oranges & lemons the standard price and the cost in the IVR increase, this increase seems to be the same behaviour as a purchased over time at different costs.

This seems to be another subject  with a myriad of posts about it and I'm a little confused. Is this correct?

FA 2.35 works correctly.

Setup info:-

This is on a clean install of V2.4.2
Theme default
Database 10.0.27-MariaDB-cll-lve
PHP V5.6.31
Server - Linux
Shared hosting.

After pressing process supplier invoice I get the following error flash up for approx 1 - 2 seconds:

Undefined variable: net_total in file: ........../purchasing/includes/db/invoice_db.inc at line 396

After it appears the screen returns to where it should be after creating a supplier invoice and everything seems to have processed correctly. (I managed to catch it by pressing [PrtScn] quickly)

Setup info:-

This is on a clean install of V2.4.2
Theme default
Database 10.0.27-MariaDB-cll-lve
PHP V5.6.31
Server - Linux
Shared hosting.

558

(12 replies, posted in Reporting)

Hi, this is excellent, will it be included in the next version? Or only as an mod?

559

(19 replies, posted in Report Bugs here)

I know you have not actually done an upgrade, but effectively you have.

The 2.3 database will not run in 2.4, there have been many changes, most noticeably in your case references have changed to reflines, so you need to continue with your upgrade:-

Its all explained in the update.html file which is in FA's root directory - Please read this 1st - I've completed many upgrades by following these instructions and never had a problem.

There are 2 parts to the upgrade, the software upgrade and the database upgrade, from your description and the screenshot, it 'looks' like you have done the software upgrade, now you need to do the database upgrade - I think you need to go to Setup - Software Upgrade (this is really the database upgrade), this should show you that you have an upgrade - click the 2.4 upgrade and it will make the necessary changes in the database. It will take a while to make the necessary changes, this will depend on the size of your database.

To answer your question

In which folder exactly there is a  update  script for the document Change or reference 'UPDATE' .

Its in the "sql" folder. Have a look at the sql in this file and you will see that it corresponds with your screenshot errors. You could run this directly in myphpadmin, but the software upgrade works fine and I've used it numerous times.

560

(11 replies, posted in Accounts Receivable)

It is quite clear in https://frontaccounting.com/punbb/viewtopic.php?id=922 but I am embarrassed to say that's the first time I've read it... but I don't think I'm the only one?

I often see your 'This info has been wiki-ed.' at the end of a post, so thought you or any one else who edits the wiki could add on '(To edit the wiki yourself, simply log-on using your forum sign-in name & password and go to the page you wish to edit and click the edit button in the bottom left corner)' as some extra publicity for wiki editing? I think the stickies need to stay.. something's just need to be repeated.

Edit: Just completed my education...all stickies read

561

(11 replies, posted in Accounts Receivable)

Perhaps it needs to be advertised more?

Maybe..

"This info has been wiki-ed.
(To edit the wiki yourself, simply log-on using your forum sign-in name & password and go to the page you wish to edit and click the edit button in the bottom left corner)

562

(11 replies, posted in Accounts Receivable)

apmuthu wrote:

Thanks @joe and @poncho1234. This info has been wiki-ed.

Added a bit too...didn't realise we were able to edit the wiki??..!!

563

(11 replies, posted in Accounts Receivable)

Thanks @Joe, that does it.

@apmuthu, for this case it would have to disregard taxes though.

564

(11 replies, posted in Accounts Receivable)

Ok, but how do you do 'adhoc discount after tax'?

In another post I read that negative prices can be made for service items; so I created a service item with same name as free gift, but excluding tax.

This gives more or less the desired result on the invoice and accounts.

But still interested to look at your 'adhoc discount after tax'.

565

(11 replies, posted in Accounts Receivable)

Local tax laws require VAT to be charged on free gift - (either purchase price or normal sale price) and the invoice needs to reflect this.

Is this possible with frontaccounting? If so then how?

Example:-

Item (Normally a non-stock item) purchased for $10.00
VAT is 20%

The invoice will state:-

Item (free gift)            $ 0.00

VAT @ 20%                 $ 2.00

Total                           $ 2.00

Any help appreciated

566

(22 replies, posted in Report Bugs here)

@apmuthu & @joe - Hi, is anything happening on this issue?

567

(22 replies, posted in Report Bugs here)

@campbell, tried most of day to get content type working, but thanks for suggestion.

568

(22 replies, posted in Report Bugs here)

function email($name, $mail)
    {
        $this->boundary = md5(uniqid(time()));

        if (extension_loaded('imap')) {
            $this->header = "From: =?UTF-8?Q?" .imap_8bit($name) ."?=". "<$mail>\n";
        }
        else
            $this->header = "From: =?UTF-8?B?" .base64_encode($name) ."?=". "<$mail>\n";

        $bcc = get_company_pref('bcc_email');
        if ($bcc)
            $this->bcc[] = $bcc;
    }

and

function subject($subject)
    {
        if (extension_loaded('imap')) {
            $this->subject = "=?UTF-8?Q?" .imap_8bit($subject) ."?=";
        }
        else
            $this->subject = "=?UTF-8?B?" . base64_encode($subject) ."?=";

    }

Functions and tested

@campbell, Hi, the problem is not with the body, its with the header and the subject.

569

(22 replies, posted in Report Bugs here)

@apmuthu it says its experimental? Are there FA users with unusable email addresses? If yes can you point me to the relevant post or give an example.

I will try to do an if / else tomorrow. Trying to think how I will test it... any ideas?

570

(22 replies, posted in Report Bugs here)

The other item that needs to be sorted out is the subject; the following works for me; replace class.mail.inc line 77 from:-

function subject($subject)
    {
        $this->subject = $subject;
    }

to:-

function subject($subject)
    {
        $this->subject = "=?UTF-8?B?" . base64_encode($subject) ."?=";
    }

or

function subject($subject)
    {
        $this->subject = "=?UTF-8?Q?" .imap_8bit($subject) ."?=";//you will need the imap module enabled
    }

I believe this only leaves the email addresses, which 'generally' are not allowed to include diacriticals. (though there is some debate about this - Google 'Are accents allowed in email addresses' - for starters)


Very interested in your comments.


What is the history / background? ie Did company name and email subject function with accents before the change to utf-8?

571

(22 replies, posted in Report Bugs here)

Working solution:-

Replace class.mail.inc line 49 from:-

$this->header = "From: $name <$mail>\n";

with either:-

$this->header = "From: =?UTF-8?B?" .base64_encode($name) ."?=". "<$mail>\n";

OR

$this->header = "From: =?UTF-8?Q?" .imap_8bit($name) ."?=". "<$mail>\n"; //you will need the imap module enabled

depending if you want base64 or imap

You should now be able to use any diacritical in your company name.

@apmuthu I'm struggling with the  mb_send_mail() & mb_encode_mimeheader(), from my understanding this encodes the whole header: When I got it to work it actually used my servers email address as the from, whereas in the above solution the actual servers email address is hidden and the company email address is shown as per FA functionality.  Can you help?

572

(22 replies, posted in Report Bugs here)

Ok, I have a partial solution which looks promising:-

From my understanding $name is not encoded so accented char will never work, this post at stackexchange pointed me in the right direction, so changing class.mail.inc line 49 from:-

$this->header = "From: $name <$mail>\n";

to

$this->header = "From: =?UTF-8?B?" .base64_encode($name)."?=";

does work, BUT:-

does NOT include the newline \n so the from $name is followed by the Bcc: bccemailaddress@example.com

So I tried to introduce a new line with the following code:-

$this->header = "From: =?UTF-8?B?" .base64_encode($name)."?=", "\n";
and
$this->header = "From: =?UTF-8?B?" .base64_encode($name)."?=". "\n";

but neither of these work as the from is now the base64 code

If anyone knows a little more php than me can help add a new line please do, will sleep on it.

573

(22 replies, posted in Report Bugs here)

To eliminate the database encoding issue (if this is the problem) I hard coded the company name in class.mail.inc line 49 from:-

$this->header = "From: $name <$mail>\n";

to

$this->header = "From: 'Psicopedagógico' <$mail>\n";

I first tried with a normal 'o' and all emails were sent perfectly.

When I replaced the normal 'o' with an accented 'ó', emails failed to send with the same fault code:-
    SMTP error from remote mail server after end of data:
    550 From contains invalid characters.


For me this says that the problem is in the encoding of the email header not with the database.

I re-tried:-

var $charset = 'iso-8859-1';
to
var $charset = 'utf-8'; //also tried utf8
and
var $charset = 'utf8_unicode_ci';
and
var $charset = 'utf8mb4_unicode_ci';

All failed. I've since read that all SMPT headers should be ASCII encoded. (I did try ASCII & even 8BITMIME but maybe unsurprisingly they failed too as believe they don't include an accent 'ó')

I'm now looking for where the encoding from charset happens, And I'can't seem to find it?

574

(22 replies, posted in Report Bugs here)

I have tried setting class.mail.inc line 41
from
var $charset = 'iso-8859-1';
to
var $charset = 'utf-8'; //also tried utf8
and
var $charset = 'utf8_unicode_ci';
and
var $charset = 'utf8mb4_unicode_ci';


Not sure what you mean about url encoding?

The problem is in company name in company configuration, not in the email address: I have tried quoted format, this returns '&quot' in the email company name, I've also tried psicopedag&oacute;gico

I assume:-
HTML Entity (decimal)     &#243;
HTML Entity (hex)     &#xf3;
will have the same result as &oacute; unless you can tell me otherwise?

575

(22 replies, posted in Report Bugs here)

Hi campbell, thanks for replying,

Please note that simply removing the accented 'o' in the company name makes the invoice by email function work perfectly; I can change email addresses to either a server defined email addresses or remote email addresses and all works correctly: Therefore the problem must be the accented 'o' in the company name.

Would you agree? Any help very welcome.