Search options (Page 173 of 246)

At the moment, just increase the number of decimal places in the Setup => Display Setup and round off the field in the report to 2 decimal places.

FA v2.4 has been in the making for quite a few years now....a few more months to wait is okay perhaps....

@dls: I think @elax did mention some limitations, possibly for Supplier Invoices.

@elax: please have a look.

@dls: Please note that there are real changes only in these 3 FA 2.3.22+ changed files:
config.default.php
includes/ui/items_cart.inc
gl/includes/gl_bank.php
when compared to elax patch files for 2.3.19.

Your archive contains a file
   gl_db_bank_trans.inc
but not the file
   gl/includes/db/gl_db_trans.inc.

Customer Credit Limits are enforced when invoicing them and will decrement as amount of unpaid customer bills add up. Supplier Credit Limits are only indicators for us and are not enforced.

Upload it anywhere and paste the url here.

My previous solutions do not work because the $all_tables is an array of arrays.

Lines 505 to 513 in admin/db/maintenance_db.inc:

    // get auto_increment values and names of all tables
    $res = db_query("show table status");
    $all_tables = array();
    while($row = db_fetch($res))
    {
        if (($conn["tbpref"] == "" && !preg_match('/[0-9]+_/', $row['Name'])) ||
            ($conn["tbpref"] != "" && strpos($row['Name'], $conn["tbpref"]) === 0))
            $all_tables[] = $row;
    }

is now replaced with:

    // get auto_increment values and names of all tables
    $res = db_query("show table status");
    $all_tables = array();
    $skip_tables_list = Array('users', 'security_roles', 'sql_trail');
    for ($i = 0; $i < count($skip_tables_list); $i++) {
        $skip_tables_list[$i] = $conn["tbpref"].$skip_tables_list[$i];
    }
    while($row = db_fetch($res))
    {
        if (($conn["tbpref"] == "" && !preg_match('/[0-9]+_/', $row['Name'])) ||
            ($conn["tbpref"] != "" && strpos($row['Name'], $conn["tbpref"]) === 0))
            if (!(in_array($row['Name'], $skip_tables_list, true)))
                $all_tables[] = $row;
    }

The variable $skip_tables_list is populated with the names of tables to be skipped (without table prefixes).

The tables missing tables in the backup remain untouched in the database when restored.

The wiki has been updated and the code has been tested.

Use a program like WinMerge on Windows and compare the sql/en_US-new.sql and sql/ar_EG-8digits.sql for differences in schema first.

Also verify that you are using the latest snapshot of FA v2.3.22+.

The said sql/ar_EG-8digits.sql Chart of Accounts has now been updated to synch with the sql/en_US-new.sql in my GitHub Repo. It now has the CREATE TABLE IF NOT EXISTS and DROP TABLE constructs in them. Overwrite your sql/ar_EG-8digits.sql file with the one from my GitHub Repo.

@joe: all FA v2.3.x CoAs should have the same schema in the official pkg repo - otherwise, the "official" and "signed" will have lost "trust".

The Standard en_US-demo.sql running on FA 2.3.22+ on windows localhost provides the attached outputs. Whilst the Balance Sheet report (rep706.php) is displayed with no zeroes, the Trial Balance report (rep708.php) has a filter for with and without zeroes.

Check your Egypt CoA with the standard en_US-demo.sql file for any differences.

A bunch of changes have been pushed from the dev's repos to the FA 2.4 Unstable Hg repo a few days ago.

The reports display error on Windows listed in the 22nd post (has fix there as well) in this thread still exists. The devs have been informed.

The current snapshot of FA v2.4 does not install out of the box for the demo CoA since in the sql/en_US-demo.sql there is an Error in field type change in it's line 836:

`type_no` `type_no` int(11) NOT NULL default '0',

which should be:

`type_no` int(11) NOT NULL default '0',

The Devs have been informed.

Here is a short list of changes in the Unstable FA 2.4 codebase since my last reporting post:

• Changes in db schema gl_trans.type_no optimized to int, changed lock_stock.reorder_level type to double.

• Added dimension edition on purchase invoice entry.

Files affected

purchasing/includes/ui/invoice_ui.inc
purchasing/includes/ui/po_ui.inc
purchasing/includes/db/invoice_db.inc
purchasing/includes/db/invoice_items_db.inc
purchasing/includes/supp_trans_class.inc
purchasing/includes/po_class.inc
purchasing/includes/purchasing_db.inc

sql/en_US-new.sql

Field Type changes:
0_gl_trans.type_no bigint(16) default 1 => int(11) default 0
0_loc_stock.reorder_level bigint(20) => int(11)

Appended 2 new fields to 0_supp_invoice_items:
  `dimension_id` int(11) NOT NULL DEFAULT '0',
  `dimension2_id` int(11) NOT NULL DEFAULT '0',

sql/en_US-demo.sql

Same as above.
Demo data INSERT statements extended with 0 values for the 2 new fields in 0_supp_invoice_items

