@ tom - I guess if you do the missiby step. It will fix the db issue.
602 04/09/2019 05:35:41 am
Re: Fiscal Year (4 replies, posted in Setup)
That comes with recent year. You can get from 2019 or 2018
603 04/08/2019 11:46:55 pm
Re: Fiscal Year (4 replies, posted in Setup)
From FA fiscal years. You can't skip years and months or even days in fiscal year creation. So create all those years from. 2014 to till and then close the unused years and then delete it.
Or simply access the database and change the years from fiscal years table
604 04/07/2019 02:34:24 am
Re: Upgrading (27 replies, posted in Installation)
Than its great to hear
605 04/06/2019 02:56:38 pm
Re: Upgrading (27 replies, posted in Installation)
I wrote the things. But I forget the reason. But there is some program helps to move from here. Its good to upgrade the database with 2.3 to 2.4
606 04/06/2019 02:53:29 pm
Re: Added Extension - does not appear in menus (5 replies, posted in Installation)
Some new updates In PHP , due to that core of FA is also updated the extension hooks. Check your extension supports the new thing. Most probably the function __construct() may be needs to be updated.
607 03/30/2019 01:53:38 pm
Re: erorr (14 replies, posted in Setup)
Unfortunately we can't recover the data from MySQL server once its lost or corrupted.
Always try an automatic backup script. Which will keep a copy of your data's safe. Everyday automatic backup is best to use. Those who are using hosting servers and Linux. They can use cron job to do the regualr backup.
But for windows, we can't use cron job to backup. But you can run a program to take backup by one click operations.
608 03/24/2019 12:23:19 pm
Re: How can i update my Arabic Language (12 replies, posted in Translations)
Try hard refresh for few times. While refreshing if you see those words are translated and after next refresh it disappears. You should recompile the Mo file again before that validate the po file for errors . If you see errors or warnings. Just fix them and translate it.
Even after several Refresh, you didn't see the translation then the problem is in the FA gettext function . _("Inventory")
Sometimes those words in po file may be commented like # infront of the msgstr or msgid. Check them carefully.
609 03/22/2019 01:58:58 pm
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
I have updated my theme here in my site to available for download and try it from users. Those who wish to try the theme. They can download it from here
610 03/17/2019 07:59:33 am
Re: The POS (22 replies, posted in Accounts Receivable)
Thank you @apmuthu. The balance can be listed in another page with listing of sales and filter it to see the reports. Will make font changes as well.
611 03/15/2019 02:08:28 pm
Re: The POS (22 replies, posted in Accounts Receivable)
I am trying to make POS for FA. You can check here
Kvcodes POS and I am trying to make fully working one. Almost ready and I am welcoming feedbacks.
Username : demo
Password : 123456
612 03/13/2019 06:07:04 am
Re: SMTP or phpmailer (4 replies, posted in Wish List)
Using SMTP elaborate the service with emailing the generated PDF. However this is not fulfill without email Templates based in types and PDF. So we need to include email Templates and SMTP together we can go with phpmailer or swiftmailer.
613 03/09/2019 01:59:17 am
Re: Error in Opening Balance (4 replies, posted in Banking and General Ledger)
Yes you can see it from journal inquiry or GL inquiry. It has memo. With opening balance
614 03/01/2019 05:58:05 am
Re: Default Theme Redesigned And available For testing (47 replies, posted in Modules Add-on's)
joe wrote:
I think we will make a poll when @notrinos has presented his new theme.
Simply let the audience decide which should be candidates. We usually have 3 themes in the core, but the other can be set as extensions. I guess there are several old themes that can be taken away from the extensions.
The best one will be the default theme. Democratic, right?
/Joe
Any further updates related to this topic.
615 03/01/2019 05:30:36 am
Re: function round2 on FA (3 replies, posted in Banking and General Ledger)
The round2 function helps to setup our decimal precision for amounts and prices. So, here they are using to calculate the allowed rounding value with a limit of decimal points.
616 02/26/2019 04:46:58 pm
Re: How to Add Column Undefined property ? (3 replies, posted in FA Modifications)
First you need to input the from variable inside the cart class . There after extend to use it in other object files. Its simple php class variable creation
617 02/21/2019 06:36:11 am
Re: Bug in rep101.php (3 replies, posted in Report Bugs here)
This thread has already predicted the issue and updated it on repo. May be you can get it from unstable repo .
618 02/18/2019 06:36:04 am
Topic: Last Visit Date with Time (2 replies, posted in Wish List)
As we are recording the time of user login as well. But we are not showing the time in "Users" Page.
Shall we show it with help of the below code.
$last_visit_date = sql2date($myrow["last_visit_date"]). ' ' .date('h:i a', strtotime($myrow['last_visit_date']));by changing it on /admin/users.php line. No: 136 (Approx)
619 02/13/2019 11:45:14 am
Topic: Customer balance Report rep101.php has one extra parameter (1 replies, posted in Reporting)
From the Customer balances report, we have a function get_open_balance
While calling this, we have 3 parameters, but in definition, we have just 2 parameters.
function get_open_balance($debtorno, $to) { And
$bal = get_open_balance($myrow['debtor_no'], $from, $convert);Here the $convert is unnecessary to pass it.
So just fix it like this.
$bal = get_open_balance($myrow['debtor_no'], $from);620 02/07/2019 12:50:26 pm
Re: Lost Configuration (1 replies, posted in Installation)
You shouldnt goto new installation. Just reconfigure the config_db.php with your previous database. Keep the config.php and installed_extensions.php and try it.
If possible enable debugging mode get us error what you face during installation
621 02/07/2019 12:44:37 pm
Re: Project Accounting (3 replies, posted in Reporting)
The functionality not available. But you can program it. It's likely similar to the manufacturing function and issue The material to the project.
622 01/25/2019 05:19:47 am
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
@joe ,sorry for my mistake.
the code should be like this.
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else
sales_items_list_cells(null,'stock_id', last_sales_order_detail($order, 'stk_code'), false, true, true);
if (list_updated('stock_id')) {
$Ajax->activate('price');
$Ajax->activate('units');
$Ajax->activate('qty');
$Ajax->activate('line_total');
}
By mistake i put in else part of list_updated.
623 01/24/2019 07:09:08 pm
Topic: sales_db.inc (1 replies, posted in Report Bugs here)
function get_sales_child_documents has count function, may be it has to be rewritten with count_array
also one more within the file
624 01/24/2019 07:05:28 pm
Topic: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
it looks like this now.
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else
if (list_updated('stock_id')) {
sales_items_list_cells(null,'stock_id', null, false, true, true);
$Ajax->activate('price');
$Ajax->activate('units');
$Ajax->activate('qty');
$Ajax->activate('line_total');
} else
sales_items_list_cells(null,'stock_id', last_sales_order_detail($order, 'stk_code'), false, true, true);But it should be like this
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else
sales_items_list_cells(null,'stock_id', null, false, true, true);
if (list_updated('stock_id')) {
$Ajax->activate('price');
$Ajax->activate('units');
$Ajax->activate('qty');
$Ajax->activate('line_total');
} else
sales_items_list_cells(null,'stock_id', last_sales_order_detail($order, 'stk_code'), false, true, true);625 01/23/2019 09:45:24 am
Topic: items_cart class has a logical bug, should be fixed. (1 replies, posted in Report Bugs here)
The items_cart.inc looks like this function
function check_qoh($location, $date_, $reverse=false)
{
global $SysPrefs;
$low_stock = array();
if (!$SysPrefs->allow_negative_stock() || is_fixed_asset($line_items->mb_flag))
{
foreach ($this->line_items as $line_no => $line_item)
if (has_stock_holding($line_item->mb_flag) || is_fixed_asset($line_item->mb_flag))
{
$quantity = $line_item->quantity;
if ($reverse)
$quantity = -$line_item->quantity;
if ($quantity >= 0)
continue;
if (check_negative_stock($line_item->stock_id, $quantity, $location, $date_))
$low_stock[] = $line_item->stock_id;
}
}
return $low_stock;
}But here is the bug,
if (!$SysPrefs->allow_negative_stock() || is_fixed_asset($line_items->mb_flag))Probably the is_fixed_asset($line_items->mb_flag) is invalid to put it here. we already checking that inside for loop. Also the object $line_items->mb_flag is not available. so change the function like this.
function check_qoh($location, $date_, $reverse=false)
{
global $SysPrefs;
$low_stock = array();
if (!$SysPrefs->allow_negative_stock())
{
foreach ($this->line_items as $line_no => $line_item)
if (has_stock_holding($line_item->mb_flag) || is_fixed_asset($line_item->mb_flag))
{
$quantity = $line_item->quantity;
if ($reverse)
$quantity = -$line_item->quantity;
if ($quantity >= 0)
continue;
if (check_negative_stock($line_item->stock_id, $quantity, $location, $date_))
$low_stock[] = $line_item->stock_id;
}
}
return $low_stock;
}Hope that fixes the undefined noin-object error