@itronics: Even when checking as opposed to activation ($check_only), shouldn't the error possibility be notified atleast in the logs / screen?
FA24extensions repo synched for auth_ldap. module.
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by apmuthu
@itronics: Even when checking as opposed to activation ($check_only), shouldn't the error possibility be notified atleast in the logs / screen?
FA24extensions repo synched for auth_ldap. module.
Yes, you're right. The devs are now focussing on basic PHP 7.0 compatibility whilst ditching all pre PHP v5.3 class constructs.
These suggested workarounds will have to do for now
- recurrent editing of a single Sales Order and continued deliveries based on it by adding more line items
- Voiding and Re-creating a new Sales Order to match desired delivery bunching
- Export and Edit CSV, Void and Import CSV back the original transaction.
@joe states that the development to inculcate this feature has been postponed to a later minor release.
Edit php.ini file and remove the semicolon comment character preceding the extension for OpenSSL dll file in windows or the .so file in linux and restart the webserver.
The $stock_item is an element of $purchase_order->line_items. The $purchase_order object gets populated from the function read_po() defined in purchasing/includes/db/po_db.inc. The stock_master table provides only the units field in the sql in the function read_po_items it calls therefrom. Extend it by appending long_description and use it where you want.
Alter line 210 in purchasing/includes/db/po_db.php:
$sql = "SELECT poline.*, units
to be:
$sql = "SELECT poline.*, units, long_description
and then use it in the view_po.php file.
What extensions did you install?
Try them one by one alone and see which ones give the error.
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.
Does this account for returns / rejects where negative qty will get lost?
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?
Unless you clone the function display_dg_pager() and use it in the dimensions file, it will affect all tabular displays.
Wiki-ed it.
Just make access/login.php at line 51 from:
$login_timeout = $_SESSION["wa_current_user"]->last_act;
to:
$login_timeout = false;
Much water has flown since then.
Take the Git Master version as it works at this point in time and has fixed many bugs.
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.
Search the wiki and forum.
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.
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.
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.
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
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!
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+.
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.
FrontAccounting forum → Posts by apmuthu
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.