Please state the list of menu navigation steps you did to realise the error.
3,226 10/24/2016 01:19:30 pm
Re: Missing transactions and overwriting (1 replies, posted in Report Bugs here)
3,227 10/24/2016 01:18:23 pm
Re: Supporting File Attachements (3 replies, posted in Wish List)
Perhaps the FA 2.4+ can sport one listing a filtered view of the attachments table.
3,228 10/24/2016 01:16:22 pm
Re: Point Of Sale (6 replies, posted in Jobs wanted/offered, non-free offers)
Check out OpenSourcePOS and see what tables and fields you want integrated.
3,229 10/24/2016 01:14:38 pm
Re: Unknown IP address within code (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 10/24/2016 01:00:33 pm
Re: Displaying Discount amount on invoice (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)
{
..
..
3,231 10/15/2016 12:24:12 pm
Re: Yellow warning sign & certain aspects of application cease functioning (17 replies, posted in Report Bugs here)
What theme are you using? Revert to default theme and see what happens.
Can be a .htaccess or Apache config issue.
3,232 10/15/2016 12:22:11 pm
Re: Google Authenticator Login Security (1 replies, posted in Installation)
Look at function get_user_auth() and similar functions in admin/db/users_db.inc.
3,233 10/12/2016 02:27:55 am
Re: Static IP Access (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 10/11/2016 03:24:39 am
Re: Add Transaction type (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 10/11/2016 02:59:22 am
Re: [SOLVED] Invoice - edit (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 10/07/2016 04:36:50 pm
Re: prices (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 10/07/2016 04:32:37 pm
Re: English India Language Problem (9 replies, posted in Setup)
Download dejavu.zip and extract it to the reporting/fonts folder.
3,238 10/07/2016 04:29:51 pm
Re: Service tax with breakup (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 10/07/2016 04:20:46 pm
Re: Service Tax India setup help (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 10/06/2016 04:35:21 pm
Re: English India Language Problem (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 10/06/2016 06:47:04 am
Re: Integrating FrontAccounting with Magento 2.0 (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 10/06/2016 06:40:39 am
Re: auto increment in 2.4 (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 10/06/2016 06:39:23 am
Re: WIKI Messages (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 10/06/2016 06:36:07 am
Re: English India Language Problem (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 10/02/2016 05:29:33 pm
Re: English India Language Problem (9 replies, posted in Setup)
Detailed answer specifically for India at CyberCiti.biz.
Also discussed in a forum post.
3,246 09/28/2016 02:36:13 am
Re: COA for Thailand (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.
3,247 09/27/2016 05:37:41 am
Re: Access to application has been blocked until database upgrade is compl (4 replies, posted in Report Bugs here)
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.
3,248 09/27/2016 02:19:40 am
Re: Access to application has been blocked until database upgrade is compl (4 replies, posted in Report Bugs here)
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 09/25/2016 02:01:07 pm
Re: Supporting File Attachements (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.
3,250 09/24/2016 05:48:26 am
Re: A/R and customer record with foreign currency (10 replies, posted in Reporting)
Wiki-ed it.