check file and folder owner and permissions and the validity of the .htaccess file - try removing / renaming it temporarily.
5,777 01/10/2013 09:27:05 pm
Re: 404 error for pdf reports after upgrade (14 replies, posted in Installation)
You can do a full install of the new version in a separate database and migrate the data - quite messy if the table structures have changed.
In your current state, take a backup of your database. Then:
You can simply login and proceed to Setup -> software upgrade and upgrade the database if needed.
Refer the Wiki for the upgrade path - you will need to manually make changes to the existing config.php to accommodate the new variables (after comparing with the new config.default.php) and make the version number 2.3.13 in it - FA Update Wiki Page
5,778 01/10/2013 09:19:23 pm
Re: Buttons missing from Sales, Purchase, etc. tables (14 replies, posted in Report Bugs here)
The subdomain is okay, but actual folder path needs to be set if not correctly determined by the program.
5,779 01/09/2013 07:48:36 pm
Re: How to delete outstanding order (14 replies, posted in Accounts Receivable)
Alternatively split the sales order into two parts - one for the delivered quantity and another for the undelivered part - cancelling the original sales order. Can have another wasted sales orders type of voucher collecting the undelivered parts. Take care to prevent splitting sales orders that have entries inadvertently omitted in the delivery order.....
5,780 01/09/2013 07:43:11 pm
Re: import csv (2 replies, posted in Modules Add-on's)
Have you tried the wiki?
Bulk export / import can be done at the db table level if you know what you are doing.
1. Take an sql snapshot from phpmyadmin
2. Add an item in FA
3. Take another sql snapshot from phpmyadmin
4. Compare the 2 sql snapshots for diff table records
5. Map your inventory entries based on the diff table record set obtained above into a CSV file
6. Import teh CSV into the table(s)
5,781 01/09/2013 07:32:48 pm
Re: 404 error for pdf reports after upgrade (14 replies, posted in Installation)
config.default.php is only a template file and not used. Copy it over as config.php
It is best you use the given installer rather than merely populating the config.php as the file paths and extra installed_extensions / installed_languages files get created automatically.
Also try the latest edition - v2.3.13 Mercurial Build 3131 listed in the announcement forum post.
5,782 01/09/2013 07:16:54 pm
Re: How to clear "current credit" in the direct invoice screen? (6 replies, posted in Accounts Receivable)
If so, is the ov_discount being stored as a negative value in the table? In related vein, will the discount percentages be stored in the negative as well while being entered positive in the form?
5,783 01/08/2013 02:44:38 pm
Re: How to clear "current credit" in the direct invoice screen? (6 replies, posted in Accounts Receivable)
Lines 457-458 of sales/includes/db/sales_order_db.inc:
cust.credit_limit - Sum(IFNULL(IF(trans.type=11 OR trans.type=12 OR trans.type=2,
-1, 1) * (ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount),0)) as cur_creditThe ov_discount field is being added - is that right - should it not be subtracted?
5,784 01/08/2013 02:37:45 pm
Re: How to delete outstanding order (14 replies, posted in Accounts Receivable)
Cancel Sales Invoice.
Edit Sales Order to match Delivery Order.
Make new Invoice.
Actually an option to make sales order from delivery order would be nice!
5,785 01/08/2013 02:30:40 pm
Re: How to create Chart of account Like this please help? (3 replies, posted in Misc. Charts of Accounts)
Since the first digit of the second column are all 0, omit it or start with 1.
Use most of the first column numbers (only with 1st col numbers alone) as account types - Assets, Liabilities, etc.
Use the second column (having only first and second columns of numbers only) as Account Groups mapped to the account types.
For others:
Use the cocatenation of the second and the third columns along with 000 as the Account codes.
For those with a fourth column of numbers, cocatenate the second, third and fourth columns as the Account Codes.
maybe create it as a Farhaj.sql and submit to FA as a 6/7 digit Account Code COA. What class of COA would this be most suitable for - Construction / Real Estate Company?
5,786 01/07/2013 03:53:24 pm
Re: Customer Setup (8 replies, posted in Accounts Receivable)
Backwards compatibility dictates the default switch setting - not "common-sense" to even many users. The config variables are listed with their functionality in the Wiki quite explicitly, but a note in the setting up wiki page will now possibly address this issue.
5,787 01/07/2013 03:42:10 pm
Re: Can't invoice customer through Direct Invoice (1 replies, posted in Accounts Receivable)
Refer the Service Item entry in the Wiki.
Setup an Itemof Type Service and then use it in billing clients. Service Item Type does not need any inventory stock and can be billed directly.
5,788 01/07/2013 03:37:07 pm
Re: Stock Sheet Report filter (5 replies, posted in Items and Inventory)
Please attach the code to the forum post as it can be studied and placed in the wiki if not added to the code base. Many contributions may not reach the codebase at all and may find it into personal repos only.
5,789 01/06/2013 11:28:53 am
Re: Buttons missing from Sales, Purchase, etc. tables (14 replies, posted in Report Bugs here)
Where have you extracted your files?
Your webroot appears to be /home/artisant/public_html
You seem to have some subdomain created for the FA install and not installed from there.
Try the url http://www.xxx.co/fademo1
5,790 01/06/2013 11:16:45 am
Re: Multiple Units of Measure in Inventory (6 replies, posted in Items and Inventory)
Create a unit of measure as "6sachets" and price it for 6 sachets as well and sell 1 unit of 6 sachets!
Not serious. Joe's take is the right one!
Wikied it.
5,791 01/06/2013 11:14:32 am
Re: Installation in delete GL transaction module (1 replies, posted in Modules Add-on's)
Mustn't you update the installed_extensions.php in the webroot and in the company/#/ folder as well? ... and enable it for the company as well?
5,792 01/06/2013 11:13:06 am
Re: UTF8 vs ISO8859-1 (7 replies, posted in Translations)
5,793 01/06/2013 11:04:11 am
Re: Printing to a Windows Shared Printer (2 replies, posted in Installation)
Windows Attached Printer on CUPS
Push Windows Printer Drivers to CUPS
64 bit CUPS Driver for Win7 not yet
Printing from CUPS to Windows-Attached Printers
Please see what works in the above urls and let us know so we can update the wiki accordingly.
5,794 01/06/2013 10:58:22 am
Re: Invoicing with Cash Basis accounting (3 replies, posted in Accounts Receivable)
The default language is "C" listed to include the "untranslated strings" as is from the code culled into the empty.po file. en_US is an example file to override entries in the empty.po.
5,795 01/05/2013 05:29:03 am
Re: ISO-8859-1 EUR symbol (2 replies, posted in Translations)
Wikied it.
Since the forum does not use any WYSIWYG Editor (saves bandwidth though), try the free BBCode Editor for windows.
5,796 01/05/2013 05:11:38 am
Re: Hard-coded problems in reports for translation (5 replies, posted in Reporting)
Thanks Joe for Changesets 3127/3131 addressing this problem. It however needs an entry in the empty.po file. Attempting to reconstruct the empty.po afresh yielded a file that is 341KB as against the current one in the fa repo that is 359KB. There are a lot of legacy entries with wrong filenames and line numbers in the repo one.
The shell script to generate the empty.po file I wrote is:
#!/bin/bash
FRONTACFILE=FrontAc_default_Mer_3127_2012-12-20.tar.gz
WEBROOT=/var/www/frontac
mkdir -p $WEBROOT
cd $WEBROOT
wget http://www.apmuthu.com/bugfixes/$FRONTACFILE
tar -xzf $FRONTACFILE
rm -f $FRONTACFILE
MAINDIR=`pwd`/
# Generate the main empty.po file
TPL=lang/new_language_template/LC_MESSAGES/empty
GTEXEC="xgettext -d empty --language=PHP --from-code=ISO-8859-1 \
-p $MAINDIR/lang/new_language_template/LC_MESSAGES "
# Backup the old main empty.po
mv $MAINDIR/$TPL.po $MAINDIR/$TPL.po.org
# Generate main header as well
$GTEXEC -k_ -n *.php
# set the charset
sed -i 's/charset=CHARSET/charset=ISO-8859-1/g' $MAINDIR/$TPL.po
mv install ..
$GTEXEC -k_ -n -j */*.php
$GTEXEC -k_ -n -j */*/*.php
$GTEXEC -k_ -n -j */*/*/*.php
$GTEXEC -k_ -n -j */*.inc
$GTEXEC -k_ -n -j */*/*.inc
$GTEXEC -k_ -n -j */*/*/*.inc
mv ../install .
# Generate the install empty.po file
TPL=install/lang/new_language_template/LC_MESSAGES/empty
GTEXEC="xgettext -d empty --language=PHP --from-code=ISO-8859-1 \
-p $MAINDIR/install/lang/new_language_template/LC_MESSAGES "
# Backup the old install empty.po
mv $MAINDIR/$TPL.po $MAINDIR/$TPL.po.org
# Generate install header as well
$GTEXEC -k_ -n install/*.php
# set the charset
sed -i 's/charset=CHARSET/charset=ISO-8859-1/g' $MAINDIR/$TPL.po
$GTEXEC -k_ -n -j install/*.inc
$GTEXEC -k_ -n -j includes/system_tests.inc
$GTEXEC -k_ -n -j includes/packages.inc5,797 01/05/2013 05:04:07 am
Re: Error when changing from Direct GRN to Direct Invoice (12 replies, posted in Report Bugs here)
Please test on fresh install using later Mercurial Build version from this post and see if the problem occurs.
5,798 01/05/2013 05:02:21 am
Re: Buttons missing from Sales, Purchase, etc. tables (14 replies, posted in Report Bugs here)
Also use the later Mercurial Build version of FA from this post.
5,799 01/05/2013 04:59:29 am
Re: discount to each item? (4 replies, posted in Items and Inventory)
Use a different pricelist.
5,800 01/05/2013 04:58:12 am
Re: Invoicing with Cash Basis accounting (3 replies, posted in Accounts Receivable)
Update the en_US .mo / .po files and submit to the the project what you consider to be real en_US.