@apmuthu, each transaction has debtor number and branch no. So thats unnecessary condition i feel. If the customer doesnot have any transactions, we can skip the branch validation and delete customer, contact, branch contact, branch and finally customer.
602 04/22/2019 05:22:15 am
Re: sales_order_ui.inc has a bug (13 replies, posted in Report Bugs here)
@joe, Yes you are right.
As like @Apmuthu words, it rolls back to the last item sold to the customer. we are not able to change the item to sell. But we can try this option.it may be fessible to work on.
We will put an if condition, if the stock_id is not exist, we can get the last_sales_order_detail,like this, here is code
if ($order->fixed_asset)
stock_disposable_fa_list_cells(null,'stock_id', null, _('[Select item]'), true, $order->line_items);
else{
if(!isset($_POST['stock_id'])){ // Check the stock id not exist
$_POST['stock_id'] = last_sales_order_detail($order, 'stk_code'); //get the llast sales stock id.
}
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');
}
Hope this may be fixed the problem.
if not, we remove the function from sales_order_d.inc last_sales_order_detail. It was defined there. and keep the sales item list cells like this
sales_items_list_cells(null,'stock_id', null, false, true, true);
603 04/21/2019 11:26:18 am
Re: Delete old customers (8 replies, posted in Accounts Receivable)
@joe - Why do we check branch to delete a customer. May if the customer has more than one branch. We should prevent deleting. Also we can allow them to delete a customer who has no sales transactions whatever the branches he has.
Because sometimes for testing purpose our users creating Customer. Than if they try to delete it will ask them to remove branches and than we have to delete it.
As of customer delete from the add manage customers it works fine by checking of existing transactions except the branch validation
604 04/21/2019 11:09:16 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.
@joe - here I gave the same code exactly what he committed there. So you can update it.
605 04/18/2019 03:21:35 pm
Re: Journal entries always have a blank Person/Item (5 replies, posted in Banking and General Ledger)
It can be used. If you record the customer payment. Supplier payouts or inventory adjustment. It will be used. When you see in journal entry form. You can see country party if you select "Accounts Receivable".
It can be used.
606 04/16/2019 12:16:31 am
Re: Second company does not create security roles records (5 replies, posted in Report Bugs here)
It depends on the COA . Which COA did you choose while creating new company. Based in that the issue can be fixed
607 04/14/2019 06:27:52 am
Topic: user_list_cells Real name sometimes shows empty (3 replies, posted in FA Modifications)
Yes the real name is sometimes empty, users may skip to input real name, because its not mandatory, Incase if they didnt input, the user_list_cells function will be showing an empty list. so lets change the query to be like this.
$sql = " SELECT user_id, IF(real_name = ' ', user_id, real_name) FROM ".TB_PREF."users";
suppose if the real name empty, it will show the user_id in it. which will avoid confusions
608 04/13/2019 11:03:23 am
Re: Upgrading (27 replies, posted in Installation)
You may be in the main menu section. Try to open sub module pages like direct invoice. It will prompt the message. Or you can directly goto setup-> software updates. There you can see update option available
609 04/13/2019 11:00:07 am
Re: unnecessary function inside sales_order_db.inc (4 replies, posted in Report Bugs here)
@Braath waate,
You found it where ist was called. I didn't spend time to know it.
@joe mistakes may happen, nothing to worry. Its not that much needy function.
610 04/13/2019 01:41:10 am
Re: Bar codes - scanning, printing, recording and generating (3 replies, posted in Items and Inventory)
For your all questions. The answer is "Yes". The barcode can be generated from the Items page as well as sales kit page.
But printing of barcode you have to program separately to take barcode out patch it on products.
611 04/12/2019 04:36:04 pm
Topic: unnecessary function inside sales_order_db.inc (4 replies, posted in Report Bugs here)
We have an unused function inside sales_order_db.inc
function name last_sales_order_detail
612 04/12/2019 03:21:17 pm
Re: Upgrading (27 replies, posted in Installation)
@tom - I forget the reason for it. But all these steps will help you to update database.if yoy have backup. Then go with test instance and try them.
613 04/10/2019 02:45:14 am
Re: Upgrading (27 replies, posted in Installation)
Not phpmyadmin
it's all through FA.
614 04/09/2019 10:56:39 am
Re: Upgrading (27 replies, posted in Installation)
@ tom - I guess if you do the missiby step. It will fix the db issue.
615 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
616 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
617 04/07/2019 02:34:24 am
Re: Upgrading (27 replies, posted in Installation)
Than its great to hear
618 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
619 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.
620 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.
621 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.
622 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
623 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.
624 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
625 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.