576

(22 replies, posted in Report Bugs here)

I have run the following:-
SHOW VARIABLES LIKE 'collation%'
Profiling [ Edit inline ] [ Edit ] [ Create PHP code ] [ Refresh ]

+ Options
Variable_name     Value    
collation_connection     utf8mb4_unicode_ci
collation_database     utf8_unicode_ci
collation_server     utf8_unicode_ci


Query results operations
Print Print Copy to clipboard Copy to clipboard Create view Create view

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Your SQL query has been executed successfully.
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%'
Profiling [ Edit inline ] [ Edit ] [ Create PHP code ] [ Refresh ]

+ Options
Variable_name     Value    
character_set_client     utf8mb4
character_set_connection     utf8mb4
character_set_database     utf8
character_set_filesystem     binary
character_set_results     utf8mb4
character_set_server     utf8
character_set_system     utf8
collation_connection     utf8mb4_unicode_ci
collation_database     utf8_unicode_ci
collation_server     utf8_unicode_ci

So all seems ok.
I am unable to create a my.cnf file as do not have access to /etc/

577

(22 replies, posted in Report Bugs here)

I ran this command in phpmyadmin:-

SHOW FULL COLUMNS FROM 0_sys_prefs

Which gave the following results

Profiling [ Edit inline ] [ Edit ] [ Create PHP code ] [ Refresh ]

+ Options
Field     Type     Collation     Null     Key     Default     Extra     Privileges     Comment    
name     varchar(35)     utf8_unicode_ci     NO     PRI             select,insert,update,references    
category     varchar(30)     utf8_unicode_ci     YES     MUL     NULL        select,insert,update,references    
type     varchar(20)     utf8_unicode_ci     NO                 select,insert,update,references    
length     smallint(6)     NULL    YES         NULL        select,insert,update,references    
value     text     utf8_unicode_ci     NO         NULL        select,insert,update,references

So all seems fine there.

However my hosting company list there only locale as:-

LANG=en_US.UTF-8

And state that all languages will run without a problem.......hmmmmmm

I need a technical argument to refute this - if this is the problem?

578

(22 replies, posted in Report Bugs here)

Hi, I have read the myriad of posts concerning encoding issues, and from my understanding all this has been resolved in FA2.4

However I have the following issue:

All accents in Spanish language display as should be on screen, however a company name 'Psicopedagógico' note the accented second 'ó' is causing me problems when sending invoice by email. Its being rejected with the following error:-
    SMTP error from remote mail server after end of data:
    550 From contains invalid characters.

Changing the accented 'ó' to a normal unaccented 'o' and emails with invoices work perfectly, so the problem is clearly the accented 'ó'.

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

But the same problem occurs.
Have logged in and out after changes and cleared cache on server and browser.

Setup info:-

This is on a clean install of V2.4.1
Theme default
Database 10.0.27-MariaDB-cll-lve
Datebase encoding - utf8_unicode_ci
Language encoding in po file - utf-8
Language encoding in installed_languages.inc - 'encoding' => 'utf-8',
Server - Linux
Shared hosting.

Am i doing something wrong or is this a bug?

579

(3 replies, posted in Items and Inventory)

How would this work Apmuthu?

Enter the components in, but then get the same components out?

Or are you talking about disassembly?

Does anyone have experience using FA for an abattoir / butchers business?
The animals will be bought live then slaughtered and butchered to various cuts. Very nearly all of the animal has some value, though like most processes there is a wastage.

How can the inventory be organized to reflect this?

At the moment I can only think that after the animal has been butchered, the various cuts, etc are weighed off an then these weights are entered into FA

Is there another way?

Can the purchase pricing unit in Items & Inventory be used? For example buy cow of a known weight (500kg) 8% of which is rump steak so system enters 40kg of rump steak into the system.

Can the kit function be used in reverse?

Any advice welcome

