Search options (Page 53 of 246)

Check if the DB user in FA has the necessary permissions - use the debug feature in FA and check it out or take local professional assistance.

It appears that you are using the dry run method which is used for checking. Try the actual run choice.

For those who want the Fiscal Year Ending {EE}/{EEEE} format as well, it is available in my commit.

Hope this addresses the new argument in the calls in:

gl/view/accrual_trans.php
reporting/rep702.php
reporting/rep704.php

Then we can also have the fiscal year end date as {EE} and {EEEE} as well so that we can have ###/2018-19 if we use {NNN}/{FFFF}-{EE}.

@joe: This can be included. Commit Diff.

Check from your browser if the following can be downloaded:

http://anonymous:password@repo.frontaccounting.eu/2.4/Release.sig
http://anonymous:password@repo.frontaccounting.eu/2.4/Release.gz

Although the folders in the path above are available for v2.4.1, 2.4.2, ... 2.4.6, they may contain outdated files and in the latest 2.4.6 folder path, the Languages are packed wrongly though some updated versions exist.

It is possible your local IP may be blocked by virtue of the server subscribing to some blacklist in your IP resides.

Which extension do you wish to install manually? Just extract the contents and place them in a folder (folder name listed in _init/config file) inside the modules/ folder. It should then appear in your list of extensions available for installation without the need to download from the official extensions repo. This is only for the "extensions" and not for the charts, themes or languages.

@joe: Which path is the latest that needs to be set in version.php ?

@joe: It might be worthwhile to synch the function get_gl_transactions() with that of @braathwaate. The said function is defined in gl/includes/db/gl_db_trans.inc and is used in the core in:

gl/inquiry/gl_account_inquiry.php
gl/view/accrual_trans.php
reporting/rep702.php
reporting/rep704.php

Furthermore, it is not used in any other extension as well. Besides, the effective_rate is not used anywhere at all (but used in the list of sql fields in function get_trans_tax_details in it!

In fact, the function get_trans_tax_details() from lines 478 to 493:

function get_trans_tax_details($trans_type, $trans_no)
{
    $sql = "SELECT tax_details.*,
                tax_type.name AS tax_type_name,
                tax_details.rate AS effective_rate,
                tax_type.rate AS rate
        FROM ".TB_PREF."trans_tax_details tax_details,
            ".TB_PREF."tax_types tax_type
        WHERE 
            trans_type = ".db_escape($trans_type)."
        AND trans_no = ".db_escape($trans_no)."
        AND (net_amount != 0 OR amount != 0)
        AND tax_type.id = tax_details.tax_type_id";

    return db_query($sql, "The transaction tax details could not be retrieved");
}

can now be simplified to be:

function get_trans_tax_details($trans_type, $trans_no)
{
    $sql = "SELECT tax_details.*, tax_type.name AS tax_type_name, tax_type.rate AS rate
        FROM ".TB_PREF."trans_tax_details tax_details INNER JOIN 
        ".TB_PREF."tax_types tax_type ON tax_type.id = tax_details.tax_type_id
        WHERE 
                trans_type = ".db_escape($trans_type)."
            AND trans_no = ".db_escape($trans_no)."
            AND (net_amount != 0 OR amount != 0)";

    return db_query($sql, "The transaction tax details could not be retrieved");
}

@braathwate: Your report uses your custom functions in ui_controls.inc and ui_view.inc files that have been appended to your quickreport_inquiry.php file for testing:

function scroll_down($div)
{
    global $Ajax;

    $js = "
        var objDiv = document.getElementById('" . $div . "');
        objDiv.scrollTop = objDiv.scrollHeight;
    ";
    if (in_ajax()) {
        $Ajax->addScript(true, $js);
    } else
        add_js_source($js);
}

function get_js_history($vars)
{
    $js = ' 
    function changeVar() {
        var stateObj = { foo: "bar" };
        var state = "";
';

    $first = true;
    foreach ( $vars as $var ) {
        $js .= '
        var element = document.getElementsByName("' . $var. '");
        if (element[0])';
        if ($first) {
            $first = false;
            $js .= '
            state += "?';
        } else
            $js .= '
            state += "&';
        $js .= $var .'="' . ' + element[0].value;';
    }

    $js .= '
        history.replaceState(stateObj, "page 2", location.protocol + "//" + location.host + location.pathname + state);
    }';
    return $js;
}

function set_posts($vars)
{
    foreach ( $vars as $var )
        if (isset($_GET[$var]))
            $_POST[$var] = $_GET[$var];
}

@joe: see if you want to include them into the core.

The js history and remembering past form field values will result in a cache use and erroneous Ajax output like when a specific customer is chosen first and then a Supplier is chosen without resetting them selectively.

Also, your use of the function get_gl_transactions() in the said report has 12 arguments whereas the standard one in gl/includes/db/gl_db_trans.inc has only 11. The extra argument used is

get_post('person_type')

.

Hope you have extension openssl .dll/.so enabled in your php.ini.

FA 2.3.22 should have been updated to 2.3.26 and a backup taken of the FA folder (company and installed extensions / languages and the sql dump of the db.

Place the sql file in the sql folder in FA and create a new company using it. Check if all is well first.
Compare the sql dumps of the schema between your existing install and the new sql file and synch them and their data into the new install.