sql/alter2.4.sql: UPDATE and ALTER statements for the above changes

reporting/includes/class.mail.inc: Cleanup and preparing for XLS extension
gl/manage/bank_accounts.php: Better Error Message when trying to use GL Accounts with transactions
reporting/includes/reporting.inc: Wrong no. of parameters for Invoice (rep107)
includes/ui/ui_controls.inc: $timeout parameter added to function meta_forward()
includes/db/inventory_db.inc: Removed unused function update_stock_move_pid()
purchasing/includes/db/invoice_db.inc: Removed commented out function update_stock_move_pid() usage

Fixed initialization of company specific settings in SysPrefs:

includes/prefs/sysprefs.inc: New function refresh_company_prefs() added
(Devs: spelling mistakes in a few places for the word 'preferences')
$_SESSION['SysPrefs']->db_ok becomes $SysPrefs->db_ok in

• includes/session.inc

• sales/sales_order_entry.php

• admin/db/company_db.inc

Added mysql query retry after database deadlock detection.

includes/db/connect_db.inc: New constant MAX_DEADLOCK_RETRY defined
The 2 db driver files use it:
includes/db/connect_db_mysqli.inc
includes/db/connect_db_mysql.inc

Small cleanup to branch name length in input form and printouts.

Affected files - can be backported:

• reporting/includes/header2.inc

• sales/manage/customer_branches.php

• sales/includes/ui/sales_order_ui.inc

Attachments were not moved to new transaction after edition for some document types.

admin/db/attachments_db.inc: New function move_trans_attachments() added
Used in:

• gl/includes/db/gl_db_banking.inc

• sales/includes/db/sales_invoice_db.inc

• sales/includes/db/sales_delivery_db.inc

• purchasing/includes/db/invoice_db.inc

includes/access_levels.inc: Additional access control related ui helpers added - check_edit_access, access_post, access_num

Most modern browsers have their key bindings changeable. FireFox 31.4.0esr on WinXP SP3  did not need any changes for F4 to work as desired in FA.

Anyway, thanks. Your valuable inputs have been used to create a new Wiki page to address it.

Lines 555 to 582 in includes/ui/ui_controls.inc:

/*
    Redirector for selector F4 calls.
    $sel_editors is array of selname=>editor_page
*/
function editor_redirect($sel_editors, $save_fun='') {
    foreach ($sel_editors as $selname=>$editor)
        if (isset($_POST['_'.$selname.'_editor'])) {
            if (function_exists($save_fun))
                $save_fun();
            unset($_POST['_'.$selname.'_editor']);
            context_call($editor, array_keys($_POST));
        }
}
/*
    Return procedure for selector F4 calls
*/
function editor_return($vars, $restore_fun='') {
    if (function_exists($restore_fun))
        $restore_fun();

    if ($ret = context_restore()) {
        foreach ($vars as $postname=>$retname)
            if (isset($ret[$retname])) {
                $_POST[$postname] = $ret[$retname];
                set_focus($postname);
            }
    }
}

Lines 445 to 479 in the same file defines the hotkeys (key 115 => F4 for Items):

/* Table editor interfaces. Key is editor type
    0 => url of editor page
    1 => hotkey code
    2 => context help
*/
$popup_editors = array(
    'customer' => array('/sales/manage/customers.php?debtor_no=', 
        113,    _("Customers"), 900, 500),
    'branch' => array('/sales/manage/customer_branches.php?SelectedBranch=', 
        114, _("Branches"), 900, 700),
    'supplier' => array('/purchasing/manage/suppliers.php?supplier_id=', 
        113, _("Suppliers"), 900, 700),
    'item' => array('/inventory/manage/items.php?stock_id=', 
        115, _("Items"), 800, 600)
);
/*
    Bind editors for various selectors.
    $type - type of editor
    $input - name of related input field
    $caller - optional function key code (available values F1-F12: 112-123,
        true: default)
*/
function set_editor($type, $input, $caller=true)
{
    global $path_to_root, $Editors, $popup_editors, $Pagehelp;

    $key = $caller===true ? $popup_editors[$type][1] : $caller;

    $Editors[$key] = array( $path_to_root . $popup_editors[$type][0], $input, 
        $popup_editors[$type][3], $popup_editors[$type][4]);
    
    $help = 'F' . ($key - 111) . ' - ';
    $help .= $popup_editors[$type][2];
    $Pagehelp[] = $help;
}

The file includes/ui_ui_lists.inc has several references to set_editor() function that defines the popup.
Lines 740 to 749 in it are:

function stock_items_list($name, $selected_id=null, $all_option=false, 
    $submit_on_change=false, $opts=array(), $editkey = false)
{
    global $all_items;

    $sql = "SELECT stock_id, s.description, c.description, s.inactive, s.editable
            FROM ".TB_PREF."stock_master s,".TB_PREF."stock_category c WHERE s.category_id=c.category_id";

    if ($editkey)
        set_editor('item', $name, $editkey);

...
...