This has now been wikied.

3,852

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

Kindly keep all FA 2.4 beta topics separate. Check your fileset as it could be erroneous.

Which report are you referring to - which repXXX.php file?
All parameters passed on to reports are defined in reporting/reports_main.php.

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);
}

There could be others using your email id in Gujarat and Jaipur, Rajasthan:

Providing a bounty and expected timeframe would get you quick responses.

3,857

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

@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

(3 replies, posted in Items and Inventory)

Wikied it.

v2.4 is in beta. The stable one is v2.3.24+ snapshot?

It does not - but you could do a search and replace for those insert statements in the backup and then restore.

3,862

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

Create a supplier invoice and then allocate a payment to the supplier invoice.

3,864

(2 replies, posted in Reporting)

CSS in PDF?

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

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

Hence no excel output for these documents - right?

3,868

(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

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

@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

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

Install an Indian language locale in your *nix system

3,873

(5 replies, posted in Reporting)

Please provide report Number (repXXX.php) and snapshot of what you think should be where.

3,874

(16 replies, posted in Reporting)

Try tags.

3,875

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