976

(1 replies, posted in Setup)

Hi.  What is your pricing and plans

If it's so.  Than we don't need to change the stock move dates.  We can keep the stock moves table as since as it is.  And it's like the stock locations table.

Here is the code of deleting the things on stock mov table.

$sql = "SELECT loc_code, stock_id, SUM(qty) AS qty, SUM(qty*standard_cost) AS std_cost FROM ".TB_PREF."stock_moves WHERE tran_date <= '$to' GROUP by 
        loc_code, stock_id";
    $result = db_query($sql, "Could not retrieve supp trans");
    while ($row = db_fetch($result))
    {
        $sql = "DELETE FROM ".TB_PREF."stock_moves WHERE tran_date <= '$to' AND loc_code = '{$row['loc_code']}' AND stock_id = '{$row['stock_id']}'";
        db_query($sql, "Could not delete stock moves");
        $qty = $row['qty'];
        $std_cost = ($qty == 0 ? 0 : round2($row['std_cost'] / $qty, user_price_dec()));
        $sql = "INSERT INTO ".TB_PREF."stock_moves (stock_id, loc_code, tran_date, reference, qty, standard_cost) VALUES
            ('{$row['stock_id']}', '{$row['loc_code']}', '$to', '$ref', $qty, $std_cost)";   
        db_query($sql, "Could not insert stock move");
    }

Here each row inserted again with the end date of fiscal year.  How its working?

and Are we need to keep the stock mov datas for next year?

shall we check this data's again after closing the previous year.

That's awesome you have solution to the problem

It's chrome firewall might be preventing ad popups. So it's not allowing you. Just click on it and continue view pop-up from the url.

981

(2 replies, posted in Reporting)

Did you change the Time zone and test it again.?

Try this one. Just add this below code on the top of your config.php

 date_default_timezone_set('Asia/Singapore'); 

I think it's working fine.  Here I tested this two with mine.  It's working and generates pdf.

Are you sure.? 

Is ur browser opens other pdf files?

And which browser are you using?.
Can you show us a screenshot of the browser page after clicking the display pdf button.

I think creating invoice before delivery is not provided option in frontaccounting.
You can get better solutions from Joe and Apmuthu

After delivering the goods. You can create invoice. I think its not in core of FA.

It's usuable for the manufacturing  and service.

Let me tell you what I have understand from it. direct invoice and direct GRN
Within it. It will create a PO behind it.

You can track the details by " Supplier transaction inquiry".

Each entries will be there.

987

(3 replies, posted in Banking and General Ledger)

not sure, but its available i think.Better you can use Google or Yahoo.

988

(10 replies, posted in Report Bugs here)

By Unkowing the `Changes.txt` was deleted. That file is not available to get the file modified time. so it failed to work on.  Soi solved it easily.

Now,the problem is large rows. It has more than 16,32,000 rows in my database.  I have to delete more than 12,00,000 rows now.So when i click the delete button. It first creates backup of the db. While making backup it has reported the error of " MYSQL Server Gone Away" .  So, its not working now.

I want to it to perform like separated files and merge it one after exporting all in different files. And there after i need to schedule the delete operation too. I think we can't delete all the rows in single delete.  for that issue, we have to use limiting for the deleting rows count.  Let me know,whether  am in the current track or not.

Is any other alternative for it. ?

989

(10 replies, posted in Report Bugs here)

Thank you  @apmuthu,

I fixed it.  But the problem is its large data. so its not working when i am deleting all together.

Is there any scheduled delete or something else for it.

990

(10 replies, posted in Report Bugs here)

i got this error

filemtime(): stat failed for ../CHANGELOG.txt in file: /home/user/public_html/FA2.3.24/config.php at line 65

can you please help me on it?

I have found the issue and solved it. But still its not deleting the fiscal year.

There are few things, that  can't be translated at this moment.hope to hear words from  joe And Jansuz regarding the translation of dashboard.

@Ken,

Good to see your expertise in other softwares. Better you should understand fully the functions than you can put it experienced.

And Senior Member like  Apmuthu, Joe,and Jansuz are really experienced in it.  Your skills on FA is not meeting much to work on it, learn it well than bring peoples to trust you.

it might be problem with missing  files.  or missing functions.

Just enable debugging mode and see the bugs in it.if you see bugs, than you should try another versions.

994

(3 replies, posted in Items and Inventory)

just create an tax type for VAT and provide the percent of tax rate.

than come to Item Tax Types. there just create a new one by selecting the previously created VAT tax.

Now,you can able to apply the VAT Tax on the items page.  Than it will applied to it.

you can call this function by adding last parameter `true`, than it will be disabled.  Try it.

try this way, i am just explaining you the way to  do it for first one. `sales_types_list_row`. you can do it others manually.

 

function sales_types_list($name, $selected_id=null, $submit_on_change=false, $special_option=false, $disabled=false)
{
    $sql = "SELECT id, sales_type, inactive FROM ".TB_PREF."sales_types";

    return combo_input($name, $selected_id, $sql, 'id', 'sales_type',
    array(
        'spec_option' => $special_option===true ? _("All Sales Types") : $special_option,
        'spec_id' => 0,
        'select_submit'=> $submit_on_change,
                'disabled'  => $disabled, 
    //      'async' => false,
    ) );
}

function sales_types_list_cells($label, $name, $selected_id=null, $submit_on_change=false, $special_option=false, $disabled=false)
{
    if ($label != null)
        echo "<td>$label</td>\n";
    echo "<td>";
    echo sales_types_list($name, $selected_id, $submit_on_change, $special_option, $disabled);
    echo "</td>\n";
}

function sales_types_list_row($label, $name, $selected_id=null, $submit_on_change=false, $special_option=false, $disabled=false)
{
    echo "<tr><td class='label'>$label</td>";
    sales_types_list_cells(null, $name, $selected_id, $submit_on_change, $special_option, $disabled);
    echo "</tr>\n";
}

Here I just added additional parameter `$disabled`. and forwarded to combo_input call.

997

(12 replies, posted in Announcements)

Sorry i was busy with some other projects.

here you can get it .

https://bitbucket.org/kvvaradha/fa-hrm

998

(10 replies, posted in Report Bugs here)

Create a custom company with demo datas, and this new company should be in a separate database, if its working fine without freeze, than its server slow.  Otherwise we can do some other alternative for it.

999

(10 replies, posted in Report Bugs here)

That's depending on your mysql server speed and the volume of data you stored in the database,

1,000

(1 replies, posted in Report Bugs here)

it seems,  some of your files are deleted from the installation. Where you updated manually or automatically.