5,576

(9 replies, posted in Banking and General Ledger)

Interest on Principal
or
Interesting (LIKES) Interest in FA?

5,577

(5 replies, posted in Reporting)

This is a browser print default setting. Probably it got reset to defaults. What browser are you using?

5,578

(0 replies, posted in Announcements)

Technical FAQ page has been placed on the Wiki. Please gather pertinent info into it without flooding it.

Thanks Janusz for the HG 3213 Fix.

Does this affect only the report or the actual invoice and legder entries as well?

What version of FA are you using. It will need the latest v2.3.15 and the HG updates till 3212 - read the Release Announcement Post.

Also try to disable the .htaccess file in the distribution and troubleshoot the Apache errors thereafter to see what can be accomodated / changed (httpd.conf) in it.

5,582

(12 replies, posted in Translations)

I see no reason why it should not work in Win7 (atleast in WinXP compatibility mode). You can still run WInXP in VMWare / VirtualBox / QEMU and run TortoiseGIT.

Refer Forum Post

After installing Dashboard Module and Theme, activate the Module for the company desired and enable the Access Roles for all users for Dashboard resource. Then browse to:

http://ip.or.domain/path.to.frontaccounting/modules/dashboard/dashboard_setup.php
and
http://ip.or.domain/path.to.frontaccounting/modules/dashboard/reminder_setup.php

and set up the reminders.

5,584

(3 replies, posted in FA Modifications)

FA uses javascripts in quite a lot of ways. If you still want to do so, then disable Javascript with:

if you want to block a third party javascript function triggered onload, you may simply add another

onload=function(){return false}

That version is quite old - do not know if any pertinent code for this issue has changed much.

Reverse Journal entry is one way.

Try to upgrade to the recent version with all patches till date.

If you wish to adjust the db manually (not recommended) then do so with care and refer similar issue in the wiki.

Use Dashboard Module and Theme

5,587

(7 replies, posted in Accounts Receivable)

Lines 127 to 138 of includes/db_pager.inc:

    //    Change sort column direction 
    //    in order asc->desc->none->asc
    //
    function sort_table($col) 
    {
        $ord = $this->columns[$col]['ord'];
        $ord = ($ord == '') ? 'asc' : (($ord == 'asc') ? 'desc' : '');
        $this->columns[$col]['ord'] = $ord;
        $this->set_page(1);
        $this->query();
        return true;
    }

This clearly shows a $ord check for empty being retained as empty becoming ASC, a check for asc being set to DESC  but if desc, no enforcement is done unless invoked by a click to be ASC. Hence Line 133:

        $ord = ($ord == '') ? 'asc' : (($ord == 'asc') ? 'desc' : '');

should possibly be explicit in all it's redundant splendour  (default being to capture any invalid declaration degrading gracefully) like:

        switch ($ord) {
            case 'asc':
                $ord = 'desc';
                break;
            case 'desc':
            case '':
                $ord = 'asc';
                break;
            default:
                $ord = 'asc';
        }

Hence a setting of 'asc' in the code would result in a default display of DESC in this case as in the earlier one as well. This code fragment does not change any logic and is unnecessary and is placed for an understanding of how activation occurs on clicking only.

If there is a check for an initial value placed in the php page we should use that value to be the default when the $ord is empty thru' clicking route - thereafter, the clicked value of $ord will be available as asc or desc.

Lines 50-62 of includes/ui/db_pager_view.php:

    foreach($pager->columns as $num_col=>$col) {
        // record status control column is displayed only when control checkbox is on
        if (isset($col['head']) && ($col['type']!='inactive' || get_post('show_inactive'))) {
            if (!isset($col['ord']))
                $headers[] = $col['head'];
            else {
                  $icon = (($col['ord'] == 'desc') ? 'sort_desc.gif' : 
                    ($col['ord'] == 'asc' ? 'sort_asc.gif' : 'sort_none.gif'));
                $headers[] = navi_button($pager->name.'_sort_'.$num_col, 
                    $col['head'], true, $icon);
            }
         }
    }

sets the sort image on the header correctly and checks used here can be used in the earlier code fragment to synch a similar behaviour.

5,588

(7 replies, posted in Accounts Receivable)

Then the following should sort by descending order by default:

_("Order #") => array('fun'=>'view_link', 'ord'=>'desc'),

Voiding should van(qu)ish the transaction, right?

5,590

(4 replies, posted in Installation)

Install the dashboard theme as well and activate the module for the company in use. Then enable the role for the user's role in the setup->access roles. Only then should the theme be used. Make sure you are using atleast the HG 3212 code as it has some new constructs to support the dashboard theme and module.

5,591

(7 replies, posted in Accounts Receivable)

Try line 268 in sales/inquiry/sales_orders_view.php :

        _("Required By") =>array('type'=>'date', 'ord'=>''),

to be:

        _("Required By") =>array('type'=>'date', 'ord'=>'desc'),

This assumes that the invoice is paid in full each time. What happens to payments on account and say two payments to fulfil one invoice?

5,593

(5 replies, posted in Report Bugs here)

Informed Janusz/Joe to decide on policy and code accordingly:

As a policy, please see that negative quantity either does not affect standard costing or make sure it does it positively!

Info for investigation:

function handle_negative_inventory($stock_id, $quantity, $standard_cost, $date_)
is defined in includes/db/inventory_db.inc

function update_average_material_cost($supplier, $stock_id, $price, $qty, $date, $adj_only=false)
is defined in purchasing/includes/db/grn_db.inc

5,594

(12 replies, posted in Translations)

On WinXP install TortoiseGIT and you will get a right-click (on any folder) context menu - Git Bash here.
Use it to do LINUX work on Windows!

Or send the company the credit note as well!

Actually the difference to should go to a"Exchange Rate P&L" account that keeps track of all such loose change. That way when we prepare the Balance Sheet in another currency (For head office of MNCs) we will not be affected. This is possible when the said entry is to be included only when the currency changes from that of the main accounts of the transaction or if it is dynamically computed at display time and not populated in the db!

5,597

(7 replies, posted in Setup)

The company/# folder may have changes and hence duplication may be in order.

Use OpenVZ Virtual Machines and synch the db and rsync the company folder - no need to change the company # as well and the db backup will be restored faithfully on the training VM.

Void the payment and create a new payment will have a proper record of the error and it's correction - that is the right way accounts should be maintained.

Correcting it in the database should be done carefully after backup and browser cache should be eliminated - logout and login again - so that there is no bad session variable lurking to trip us.

It is possible that the backup itself had the double records!

5,600

(5 replies, posted in Report Bugs here)

If negative inventory is used, then the quantity that is negative should not be used to update the standard cost - this will most probably be the source of the error.