Please state the list of menu navigation steps you did to realise the error.

3,227

(3 replies, posted in Wish List)

Perhaps the FA 2.4+ can sport one listing a filtered view of the attachments table.

3,228

(6 replies, posted in Jobs wanted/offered, non-free offers)

Check out OpenSourcePOS and see what tables and fields you want integrated.

3,229

(3 replies, posted in FA Modifications)

In case the DNS resolver fails, the IP is the standby for it.
Check the function get_extern_rate in the said file.

3,230

(13 replies, posted in Reporting)

@seahawk: The global variable $no_zero_lines_amount is used to display the zero amount line in reports 107, 109, 110, 111:

                if ($Net != 0.0 || !is_service($myrow2['mb_flag']) || !isset($no_zero_lines_amount) || $no_zero_lines_amount == 0)
                {
..
..

What theme are you using? Revert to default theme and see what happens.
Can be a .htaccess or Apache config issue.

3,232

(1 replies, posted in Installation)

Look at function get_user_auth() and similar functions in admin/db/users_db.inc.

3,233

(2 replies, posted in Wish List)

An Apache vhosts conf file would prevent .htaccess files being compromised. Most standard OpenVZ and other templates provide examples of such configs.

Here is one from a Debian FA apache conf where the rewrite conditions above be inserted:

ServerAdmin webmaster@localhost
ServerSignature Off
ServerTokens Prod

<IfModule mpm_prefork_module>
    StartServers 2
    MinSpareServers 1 
    MaxSpareServers 2
    MaxClients          50
    MaxRequestsPerChild 100
</IfModule>

<VirtualHost *:80>

DocumentRoot /var/www/frontac

<Directory />
        Options FollowSymLinks
        AllowOverride None
</Directory>

<Directory /var/www/frontac>
        Options FollowSymLinks MultiViews
        AllowOverride None
        Order allow,deny
        allow from all
        DirectoryIndex index.php index.html
</Directory>

### Will possibly affect any other php script in it 
# <Directory /var/www/frontac/sql/>
#   Order Deny,Allow
#   Deny from All
# </Directory>

<IfModule mod_rewrite.c>
        <Location /modules/api/>
                Options -MultiViews
                RewriteEngine on
                RewriteCond %{REQUEST_FILENAME} !-f
                RewriteRule ^ index.php [QSA,L]
        </Location>
</IfModule>

# Protect sensitive files.
<FilesMatch "\.(inc|po|sh|.*sql|log)$">
    Order allow,deny
    Deny from All
    Satisfy All
</FilesMatch>

# Disable directory listings.
Options -Indexes

# Set the default index.
DirectoryIndex index.php

<IfModule mod_php5.c>
    php_flag magic_quotes_gpc Off
    php_flag register_globals Off
    php_flag session.use_trans_sid Off
</IfModule>

ErrorLog /var/log/apache2/error.log

# Possible values include: debug, info, notice, warn, error, crit,
# alert, emerg.
LogLevel warn

CustomLog /var/log/apache2/access.log combined

</VirtualHost>

3,234

(4 replies, posted in FA Modifications)

Which version of FA are you referring to - FA 2.3.25+ or 2.4RC1?

In FA 2.4RC1, the following new defines have been added:

//
//    Depreciation period types
//
define('FA_MONTHLY', 0);
define('FA_YEARLY', 1);
...
//    Manufacturing types
//

define('WO_MATERIALS', 2);
...
// Tax calculation algorithms used in als and purchase (depends on supplier's invoicing software)

define('TCA_TOTALS', 1); // taxes are calculated from respective net totals for all lines
define('TCA_LINES', 2); // taxes calculated for every line, then summed
//
//    Bank account owner types
//
define('BO_UNKNOWN', 0);
define('BO_COMPANY', 1);
define('BO_CUSTBRANCH', 2);
define('BO_SUPPLIER', 3);
...
// tax register type
define('TR_OUTPUT', 0); // sales
define('TR_INPUT', 1);    // purchase
...

Quite a few settings in the config.php have been migrated to the sys_prefs table on a per company basis.

You can possibly check the (ST_CUSTPAYMENT && ST_CUSTCREDIT)  in your constructs without touching the include/types.inc file.

3,235

(4 replies, posted in Setup)

Check out the wiki page on reports.

Forum posts of pertinence are:
https://frontaccounting.com/punbb/viewtopic.php?id=4511
https://frontaccounting.com/punbb/viewtopic.php?id=4331
https://frontaccounting.com/punbb/viewtopic.php?id=3470

3,236

(7 replies, posted in Items and Inventory)

@joe: This is very essential atleast in FA 2.4 - can implement it by making a certain role feature permission in the access roles - a back port too would be in order as there is no db change needed.

3,237

(9 replies, posted in Setup)

Download dejavu.zip and extract it to the reporting/fonts folder.

3,238

(3 replies, posted in FA Modifications)

Service Tax (ST): 12% of 40% of Amount = 4.8% of Amount = 4.8%
Education Cess (EC) = 0.24% of Service Tax = 0.24% of 4.8% of Amount = 0.01152%
Higher Education Cess (HEC) = 1% of Education Cess = 0.01 * 0.01152 % of Amount = 0.0001152%
Total tax = 4.8% + 0.01152 % + 0.0001152% = 4.8116352 %

Hence just keep 1 tax at 4.8116352% and pass a JV for the split at the end of each month to split the taxes in the ratio of:
0.002394 : 0.2394 : 0.997582 for HEC : EC: ST
ie., 10: 1000 : 4167

3,239

(1 replies, posted in Setup)

All will hopefully get washed out by next fiscal when GST kicks in..... Swachh Bharat => Swachh Multi Tax => Swachh all tax. (Swachh == Clean Up).

Read FA's Tax System in the Wiki

3,240

(9 replies, posted in Setup)

You are correct. CentOS 6.8 does not support "en_IN.iso-8859-1".

# locale -a | grep en_IN
en_IN
en_IN.utf8

Hence you will need to make your en_IN lang file as utf8 or just en_IN alone and make sure the entries in the lang/installed_languages.inc file are appropriately set.

Check out the lang/installed_languages.inc in my FAMods.

3,241

(2 replies, posted in Setup)

Contact any of the FA Support consultants in the Wiki.

FA has 78 to 80 tables in MySQL and the schema are well documented. Importing data into FA will be trivial using any MySQL Client (phpMyAdmin, SQLyog, etc).

Creating plugins for features / reports available in your existing accounting system will be the real time hogger.

As you have sufficient tech personnel with Linux experience that should work in your favour.

As far as Magento eCommerce (v1.9.01 2014-05-15) is concerned, upgrading it to the latest version (v2.1.1) will be the first step and as it uses PDO_MySQL, your work becomes easier. The latest version of Magento uses the Zend framework and Symphony quite extensively besides a number of other libraries with their version specifics handled by composer.

If there are any specific roadblock you encounter, the forum here is well supported.

Good Luck.

3,242

(1 replies, posted in Report Bugs here)

Check your upgraded db schema with that of the sql/en_US-new.sql and see what is different.

3,243

(1 replies, posted in Installation)

Copy the FrontAccounting Wiki pages over to your localhost webserver using Win HTtrack or some sort of website copier or use some wiki software (MediaWiki, PMWiki, DocuWiki, etc).

3,244

(9 replies, posted in Setup)

Look at the heading "View/set global locale for all users on a “CentOS/RHEL/Scientific Linux v5.x/6.x” and older" in the CyberCiti.biz link.

3,245

(9 replies, posted in Setup)

Detailed answer specifically for India at CyberCiti.biz.

Also discussed in a forum post.

3,246

(5 replies, posted in Misc. Charts of Accounts)

http://www.oag.go.th/en/home
http://www.thailawforum.com/database1/acconting-act.html
http://www.dbd.go.th/dbdweb_en/ewt_news.php?nid=3937
http://msnagroup.com/thai-accounting-law/
http://msnagroup.com/thai-accounting-standards/
http://www.thailand-business-law-center.com/thailand-tax-and-accounting-regulations-2/
http://www.ifrs.org/Use-around-the-world/Documents/Jurisdiction-profiles/Thailand-IFRS-Profile.pdf
http://www.fap.or.th/
http://www.iasplus.com/en/jurisdictions/asia/thailand

Looks like Thailand appears to follow International Accounting Principles.

Any Thai Accounting professionals would like to check out FA's features and comment on differences?
Any concessions / exemptions for the royalty or special privileged groups?

The reporting standards / requirements can be different everywhere - just build / tweak what reports you need. FA is an open system and can be extended at will.

When an upgrade is done, generally the SysAdmin logs in, logs out and logs in again to check if all is okay. Such upgrade permissions should be unnecessary for the user as the extension should be so designed to upgrade automatically if the admin's records have been updated.

Make sure that the access roles assigned to your other users have the requisite privileges for your activated application.
The password field stores the MD5 of the plain text password unless you have modified it.

3,249

(3 replies, posted in Wish List)

Actually, we need a transaction number for the transaction before attaching files. Also, uploading files when a transaction is being entered will become a waste of time if the latter fails.

You can certainly make a module to extend the transaction entry pages and share the code.

Wiki-ed it.