Search options (Page 88 of 245)

You have quoted from the Wiki.
There is no YouTube video for this. You can create one and paste the link here.

Yes. The Ajax should be out of the "if" construct.
Attached is the "beautified" page.

Your import file does not have the data in the correct format - the third ($memo) and last but one ($person_id) fields are missing in your data file's records.

The function get_standard_cost() was available in FA 2.3, being defined in it's includes/db/inventory_db.inc and can be inserted somewhere in the module's file: modules/import_transactions/includes/import_sales_order_entry.inc as:

function get_standard_cost($stock_id)
{
    $sql = "SELECT (material_cost + labour_cost + overhead_cost) AS std_cost
        FROM ".TB_PREF."stock_master s WHERE stock_id=".db_escape($stock_id);
    $result = db_query($sql, "The standard cost cannot be retrieved");

    $myrow = db_fetch_row($result);

    return $myrow[0];
}

where you can replace the function name with it in the module's file.

If you wish to use the current code base, the above function has now been superseeded (on 2016-02-23 in FA 2.4 RC1) in the same file by:

function get_unit_cost($stock_id)
{
    $sql = "SELECT material_cost
        FROM ".TB_PREF."stock_master
        WHERE stock_id=".db_escape($stock_id);
    $result = db_query($sql, "The standard cost cannot be retrieved");

    $myrow = db_fetch_row($result);

    return $myrow[0];
}

The unit labour cost and unit overhead cost are also used now and hence the unit cost is sought to denote the unit material cost only.

Try the attached one that follows the latter code that leverages the currently available function.

@joe: which method is recommended?

The updated extension is attached with whitespace synch with rep101.php and all CRLF converted to LF line endings.

Added to the FA24extensions repo.

Which dropdown are you referring to and where?

This must be used with caution when there are transactions for the inactive customers / suppliers and when needed to be in future journal transactions.

FA does not support discount on line items for purchases - it is there in sales invoices and reports.
An extension is currently needed to accommodate  purchase order discounts for line items.

Purchase Invoice discounts are entered when payment is made for the whole invoice unless you choose to pay per line item when what you need gets accommodated as amounts and not as % discount.

Latest attached.

P&L is calculated at the end of the year by taking the balance of all expense and income accounts and stock differentials and then auto inserted. Only the Trial Balance and computed P&L are used during the year in a similar manner. What you want is a hierarchy of P&L accounts in the Accounts Master. You are free to change the nomenclature for the Account Classes, Account Groups and Account heads.

Since most non African FA users are not familiar with the OHADA implementation, I had to look it up and provide some links for others to evaluate and advise quickly.
Look up the FA users list and see if any are from your region willing to assist.

Alternatively, upload an excel sheet of your current OHADA accounts master and their desired classification and provide the link here to assist others to advise.

@joe: Providing a native OHADA Chart would increase the FA footprint into West and Central Africa tremendously.

What is the standard procedure to include it in the invoice? Must we edit it like here or in the repXXX file in any different way? Should it be some choice in the company setup as candidates for the sys_prefs table?

Start from a blank chart master, chart class and chart groups set of tables and manually put in whatever classification you want. You can nest the Group's Accounts as well as desired to get your OHADA CoA.

In your parlance, you mean that your "fiscal result" other than income tax is FA's native P&L account. All the others can be nested in the P&L.

From Wikipedia:

ODOO Apps supports OHADA natively and is developed on GitHub, being based on Python.
This French Article may be useful.
Will this CoA meet your needs?
OHADA Accounting Plans

See the wiki for more info.