You can probably either hardcode it yourself or modify the string in the .po file and then compile the .mo file and use it to suit your understanding.
3,526 06/01/2016 03:34:29 pm
Re: Isn't it Supplier Debit Note? Why do you call it Credit Note in FA? (3 replies, posted in Accounts Payable)
3,527 06/01/2016 03:32:35 pm
Re: FA won't close fiscal year (10 replies, posted in Report Bugs here)
FA 2.4 config.default.php lines 49-50:
// Build for development purposes
$build_version = date("d.m.Y", filemtime("$path_to_root/CHANGELOG.txt"));Check the value of $path_to_root at that point.
3,528 05/29/2016 12:30:18 pm
Re: Isn't it Supplier Debit Note? Why do you call it Credit Note in FA? (3 replies, posted in Accounts Payable)
Probably because it is the prerogative of the Supplier to provide us the credit note that we take cognizance of in our books.
3,529 05/27/2016 05:44:06 pm
Re: 2 factor authentication to FrontAccounting (4 replies, posted in Modules Add-on's)
Modify the function that processes the login credentials. Get the second factor from an email or SMS and enter it into a session variable and then verify with the second factor server and populate a second session variable which then becomes a token of the outcome and remains persistent thereafter for the login session.
3,530 05/27/2016 05:33:58 pm
Re: Users can't login to live companies other than demo company (2 replies, posted in Setup)
Use v2.3.25+ from the GitHub master.
Choose the company in the login page.
The default company is the one from which new companies can be created.
If you did not give a password during company creation then it is assumed to be "password".
Make sure you close all instances of the browser before logging into a different company.
All super users are "admin" for all companies created anew within FA.
3,531 05/27/2016 05:29:49 pm
Re: report on journal edits or voids (1 replies, posted in Banking and General Ledger)
Turn on Audit Trail in config file. It will not be specific to your filter.
3,532 05/25/2016 03:21:26 am
Re: SALES PRICING IN "ITEMS" AND UNDER "ITEMS AND INVENTORY" (5 replies, posted in Report Bugs here)
@Joe: can you replicate this issue and if so please set the permissions for Items view fields.
3,533 05/24/2016 11:45:48 am
Re: Scalabilty (1 replies, posted in Announcements)
You might want to use the MySQL tuning Wizard and think about using the InnoDB File per table option (it is enabled by default in MySQL v5.6+).
A few index tweaks for the current stable version are available.
3,534 05/24/2016 05:47:58 am
Re: BLOOMBERG Exchange Rate Fix (2 replies, posted in Banking and General Ledger)
3,535 05/22/2016 07:23:23 am
Re: How to modify the login page of FA (1 replies, posted in Setup)
access/login.php3,536 05/20/2016 07:42:14 pm
Topic: BLOOMBERG Exchange Rate Fix (2 replies, posted in Banking and General Ledger)
Bloomberg has changed their wrapper from span to div. Attached is the fix for FA 2.3. Kindly update both repos.
3,537 05/20/2016 05:33:20 pm
Re: Release 2.3.25 (2 replies, posted in Announcements)
Post Release fixes for FA v2.3.25.
Read caveats on using extensions with the new improved entropy.
3,538 05/20/2016 02:25:11 pm
Re: email sale invoice with extra attachment does not work (16 replies, posted in Accounts Receivable)
Alternatively, you can send the email out to your gmail address from FA and then manipulate it in gmail and forward to who you want.
If you are using Mercury Mail in Windows XAMPP then you can configure your mail client to approve all outgoing mail before being sent.
3,539 05/20/2016 02:22:54 pm
Re: How to show shipping company on invoice and sales order (3 replies, posted in Reporting)
Have a look at the Reporting Wiki Page which illustrates how to add a Signature to the Invoice and how to add extra lines to the invoice.
3,540 05/20/2016 02:19:45 pm
Re: Vat Inclusive Price (3 replies, posted in Items and Inventory)
This called Tax inclusive price of product.
Have a look at Sales Types in the Wiki.
3,541 05/17/2016 08:18:28 pm
Re: I try to install new copy of FA2.3.25, there is a bug! (2 replies, posted in Setup)
Disable Strict Mode in MySQL 5.7 and beyond:
https://support.kayako.com/article/472-how-do-i-disable-mysql-strict-mode-on-the-server
https://mattstauffer.co/blog/how-to-disable-mysql-strict-mode-on-laravel-forge-ubuntu
MySQL actually looks five different places for configuration files, so you can make the change I'm about to recommend several places. It'll look in
/etc/my.cnf,
/etc/mysql/my.cnf,
SYSCONFDIR/my.cnf,
$MYSQL_HOME/my.cnf, and
~/my.cnf.The last one above is user-specific, and the third and fourth options rely on specifics from your environment.
In the my.cnf file, use the following:
[mysqld]
sql_mode=ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONThen restart MySQL - in Debian / Ubuntu it is:
/etc/init.d/mysql restart3,542 05/17/2016 07:55:14 pm
Re: Where are translations for "Top $limit....." in FA 2.4? (3 replies, posted in Translations)
Thanks Janusz. Fixed in this commit.
3,543 05/17/2016 07:33:09 pm
Re: email sale invoice with extra attachment does not work (16 replies, posted in Accounts Receivable)
First decide where you will have your pdfs to be attached and what naming convention you would use so that the "id" of the invoice is part of the file name. When creating links, the invoice number will be available to the script which can be used to construct the desired link for the file. Check out the code where the invoice is attached and add a similar line for your file.
Please note that this kind of change should be attempted by PHP programmers and is not meant for the faint of heart. Sufficient debugging will be needed as well besides checks for file presence, content and permissions need to be taken care of.
3,544 05/17/2016 07:27:43 pm
Re: How to show shipping company on invoice and sales order (3 replies, posted in Reporting)
Checkout the reporting/includes/doctext.inc and reporting/includes/header2.inc files.
3,545 05/17/2016 07:23:10 pm
Re: Name on Delivered to line on invoice (3 replies, posted in Wish List)
Create a reporting folder in your company/# folder and place your modified repXXX.php files there. They will override the ones in the one in the webroot. This way your will not get overwritten on any update though you will have to manually update your mods for any enhancements changes in the core.
Make the different "Company Names" as part of the "Branch Address".
3,546 05/17/2016 03:49:09 pm
Re: problem logging in as admin after installation (5 replies, posted in Installation)
If it is just an issue of password, then reset it to "password" by using phpmyadmin or sqlyog or any other mysql client (even CLI) and execute the command for your company (assumed 0 here):
UPDATE 0_users SET
`password`=MD5("password")
, inactive=0
, role_id=2
, startup_tab='orders'
WHERE user_id='admin';3,547 05/17/2016 03:42:46 pm
Re: Name on Delivered to line on invoice (3 replies, posted in Wish List)
Make a list of reports in FA where VAT is used that you would like to get rid of and see if a mere translated string can be hardcoded (as possibly blank) or removed from it. All such report files are in reporting/repXXX.php though the header files reporting/includes/*.inc/php.
It is indeed quixotic that the default CoAs distributed with FA are for the US whilst the EU/Asian VAT/GST seems to be in them!
3,548 05/16/2016 05:12:52 am
Re: I try to install new copy of FA2.3.25, there is a bug! (2 replies, posted in Setup)
When posting information on an error you should post the choices made in the preceeding form. Assuming you chose the en_US-new.sql Chart of Accounts in the previous form, line 42 in sql/en_US-new.sql is:
`tran_date` date NOT NULL default '0000-00-00',Some recent versions of MySQL do not allow '0000-00-00' as a valid date field value. Try removing all such constructs (default '0000-00-00') from the said sql file and re-try the installation after emptying the db. Alternatively set strict mode off in MySQL.
The following links provide further info:
https://dev.mysql.com/doc/refman/5.6/en/datetime.html
http://stackoverflow.com/questions/25349126/how-can-i-set-the-default-value-of-a-field-as-0000-00-00-000000
http://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime
The error is because of the sql mode which can be strict mode as per latest MYSQL 5.7 documentation
MySQL Documentation 5.7 says:
Strict mode affects whether the server permits '0000-00-00' as a valid date: If strict mode is not enabled, '0000-00-00' is permitted and inserts produce no warning. If strict mode is enabled, '0000-00-00' is not permitted and inserts produce an error, unless IGNORE is given as well. For INSERT IGNORE and UPDATE IGNORE, '0000-00-00' is permitted and inserts produce a warning.
To Check MYSQL mode
SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session
There are a total of 31 places in the en_US-new.sql file where the said construct is there.
There are many places in the php codebase where the equivalent of the following constructs are available:
if ($date == 0) $date = '0000-00-00';and
$sql .= " tran_date > IF(ctype>0 AND ctype<".CL_INCOME.", '0000-00-00', '$from_date') AND";Hence it is better to turn the strict mode off in the mysql and not tamper with the Charts sql.
3,549 05/16/2016 04:11:15 am
Re: email sale invoice with extra attachment does not work (16 replies, posted in Accounts Receivable)
All email in FA are sent using the class email which is in reporting/includes/class.mail.inc.
Search for the text "new email" in the FA code and all such places that use it will emerge and in FA it will be:
reporting/includes/inventory_db.inc => function send_reorder_email()
reporting/includes/pdf_report.inc => function FrontReport::End()Since it is inside functions, search recursively for each function call in the codebase.
3,550 05/14/2016 09:33:30 am
Re: Front Accounting and ERP Expert (4 replies, posted in Jobs wanted/offered, non-free offers)
You mentioned that you are a "experienced Front Accounting..... expert" .....
Kindly note that FA 2.3 is quite mature whilst it's CoAs in the official repo are not all of the "exact" schema. Since you are implementing FA for your clients, you will do well to check out the extensions development in the unofficial repo as well besides the FAMods.
Other than being free what made you choose FA after so much experience with "big ERPs"?
Cheers and good luck. Enjoy FA.