@poncho1234 - Thank you for all your efforts Sir :-)

I increased the 50 to 80 in the tables and that has fixed it, probably the simplest way however I have no idea if this was a bad idea especially later on down the line.

I looked around the SQL tables and find CHAR(200) all over, I assume the CHAR(50) could be in error? if not, then I would assume it is 50 for a some reason?

Anyway, for now it seems to all be working.

Kind Regards,
Steven Brewer

2

(1 replies, posted in Report Bugs here)

Good day, I trust you are all well.

I have been using FrontAccounting for over a year hosted with a hosting company with no issues however, suddenly emails sent by the FrontAccounting package are not been sent to my clients. I tested this on myself and also never received anything, it was working fine just yesterday.

Anyway the hosting company are confused too.

The green bar confirms sent but nothing is sent. I am not using multiple email addresses do its not that.

This was a question from my hosting company:
Please advise if you using a PHP script to send these mails and using one of your existing email accounts to authenticate? If NOT these mails will be sent via the host server email address which is not recommended.

Please is there a way to fix this? is there code to add to force FA not to use the hosting email address? An SMTP coding perhaps?

Hello :-)

Thank you so much for your input.

What I did was to increase the char(50) to char(80) which covers the description characters for all items.

I installed a fresh copy of FA and had a look at the tables, they are char(50), making them char(80) fixed it.

I hope this wont cause any issues?

Version 2.4.7: Purchases - Direct Supplier Invoice, after filling out the form and clicking "Process Tax Invoice" nothing happens, after clicking "Process Tax Invoice" again it looks like it processes, however instead of saying "Direct Purchase Tax Invoice has been entered" on the next screen, it says "Purchase Order has been updated". The transaction is never actually processed. I backed up the SQL right there and restored it into 2.4.6 and it then works fine. This does not affect all product items, some of them process fine and some have this issue, in 2.4.6 all of them process fine.