751

(5 replies, posted in Installation)

Not dashboard theme. It's dashboard module is still active

752

(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

(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.

@joe commit this to github as well.

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.

@joe, did you check this post.

I think its good to adapt the calculation,

757

(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

(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

(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

@boxygen -  The commit code was adjusted by myself. it was discussed here. I hope you understand, when you check this thread.

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");
joe wrote:

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.

rafat wrote:

Which file is this in?

Fiscal years db file. The fiscal year close function

764

(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')) {                           

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

(7 replies, posted in Reporting)

apmuthu wrote:

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

(27 replies, posted in Setup)

Hope you have an idea to start implementing the HMRC with FA.

768

(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

(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

(18 replies, posted in Setup)

Can i get credentials to check there.?

771

(7 replies, posted in Reporting)

akshaya1972 wrote:

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

(18 replies, posted in Setup)

JimmyC wrote:

@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.

Also some unused mysql queries in reporting/includes/reports_classes.inc

774

(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:

HMRC Developer Documentation FOR API

775

(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.