Search options (Page 147 of 247)

Wouldn't you want to submit your code?

In your article, you stated:

Which github page of yours has the functions?

When you enter foreign item code, the quantity you enter for it will be the number of units of the main item that will be used for billing. The foreign item code represents a means of bulk billing (qty > 1) or alias billing name (qty = 1).

Your suggestion for grouping items dropdown box  by stock_id instead of by item_code would mean that the user must remember the stock_id for each item_code wanted which may not be feasible. The replacement of the i.description with s.description will render both descriptions the same and would make for ambiguity in selection.

The Foreign Item Code is to be able to sell a bunch (Quantity) of items as a single bulk coded item.

Have a look at includes/ui/ui_input.inc lines 768 to 775:

//JAM  Allow entered unit prices to be fractional
function unit_amount_cells($label, $name, $init=null, $params=null, $post_label=null, $dec=null)
{
    if (!isset($dec))
          $dec = user_price_dec()+2;

    amount_cells_ex($label, $name, 15, 15, $init, $params, $post_label, $dec+2);
}

Either 2 or 4 more decimal places are used when evaluating the unit amount.

If you extend the number of decimal places in the db table fields for unit price, the you can do all computations on unit_price with such more decimal places.

@joe: Is this issue addressed in FA 2.4?

Yes, the existing popup search functionality F2,F3, F4 and space.

See my previous post again for some edits and the attachment.

Today's commits have brought on FA v2.4RC1 with most FA 2.3 bugfixes ported forward to FA 2.4.
The de_DE and pt_PT install language strings need to be fixed in the core. It is available from my unofficial FA 2.4 repo.

FA 2.4.x sports a new feature while restoring a backup - the default option of keeping existing security settings.

You can use the Document Upload feature in FA and link it to the Customer Invoice.

Todays commits have removed the popup search feature for Fixed Assets since there will be only a few in most accounting scenarios. The commits are:

Removed fixed assets from list item search and popup search.
and
Rerun of last non fixed assets search.

The above can be reverted for those who want it - use cases: Asset / Equipment / Building Leasing companies and large Fixed Asset companies.

Thanks for pointing this out. FA currently has no means of printing out Supplier Invoices. Only Purchase Orders can be printed.

@joe: Print Supplier Invoices is now needed for this use case. This way we can keep track of how they have been entered in FA.

For generic CRUD type applications like phpMyAdmin, Adminer, etc, these functions are okay.

For some of the cases in FA where we predominantly have PHP based threshold WHERE conditions when a strange set of records with or without primary keys and/or structured generic JOINs needs to be selected or updated/manipulated we will end up making several atomized queries if we use the functions you suggest.

Also do not land up double db_escaping values!

However, most of the atomic changes can be accommodated using your functions and in the extreme, a SOAP API can be integrated into FA to perform such tasks generically other than for the exceptions in the light of optimization.

FluentPDO is one such PHP Library.
WordPress and Joomla have their own.
Time saving DB Functions
10 Useful PHP DB Functions | MySQLi variants

Which of your repositories has your functions.php file?