The problem is not in Cloning but Just in View of an already Created Item whose Code is Same as that of any GL Code.

To Reproduce the Error follow the steps below

Login here
id: admin
pass: Pakistan1947

Go to Iitems&Inventory>>Items

Create a New Item with Code 5800 and check the behavior.

There is already a GL Account with Code 5800 named Licenses.

Once you Create the Item and then Reopen it you will see this screen

While you see the above screen the Data in Database is absolutely correct. The problem is just in View of the related GL Codes for this Item.

Note: This installation is a Fresh installation with the Demo Data

After this Commit a bug is found in items.php.

If by chance the Item Code matches with any of the GL Code then When you see the details of any Item it shows that GL Code in all related GL Accounts for that Item.

353

(9 replies, posted in Setup)

Yes, this solution has solved my problem

354

(9 replies, posted in Setup)

Actually I need to avoid the process of previewing and then printing through browser. It will save time by avoiding a repetitive process while handing customers at Point of Sale location.

Can't we set print profiles for this reason?

355

(9 replies, posted in Setup)

By FA location if you mean the hosted location then yes FA is hosted at cloud. But if you mean the browser location from where print is sent then it is the same location i.e same computer to which POS printer is connected .

Only one printer i.e the POS printed is connected to the POS machine (computer )

356

(9 replies, posted in Setup)

How to use Print Profiles to send print directly to printer at a POS Location without going to browser preview. I am using Windows 10.

Printer is connected to the same computer where FA is used.

@kvvaradha , I think it is done in HR module by @notrinos

@TOR,
comment out lines from 323-328 in /gl/gl_bank.php

// if (!check_num('amount', 0))
    // {
    //     display_error( _("The amount entered is not a valid number or is less than zero."));
    //     set_focus('amount');
    //     return false;
    // }

You will get your desired result. I hope it will not cause any other anomaly in Database.

Why don't you look at the HR module by @notrinos. This is already done there

@ichtus See this Post

https://frontaccounting.com/punbb/viewtopic.php?id=7530

I am using free.CurrencyConverterAPI.com and it works for almost all Currencies

elseif ($provider == 'CCA') //free.currencyconverterapi.com
    {
        $filename = "/api/v5/convert?q={$curr_b}_{$curr_a}&compact=y";
        $site = "free.currencyconverterapi.com";
        $proto = 'https://';

    }

@oakstreet1 which HostingProvider are you using?

I am writing this post just to share my experiences so that any newbie, non IT professional, can gets benefit from this.

When we talk about Installation of FA, we are generally not assuming the installation of any server. Since FA is very light weight and it can easily run on Shared Hosting so the users don't need any VPS. But sometimes for better performance and for critical users one need to have a VPS.

The worst thing about VPS, that I faced as a Non IT professional, is that hosting companies don't take the total responsibility of a VPS's uptime. It is only you who has to take care of all aspects of VPS.

For this reason I was prolonging the use of a VPS. But finally when it became inevitable for me I met @fernando_bender one of the members of FA community and founder of myERPlink.com. I found him very well versed in Server Management. He offers complete server support. So people like me who want to focus on their core business like consultancy can hire his services at a very reasonable prices.

For server security I spent hours on internet to know how to get my linux server secured (Not SSL). I found this articl http://billpatrianakos.me/blog/2014/07/ … right-now/ very helpful in this regard.

I would like to mention few steps that any newbie can follow.

1. Buy a Blank VPS, preferably with Debian OS
2. Install VestaCP.com a very light weight GUI. This install will automatically install all related services
3. Use above article to secure your server
4. Start using it after installing FA.

I would be sharing my further experiences good or bad in using the VPS in the same post.

Thanks to FA Community smile

Yes, I can verify

@kvvaradha, thanks got it.

366

(2 replies, posted in Report Bugs here)

I got it. This problem is due to this last commit

367

(2 replies, posted in Report Bugs here)

I downloaded the latest repo from Github today and installed it. The Sales Order Entry page when open for the first time is showing some problem. I suspect that this problem has arised due to some recent commits.

The screenshot is here

You can see the Drobdown List of Items in Unit Column. This gets fixed automatically as soon as any Item is selected

I can see this commit by @joe for Item Editable Description. I have applied this but I couldn't find any change in Behaviour of Editable Item Description. Any Idea how shall I expect the change?

I copied the Logic from rep101.php and it worked.

function get_open_balance($supplier_id, $to)
{
    if($to)
        $to = date2sql($to);

        $sql = "SELECT SUM(IF(t.type = ".ST_SUPPINVOICE." OR (t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.") AND t.ov_amount>0),
                        -abs(t.ov_amount + t.ov_gst + t.ov_discount), 0)) AS charges,";

 $sql .= "SUM(IF(t.type != ".ST_SUPPINVOICE." AND NOT(t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.") AND t.ov_amount>0),
                        abs(t.ov_amount + t.ov_gst + t.ov_discount) * -1, 0)) AS credits,";

     $sql .= "SUM(IF(t.type != ".ST_SUPPINVOICE." AND NOT(t.type IN (".ST_JOURNAL." , ".ST_BANKDEPOSIT.")), t.alloc * -1, t.alloc)) AS Allocated,";

     $sql .=    "SUM(IF(t.type = ".ST_SUPPINVOICE.", 1, -1) *
             (abs(t.ov_amount + t.ov_gst + t.ov_discount) - abs(t.alloc))) AS OutStanding
        FROM ".TB_PREF."supp_trans t
        WHERE t.supplier_id = ".db_escape($supplier_id);
    if ($to)
        $sql .= " AND t.tran_date < '$to'";
    $sql .= " GROUP BY supplier_id";

    $result = db_query($sql,"No transactions were returned");
    return db_fetch($result);
}

I found a bug in Supplier Balances Report.

Check this screen shot of comparison. Opening Balance of the SUpplier was recorded on 30th June. When we query including 30th June the report shows value correctly under Charges Column But When we query from 1st July the Reports Shows the opening balance wrongly under Credits Column.

The reason is that the Opening Balance was entered through Journal Entry. and Journal Entry is not being checked in the get_open_balance() function in rep201.php.

371

(2 replies, posted in Setup)

When a Transaction is selected to be voided in FA, It is not highlighted.

Below code would server the cause. Replace the code starting at Line # 174

function is_selected($row) // Function added by faisal
        {
            global $selected_id;
            return $row['trans_no'] == $selected_id ? true : false;
        }

    $trans_ref = false;
    $sql = get_sql_for_view_transactions(get_post('filterType'), get_post('FromTransNo'), get_post('ToTransNo'), $trans_ref);
    if ($sql == "")
        return;

    $cols = array(
        _("#") => array('insert'=>true, 'fun'=>'view_link'),
        _("Reference") => array('fun'=>'ref_view'),
        _("Date") => array('type'=>'date', 'fun'=>'date_view'),
        _("GL") => array('insert'=>true, 'fun'=>'gl_view'),
        _("Select") => array('insert'=>true, 'fun'=>'select_link')
    );

    $table =& new_db_pager('transactions', $sql, $cols);
    $table->set_marker('is_selected', _("Marked transactions will be voided.")); //Added by Faisal

Unlike Customer payment, Supplier payment is not editable. Any solution for this

@cs you need to enable it from Access Setup

I wrote a function to write to a file the sql output for debugging purpose. I forgot to comment that out. That was actually taking too long.

@poncho1234 yes lac is 100,000 in our local language smile