Search options (Page 42 of 246)

Keep changing the next invoice number manually in Setup => Transaction References and then let it auto-populate this manually provided value in the invoice you enter. The responsibility of maintaining non duplicate Invoice Number will then vest with you as the system will simply reject duplicates only after entering the invoice.

Since this does not affect the DB schema, can we not make a start here?

@joe committed it.

Done.
Also referred in this post.

Putting it in a variable and then using it everywhere will make sense.
@joe?

FA currently just has "Ship Via" specific Shipper info and no shipping rates based on volume/weight/distance on a per shipper basis. Maybe this might be a good inclusion into FA 2.5.

We cannot add apples and oranges.

Abbreviations.com has some nice elaborations (just in jest only):
ORACLE: One Rich A** Called Larry Ellison
SAP: Slow and Painful
MICROSOFT: My Incredible Computer Runs Oddly So Oust Forged Trash

Using above may be like using a hammer to swat a fly/ant in most cases. That's where FA scores - with KISS technologies and gratis indeed. Some things are better than what money can buy and FA seeks to be the numero uno here.

Check if your input data had any extraneous characters that caused a mess up in escaping (or double escaping?). The escape was to prevent SQL injection.

The attachment in my previous post can be safely used to overwrite the modules files as the official module has not been really updated in a while (just version bumps).

Lines 43 to 49 of import_items.php:

function get_supplier_id($supplier) {
    $sql = "SELECT supplier_id FROM ".TB_PREF."suppliers where supp_name = ".db_escape($supplier);
    $result = db_query($sql, "Can not look up supplier");
    $row = db_fetch_row($result);
    if (!$row[0]) return 0;
    return $row[0];
}

If an existing supplier name is available in the target table, then it will return the supplier_id, otherwise it returns a 0. Make sure that the Supplier Name is exactly the same as the one in FA when an import occurs.