Chances are that they may be overwritten by others with similar ideas (from their extensions). Better to keep your constants inside your extension and do an array merge of standard arrays with yours for use within your extension.
2,726 09/17/2017 04:12:04 pm
Re: Can i Add new Sysname from Extensions ? (2 replies, posted in Modules Add-on's)
2,727 09/17/2017 03:44:24 am
Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)
The sales/merge_customers.php file has been updated with TB_PREF and sql_injection protection.
@joe: can include in core with appropriate menu entry and role permission.
The same can be done for suppliers and items as well.
2,728 09/15/2017 04:37:49 pm
Re: Report Generator (3 replies, posted in Modules Add-on's)
Try this one. Repo updated with auto http / https.
2,729 09/15/2017 02:37:56 pm
Re: Standard pricing & Inventory Valuation Report showing 50% on manufact (3 replies, posted in Items and Inventory)
@poncho1234: update to latest codebase after FA v2.4.2 released. See Announcements and patch.
2,730 09/15/2017 02:36:55 pm
Re: Account & Account Type Ordering (7 replies, posted in FA Modifications)
@joe: makes sense.
2,731 09/15/2017 02:36:23 pm
Re: Bug in rep108 (10 replies, posted in Report Bugs here)
@joe: any separate code for JE?
2,732 09/15/2017 02:27:11 pm
Re: Error flashes up after creating a supplier invoice (6 replies, posted in Report Bugs here)
@poncho1234: You have just found a bug!
@joe: There is no variable $net_total in entire FA 2.4.2 but is used in /purchasing/includes/db/invoice_db.inc at line 396. Should it be $invoice_items_total or $allocate_amount or something else?
2,733 09/14/2017 05:41:38 pm
Re: Can't change the currency of bank accounts (2 replies, posted in Banking and General Ledger)
The "Banking and General Ledger => GL Accounts => Edit Bank Account" does not bear the Currency details.
The "Banking and General Ledger => Bank Accounts => Edit" does not allow the changing of Currency once set. This can be changed in the database directly only. Take a backup, correct it in the sql and upload and restore it. This should be done only when you know that no transactions exist for the said Bank Account as yet.
Make sure that the Home Currency is properly set in the Setup => "Company Setup".
2,734 09/14/2017 05:33:28 pm
Re: Multiple Products From One Manufacturing Process (5 replies, posted in Manufactoring)
Raw Milk, Toned Milk and Cream are 3 different products.
100 Ltr of Raw Milk = 100 Ltr of Toned Milk + 10 Kg of Cream
If you treat the output products as the real constituent items and the input product as the "Kit", you will ordinarily be dismantling the "Kit" and selling the constituent items whilst you can also sell the Raw Milk directly if desired - directly in the "Kit" form.
2,735 09/13/2017 03:11:47 pm
Re: Fixed Assets (30 replies, posted in Fixed Assets)
Fixed Assets was an extension in FA 2.3 and is builtin to FA 2.4 natively. The wiki does not yet have a page on it.. Fixed Assets on the Wiki
To configure the Fixed Assets, enable the role for it (Fixed Assets Configuration), save the role and logout and login again.
The attached screenshots are self explanatory.
2,736 09/13/2017 02:57:01 pm
Re: Option for printing logo on reports. (12 replies, posted in Reporting)
This has already been committed in the Official repo and in the standard charts. It will hence be part of the next release.
2,737 09/12/2017 04:21:15 pm
Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)
To avoid sql injection where we know the 2 POST variables are integers, just use:
$deletecustomer = $_POST['deletecustomer']+0;
$keepcustomer = $_POST['keepcustomer']+0;
2,738 09/12/2017 04:14:09 pm
Re: Report Generator (3 replies, posted in Modules Add-on's)
Compare the files in the official repgen pkg as extracted to the modules folder with that in my GitHub repo and synch as needed.
There 2 places in repgen_createfunct.php (88, 104) and 1 place in repgen_del.php (58) where http can be changed to https - maybe it should be coded to auto choose.
2,739 09/10/2017 07:50:33 pm
Re: How Can I Merge Customers? (16 replies, posted in Accounts Receivable)
Study the schema / ERD for your version of FA and then replace all discardable customer ids with the preferred customer id.
The FA 2.3.x schema is available in the Wiki and FA v2.4.x isn't too different.
2,740 09/08/2017 06:54:39 am
Re: Invoice problem with new version (13 replies, posted in Reporting)
Attached is the Company Setup page with the said option.
2,741 09/08/2017 06:52:04 am
Re: Option for printing logo on reports. (12 replies, posted in Reporting)
Attached is the screenshot of the new Company Setup page.
Also incorporate in all the Charts as in my FA24Mods.
2,742 09/08/2017 05:42:35 am
Re: Upgrade from 2.3.25 to 2.42: DB upgrade not working (7 replies, posted in Installation)
@joe: change line 23 in sql/alter2.4.php:
$this->description = _('Upgrade from version 2.3 to 2.4RC1');
to
$this->description = _('Upgrade from version 2.3 to 2.4.1');
Also line 158 in the same file needs to be conditionally acquired:
$old_encoding = 'latin1'; // default client encoding
Looks like your db schema needs 900 secs time out instead of 300. Also check the attached schema differences between FA 2.3 and 2.4.
2,743 09/08/2017 05:15:59 am
Re: Reset Document Number with new Fiscal Year (1 replies, posted in Banking and General Ledger)
See the reflines table. The pattern field in FA 2.4.2 which automatically does this.
2,744 09/05/2017 01:46:05 am
Re: Option for printing logo on reports. (12 replies, posted in Reporting)
Would be nice to have it on a per company basis.
Will an entry in the sys_prefs table override this setting treating the global one as the default?
The Wiki has been updated.
2,745 09/04/2017 10:02:16 am
Re: Forum Usage - best practices (5 replies, posted in Announcements)
Greenshot does not yet do scrolling window capture (FastStone does). It, however, has a portable version and a non installer zip version too.
2,746 09/04/2017 04:52:22 am
Re: Forum Usage - best practices (5 replies, posted in Announcements)
Format your BBCode using the likes of WYSIWYG BBCode Editor.
FastStone Screen capture was free till v5.3 and makes for good screenshots although PrtScreen button and MS Paint do the job as well. Various portable ones are available too.
2,747 09/04/2017 04:51:20 am
Topic: Forum Usage - best practices (5 replies, posted in Announcements)
As the FrontAccounting forum is community managed and driven, please use it diligently and with care. Whilst every effort is taken to ban advertising and undesirable SEO activities, it is incumbent on the user fraternity to report any
1. irrelevant posts,
2. duplicate postings and
3. postings in old threads with seemingly relevant matter often taken from other valid posts.
All of these and others not listed here introduce needless complexity and waste of human resources in moderating the board. Attempting to maintain a Hall of Shame would be an additional waste of resources.
When posting issues, please list
1. version numbers of Platform OS, Browser, PHP, MySQL, Webserver, plugins, upgrade path and locale among others as necessary
2. relevant Menu Navigation sequences,
3. screenshots appropriately annotated (host the images/documents anywhere - flickr, dropbox, etc) and linked into the posts,
4. use BBCode to format your posts
2,748 09/03/2017 12:56:53 am
Re: Work order give me a error in my Standard cost (8 replies, posted in Manufactoring)
2,749 09/02/2017 04:41:21 pm
Re: Error Rounding with Tax (8 replies, posted in Accounts Payable)
Try smaller numbers first and see when the error occurs. You should not exhaust the floating point precision of your variable.
This is a PHP issue:
$a = 31975454.54545400;
$b = 3197545.45454540;
echo $a+$b;
// Outputs: 35172999.999999
What is the value of precision in your php.ini file?
Increase it and see what happens.
Increasing it from 14 to 17 in PHP 5.3.3 on 32 bit XAMPP:
$a = 31975454.54545400;
$b = 3197545.45454540;
echo $a+$b;
// Outputs 35172999.999999397
This might do the job.
In the code, it can be dynamically set as well:
ini_set('precision', 17);
2,750 09/02/2017 03:47:50 pm
Re: Group Total in Trial Balance (13 replies, posted in FA Modifications)
Thanks @joe.
Committed