Make sure that the cron script has the necessary session values or hard code them into it and keep it beyond your webroot and an appropriately set $page_security and $path_to_root.
3,277 10/30/2016 07:10:10 am
Re: I cant get access to Items (1 replies, posted in Items and Inventory)
Check your DB permissions for the FA user.
What is the version of PHP / MySQL and what platform are you on - Linux/Windows/Mac and version.
3,278 10/30/2016 06:58:23 am
Re: Yellow warning sign & certain aspects of application cease functioning (17 replies, posted in Report Bugs here)
Tested a db backup and then restore which failed possibly due to lack of sufficient db permissions for the mysql user used by FA.
Can confirm your yellow triangle on Ajax change of customer in new direct invoice in WinXPSP3 / FF 37.0.2. This is specific to your install and you would need to access your apache error log and php error log in FA to see what gives.
Even changing to the current fiscal year and attempting the above results in the same error.
What is the version of PHP / MySQL you are using?
3,279 10/28/2016 04:25:06 am
Re: Yellow warning sign & certain aspects of application cease functioning (17 replies, posted in Report Bugs here)
Place a link to a demo install and let us see what breaks.
Hope you are using the FA git master code.
3,280 10/24/2016 01:26:54 pm
Re: Print (PDF) is not working anywhere in 2.3.25 (13 replies, posted in Report Bugs here)
Try the lightweight SumatraPDF instead.
3,281 10/24/2016 01:25:05 pm
Re: Yellow warning sign & certain aspects of application cease functioning (17 replies, posted in Report Bugs here)
Try an older version of FireFox from the portable Apps site. The SF site too has them.
3,282 10/24/2016 01:21:32 pm
Re: GL Account restriction to different user (1 replies, posted in Banking and General Ledger)
If the aim is to provide a login for a customer / supplier, create a role for it and an extension that allows only that GL account associated with the customer / supplier.
3,283 10/24/2016 01:19:30 pm
Re: Missing transactions and overwriting (1 replies, posted in Report Bugs here)
Please state the list of menu navigation steps you did to realise the error.
3,284 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,285 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,286 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,287 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,288 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,289 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,290 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,291 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,292 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,293 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,294 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,295 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,296 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,297 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.utf8Hence 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,298 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,299 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,300 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).
