Delete the modules\_cache\*.gz files and try again after clearing all browser cache and make sure you have the correct FA.pem file in your FA webroot.
2,851 07/31/2017 04:20:26 pm
Re: Release file in repository is invalid, or public key is outdated (1 replies, posted in Translations)
2,852 07/31/2017 04:11:28 pm
Re: Release 2.4.2 (11 replies, posted in Announcements)
The zip of changed files between FA 2.4.1 and 2.4.2 is attached.
2,853 07/31/2017 08:02:04 am
Re: Release 2.4.2 (11 replies, posted in Announcements)
Non default company login after files upgrade results in:
Access to application has been blocked until database upgrade is completed by system administrator.
WinXPSP3 / FireFox 37.0.2 / XAMPP 1.7.3 (Apache 2.2 / MySQL 5.0 / PHP 5.3.1.
Default Company login is okay. The Database version shows 2.4.1 in Setup -> Software Upgrade for all companies. Doing a software upgrade on each company does not alleviate the issue.
Since there is no db change in this version, the $db_version variable should have remained '2.4.1'. in version.php. Kindly revert.
2,854 07/30/2017 06:32:36 pm
Re: disable edit (1 replies, posted in Accounts Receivable)
Fine grained permissions like this needs custom modules to be written. Currently not available in FA.
2,855 07/29/2017 07:57:00 am
Re: HR and Payroll Module (66 replies, posted in Modules Add-on's)
"Nomina and Human Resources" ??
Did you mean Spanish "Nomina" to be "Appointment" or "Approval "?
There is no "Approval" system in default FrontAccounting for now.
There is no standard "Payroll / Recruitment (Appointment) / HR" module for FrontAccounting. Some users have created it for themselves and some have put it up for free use. @Farhaj and @kvvaradha have commercial ones. @notrinos has an open source one.
2,856 07/28/2017 01:35:27 pm
Topic: Tabs to 4 space indentation (0 replies, posted in Report Bugs here)
The FA codebase currently has a mixture of tabs and spaces used for indentation. To convert all such tabs into 4 space indentations we use the linux sponge command from moreutils package which does not alter the file permissions / ownerships / possibly timestamps.
cd /var/www/webroot
# Upload the core files
unzip core.zip
mv core core_org
unzip core.zip
apt-get install moreutils
cd core
find ./ -name '*.php' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
find ./ -name '*.inc' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
find ./ -name '*.css' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
find ./ -name '*.js' -type f -exec bash -c 'expand -t 4 "$0" | sponge "$0"' \{\} \;
cd ..
diff -r core_org core > fa24_t2s.diff
tar -czf fa24_t2s.diff.tar.gz fa24_t2s.diff
zip -r core.zip core
2,857 07/28/2017 11:53:18 am
Re: Advance Manufacture Stock Status (2 replies, posted in Manufactoring)
As @joe said, there is no need to issue items that are already there in the BoM as they would get issued when manufactured.
FA v2.3.5 was released on 2011-06-09.
The manufacturing/work_order_entry.php file is one of the files that manages your issue and was changed marginally during the release of FA v2.3.14 on 2013-01-18.
On 2014-09-22, there was a commit titled:
Fixed stock quantity checks to block transactions which would result in negative inventory status (if not allowed).
It is possible that other issues in this arena may been subsequently set right.
Kindly upgrade to the final edition of FA v2.3.26+ for best results.
2,858 07/27/2017 04:56:17 pm
Re: Import Transactions (154 replies, posted in Modules Add-on's)
@BarryHavenga: As you are using MySQL v5.7.x, the '0000-00-00' and it's timestamp counterpart are no longer accepted as an empty date unless the strict mode is turned off. There may be some PHP 7.x gotchas we need to weed out. Follow @braathwaate's instructions and see what gives.
Someone can test with PHP between 5.3 and 5.6 (both inclusive) along with MySQL between v5.0 and v5.6 and see if all is well.
2,859 07/27/2017 09:49:24 am
Re: Database connection issue (4 replies, posted in Installation)
@joe / @itronics: Thanks for the commit that now allows non standard db ports in FA 2.4.x.
Gracefully degrades to accommodate old config_db.php files that do not have the port element in each connection instance.
For later versions of MySQL (v5.7+) turn off strict mode with:
SET @@global.sql_mode= '';
This will accomodate zero values in dates.
2,860 07/27/2017 09:46:05 am
Re: Default Date selection (5 replies, posted in Reporting)
If your browser is set to clear all cookies and cache on exit from FA then these values and the session will vanish on logout and close of all browser instances.
2,861 07/27/2017 09:00:35 am
Re: Default Date selection (5 replies, posted in Reporting)
The parameter sticky_doc_date is stored in the sys_prefs table on a per company basis in FA 2.4.x and is set in the Preferences page at admin/display_prefs.php and is by default disabled (0). The function sticky_doc_date() in the class user shows the current session user's preference from function sticky_date() which reads the property $sticky_date in includes/prefs/userprefs.inc file.
2,862 07/27/2017 04:58:51 am
Re: Default Date selection (5 replies, posted in Reporting)
If these string are in the drop down box, then the start and end values will need to get allotted in the code by a js that dynamically sets those fields accordingly. The latter way will ensure no change to the real php processing codebase.
2,863 07/27/2017 04:56:22 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
The file I posted is the same as the one in the zip which had other changed files as well.
It appears you may have some browser cache issue - what browser and version did you now text on? As InnoDB tables are being used, some some tables having an auto_increment field will need to reset their auto_increment values after an insert depending on your version of MySQL (?) and PHP (?).
Credits (and brickbats too) for the latest code for this module goes to @braathwaate on Github.
2,864 07/26/2017 04:26:44 am
Re: Company Setup / Tax Period / Tax Last Period (5 replies, posted in Setup)
Yes.
2,865 07/26/2017 04:21:20 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
Looks like you will have to overwrite all your import_transaction module files. Take it from the attachment.
2,866 07/25/2017 11:57:59 am
Re: Database connection issue (4 replies, posted in Installation)
Maybe it is time the array $db_connections in config_db.php now has a new element dbport implemented in create/edit/list new company and in the connect files.
2,867 07/25/2017 11:50:04 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
You may not have applied the correct version of import_transactions/import_transactions.php. Lines 63 to 68 of the said file should be:
all_delete($yes = false);
$js = "";
if ($SysPrefs->use_popup_windows)
$js .= get_js_open_window(800, 500);
$help_context = "Import General Journals / Deposits / Payments / Bank Statements / Sales Orders / Sales Invoices <a href='spreadsheet_headers.html'>Help: Formats</a>";
page(_($help_context), false, false, "", $js);
All modules must be unzipped into the <FA_WebRoot>/modules/ folder to be usable. When installed and activated, they must find an entry in the relevant installed_extensions.php files.
Clear the browser cache and try anew.
2,868 07/25/2017 11:42:48 am
Re: GRN Removal (1 replies, posted in Banking and General Ledger)
GNR: Goods Not Received.
When you make a Purchase Order and the Supplier makes delivery and has short delivered, this situation arises.
2,869 07/25/2017 11:40:25 am
Re: Implementing In The Philippines (3 replies, posted in FA Modifications)
FrontAccounting is a copyright of this project's developers. It is advisable to register a domain that represents ecommerce, online accounting, etc and state that you support and host FrontAccounting. That way you will be able to represent a host of applications and integrate them together as well, say, like a Point of Sale (Open Source POS), osCommerce, etc. Your team can also fork the FA project on GitHub and then either send back pull requests or take a completely different development path. FrontAccounting itself is an early fork of the WebERP project.
There is ofcourse nothing to officially prevent you from registering a domain like frontaccounting.ph but it would be nice if you redirect users seamlessly back to frontaccounting.com - that way the Phillipino FA community will remain integrated with their world wide counterparts. You may also choose to provide a localised translation of frontaccounting.com in your frontaccounting.ph domain to enable easy adoption of FA in your country. Cybersquatters too will soon try to register such domains in their country extensions and mislead new users.
2,870 07/25/2017 11:31:18 am
Re: MySQL version in System Diagnostics (1 replies, posted in Setup)
The installer needs to be modified to accommodate MariaDB.
You can ignore the Database Server Type in this case.
The corrections will need to be done in includes/system_tests.inc.
2,871 07/24/2017 01:04:22 pm
Re: access users (1 replies, posted in Items and Inventory)
This is not available in standard FA. Edit location drop down box in sales/sales_order_entry.php file for hard-coded usage.
2,872 07/24/2017 11:01:37 am
Re: Implementing In The Philippines (3 replies, posted in FA Modifications)
Thankyou for your interest in FA and expect you have sufficient accounting knowledge to see your business through. All you want to know about FA is in the Wiki which has links to video tutorials and code repos. If you wish to customise FA to suit the Phillipine market, then you should learn PHP or have a team that supports the PHP programming language.
There is currently no Phillipine language translation for FA available. You can contribute one by taking the empty.po file and translating the empty strings.
There is a Phillipino Chart of Accounts (updated today for FA 2.4.1) to start you off with though I do not see anything Phillipine about it as of now.
2,873 07/24/2017 10:43:45 am
Re: Can't Enter Supplier Invoice (8 replies, posted in Accounts Payable)
If you want to turn off this warning, then in your config.php file, set the variable:
$check_price_charged_vs_order_price = false;
The function over_charge_allowance() (in the file includes/prefs/sysprefs.inc) returns the margin (default = 10%) using the per company variable po_over_charge in the sys_prefs table.
2,874 07/24/2017 10:34:19 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
What is the exchange rate employed?
2,875 07/24/2017 10:27:12 am
Re: Issues with new version and tax (7 replies, posted in Report Bugs here)
The sql in the function getTaxTransactions in rep709.php is responsible for the line entries under investigation. Try to debug the actual sql string and it's output on execution in the database and see what went wrong.