@joe: can this be done in the core with a sys_prefs flag for now?
676 07/14/2020 06:00:36 pm
Re: How do I restrict user not to raise invoice for all customers (5 replies, posted in Accounts Receivable)
677 07/14/2020 05:59:27 pm
Re: translation is not working in User interface (6 replies, posted in Translations)
Wiki-ed.
678 07/12/2020 02:59:00 pm
Re: How can i create a new language (1 replies, posted in Translations)
Read the Wiki.
679 07/12/2020 02:56:34 pm
Re: How do I restrict user not to raise invoice for all customers (5 replies, posted in Accounts Receivable)
You will need a custom extension done for this as it is not available in the core.
680 07/12/2020 02:54:56 pm
Re: Insert rows between lines (5 replies, posted in Accounts Receivable)
Changing the primary keys of the respective tables and re-ordering them is possible but must be done carefully or through a separate script / extension.
681 07/12/2020 02:38:03 pm
Re: Receive Purchase Order Items: stopped working since 2.4.7! (6 replies, posted in Items and Inventory)
Please make sure you have tested with the Git Master which has the post release fixes too. The file includes/ui/allocation_cart.inc was updated on these dates:
2020-03-18 (after FA 2.4.8 was released)
2020-01-11
2019-12-26 (after FA 2.4.7 was released)
2017-11-10 (before AF 2.4.6 was released)
FA 2.4.8 was released on 2020-02-05
FA 2.4.7 was released on 2019-06-25
FA 2.4.6 was released on 2018-12-18
682 07/10/2020 02:45:35 pm
Re: Role Permission For search Items Popup (3 replies, posted in Items and Inventory)
@joe: is this desirable for certain restricted tables or can it be taken into the core? Will possibly need to change the permissions in the chart sqls as well.
683 07/10/2020 02:43:48 pm
Re: Mailing doesn't work if the header contains "&" (9 replies, posted in Report Bugs here)
Make sure you have a valid domain in your /etc/hosts (Windows: C:\Windows\System32\drivers\etc\hosts) for 127.0.0.1 along with localhost (space separated or on a new line with the said IP)
Then the valid domain in your php.ini and the changes to your php script should work fine provided your DNS SPF entry is okay for the IP you will be dishing out.
684 07/10/2020 02:32:38 pm
Re: PHP 7.4 bug (20 replies, posted in Report Bugs here)
@itronics commit should fix it.
685 07/04/2020 10:03:14 am
Re: Inventory Valuation Report showing 0 (zero) on Unit Cost (16 replies, posted in Items and Inventory)
Although the specific rep301.php has not changed in the meanwhile, some functions it directly / indirectly uses may have been changed post release in other files. No harm in putting in the post release changed files - it does not change the db in any manner and any missing sys_prefs variables entries will get auto populated. Then see if the situation changes.
686 07/04/2020 05:20:24 am
Re: PHP 7.4 bug (20 replies, posted in Report Bugs here)
Please try the attached fix on both PHP 7.4 and PHP5.x as well.
@joe: please verify and take in the fix into the core ensuring backwards compatibility.
687 07/04/2020 05:03:58 am
Re: PHP 7.4 bug (20 replies, posted in Report Bugs here)
An example of curly brace correction is available in another project's commit.
A migration script to automatically make these changes is here.
This is an issue since 2008 when both square and curly brackets were used interchangeably for arrays and string elements though it was the intention to sue them for separate purposes as explained at:
https://wiki.php.net/rfc/deprecate_curly_braces_array_access
Though currently in PHP 7.4, only the square braces can be used to initialise arrays and also assign to them values, the curly braces can generally be used everywhere else where the square bracket is used.
Other threads elsewhere that refer to this problem are at:
https://github.com/squizlabs/PHP_CodeSniffer/issues/2558
https://stackoverflow.com/questions/59158548/array-and-string-offset-access-syntax-with-curly-braces-is-deprecated
688 07/04/2020 04:49:17 am
Re: Salesman / Artisan Commission Report (3 replies, posted in Reporting)
Try tags for the specific Artisan instead of treating them as salespersons so as not to confuse with counter salesmen. The Artisans could be a profit centre, maybe even a Dimension instead too.
@joe: any SOP for this in FA?
689 06/30/2020 06:57:03 pm
Re: Inventory Valuation Report showing 0 (zero) on Unit Cost (16 replies, posted in Items and Inventory)
Check if this was a server time zone issue at the time when you tried it. This is a very old thread. Hope you have all the post release fixes in your install. Also a latest change was reverted to await v2.5 but is in mt FA24Mods folder (2019-06-24).
690 06/29/2020 06:58:57 am
Topic: FA on Later MySQL versions (0 replies, posted in Installation)
If you install FA on a platform running MySQL >= 5.7, chances are that the defaults will conflict with FA and cause errors.
Here are some useful links to sort these issues out:
https://www.tutorialspoint.com/how-to-disable-only-full-group-by-in-mysql
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
https://riptutorial.com/mysql/topic/8245/error-1055--only-full-group-by--something--is-not-in-group-by-clause----
You can also download a free MySQL book (2 MB) too.
691 06/29/2020 06:49:34 am
Re: Retained Earnings and Profit/Loss Year issue (23 replies, posted in Setup)
@x-roast: Kindly share your workaround for peer review to ensure that you are on the right track.
692 06/26/2020 01:51:00 am
Re: I have a problem with late customer invoices (4 replies, posted in Accounts Payable)
I do not understand what you mean by "entered an arrested client with all the debts". Kindly contact your country users with sufficient experience (if classified by number of posts) like:
@almohasb
@abozeed
@AsimACC
@JavaMan
@Mahmoud Ali
693 06/26/2020 01:39:28 am
Re: Change Customer On Edit Customer Payment (3 replies, posted in Accounts Receivable)
@joe: An alert in both instances before acceptance stating the possible ambiguity may be in order.
694 06/25/2020 06:07:39 am
Re: I have a problem with late customer invoices (4 replies, posted in Accounts Payable)
How did you "collect all dues"? A Journal entry or by debit note? Only latter is allocatable to the due invoices.
695 06/25/2020 06:03:39 am
Re: New installation but i can't create new customers (2 replies, posted in Accounts Receivable)
Which version of MySQL / PHP are you using? Later versions of MySQL may prevent blank value for salesman not to be taken as NULL and may wrongly insist in a NOT NULL field definition (with a default of 0) and strict mode enabled in the MySQL settings. See that there is atleast one entry in the "0_salesman" table and make sure that is chosen for the new company's default salesman.
CREATE TABLE `0_cust_branch` (
...
...
`salesman` int(11) NOT NULL DEFAULT '0',
...
...
696 06/25/2020 05:55:00 am
Re: What does Table Pref refer to in Company Setup? (4 replies, posted in Installation)
The counter value is in the file config_db.php where the variable $tb_pref_counter should refer to the next available array element.
The command to set the auto increment field correctly (self-adjusting) at the end would be:
ALTER TABLE <table_name> AUTO_INCREMENT = 1;
but in FA, there is no "Company" table.
697 06/25/2020 05:51:23 am
Re: Cannot create new company due to bugs in sql file (5 replies, posted in Setup)
Creation of the DB would require additional privileges that the FA's DB user should have atleast for the duration of the install. Use phpMyAdmin / SQLyog / MySQL Workbench or some such MySQL client tool or just operate from the hosting control panel or the SSH terminal if you have access. Otherwise contact your hosting provider.
What platform are you having your FA hosted (Webserver / PHP / MySQL / OS) and their versions and what privileges and skills you have in manipulating them? If you are handicapped in the above skills, then take professional assistance providing a bounty on the Job Offers board.
698 06/25/2020 05:46:52 am
Re: Trial Balance drilldown (11 replies, posted in Banking and General Ledger)
Thanks @cedricktshiyoyo for the use case and @joe for the quick update.
Updated Post Release Fixes.
699 06/21/2020 02:41:01 am
Re: Trial Balance drilldown (11 replies, posted in Banking and General Ledger)
Check if the attachment is what you need.
@joe: if acceptable, it can be placed with a checkbox in the filter fields to achieve this feature.
700 06/20/2020 08:16:41 am
Re: Reports For Class: General Ledger -> Trial Balance (2 replies, posted in Banking and General Ledger)
Try making the "Only Balances" option to "Yes".