Interest on Principal
or
Interesting (LIKES) Interest in FA?
5,576 03/31/2013 03:27:28 am
Re: Credit card payment (9 replies, posted in Banking and General Ledger)
5,577 03/31/2013 03:22:58 am
Re: PDF-Prints (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 03/31/2013 02:55:52 am
Topic: Technical FAQ on Wiki (0 replies, posted in Announcements)
Technical FAQ page has been placed on the Wiki. Please gather pertinent info into it without flooding it.
5,579 03/29/2013 07:59:58 pm
Topic: Journal Inquiry WorkOrder Fix - HG 3213 - Thanks (0 replies, posted in Report Bugs here)
Thanks Janusz for the HG 3213 Fix.
5,580 03/29/2013 02:59:00 am
Re: Wrong sales figure in Inventory Sales Report (2 replies, posted in Report Bugs here)
Does this affect only the report or the actual invoice and legder entries as well?
5,581 03/29/2013 02:56:31 am
Re: how to keep track of overdue invoices? (5 replies, posted in Accounts Receivable)
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 03/29/2013 02:52:15 am
Re: Poedit msgid limitation (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.
5,583 03/27/2013 05:57:16 pm
Re: how to keep track of overdue invoices? (5 replies, posted in Accounts Receivable)
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 03/27/2013 05:51:56 pm
Re: Timeout Error (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}
5,585 03/27/2013 05:45:22 pm
Re: Allocate Customer Payment module (1 replies, posted in Accounts Receivable)
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.
5,586 03/27/2013 04:00:54 am
Re: how to keep track of overdue invoices? (5 replies, posted in Accounts Receivable)
Use Dashboard Module and Theme
5,587 03/27/2013 03:40:43 am
Re: Sales Orders view DESC mode (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 03/26/2013 07:04:02 pm
Re: Sales Orders view DESC mode (7 replies, posted in Accounts Receivable)
Then the following should sort by descending order by default:
_("Order #") => array('fun'=>'view_link', 'ord'=>'desc'),
5,589 03/26/2013 11:13:51 am
Re: Using VOID - what are the limits (2 replies, posted in Banking and General Ledger)
Voiding should van(qu)ish the transaction, right?
5,590 03/26/2013 11:10:28 am
Re: Dashbord module (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 03/26/2013 11:07:49 am
Re: Sales Orders view DESC mode (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'),
5,592 03/26/2013 02:32:59 am
Re: Entering foreing currency amount in payment (18 replies, posted in FA Modifications)
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 03/26/2013 02:23:51 am
Re: Stock Valuation Report (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 03/26/2013 02:19:19 am
Re: Poedit msgid limitation (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!
5,595 03/25/2013 03:19:23 pm
Re: How to deal with over or under payments? (3 replies, posted in Accounts Payable)
Or send the company the credit note as well!
5,596 03/25/2013 03:15:11 pm
Re: Entering foreing currency amount in payment (18 replies, posted in FA Modifications)
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 03/25/2013 03:00:11 pm
Re: Set a different background color (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.
5,598 03/25/2013 02:56:17 pm
Re: How to correct an incorrect payment? (2 replies, posted in Accounts Payable)
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.
5,599 03/25/2013 02:53:45 pm
Re: double recodes in table call comments (1 replies, posted in Report Bugs here)
It is possible that the backup itself had the double records!
5,600 03/25/2013 02:52:30 pm
Re: Stock Valuation Report (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.