Not dashboard theme. It's dashboard module is still active
752 09/03/2018 02:04:35 pm
Re: Inventory Item Cost Update (3 replies, posted in Items and Inventory)
`update_average_material_cost` function helps to update the material cost on every purchase or credit the goods. So its ultimately Average cost update is the functionality.
when you write
return $price;
the return value of this function used when crediting the goods. the purchase order standard cost will get an effect.
but within the update_average_material_cost, it updates the material cost on stock_master.
If the material cost is zero, while making the inventory valuvation report,and its inventory value calculation related functionalities all result you zero value there,
753 09/03/2018 01:32:53 am
Re: Blank page after login (5 replies, posted in Installation)
The dashboard extension is no need to install. Within 2.4.4 itself. It has the core feature. If you rename the dashboard module folder it will work.or simply remove from there it will work.
754 08/30/2018 11:59:05 am
Re: 2.4.4 no Longer Displays 0.00 Sales Invoices in customer_inquiry.php (10 replies, posted in Report Bugs here)
@joe commit this to github as well.
755 08/29/2018 10:51:01 am
Topic: Is it possible to add custom cases into "BoxReports->get_ctrl()" ? (1 replies, posted in Reporting)
This question is technical doubt. So looking experts advice.
I am making an extension,which actually needs to show a drop down on reports page, which actually get the drop down details from a custom table.
So I need to use custom element into reporting/includes/reports_classes.inc file especially under the get_ctrl function to define the Case in Switch.
756 08/29/2018 10:33:42 am
Re: Update material cost when quantity on hand is zero (4 replies, posted in Report Bugs here)
@joe, did you check this post.
I think its good to adapt the calculation,
757 08/29/2018 10:31:02 am
Re: User permission for each company/database (5 replies, posted in Setup)
Sofar, the Login system is different for each company. You can create similar login credentials for both company and access it. But if you want to switch to other company, you need to logout and login again by selecting the second company from the login screen.
758 08/21/2018 03:53:41 am
Re: Interest advice/invoice (3 replies, posted in Accounts Receivable)
Reminder kind of functionality is available with the transaction inquiry itself. You can see the overdue invoices in highlighted color. If you wish to bring it out, you can separately create a page for it or go with extension like @apmuthu told. https://github.com/rossaddison
759 08/20/2018 05:06:03 am
Re: Inventory Movements (1 replies, posted in Items and Inventory)
You can have the features of Purchase, cost, Material cost, Labour cost and Overhead cost. So far we have not included the Landed cost functionality in it, but you can do it with help of journal entries. You can make Quick Entries for the Shipping, and Import Duties, which can be used on the supplier invoices page.
I hope you can do some more research about the landed cost on FA.
Here is a reference for Landed cost development
760 08/20/2018 04:27:42 am
Re: Editable Item Description's Input is TextBox. How to Enable TextArea (13 replies, posted in FA Modifications)
@boxygen - The commit code was adjusted by myself. it was discussed here. I hope you understand, when you check this thread.
761 08/18/2018 04:34:23 pm
Topic: Sales Order Entry has reporting.inc (1 replies, posted in FA Modifications)
I don't think the below line needed to include it on sales_order_entry.php
include_once($path_to_root . "/reporting/includes/reporting.inc");
762 08/18/2018 12:11:03 pm
Re: Closing a fiscal year needs to update the query a bit. (9 replies, posted in FA Modifications)
But isn't the voided entries all set to 0 amounts? So in my eyes this is a redundant change, right?
Joe
I guess you are right. But one of a FA user asked to check it,when he closes the fiscal year. he had some voided balance included in the balance. His version is 2.4.3.
763 08/17/2018 02:28:22 am
Re: Closing a fiscal year needs to update the query a bit. (9 replies, posted in FA Modifications)
Which file is this in?
Fiscal years db file. The fiscal year close function
764 08/16/2018 12:41:04 pm
Topic: A function line misplaced (3 replies, posted in Report Bugs here)
From this commit
The function was misplaced. It was like this now.
https://github.com/kvcodes/FA/commit/42751ff1e05ac803548a07d412f4a173cd0e0450
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else
if (list_updated('stock_id')) {
sales_items_list_cells(null,'stock_id', null, false, true, true);
And it should be like this.
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else
sales_items_list_cells(null,'stock_id', null, false, true, true);
if (list_updated('stock_id')) {
765 08/16/2018 09:53:55 am
Topic: Closing a fiscal year needs to update the query a bit. (9 replies, posted in FA Modifications)
The fiscal year close needs to change the query to get the amount.
It was now like this.
// retrieve total balances from balance sheet accounts
$sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans INNER JOIN ".TB_PREF."chart_master ON account=account_code
INNER JOIN ".TB_PREF."chart_types ON account_type=id INNER JOIN ".TB_PREF."chart_class ON class_id=cid
WHERE ctype>=".CL_ASSETS." AND ctype <=".CL_EQUITY." AND tran_date <= '$to'";
And it should be like this
// retrieve total balances from balance sheet accounts
$sql = "SELECT SUM(amount) FROM ".TB_PREF."gl_trans trans LEFT JOIN ".TB_PREF."voided v ON trans.type_no=v.id AND v.type=trans.type INNER JOIN ".TB_PREF."chart_master ON account=account_code
INNER JOIN ".TB_PREF."chart_types types ON account_type=types.id INNER JOIN ".TB_PREF."chart_class ON class_id=cid WHERE ctype>=".CL_ASSETS." AND ctype <=".CL_EQUITY." AND tran_date <= '$to' AND ISNULL(v.date_)";
I think we missed to check voided transactions before getting results.
766 08/15/2018 08:19:22 am
Re: Reporting (7 replies, posted in Reporting)
I think he means to include the description of items inside the report.
May be you are right. but from his question, he shows the button display text and asked to modify.
767 08/15/2018 01:30:41 am
Re: Making Tax Digital VAT in UK and EEC (27 replies, posted in Setup)
Hope you have an idea to start implementing the HMRC with FA.
768 08/14/2018 03:42:00 pm
Re: Does SQL_Trail accurately show errors? (18 replies, posted in Setup)
Hope it will be fixed and incase of error reporting issue, you can check with 1and1 for more details.
769 08/14/2018 02:06:25 pm
Re: Does SQL_Trail accurately show errors? (18 replies, posted in Setup)
@JimmyC - I just checked your message and replied it. Anyway i post the answer here.
I read it. i dont think you have problem. Some php versions has conflicting problem. sometimes a certain module is prohibited to use.. Like that some functions of FA is prohibited to run there.
Example when i open the purchase invoice,, it shows the below error
There are no suppliers defined in the system.
/homepages/36/d687707890/htdocs/rrbc/includes/ui/ui_msgs.inc:14: trigger_error('There are no suppliers defined in the system.','256')
/homepages/36/d687707890/htdocs/rrbc/includes/data_checks.inc:245: display_error('There are no suppliers defined in the system.','1')
/homepages/36/d687707890/htdocs/rrbc/purchasing/po_entry_items.php:73: check_db_has_suppliers('There are no suppliers defined in the system.')
For this error, you dont need to worry, it has to show "There are no suppliers defined in the system."
trigger_error - function was failed to work in your server. may be the error reporting functions are affected badly due to their 1and1 firwall. so its connected few functions affected. display_error, check_db_has_supplier
function display_error($msg, $center=true)
{
trigger_error($msg, E_USER_ERROR);
}
function display_notification($msg, $center=true)
{
trigger_error($msg, E_USER_NOTICE);
}
function display_warning($msg, $center=true)
{
trigger_error($msg, E_USER_WARNING);
}
770 08/14/2018 09:31:41 am
Re: Does SQL_Trail accurately show errors? (18 replies, posted in Setup)
Can i get credentials to check there.?
771 08/14/2018 05:34:27 am
Re: Reporting (7 replies, posted in Reporting)
Dear AP Muthu sir ,
Where I can modify the "Display : print sales quotation page" with description of items attached. ??
_akshaya
If you are looking to change the button name Display : Print Sales Quotation.
The Display is programmed to create automatically here. And the Print Sales Quotation Comes from the reporting/reports_main.php i am not sure about line number .138 . Anyhow the code will be like this.
$reports->addReport(RC_CUSTOMER, 111, _('&Print Sales Quotations'),
array( _('From') => 'QUOTATIONS',
_('To') => 'QUOTATIONS',
_('Currency Filter') => 'CURRENCY',
_('Email Customers') => 'YES_NO',
_('Comments') => 'TEXTBOX',
_('Orientation') => 'ORIENTATION'));
And here you can see the text there. Just change this text to something else.
$reports->addReport(RC_CUSTOMER, 111, _('&Print Quotations'), //Edited by Varadha for your understanding
array( _('From') => 'QUOTATIONS',
_('To') => 'QUOTATIONS',
_('Currency Filter') => 'CURRENCY',
_('Email Customers') => 'YES_NO',
_('Comments') => 'TEXTBOX',
_('Orientation') => 'ORIENTATION'));
772 08/14/2018 05:24:14 am
Re: Does SQL_Trail accurately show errors? (18 replies, posted in Setup)
@kvvaradha has offered to help me diagnose the DB setup and trouble shoot what may be causing my errors and hopefully I will learn.
But, I still don't know how to change the DB, username or password in FA. Could you point me where to look?
You can do it through config_db.php
Probably. try to install some other framework or cms like wordpress. and use it there. if the server has problem you can experience the same problem there.
773 08/13/2018 05:47:38 am
Re: Inventory Movement Report unnecessary queries (4 replies, posted in Reporting)
Also some unused mysql queries in reporting/includes/reports_classes.inc
774 08/13/2018 04:19:47 am
Re: Making Tax Digital VAT in UK and EEC (27 replies, posted in Setup)
Hello @Hirum,
I am not sure, whether this post helps you or not. But the basic things of HMRC is required to submit in their provided format. Though the given link is not developer understandable API program document. its the instruction document.
Addtional:
775 08/13/2018 04:06:13 am
Re: Does SQL_Trail accurately show errors? (18 replies, posted in Setup)
@JimmyC - It looks like the server is not responding you for all ur queries. If you need me to check your server contact me, we can check in either TV or Anydesk.