2,451

(11 replies, posted in Setup)

What extensions did you install?
Try them one by one alone and see which ones give the error.

2,452

(14 replies, posted in Report Bugs here)

Should it not be:

$sql .= " AND s.mb_flag='M' AND (
                     (m.qty > 0 AND m.type <> " . CUSTCREDIT . ") OR 
                     (m.qty < 0 AND m.type = " . CUSTCREDIT . ")
                   )" ;

Attached is the set of files for the standard English template for FA v2.4.2 core strings and their Google translated counterparts in Marathi, Bengali, Malayalam, Telugu, Punjabi, Kannada, Gujarathi, Nepali, Sinhala and Burmese.

Those natively proficient in these languages can use WinMerge to compare the English and their target language files and correct them manually and upload anywhere and post the link here. Any interest in other languages too can do the same.

The Wiki has info on rapid language translation techniques.

2,454

(14 replies, posted in Report Bugs here)

Does this account for returns / rejects where negative qty will get lost?

2,455

(12 replies, posted in Wish List)

How about voiding the Sales order and creating a new one or just exporting it earlier, editing the CSV and then importing it after voiding the current one?

2,456

(3 replies, posted in FA Modifications)

Unless you clone the function display_dg_pager() and use it in the dimensions file, it will affect all tabular displays.

Wiki-ed it.

2,457

(11 replies, posted in Setup)

Just make access/login.php at line 51 from:

    $login_timeout = $_SESSION["wa_current_user"]->last_act;

to:

    $login_timeout = false;

2,458

(11 replies, posted in Setup)

Much water has flown since then.
Take the Git Master version as it works at this point in time and has fixed many bugs.

2,459

(1 replies, posted in Wish List)

The direct sales invoice (and direct purchase invoice) actually do all of the other work like making sales quote/order/delivery and possibly payment if it is a cash terms invoice and hence the need for all the code to be in one place. They all populate the same set of transaction tables and share a lot of the same code.

Functions can be created for wach work but they will need to address scope of variables too - global-ising everything is not controllable.

2,460

(11 replies, posted in Setup)

Search the wiki and forum.

Post

Otherwise hack the code as stated in one of the forum posts to bypass the timeout check if your IP changes frequently.

Check the access/login.php file at line 51:

    $login_timeout = $_SESSION["wa_current_user"]->last_act;

This records the last activity as a boolean of the logged in user. This is for login only and not for the Authorization timeout you refer to.

Timezone issues too may be the cause.

The actual function login_timeout() is the one that provides the boolean is based on the timeout set in the company preferences (sys_prefs table record) that elapsed after the last activity time and is defined in includes/session.inc. If this function is used properly then the timeout should not occur.

The function session_timeout() defined in includes/current_user.inc is the one that sets the $tout variable from time to time when the check is made.

2,461

(1 replies, posted in FA Modifications)

How would you know which non first page belongs to which first page is there are many different files of the same report? The same would then apply to the footer to be in the last page only!

To use the new Tamil Language in the installer, add it to the $inst_langs array in install/isession.inc file:

  'ta_IN' => array ( 'name' => 'Tamil',    'code' => 'ta_IN',    'encoding' => 'utf-8'),

and place the ta_IN folder from this install translation commit in the install/lang folder.

2,463

(3 replies, posted in FA Modifications)

The function display_db_pager() defined in includes/ui/db_pager_view.inc is responsible for almost all tabular paged displays in FA. Clone the function and call it instead in the dimensions/inquiry/search_dimensions.php if you do not want such a modification in all table displays. The code that displays the header is:

table_header($headers);

Try line 85 in it as:

if ($line_no > 1 && $line_no % 10 === 0) table_header($headers);

In accrual method, only when payment is received is the invoice bookable. That is you do not consider it income till you get paid or the customer has agreed to pay and you accept that as the point of income. FA does not bother about when you choose to record the payment voucher and when you wish to invoice the sale. This may be useful for computing tax on sales that have been paid for.

Now it is possible to install FA 2.4 in the Tamil language as it has been fully translated.
Committed in my repo.

2,466

(1 replies, posted in Translations)

Get all your target language strings by suitably forming your URL thus:

Arabic:
http://translate.google.com/translate?js=n&sl=auto&tl=ar&u=http://www.sacollege.net/FA24_en_tx.html

Hindi:
http://translate.google.com/translate?js=n&sl=auto&tl=hi&u=http://www.sacollege.net/FA24_install_en_tx.html

Obtain your language code from:

https://cloud.google.com/translate/docs/languages

2,467

(9 replies, posted in Setup)

From time to time, stop FA and DB Access and optimise / re-index the databases after a backup. The indexes should be recreated and the data packed before restarting DB Access.

Migration of all tables to InnoDB in FA 2.4.x when there is no sign of any CASCADES is actually a retrograde step in so far as it increases the difficulty in table data recovery which would require expert assistance and commercial tools. Rarely changing lookup data should not need to reside in InnoDB tables ordinarily.

Only where transactional integrity with commit and rollback along with cascade deletion/updation of child tables are available in the codebase would it become necessary. Linkage with such enabled external applications is also another case when InnoDB conversion would become necessary.

Using the directive to keep files on a per table basis may improve the chances of recovery and restict damage to specific tables in InnoDB which would otherwise by default choose to store everything in one big file - lose it and you lose everything!

2,468

(1 replies, posted in Translations)

The Wiki has been updated with the information on using my scripts attached) for rapid translation of FA and others using GetText. These scripts are maintained at GitHub in my PHPProjects Repo.

The Hindi (hi_IN) translation is now fully done for FA 2.4.2+.

To get a starting list of strings for any language, use Google Translate (5000 character limit per submission) or choose to translate this page in it for FA 2.4.2+.

2,470

(9 replies, posted in Setup)

Processor speed and hard disk size and speed will matter apart from sufficient RAM that must be appropriately allocated  to PHP/Apache and MySQL. Use MySQL Tuner to tune your db settings.

Upto 10MB backup size has been no problems so far on modern machines.

Make sure that the $path_to_root variable never ends in a slash (/) and is what it should be (compare both FA 2.3 and FA 2.4 instances). You can temporarily put in the following snippet at the beginning of the php code (after the starting <?php line in config.php and check the output:

echo $path_to_root;
exit;

or use one of the troubleshooting techniques in the wiki.

@barbarian: Thanks for sharing.

Wiki-ed it.

ChromeLogger is available for quite a few programming languages.

The entire Troubleshooting FA wiki page as on date is attached for offline usage.

2,473

(2 replies, posted in Jobs wanted/offered, non-free offers)

Download the P8000 specs and the SDK without registration. Modify the reporting/repXXX.php files to suit your printer width and use the fonts available in the device. The device will be having the default printer as the thermal one as it is integrated in it.

Tamil translations have been done 100% in Transifex for both FA 2.3 and 2.4 and committed for the latter in the FA24extensions repo for ta_IN.

Hindi too is progressing rapidly.

@kvvaradha - you can verify with your version and suggest improvements. Completed it on my own as your version was not provided.

Thanks @joe/@itronics. This will help streamline all the extensions as well and avoid security tinkering in the themes.