601

(8 replies, posted in Accounts Receivable)

@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

(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

(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

(13 replies, posted in Report Bugs here)

kvvaradha wrote:

@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.

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.

It depends on the COA . Which COA did you choose while creating new company. Based in that the issue can be fixed

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

(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

@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.

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.

We have an unused function inside sales_order_db.inc

function name last_sales_order_detail

612

(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

(27 replies, posted in Installation)

Not phpmyadmin
it's all through  FA.

614

(27 replies, posted in Installation)

@ tom - I guess if you do the missiby step.  It will fix the db issue.

615

(4 replies, posted in Setup)

That comes with recent year. You can get from 2019 or 2018

616

(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

(27 replies, posted in Installation)

Than its great to hear

618

(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

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

(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

(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.

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

(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

(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

(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.