4,776

(9 replies, posted in Modules Add-on's)

You must decide on your webroot path and set them in your apache conf file and restart your webserver.

The extensions are available in my GitHub repo for manual inclusion for offline use - slightly outdated by a one point release in some pkgs as on date.

I have just uploaded a tutorial on Manual Import of Customers into FA.

It can be studied with the help of the ER Diagram available in the Wiki.

Thanks to Rick Miller of Lone Star Tool who provided test data and insight and @joe for shipping address location that made this possible.

Updated on 2014-12-09 to address the Shipping Address issue and now includes TaxNum population.

4,778

(66 replies, posted in Modules Add-on's)

Thanks, will try it out.

Still not available.
Check your apache conf / vhosts conf for deny/allow rules

4,780

(6 replies, posted in Installation)

if the webroot is /var/www/frontac
and the webserver user:group is www:data:www-data
then:

WEBPATH=.var/www/frontac
chown -R www-data:www-data ${WEBPATH}
find ${WEBPATH} -type f -exec chmod 644 {} \;
find ${WEBPATH} -type d -exec chmod 755 {} \;

4,781

(3 replies, posted in Accounts Receivable)

[ Quote ] -> [ Order ] -> Delivery -> Invoice

That's right. Waiting for @joe to clarify way forward and integrate a fix.

Thanks Joe.

Wiki-ed it and cross referenced it as well.

A possible search and replace using the QUOTE() function of MySQL may be one solution. Another would be a search and replace of such known entities in the most affected fields or in the db_escape function itself. This is also the reason why the currency symbols stand as "?" in the CoA sqls.

Where in the Branch should we put in the default Shipping address? Is Shipping Address synonymous with Billing Address as far as the branch is concerned?

All customer / branch forms show Mailing Address and Billing Address only and there is no Shipping Address in them. The Shipping Address only appears in the Invoice forms.

For a new or existing Customers, where can we enter their default Shipping address?

New Customer data entry shows Mailing Address and Billing Address only.

4,787

(6 replies, posted in Installation)

Change ownerships of all files to your web server process owner (www-data:www-data in Ubuntu/Debian, httpd or apache in CentOS)

Make all folders 755 and all files 644 to start with and disable all .htaccess files and put them back one by one to see what breaks where.

4,788

(3 replies, posted in Setup)

Use the code snippet in:
https://frontaccounting.com/punbb/viewtopic.php?pid=6179#p6179
to check if the "from" and "to" addresses are obeyed or if sendmail is overwriting it with some hard coded entry in the php.ini file.

4,789

(25 replies, posted in Reporting)

@joe: Thanks. Just checked the code fully, there is no 'ZONES' and only 'AREAS'.
@dz: Just replace your 'ZONES' with 'AREAS'

4,790

(6 replies, posted in Setup)

When using the inventory import module (items export/import) there will be one entry for each item for each Sales Type and by default, since there is Retail and Wholesale, we land up getting two entries for each item if all prices are populated.

4,791

(3 replies, posted in Items and Inventory)

Correcting the material_cost directly in the table could have repercussions in the stock valuation and the dependent contra accounts as well when future FA inventory transactions occur.

4,792

(6 replies, posted in Installation)

Check for file / folders permissions and ownerships and webserver (apache) conf and .htaccess file issues.

The download link http://www.kwikpay.co.nz/download/import_paypal.zip seems to be unavailable.

Even the domain default page http://www.kwikpay.co.nz/ is inaccessible too.

4,794

(3 replies, posted in Setup)

Please refer Wiki page.

Other relevant / related posts may be:
https://frontaccounting.com/punbb/viewtopic.php?id=341
https://frontaccounting.com/punbb/viewtopic.php?id=3774
https://frontaccounting.com/punbb/viewtopic.php?id=5258

4,795

(2 replies, posted in Items and Inventory)

To import opening stock of items we need to make sure how we are going to handle the contra entry in values of the stock.

1. If it is going to a lump sum value in the stock asset account then that account must be treated as the supplier.

2. If each individual supplier is going to be credited with the contra value of the stock, then a transfer of such values in each supplier account should be journal vouchered into the stock asset account.

The latter, though cumbersome, has the added feature of automatically getting in the cost price to the stock table directly.

For the former, the material_cost field in the stock_master table should be entered and the final open stock value computed (adjustments stock qty * material_cost) and put in to the stock asset account.

Each PHP build, not necessarily based on version alone, will have different default php modules/extensions installed or enabled. A check on php -m would reveal all those available to it and a comparision will possibly reveal the lack of gzopen() function.

The PHP 5.5 gzopen() bug is quite well alluded to in stackoverflow.com and other public forums.

http://pear.php.net/bugs/bug.php?id=20246
http://ubuntuforums.org/showthread.php?t=2217927

https://bugs.launchpad.net/ubuntu/+source/php5/+bug/432291/comments/7



The bug is NOT zlib link problem because it can open gz files with "fopen" for example:

<?php
$gzfile = fopen("compress.zlib://hello.txt.gz", "w");
fwrite($gzfile, "hello world!");
fclose($gzfile);
?>

is work well on released binaries. BUT "gzopen" is not defined in php5 binaries it cannot run:

<?php
$data = "Hello World!";
$gzfile = gzopen("hello.txt.gz", "w9");
gzwrite($gzfile, $data);
gzclose($gzfile);
?>

configure php with the --with-zlib=yes option and for 64 bit systems check if gzopen64() exists and possibly either do a search and replace in the FA code or create an alias function / wrapper for it:
http://stackoverflow.com/questions/23417519/php-zlib-gzopen-not-exists

https://wordpress.org/support/topic/php-function-is-disabled-abort-expected-gzopen-updraft

"because of large file support, gzopen() has been replaced by gzopen64()"
Link: http://www.dotdeb.org/2012/03/01/php-5-4-0-preview-packages/#comment-23656

Looks like the gzopen() function is no longer available on new versions..

4,797

(25 replies, posted in Reporting)

@joe: must this get into the core - ZONES => AREAS ?

You can hardcode the dot-slash coding inside the php script and allow the full filename with path to be put in there instead.

4,799

(5 replies, posted in Reporting)

Some partners may be busy with ongoing projects or moved on and hence the lack of response.

The current v2.3.22 mo file for German is available in the FA repo as a language pkg and is also available in extracted form in my unofficial GitHub repo.

You can also convert the mo to po file and then translate/modify it before recompilation and use.

4,800

(4 replies, posted in FA Modifications)

Refer Wiki page on config.php and the comments in the config.php file itself - self explanatory.

Search for the variable: $help_base_url
and read the comments around it.