There was an issue with mod-security, hosting company refuse to tell me exactly what the issue was; so I think it's time to find a new hosting company, maybe semi dedicated to..

Many thanks to apmuthu and cambell for your help, time and suggestions.

Hi cambell, I tried changing / deleting .htaccess - no change

Temporary disabled mod-security this cured the problem...!!!!

I now have something to give to hosting techs....

Will let you know how this ends.

I cannot print anything either, with or without java similar to this post https://frontaccounting.com/punbb/viewtopic.php?id=6199 I have tried V2.3.24 but this does not work for me.

Just to eliminate this I rolled back to 2.3.15 and still it has the same problem

Hi Apmuthu, thanks for your time in looking at the problem.
In same order as your posts

I confirm that the mysql user had full permissions, I have noticed that turning java off in the browser allows the restore function to work.

I'm a bit confused by this one, (i think...) To run win xp would require me to set up a VM and I do not have a copy of SP3 (or even XP..I have to look) .. How does this help the diagnosis? The same issue is seen on multiple pc, win 7, 8 & 10. If you could explain the reasoning behind this please.

MySQL version 5.6.33
PHP version 5.6.27

You had accessibility problems? Do have this intermittently as is shared hosted, but not had recently.

Updated mysql with above values, no change in problem.

Hi apmuthu, I've set up a new installation for you here.. http://www.colombiaonline.net.co/apmuthu/index.php

login
apmuthu

password
12345678

I confirm I used FA git master code. The previous installations I have used softaculous apps installer.

The problem still occurs in the FA git master code as you will see.

Hope you can diagnose this for me.

Hi cambell, the problem occurs on latest versions of chrome, firefox and opera, also ie 11.
I have disabled all plug-ins / extensions as you have suggested, no change.
The problem also occurs on 3 other pc's and laptops / phones.

I still think its something serverside, but finding it very hard to diagnose as shared hosting.

After turning javascript off in chrome everything works.

Apmuthu, any more details on apache config?

Could it be anything in php.ini?

Thanks for replying cambell...

Yes the session timed out after approx 10 secs...which corresponds with js/utils line I think its 39 =10000.

I am not redirected to login, please read 1st post...the installation has been running perfectly since march, so seems unlikely to be installation + I have done done 2 clean installations with v2.3.25 and have exactly the same issue.

Ctrl-R just takes the page back to original custom (1st customer in list). The part I find strange is that i can add/ change in items & inventory

Thanks for replying apmuthu...

I am using default theme.

I've tried various changes in htaccess, no change.

Any ideas for getting further info?

Up until last Saturday, FrontAccounting v2.3.25 worked perfectly, on Monday morning, whilst changing a customer in a new direct invoice a yellow triangle with an exclamation mark appeared. Also tried various other modules, sales and purchasing seemed to have the problem, (failed to add new customer did not work, etc) items & inventory seemed to work (added new item, edited item, no problem.)

Read through various forum posts here, but no solution found

I have made a 'clean' installation and the problem is exactly the same.

Has anyone else had a similar issue?

