3,626 Reply by apmuthu

(4 replies, posted in Accounts Receivable)

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.

Go to forum: Accounts Receivable

3,627 Reply by apmuthu

(3 replies, posted in Items and Inventory)

In FA 2.3 it currently shows up only in Sales Entry Forms - Order, Quotation, Invoice, Delivery.

@joe: Is this the intended design?

Go to forum: Items and Inventory

3,628 Reply by apmuthu

(1 replies, posted in Items and Inventory)

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

Go to forum: Items and Inventory

3,629 Reply by apmuthu

(48 replies, posted in Setup)

Today's commits have replaced aqua and cool standard themes with canvas and dropdown themes.

Dashboards can now be used in all themes with these new commits.

When we logout, the user session is completely destroyed and if the "login again" link is clicked, the previous session's username is not pre-populated in it's form field.

A small bugfixis necessary for thecanvastheme to show the graphic links and standscommitted in my unofficial repo. This has now been committed in the official repo.

The de_DE and pt_PT install lang files have yet to be corrected in the official repo. It stands committed in my unofficial repo.

Go to forum: Setup

3,630 Reply by apmuthu

(14 replies, posted in Setup)

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?

Go to forum: Setup

3,631 Reply by apmuthu

(8 replies, posted in FA Modifications)

10 items that match the filter is displayed. cool-autosuggest would be nice.

Go to forum: FA Modifications

3,632 Reply by apmuthu

(8 replies, posted in FA Modifications)

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

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

Go to forum: FA Modifications

3,633 Reply by apmuthu

(8 replies, posted in FA Modifications)

I do hope they do not clash with the new popup search functionality in FA 2.4 and the existing one in FA 2.3.

Whenever you make changes to the core files, make sure you make all your white space changes first and then do a commit before the actual commit with your code changes. This will make it easier to follow the real changes.

Attached is an example of your latest BOM Session change.

When we login, a new session is created but when we access the init() function during FA usage thereafter, we need to make sure that we have a new BOM session but not when editing one. Hence it may need review.

Go to forum: FA Modifications

3,634 Reply by apmuthu

(48 replies, posted in Setup)

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.

Go to forum: Setup

3,635 Reply by apmuthu

(2 replies, posted in Banking and General Ledger)

In FA, just change the Account Name / description.

Go to forum: Banking and General Ledger

3,636 Reply by apmuthu

(9 replies, posted in Accounts Payable)

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

Go to forum: Accounts Payable

3,637 Reply by apmuthu

(3 replies, posted in Modules Add-on's)

It is possible that php is not enabled for your server or FA folder or there are folder / file permission issues.

Go to forum: Modules Add-on's

3,638 Reply by apmuthu

(48 replies, posted in Setup)

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.

Go to forum: Setup

3,639 Reply by apmuthu

(14 replies, posted in Reporting)

Did you try to restore a backup that already exists on the FA server or attempted to upload one thru' the FA web interface? It could be a Apache limit - check the httpd.conf files.

Go to forum: Reporting

3,640 Reply by apmuthu

(9 replies, posted in Accounts Payable)

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.

Go to forum: Accounts Payable

3,641 Reply by apmuthu

(9 replies, posted in Accounts Payable)

That would be manual. Make the Supplier Invoice in FA, print it out and then email it.
You can look at how the Customer invoices are mailed out and hack the code into purchase invoices for auto mailing.

Go to forum: Accounts Payable

3,642 Reply by apmuthu

(5 replies, posted in Announcements)

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?

Go to forum: Announcements

3,643 Reply by apmuthu

(14 replies, posted in Reporting)

Increase the script max execution timeout as well in the php.ini apart from the max POST size and max upload size values and restart the webserver.

Go to forum: Reporting

3,644 Reply by apmuthu

(9 replies, posted in Accounts Payable)

FA provides for entering Suppliers Invoices - assume the Supplier has billed you and make an appropriate Supplier Invoice Entry.

Go to forum: Accounts Payable

3,645 Reply by apmuthu

(8 replies, posted in Accounts Payable)

Thanks @joe.

FA 2.3 commit
FA 2.4 commit

Go to forum: Accounts Payable

3,646 Reply by apmuthu

(1 replies, posted in Report Bugs here)

This is a feature option.

In FA 2.3, check the config.php for the lines 161-172 (FA 2.4 - lines 115-126):

    /* Accounts Payable */
    /* System check to see if quantity charged on purchase invoices exceeds the quantity received.
       If this parameter is checked the proportion by which the purchase invoice is an overcharge
       referred to before reporting an error */

    $check_qty_charged_vs_del_qty = true;

    /* System check to see if price charged on purchase invoices exceeds the purchase order price.
       If this parameter is checked the proportion by which the purchase invoice is an overcharge
       referred to before reporting an error */

    $check_price_charged_vs_order_price = True;

Go to forum: Report Bugs here

3,647 Reply by apmuthu

(48 replies, posted in Setup)

The ERD Anomalies in the previous post have been addressed in today's commits along with the typo fix in en_US.new.sql in the 44th post.

The FA version number will be updated during release of FA v2.4rc1 as also the *.mo files in the install/lang language folders along with all translations in the core.

Company level configurable sys_prefs (company.setup) options to be able to hide the Fixed Assets and Manufacturing applications are now available in today's commit - use_manufacturing and use_fixed_assets.

Two new config file options have been introduced - $use_popup_search and $max_rows_in_search - enabling popup search in Customers, branches, suppliers, inventory, fixed assets and GL Accounts.

Some 14px icons have been replaced by 16px icons but the css is retained to display them as 14px icons.

A small fix to the upgrade scriptis in my repo. Committed in the official core now.

stock_fa_class table field widths and form field widths for Fixed Assets Classes form is attached for review and correction.

Go to forum: Setup

3,648 Reply by apmuthu

(1 replies, posted in Reporting)

Set the config variable:

$hide_inaccessible_menu_items = 1;

Go to forum: Reporting

3,649 Reply by apmuthu

(8 replies, posted in Accounts Payable)

This is possibly done to increase the precision for computing to avoid rounding errors / deltas where unit amounts are computed from large quantities based bulk pricing.

Go to forum: Accounts Payable

3,650 Reply by apmuthu

(5 replies, posted in Setup)

The ERD is available in the Wiki.

The method I outlined above is to make sure the "scripting" is right before making it into a php script - form to acquire the csv, validate it, process it.

Go to forum: Setup