Sorry Joe, I may have confused you with my lack of understanding of how the code worked... please ignore last post
551 09/18/2017 08:03:37 pm
Re: Account & Account Type Ordering (7 replies, posted in FA Modifications)
552 09/15/2017 05:27:16 pm
Re: Account & Account Type Ordering (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..
553 09/15/2017 04:24:28 pm
Re: Standard pricing & Inventory Valuation Report showing 50% on manufact (3 replies, posted in Items and Inventory)
@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.
554 09/15/2017 04:20:20 pm
Re: Error flashes up after creating a supplier invoice (6 replies, posted in Report Bugs here)
ok... good! Shall I enter this in the mantis bug tracker?
555 09/15/2017 04:06:24 am
Re: Account & Account Type Ordering (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.
556 09/15/2017 03:57:53 am
Topic: Standard pricing & Inventory Valuation Report showing 50% on manufact (3 replies, posted in Items and Inventory)
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.
557 09/15/2017 03:43:18 am
Topic: Error flashes up after creating a supplier invoice (6 replies, posted in Report Bugs here)
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 09/13/2017 02:27:14 pm
Re: Option for printing logo on reports. (12 replies, posted in Reporting)
Hi, this is excellent, will it be included in the next version? Or only as an mod?
559 08/26/2017 04:02:34 pm
Re: Reference problem (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 08/15/2017 01:52:33 am
Re: Tax on free gift (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 08/14/2017 04:38:40 pm
Re: Tax on free gift (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 08/13/2017 06:27:39 pm
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
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 08/12/2017 03:42:24 pm
Re: Tax on free gift (11 replies, posted in Accounts Receivable)
Thanks @Joe, that does it.
@apmuthu, for this case it would have to disregard taxes though.
564 08/11/2017 06:59:21 pm
Re: Tax on free gift (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 08/10/2017 03:05:48 pm
Topic: Tax on free gift (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 08/10/2017 02:56:48 pm
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
@apmuthu & @joe - Hi, is anything happening on this issue?
567 07/12/2017 10:34:40 pm
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
@campbell, tried most of day to get content type working, but thanks for suggestion.
568 07/11/2017 01:15:48 pm
Re: Yet another problem with utf-8 (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 07/11/2017 01:22:37 am
Re: Yet another problem with utf-8 (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 07/10/2017 09:08:35 pm
Re: Yet another problem with utf-8 (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 07/08/2017 02:26:20 pm
Re: Yet another problem with utf-8 (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 07/08/2017 01:57:52 am
Re: Yet another problem with utf-8 (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 07/07/2017 11:31:49 pm
Re: Yet another problem with utf-8 (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 07/07/2017 06:06:21 pm
Re: Yet another problem with utf-8 (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 '"' in the email company name, I've also tried psicopedagógico
I assume:-
HTML Entity (decimal) ó
HTML Entity (hex) ó
will have the same result as ó unless you can tell me otherwise?
575 07/07/2017 05:24:14 pm
Re: Yet another problem with utf-8 (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.