Hi. What is your pricing and plans
977 07/08/2016 09:46:41 am
Re: Deleting fiscal year stock_mov doesn't delete data's (2 replies, posted in Report Bugs here)
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.
978 07/04/2016 07:46:36 am
Topic: Deleting fiscal year stock_mov doesn't delete data's (2 replies, posted in Report Bugs here)
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.
979 06/30/2016 02:01:09 pm
Re: Problem with German and French versions (2 replies, posted in Translations)
That's awesome you have solution to the problem
980 06/27/2016 01:08:03 pm
Re: Print (PDF) is not working anywhere in 2.3.25 (13 replies, posted in Report Bugs here)
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 06/26/2016 05:41:23 pm
Re: GST Reporting for Singapore (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');
982 06/26/2016 05:37:43 pm
Re: Print (PDF) is not working anywhere in 2.3.25 (13 replies, posted in Report Bugs here)
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.
983 06/25/2016 02:52:23 pm
Re: How to add additional charges to Direct GRN and Direct Invoice (1 replies, posted in Accounts Payable)
I think creating invoice before delivery is not provided option in frontaccounting.
You can get better solutions from Joe and Apmuthu
984 06/25/2016 02:43:12 pm
Re: Direct PI & GRN later Purchase Order. (3 replies, posted in Accounts Receivable)
After delivering the goods. You can create invoice. I think its not in core of FA.
985 06/23/2016 02:46:40 pm
Re: Plastic Manufacturing Industry Applicable ?????? (1 replies, posted in Accounts Receivable)
It's usuable for the manufacturing and service.
986 06/23/2016 02:44:29 pm
Re: Direct PI & GRN later Purchase Order. (3 replies, posted in Accounts Receivable)
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 06/20/2016 11:35:42 am
Re: EXCHANGE RATE SOURCE (3 replies, posted in Banking and General Ledger)
not sure, but its available i think.Better you can use Google or Yahoo.
988 06/03/2016 05:47:11 am
Re: FA won't close fiscal year (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 06/02/2016 05:34:28 am
Re: FA won't close fiscal year (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 06/01/2016 07:53:29 am
Re: FA won't close fiscal year (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.
991 05/17/2016 10:43:13 am
Re: Where are translations for "Top $limit....." in FA 2.4? (3 replies, posted in Translations)
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.
992 05/17/2016 10:41:16 am
Re: Front Accounting and ERP Expert (4 replies, posted in Jobs wanted/offered, non-free offers)
@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.
993 05/17/2016 10:35:14 am
Re: problem logging in as admin after installation (5 replies, posted in Installation)
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 05/17/2016 10:33:25 am
Re: Vat Inclusive Price (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.
995 04/26/2016 07:53:52 am
Re: Disable input or change some objects in customer invoice (2 replies, posted in FA Modifications)
you can call this function by adding last parameter `true`, than it will be disabled. Try it.
996 04/26/2016 07:52:44 am
Re: Disable input or change some objects in customer invoice (2 replies, posted in FA Modifications)
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 04/21/2016 05:20:57 pm
Re: New UI For Frontaccounting (12 replies, posted in Announcements)
Sorry i was busy with some other projects.
here you can get it .
998 04/06/2016 09:08:09 am
Re: F.A Get Hangs/Freeze (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 03/20/2016 04:24:45 am
Re: F.A Get Hangs/Freeze (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 03/15/2016 09:24:36 am
Re: Error on using NewWave theme (1 replies, posted in Report Bugs here)
it seems, some of your files are deleted from the installation. Where you updated manually or automatically.