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,852

(11 replies, posted in Announcements)

Committed in GitHub.

The zip of changed files between FA 2.4.1 and 2.4.2 is attached.

2,853

(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

(1 replies, posted in Accounts Receivable)

Fine grained permissions like this needs custom modules to be written. Currently not available in FA.

2,855

(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

(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

(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

(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

(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

(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

(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

(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

(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 wink too) for the latest code for this module goes to @braathwaate on Github.

2,864

(5 replies, posted in Setup)

Yes.

2,865

(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

(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

(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

(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

(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

(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

(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

(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

(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

(27 replies, posted in Banking and General Ledger)

What is the exchange rate employed?

2,875

(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.