This has now been wikied.
3,851 09/16/2015 11:31:32 am
Re: Password problem, even after reseting it at MYSQL table through PhpmyA (13 replies, posted in Installation)
3,852 09/16/2015 11:22:47 am
Re: Restoring from Backup (7 replies, posted in Setup)
In phpMyAdmin or SQLyog or any MySQL client, drop your FA database (or delete the 1_ prefixed tables in a shared db) for the said company. Recreate the database for the 1_ company. Now get your extracted sql file from your earlier backup and load it into the newly created database.
If you still have any problems, PM me with the access details and a link to your backup.
3,853 09/15/2015 02:41:03 pm
Re: White Screen after login after activating extensions (10 replies, posted in Report Bugs here)
Kindly keep all FA 2.4 beta topics separate. Check your fileset as it could be erroneous.
3,854 09/15/2015 11:47:34 am
Re: Where to change the table alignment of pdf report (2 replies, posted in Reporting)
Which report are you referring to - which repXXX.php file?
All parameters passed on to reports are defined in reporting/reports_main.php.
3,855 09/15/2015 11:24:24 am
Re: White Screen after login after activating extensions (10 replies, posted in Report Bugs here)
Dashboard theme and extension should be installed before being activated and chosen.
The file includes/ui/ui_input.inc does not contain the function text_input() and hence it could have been declared in it.
Which version of FrontAccounting are you using?
Only the file modules/dashboard/dashboard_ui.inc has the said function at lines 28 to 47:
function text_input($label, $name, $value=null, $size="", $max="", $title=false,
$labparams="", $post_label="", $inparams="")
{
global $Ajax;
default_focus($name);
if ($label != null)
label_cell($label, $labparams);
if ($value === null)
$value = get_post($name);
echo "<input $inparams type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" value=\"$value\""
.($title ? " title='$title'" : '')
.">";
if ($post_label != "")
echo " " . $post_label;
$Ajax->addUpdate($name, $name, $value);
}
3,856 09/15/2015 11:22:10 am
Re: Work for replacing frontaccounting grid with jQuery datatables (3 replies, posted in Jobs wanted/offered, non-free offers)
3,857 09/15/2015 11:09:17 am
Re: Blank page occasionally (4 replies, posted in Setup)
If you have installed the auth_ldap extension, the default is that it is enabled. It will come into action when the extension is activated for a specific company.
You may want to update the auth_ldap extension's files from my GitHub repo.
3,858 09/15/2015 10:59:05 am
Re: FA Planet announced (www.faplanet.pl) (17 replies, posted in FA Modifications)
@omerabbas:
The file includes/menu.inc does not exist in both FA v2.3.x and FA v2.4.
The table 0_menu too does not exist in both versions.
It is possible you are using a very old or customised version of FA or it's fork or parent.
If you are using Drupal in the same folder and database you might encounter such an error.
3,859 09/13/2015 03:16:12 pm
Re: Purge Old Item Numbers (3 replies, posted in Items and Inventory)
Wikied it.
3,860 09/13/2015 03:11:17 pm
Re: need retrieving tax rate per item during invoice generation (14 replies, posted in Reporting)
v2.4 is in beta. The stable one is v2.3.24+ snapshot?
3,861 09/13/2015 03:09:47 pm
Re: Changing Chart of Accounts type *after* setup of hosted account (3 replies, posted in Banking and General Ledger)
It does not - but you could do a search and replace for those insert statements in the backup and then restore.
3,862 09/11/2015 08:35:09 pm
Re: Keen on translating (40 replies, posted in Translations)
Check the wiki for abbreviations and then translate them as well for the wiki!
Post your translated .po file in the forum for peer review apart from sending it to the official email id for inclusion into the official repo.
3,863 09/11/2015 08:33:05 pm
Re: Supplier Payment v Bank Payment (4 replies, posted in Banking and General Ledger)
Create a supplier invoice and then allocate a payment to the supplier invoice.
3,864 09/11/2015 08:31:06 pm
Re: Where to change the css for pdf report (2 replies, posted in Reporting)
CSS in PDF?
3,865 09/11/2015 08:30:04 pm
Re: Changing Chart of Accounts type *after* setup of hosted account (3 replies, posted in Banking and General Ledger)
1. Take a backup of your existing FA from within the Web GUI.
2. Copy the admin username and password hash from the users yable in the backup.
3. Download the 4 or 5 digit CoA of your choice from the official repo or from my GitHb repo.
4. Copy the username and password into the users table data and make sure the table prefixes are matched.
5. Restore the 4 or 5 digit CoA from the repo into your FA.
3,866 09/09/2015 09:37:46 pm
Topic: Hard coding $params for dimensions (0 replies, posted in Reporting)
In reporting/includes folder, in the files pdf_reports.inc and excel_reports.inc, the function header3() has hardcoded subscripts of 3, 4 and 5 for dimension1, dimension2 and tags respectively (tags not done yet in excel_reports.inc).
Hence in all reports that use dimensions and tags we need to make sure these are adhered to if header3 is used!
3,867 09/09/2015 09:31:28 pm
Re: Report Destination missing in some reports (3 replies, posted in Reporting)
Hence no excel output for these documents - right?
3,868 09/09/2015 08:15:45 pm
Re: More detail needed for dimensions (16 replies, posted in Reporting)
That would be rep108.php file along with form field entries coming from the reports_main.php file.
After backing up the files, overwrite the files in the reporting folder with the ones in the attachment and see if it is what you want.
rep108.php in it's function getTransactions() has an sql statement that refers to just 1 table where the fields can be written without the table name prefix.
3,869 09/09/2015 08:14:02 pm
Re: Customer Statement Reference (5 replies, posted in Reporting)
File Upload is controlled by the SysAdmin for the board.
The Customer's Reference will be different for each invoice and payment and hence it should be removed from this report in it's entirety.
Sales Person is not attached to any company - just to an Invoice or a Payment.
Hence Sales Person along with Our Order No and Delivery Date are also meaningless in this report and should be removed.
3,870 09/09/2015 08:07:27 pm
Topic: Report Destination missing in some reports (3 replies, posted in Reporting)
@joe: Some of the forms requesting reporting/repXXX.php to print reports do not have the "Destination" parameter. Is this by design?
These reports are:
107
108
109
110
111
112
113
209
210
3,871 09/09/2015 05:39:14 am
Re: More detail needed for dimensions (16 replies, posted in Reporting)
Which specific report (repXXX.php) are you referring to - maybe we can alter it's sql to include a dimension filter to get what you want. The Wiki has a list of reports and their screenshots.
3,872 09/08/2015 03:08:40 pm
Re: Change International Numeric System to Indian Numeric System. (2 replies, posted in Banking and General Ledger)
Install an Indian language locale in your *nix system
3,873 09/08/2015 03:07:25 pm
Re: Customer Statement Reference (5 replies, posted in Reporting)
Please provide report Number (repXXX.php) and snapshot of what you think should be where.
3,874 09/08/2015 03:04:03 pm
Re: More detail needed for dimensions (16 replies, posted in Reporting)
Try tags.
3,875 09/08/2015 03:03:00 pm
Re: Fix For The Alt + Tab Problem (5 replies, posted in Report Bugs here)
The problem is visible on the FA v2.3.21 FA demo intermittently - 2 times in 7 tries on a WinXP SP3 / FireFox 34+ client.
Unable to see it on my WinXP XAMPP install and my Debian Linux install of the latest snapshot.