@joe: any separate code for JE?
2,727 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,728 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,729 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,730 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,731 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,732 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,733 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,734 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,735 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,736 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,737 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 encodingLooks 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,738 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,739 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,740 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,741 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,742 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,743 09/03/2017 12:56:53 am
Re: Work order give me a error in my Standard cost (8 replies, posted in Manufactoring)
2,744 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.999999What 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.999999397This might do the job.
In the code, it can be dynamically set as well:
ini_set('precision', 17);2,745 09/02/2017 03:47:50 pm
Re: Group Total in Trial Balance (13 replies, posted in FA Modifications)
Thanks @joe.
Committed
2,746 09/02/2017 01:04:56 pm
Re: add view (3 replies, posted in Banking and General Ledger)
There is no 1100 in your image.
If you want an amount in words, then you will have to use the locale script to get it. The template is available in lang/new_language_template/locale.inc. Translate and use in your language folder.
If you want the hint "View this transaction" when you hover on the Trans# link, then add the attribute title="View this transaction" to the link's anchor <a ....> tag.
Kindly take professional assistance on the Job board from someone who understands your language.
2,747 09/02/2017 09:39:06 am
Re: thermal print (1 replies, posted in Jobs wanted/offered, non-free offers)
Set default printer in AndroidPOS device and print from the browser UI in the Android device itself. Some may also come with the web interface API.
2,748 09/02/2017 09:33:33 am
Re: add view (3 replies, posted in Banking and General Ledger)
It is already present.
2,749 09/02/2017 09:22:54 am
Re: Work order give me a error in my Standard cost (8 replies, posted in Manufactoring)
There is certainly no decimals issue in using all hard currencies and the SA Rand.
Posting as Guest has been hopefully disabled by now.
The kit is formed in Assembly like a bunch of items sold together as a pack. It will have another Stock ID as well and hence placing them in stock should be no issue.
Items and Inventory => Sales Kits
@joe: Does this warrant a check? Assign the first post in this thread to user: @karl1234. (done)
2,750 09/02/2017 04:32:42 am
Re: Work order give me a error in my Standard cost (8 replies, posted in Manufactoring)
It appears that your email id is not available and your credentials are wrong. Kindly contact the board admin (@joe) for account validation.
Sell the Necklace as a Kit of 2 items - a sort of package.