626 Reply by kvvaradha

(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

Go to forum: Banking and General Ledger

627 Reply by kvvaradha

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

Go to forum: Modules Add-on's

628 Reply by kvvaradha

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

Go to forum: Banking and General Ledger

629 Reply by kvvaradha

(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

Go to forum: FA Modifications

630 Reply by kvvaradha

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

Go to forum: Report Bugs here

631 Topic by kvvaradha

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

Go to forum: Wish List

632 Topic by kvvaradha

(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);

Go to forum: Reporting

633 Reply by kvvaradha

(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

Go to forum: Installation

634 Reply by kvvaradha

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

Go to forum: Reporting

635 Reply by kvvaradha

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

Go to forum: Report Bugs here

636 Topic by kvvaradha

(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

Go to forum: Report Bugs here

637 Topic by kvvaradha

(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);

Go to forum: Report Bugs here

638 Topic by kvvaradha

(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

Go to forum: Report Bugs here

639 Reply by kvvaradha

(2 replies, posted in Jobs wanted/offered, non-free offers)

Implementation of FrontAccounting does not take much time. But make it suitable to your company needs will take time.  Basically you need expert advice for each step of changes and development you required.

Go to forum: Jobs wanted/offered, non-free offers

640 Reply by kvvaradha

(25 replies, posted in FA Modifications)

anoopmb wrote:

@boxygen

sorry mistakenly uploaded non-ajax version

here is the download link again

Download

@anoopmb - This is what i asked, This is awesome.  i have tested your program, it works fine.

I found one thing was missing from the core. Let me tel you here.

From sales invoice page,or items page. you can see a textbox before the drop down. When we type the item code like say for example if i type 101 with default US coa. it will get us first item automatically in the drop down. This you have override it. i mean its not working either in your auto complete and ajax auto complete versions.

While taking one step forward, we dont need that feature, if we can type the stock id to get the product in the list.

I mean, if you enable it to check the stock id for items, debtor no for customers, supplier id for suppliers to get the list working.  If you add it like this, i guess it would be perfect replace for the existing textbox item code search, and popup search box. quite simple textbox will filter the product from the list, whether its 1,00,000 or more than that, we dont need to worry,  FA will handle the items.

Once again, its a great job @Anoopmb. Congrats for the bold step to change the core concept.

Go to forum: FA Modifications

641 Reply by kvvaradha

(11 replies, posted in FA Modifications)

The other chart of accounts are from your repository. So it can be override the year change for me is not easy.

May be we can write a override program to update the years in all chart of accounts.

Go to forum: FA Modifications

642 Reply by kvvaradha

(25 replies, posted in FA Modifications)

anoopmb wrote:

I didnt get it

I mean, the ajax driven autocomplete means, when a FA has more than 1,00,000 customers. and when a user has to pick a right customer is from the drop down is complicated. So your auto complete helps to get it from the list.  But the problem is , the select list loads all the 1,00,000 customers in the list. So the FA freezes in its page load and its operations. So, when the customers list renders, it should show the most recent 10 customers in the list.  When the salesman starts typing the customer name, it should bring the filtered results from the server to narrow down the search and by the way it will not freeze or hang the invoice page.

The samething i already explained in your another topic which talks about autocomplete.

So i thought this one handles such a thing.

Go to forum: FA Modifications

643 Reply by kvvaradha

(25 replies, posted in FA Modifications)

@anoopmb I have tested your code. it creates "popups" each key i type.

Like it creates like this " popups popups popups popups popups popups popups popups popups popups popups popups popups popups popups" .

<div class=" popups popups popups popups popups popups popups popups popups popups popups popups popups popups popups" style="position: fixed; left: 267.5px; top: 174px; width: 169px; display: none;"><div class="lister"><ul class="mselect-rset"><li title="" class=" anoselect" id="1">Donald Easter</li><li title="" class=" anoselect" id="2">MoneyMaker&nbsp;-&nbsp;EUR</li><li title="" class=" aselected" id="3">Varadha</li></ul></div></div>

Kindly fix it. also the Ajax concept i didnt understand. it brings all the elements in the customers when i see.

Go to forum: FA Modifications

644 Topic by kvvaradha

(11 replies, posted in FA Modifications)

@joe, the demo and fresh sql files has 2017 data's. We need to refresh the dates with 2019 and also fiscal year also 2018. we need to allow them to see 2019 on both default SQL files with current year. So the new users wont get confusions.

Go to forum: FA Modifications

645 Reply by kvvaradha

(13 replies, posted in Accounts Receivable)

Invoice Edit option is available.  But you can't edit the price, here its showing it to alter the quantity only. Which is also retricted certain way.

May be @joe, @janusz can tell you exactly, why they are preventing to edit the invoice.

If you wish to see the edit invoice, take a look at there .

http://yousite.com/FA/sales/customer_invoice.php?ModifyInvoice=1

Hope you can change the invoice number and see it. Goodluck

Go to forum: Accounts Receivable

646 Reply by kvvaradha

(82 replies, posted in FA Modifications)

Yes ofcourse, But when i try, i got this error 

Undefined variable: title in file: /var/www/246/reporting/includes/dashboard_classes.inc at line 233

Go to forum: FA Modifications

647 Reply by kvvaradha

(82 replies, posted in FA Modifications)

@notrinos - Show us a demo from your work.

Go to forum: FA Modifications

648 Reply by kvvaradha

(4 replies, posted in Banking and General Ledger)

you need to close the previous fiscal years by going to "Setup->Fiscal Years" there edit the preivous year and close it.it will create the opening balance of current year.

Go to forum: Banking and General Ledger

649 Reply by kvvaradha

(47 replies, posted in Modules Add-on's)

@joe, You are right. Lets wait for @notrinos theme and poll it.

Go to forum: Modules Add-on's

650 Reply by kvvaradha

(47 replies, posted in Modules Add-on's)

May be. Are you interested to take this theme to core?

Logo also i have edited.

Go to forum: Modules Add-on's