Is this a FrontAccounting problem or a server problem? (For me it is a server issue as the clean installation has exactly the same problem, the server techs are pushing me that it is a FA issue, but I'm struggling with their logic)

Any help much appreciated.

Edit, the following is from the console

ReferenceError: reference to undefined property (intermediate value).description
    

throw new Error(msg);

    
JsHttpRequest.js (line 235, col 21)
Error: JsHttpRequest: JavaScript code generated by backend is invalid!
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<html>
 <head>
  <title>Index of /</title>
 </head>
 <body>
<h1>Index of /</h1>
  <table>
   <tr><th valign="top"><img src="/sharedApache2Icons/blank.gif" alt="[ICO]"></th><th><a href="?C=N;O=D">Name</a></th><th><a href="?C=M;O=A">Last modified</a></th><th><a href="?C=S;O=A">Size</a></th><th><a href="?C=D;O=A">Description</a></th></tr>
   <tr><th colspan="5"><hr></th></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="afroin/">afroin/</a>                </td><td align="right">2016-02-21 15:37  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="backup/">backup/</a>                </td><td align="right">2016-10-13 22:45  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="cgi-bin/">cgi-bin/</a>               </td><td align="right">2016-03-26 11:26  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="test/">test/</a>                  </td><td align="right">2016-02-21 15:37  </td><td align="right">  - </td><td>&nbsp;</td></tr>
<tr><td valign="top"><img src="/sharedApache2Icons/folder.gif" alt="[DIR]"></td><td><a href="tmvr/">tmvr/</a>                  </td><td align="right">2016-02-21 15:37  </td><td align="right">  - </td><td>&nbsp;</td></tr>
   <tr><th colspan="5"><hr></th></tr>
</table>
</body></html>
    

throw new Error(msg);

I have tried clearing the cache, still not working

I turned off javascript as suggested on https://frontaccounting.com/wbt/pages/faq.php, but no error messages appeared.

591

(4 replies, posted in Accounts Receivable)

Apmuthu, can you please expand on your reply, preferably with an example?

592

(4 replies, posted in Accounts Receivable)

Hi apmuthu, sorry for my delay in replying, I have looked at the Tax Accrued (Payable) and Tax Paid accounts, and cannot see how I can use these accounts to  retain 3.5% of a suppliers invoice as an initial tax payment which is paid monthly to the Tax Administrator(By Tax Administrator I mean the government)
Could you please expand on your reply.

Please note, my wife is the accountant, but she only speaks spanish.

593

(4 replies, posted in Accounts Receivable)

How can I setup FA so that tax is retained, both in the customer invoice, and the supplier invoice?
I have read the wiki and searched the forum extensively

In Colombia, depending on a company's tax responsibility:

1. It is necessary for a customer to discount my invoice to them by 3.5% as an initial tax payment which is paid monthly to the Tax Administrator
2. It is necessary for me to retain 3.5% of a suppliers invoice as an initial tax payment which is paid monthly to the Tax Administrator

How can I do this in FA and show this in the GL?

What I have tried.

Allowing negative tax rates would achieve this, is this possible?
Using the customer / supplier discount functions would also achieve this, but prevent me from using these functions for their correct purpose.
From what I understand the quick entries function would do this for the supplier, but I do not know how to set this up for the above settings? Can someone please show me?
Also from my understanding of quick entries, they cannot be used for customer invoices?

Any help would be appreciated

Sent to 'contributions@frontaccounting.com'

Thanks for the link to post ref FA v2.4 I'm waiting expectantly!
Meanwhile I decided to modify the theme 'elegant' I've replaced the existing static quick access side menu with a dynamic menu listing all app functions for selected application. All 'hotkeys' work as expected, so no need to use the mouse. Also included hide_inaccessible_menu_items for user roles. Other than that all is exactly the same as the existing elegant theme
I've tested the theme in FA v2.3.22 and  FA v2.4
Would you be interested in including this in FA's theme collection?
My code will probably need checking by someone more experienced.
If you are interested please advise on 'how' as this will be my first contribution to an open source project

ok..thanks anyway, is there an approx date for FA v2.4?

As in my original post. Pressing alt and continuing to press it whilst pressing 'i' repeatedly will allow you to access all the 'i's in the default theme. There is nothing wrong with the default theme, keyboard shortcuts work fine in the default theme as per the code in inserts.js or what I understand of it. The problem is keyboard shortcuts do not work in dashboard, exclusive & exclusive_db themes.

As in title, the problem is only in dashboard, exclusive & exclusive_db themes for me....default theme works as I think is expected.

I cannot get g to work in dashboard, exclusive or exclusive_db.

Tried in chrome Version 40.0.2214.45 (64-bit), firefox 34.0 & opera 26.0.

FA 2.3.22

Tried on local devel server and a production server.

Win 8.1