Yes, when you check in inventory movement report file rep307
The same function called 4 times. its better call it once and use the decimal position same to 4 columns.
Here the commit change
776 08/12/2018 09:54:55 am
Topic: Inventory Movement Report unnecessary queries (4 replies, posted in Reporting)
777 08/12/2018 09:31:38 am
Re: Does SQL_Trail accurately show errors? (18 replies, posted in Setup)
There are two possibilities.
1. The Database user many not have Insert.Update Permissions to perform operations.
2. The Given database corrupted the columns. or it might be corrupted database like missing some tables.
Check these facts and if you still face the same issue comment it back.
778 08/12/2018 09:24:22 am
Re: Search Item List (10 replies, posted in Report Bugs here)
I think you enabled "Search Item List" . So goto "Setup->Company Setup -> Search Item List" Uncheck the checkbox and try it. If you still face issues. You can comment again
779 08/12/2018 09:21:34 am
Re: Item Editable Description Issue (10 replies, posted in Items and Inventory)
I have tested it. You can include to core.
780 08/12/2018 01:55:09 am
Re: Item Editable Description Issue (10 replies, posted in Items and Inventory)
I think it can be included to core. But let's see Joe's answer.
781 08/12/2018 01:53:25 am
Re: Suppliers Payment is not editable. Any solution? (11 replies, posted in Accounts Payable)
@boxygen, you are right.
The customer payments can be edited after the customers payment. But the supplier payments we don't have an edit option after supplier payment from the suppliers transaction inquiry.
782 08/12/2018 01:43:40 am
Re: Search Item List (10 replies, posted in Report Bugs here)
@rafat, it looks like bug. But one question. Did you enable the editable description for the item from the inventory module.?
783 08/05/2018 04:24:48 am
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
boxygen wrote:
@kvvaradha, you are right. Thanks alot
I got the problem. One of my customization was basically causing the issue. I must have checked that without customized code.
Regards.
Glad to hear that you found actual reason for the issue. Can you share the details of it?
and it might helpful to someone else knocks with similar issue in future.
784 08/05/2018 04:23:26 am
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
poncho1234 wrote:
@kvvaradha whats a lac? Do you mean 100,000?
Yes its 1,00,000 records.
785 08/04/2018 05:53:47 pm
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
@boxygen, This is not optimal solution. The actual problem is different. 300 records is not big thing. more than 1 lac records queried and display the results even in shared hosting without changing FA timeout. There is some other issue causing this issue. May be inefficient query is there to consume more RAM to get it expire the time limit.
786 08/04/2018 06:29:25 am
Re: Item Editable Description Issue (10 replies, posted in Items and Inventory)
Finally Found solution for it. Here is the commit .
787 08/03/2018 12:47:55 pm
Re: Ajax Time Out in GL Inquiry (11 replies, posted in Banking and General Ledger)
300 records does not a problem to query and get in FA time. it ends with bugs from the query results or the server may experience load problem. try take a backup of your database and check it on load free server like localhost or separate vps.
Try enable debuging mode to get errors on FA error.log
788 07/28/2018 07:01:44 am
Re: Batch Processing Modifications for FA (14 replies, posted in Setup)
This is nice to read. I am actually trying to bring-out with the Batch feature, with that we can allow to use other costing methods as well. Let's get opinion from other users as well.
789 07/28/2018 06:44:29 am
Re: Incorrect display of sales_price (1 replies, posted in Setup)
it looks like the decimal format issue.
But in core there is no such a problem, I tested your input, it comes like 1,495.00. and if i remove decimals it becomes 1,495
790 07/21/2018 08:07:30 am
Re: Items, supplier and Customer vanished (3 replies, posted in Banking and General Ledger)
Goto browser and login to your FA and then goto Setup->Company Setup
There you can see the options like this.
Search Item List, Search Customer List, Search Supplier List
If these are all checked, the drop down wont show the customers, suppliers, and items. Uncheck them all and logout and login again.
791 07/19/2018 06:30:41 am
Re: Transaction References : The value is not incremented (10 replies, posted in Setup)
@haris.cowlas - we done the job .
792 07/13/2018 12:53:15 pm
Re: Recovery of old installation (5 replies, posted in Installation)
@apmuthu , I think he wants access files(May be he has some attachments). So he has to bring the config_db.php and also the company directory to retrieve files and database access to.
793 07/13/2018 12:49:48 pm
Re: Editable Item Description's Input is TextBox. How to Enable TextArea (13 replies, posted in FA Modifications)
@boxygen , I gave it as simple and stand to replace the textbox with textarea. But it requires to save the multi lines as like it inputted. For that, we need to change some more to take effect. Also it may possible to add a option to change it either textbox or textarea
794 07/13/2018 02:06:18 am
Re: Editable Item Description's Input is TextBox. How to Enable TextArea (13 replies, posted in FA Modifications)
Open ui_list.inc and goto line number 259 around and find the below code.
."<input type='text' $disabled name='{$name}_text' id='{$name}_text' size='".
$opts['editable']."' maxlength='".$opts['max']."' $rel value='$edit'>\n";and replace with below one.
."<textarea $disabled name='{$name}_text' id='{$name}_text' cols='35' rows='5" .($name ? " title='$name'" : '') .">$edit</textarea>\n";this is code helps you to change it multi-line input(TextArea). But it wont save them like multi lines. There are few other files needs to be edited to allow it to process multi line inputs
795 07/13/2018 01:45:58 am
Re: a big help (4 replies, posted in Setup)
The dashboard module is not updated for last 3 years and current version 2.4 is newer one. There are many core changes from 2.3 to 2.4 So its not working with 2.4 as of your tried version.
I would suggest you to get separate queries and functions separately. update core FA 2.4 dashboard programs.
796 07/12/2018 04:29:44 am
Re: Stock goes negative even, the negative inventory is turned off (5 replies, posted in Report Bugs here)
That's perfect.
797 07/11/2018 02:06:43 pm
Re: Stock goes negative even, the negative inventory is turned off (5 replies, posted in Report Bugs here)
@joe can you check this issue and fix it.
798 07/11/2018 08:26:42 am
Re: Adding Column Value in Drop Down (3 replies, posted in FA Modifications)
You can use query concatenation to achieve this.
CONCAT_WS(' ', i.description, s.long_description) as full_description Use the full_description within the combo_input
799 07/11/2018 03:34:54 am
Re: Fiscal year delete leads to undefined variable $total (4 replies, posted in Report Bugs here)
I am not sure. But this may be their idea to get $total here.
800 07/11/2018 03:26:23 am
Re: Install trouble on shared hosting using Microsoft IIS and Plesk (14 replies, posted in Installation)
@ROBERTRACKL - Do this steps and tell us clearly.
1. Enable Debugging mode for FA,if you installed it already, otherwise leave this step.
2. Check the root of FA if it has config.php or config_db.php , if the file is there. rename the files and try again.
3. If you didnt install the FA do this step. Open the index.php and add the below code and get us the errors what you see
error_reporting( E_CORE_ERROR | E_CORE_WARNING | E_COMPILE_ERROR | E_ERROR | E_WARNING | E_PARSE | E_USER_ERROR | E_USER_WARNING | E_RECOVERABLE_ERROR );
ini_set('display_errors', 1);4. And also echo the path what you are trying to access. I feel that the path we call the install.php is not including the right path.
May be this helps to resolve your problem