The Initial Password for the admin user is in the config_db.php file after this is done
Other than
  creating a default company folder
the following should be able to create a new company - tested on debian 6 squeeze:

# Script to create a new company with all random credentials in Debian

COA=en_IN_24-new

# To be shown in the login form
COMPANYNICKNAME="My New Company"

FADBCONFIG=/var/www/frontac/config_db.php

UPASSWD=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-12`
RANUSER=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-12`
FADBNAME=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-12`
DEFCOPWD=`dd if=/dev/urandom count=200 bs=1 2>/dev/null|tr "\n" " "|sed 's/[^a-zA-Z0-9]//g'|cut -c-8`

mysql <<EOF

CREATE USER ${RANUSER} IDENTIFIED BY '${UPASSWD}';
DROP USER '${UPASSWD}'@'%';
CREATE DATABASE ${FADBNAME} DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, SHOW VIEW, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, EXECUTE, LOCK TABLES, REFERENCES, TRIGGER ON ${FADBNAME}.* TO '${RANUSER}'@'localhost' IDENTIFIED BY '${UPASSWD}';
FLUSH PRIVILEGES;
USE ${FADBNAME};
source /var/www/frontac/sql/${COA}.sql
INSERT INTO `0_users` (`id`,`user_id`,`password`,`real_name`,`role_id`,`phone`,`email`,`language`,`date_format`,`date_sep`,`tho_sep`,`dec_sep`,`theme`,`page_size`,`prices_dec`,`qty_dec`,`rates_dec`,`percent_dec`,`show_gl`,`show_codes`,`show_hints`,`last_visit_date`,`query_size`,`graphic_links`,`pos`,`print_profile`,`rep_popup`,`sticky_doc_date`,`startup_tab`,`transaction_days`,`save_report_selections`,`use_date_picker`,`def_print_destination`,`def_print_orientation`,`inactive`) VALUES
 ('1', 'admin', MD5('${DEFCOPWD}'), 'Administrator', '2', '', 'admin@example.com', 'C', '1', '2', '0', '0', 'default', 'A4', '2', '2', '4', '1', '1', '1', '1', NOW(), '10', '1', '1', '', '1', '0', 'orders', '30', '0', '1', '0', '0', '0');

QUIT
EOF

# If the ${FADBCONFIG} script ends with "?>"
# Then remove it first with
sed '${/?>/d;}' -i ${FADBCONFIG}

echo "" >> ${FADBCONFIG};
echo "\$db_connections[] = array(" >> ${FADBCONFIG};
echo "    'name' => '${COMPANYNICKNAME}'," >> ${FADBCONFIG};
echo "    'host' => 'localhost'," >> ${FADBCONFIG};
echo "    'port' => ''," >> ${FADBCONFIG};
echo "    'dbuser' => '${RANUSER}'," >> ${FADBCONFIG};
echo "    'dbpassword' => '${UPASSWD}'," >> ${FADBCONFIG};
echo "    'dbname' => '${FADBNAME}'," >> ${FADBCONFIG};
echo "    'collation' => 'utf8_xx'," >> ${FADBCONFIG};
echo "    'tbpref' => '\$tb_pref_counter'.'_'," >> ${FADBCONFIG};
echo "  );" >> ${FADBCONFIG};
echo "\$tb_pref_counter++;" >> ${FADBCONFIG};
echo "" >> ${FADBCONFIG};
echo "# Company $tb_pref_counter admin password: " .  ${DEFCOPWD}  >> ${FADBCONFIG};
echo "" >> ${FADBCONFIG};

Users can extend this script or make one for using with an existing php script.

This can be used with the form in this post to auto create a company from a signup form.

Anyone interested in an OpenVZ or LXC template for FA can also chip in.

It can also be made into an extension.

This could be a generic form hosted by FA team where the paid Service providers can be in a drop down selection list by country as well. A captcha can also be used. It can also serve as a curated list of competent FA hosting service providers.

Attached is a sample form screenshot for ordering a FA hosting service.
Anyone interested?

As feedback, what other minimal fields are necessary.

A note on what the initial offering entails like: 1GB, 512MB, single initial admin user, Chart of Accounts, Languages preferred, etc ?

Initially a restricted user can be provided whilst the admin user can be retained by the Hosting provider's support personnel.

The details of this form can go to a database where it can be vetted and then taken into a CRM when it becomes a potential client.

No attachment.

Highlight or circle the wrong entry for ease of correction. It appears to be only a reporting / viewing issue that should be easily corrected generally but in this case it prevents you from payment allocation as well. Some function used for status checking may be in error.

@joe: is this an issue.
@jcuning: Kindly post all relevant version info.

157

(15 replies, posted in Installation)

Have a look at this.

It is still better to make NULL into empty strings to support a wide range of PHP versions.

@joe: is this a real issue?

Looks like you need the second version alone and a general inventory from FA.
Do the output items always remain output only and do not become input items for other output items?
To reduce complexity, you might want to split your 2 requirements into different applications.

Increase these settings in php.ini and restart webserver.

161

(1 replies, posted in FA Modifications)

What was this commit all about?

Thanks @itronics.

Language list versions updated and attached herein.

@joe: I have updated the extensions for Tamil and Hindi languages at: https://github.com/apmuthu/frontac24/commit/29cc99ff3938e31e7e8160508e85cfcb942300c9

Also attached them here for ease of integration into the official Extensions Repo.

164

(3 replies, posted in Announcements)

Post Release Fixes attached.

CHANGELOG

Github Master (Bleeding Edge) Download Link

These fixes can be applied to (overwrite) the release version to be fully functional.

165

(20 replies, posted in Accounts Receivable)

@joe: appears to be a useful feature. Care to place it in the core with an toggle flag in the per company options?

166

(1 replies, posted in Report Bugs here)

php-residence is now hoteldruid.
https://www.hoteldruid.com/download/php-residence_1.3.1.tar.gz
last known version as php-residence.

https://www.hoteldruid.com/download/hoteldruid_1.3.2.tar.gz

Current one that supports PHP 8 is:
https://www.hoteldruid.com/download/hoteldruid_3.0.6.tar.gz

Updated the FA24extensions repo with the updated code from @trafficpest into the my main repo.
https://github.com/apmuthu/FA24extensions/commit/27098d7653d86278dcafda09a7d4b0c71b72548b

168

(0 replies, posted in Reporting)

In the files reporting\rep301.php (Line 33 - Inventory Valuation) and reporting\rep308.php (Line 35 - Costed Inventory Movements),

    if ($myrow['type'] == ST_SUPPRECEIVE || $myrow['type'] == ST_SUPPCREDIT)

can be changed to

    if ($myrow['type'] == ST_SUPPRECEIVE || $myrow['type'] == ST_SUPPCREDIT || $myrow['type'] == ST_INVADJUST)

@joe: see if it is fit to take into the core.

It is already there as "Deliver To". Use "Deliver to location via Shipping Co"
Check out the Delivery Note screenshot and the Packing List screenshot.
The Packing List and Delivery Note are in reporting/rep110.php.

Compare the DB structures of the good and erroneous instances.
Compare the file and folder permissions of the web facing files.
Try to make the unset command into two separate commands, one for each variable, preferably after checking if it exists.
Compare the php.ini files across both installations.

In the file sales/sales_order_entry.php, at line 603, the unset appears as:

    unset($_POST['_stock_id_edit'], $_POST['stock_id']);

Wonder what the subsequent page_modified() does after the above statement that causes the error.

Your URL is not reachable in India as the major ISP has blocked ibb.co hosted at 213.174.132.224

172

(3 replies, posted in Announcements)

Release date 2024-04-03 as of GitHub commit https://github.com/FrontAccountingERP/FA/commit/3a682c094f4b40cdf4937a0157ae3552ab9d7930

SF Download Link
MD5: fc3cc6b83b5917a29c4840293d45d22e
Filesize: 1,886,651 bytes

First 3 day download stats in SourceForge

CHANGELOG

173

(3 replies, posted in Announcements)

Two new translation strings introduced in lang/new_language_template/LC_MESSAGES/empty.po

"Select a Bank Account: "
"Bank Account ID"

2024-04-26: A nice addition of"copy_link"feature - Assimilated into the core now.

174

(3 replies, posted in Translations)

Use Transifex

Use a tar command to zip up the web folder where FA is installed. Also backup the apache conf and php.ini files. Then use phpMyAdmin or mysqldump to backup the sql dump.