Search options (Page 89 of 246)

Actually, the Sales Invoices import was coded later and old PHP's graceful degradation based on loose type acceptance is no longer available.

Try this version now.

Wiki updated.

Setup => payment Terms => create new payment terms as Cash type but name it credit card. make an account code similar to cash and call it credit card. Make it a bank account - your merchant bank account.

It appears that the first non default cash type of account in the bank accounts gets hard coded in creating a direct invoice.

Quick Entries as in this post may be useful.

@joe: What is the correct way to make a "Cash" sale (Payment Terms) for a credit card transaction.

Tax is set to be included in your price so 5000 * 0.05 / 1.05 = 238.10 SR. Setting it to be Tax Excluded will result in 250 SR = 5000 * 0.05. This setting is in Sales => Sales Types => Tax Incl (checkbox).

Unzip into modules folder and a subfolder called rep_customer_ledger will get created. Now in your default company (generally company #0) go to Setup => Install/Update Extensions and "Install" the extension rep_customer_ledger. Then in the top dropdown box, choose Activate for target company and tick checkbox there. Logout and now login to your target company. Read the wiki.

Updated extension in last post with heading line fixed in template. I thought there was an export feature in it. The import_items extension has it though.

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?