In Purchase tab inactive item still on item description so user still do actions on them.
Pls Help,
1 06/10/2011 02:39:07 pm
Topic: inactive item still on picklist (0 replies, posted in Items and Inventory)
2 05/27/2011 02:15:54 pm
Re: Error when changing from Direct GRN to Direct Invoice (12 replies, posted in Report Bugs here)
I have the same issue too.
Janusz, you should do some action in/out for some time in direct Invoice form then the issue will be appear.
Thnks,
3 05/26/2011 06:33:26 am
Re: Attaching Documents (9 replies, posted in Wish List)
I got an idea
why do we attach file from all pages (I mean in In Sales invoice page, in general entry page, in bank payment page....) other than setup tab only so users can attach file easly.
Regards,
4 05/07/2011 03:16:00 am
Topic: c:\\wamp\tmp folder not empty when exit and make disk space full up (3 replies, posted in Report Bugs here)
I used firefox 3.6.17 and FA 2.3.4.
I have to delete these sess*** file in folder c:\wamp\tmp manuall even I exit FA already. These large file size make my Disk Space full up. I thought some wriong in session.inc maybe?
Is there any one who know how to solve this problem? Please help
thanks
5 04/18/2011 02:32:05 pm
Re: Problems with login (2 replies, posted in Installation)
i got the same issue and the erros log:
[18-Apr-2011 21:03:01] 0:admin:date_functions.inc:253: mktime() [<a href='function.mktime'>function.mktime</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Bangkok' for 'ICT/7.0/no DST' instead
[18-Apr-2011 21:03:01] 0:admin:date_functions.inc:262: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Bangkok' for 'ICT/7.0/no DST' instead
[18-Apr-2011 21:03:01] 0:admin:date_functions.inc:127: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier.
Please help,
Many Thanks
6 09/10/2010 02:12:33 am
Re: SQL script execution failed in line 4: Table 'frontaccount23.crm_users (3 replies, posted in Installation)
Dear Janusz,
I ignored the message as you said but it all doesn 't work normally. the message on all pages:
"System is blocked after source upgrade until database is updated on System/Software Upgrade page"
What should I do next?
7 09/09/2010 10:44:32 am
Topic: SQL script execution failed in line 4: Table 'frontaccount23.crm_users (3 replies, posted in Installation)
I got this message while upgrading:
"SQL script execution failed in line 4: Table 'mydatabase.crm_users' doesn't existDatabase upgrade to version 2.3 failed for company 'My company.'.
You should restore company database from latest backup file"
Then I try force upgrade and the result is:
"SQL script execution failed in line 54: Table 'mydatabase.company' doesn't existDatabase upgrade to version 2.3 failed for company 'My Company.'.
You should restore company database from latest backup file"
I upgrade from 2.3 beta to 2.3 RC1,
Please help,
Thanks,
8 08/12/2010 04:55:30 am
Topic: Customer Credit note entry: SQL syntax error (1 replies, posted in Accounts Payable)
DATABASE ERROR : The debtor transaction detail could not be written
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0')' at line 6
sql that failed was : INSERT INTO 0_debtor_trans_details (debtor_trans_no, debtor_trans_type, stock_id, description, quantity, unit_price, unit_tax, discount_percent, standard_cost, src_id) VALUES ('4', '11', '102', '17inch VGA Monitor', 1, 26.42, 2.4571, 0, ,'0')
I am using ver. 2.3 beta.
How do i fix this?
Many Thanks.
9 08/12/2010 04:52:08 am
Topic: foreign currency amount in Supplier Transaction Inquiry is not correct (1 replies, posted in Accounts Payable)
I am using ver. 2.3
I have an bank account payment entry:
CD bank account: 25,022,000 vnd
DB Payable account: 25,000,000 vnd.
DB bank fee: 22,000 vnd.
I pay in USD with Ex. rate of 19,100 vnd = 1 usd.
When I check Supplier Transaction Inquiry
amount is presented in usd is calculated by this way: 25,022,000/19,100= 1310.05 usd.
Correct answer must be: 25,000,000/19,100= 1308.9.
I posted this issue on Mantis but no reply so I have to post in this forum.
Please tell me when Mantis is available. Thnks,
10 08/05/2010 10:16:19 am
Re: amount display in journal inquiry is double when edit an entry (3 replies, posted in Banking and General Ledger)
http://next.frontaccounting.eu/gl/view/gl_trans_view.php?type_id=1&trans_no=14
http://next.frontaccounting.eu/gl/inquiry/journal_inquiry.php?
Please compare them.
I found that did not happen with Journal Entry
Brgds,
11 08/03/2010 01:54:28 am
Topic: amount display in journal inquiry is double when edit an entry (3 replies, posted in Banking and General Ledger)
Using ver. 2.3
when I edit journal entry, ok for GL but it's amount that display in journal inquiry is doubled, the same for memo. content in view panel.
Thanks in advance.
12 07/30/2010 03:51:23 am
Topic: Current Credit amount is not match (1 replies, posted in Accounts Receivable)
Current Credit amount in Direct Sales Invoice module is not match to amount in customer inquiry
Please compare 2 link:
http://next.frontaccounting.eu/sales/inquiry/customer_inquiry.php?
http://next.frontaccounting.eu/sales/sales_order_entry.php?NewInvoice=0
using 2.3 beta
13 07/30/2010 03:42:01 am
Topic: ver. 2.3 edit invoice error (1 replies, posted in Banking and General Ledger)
when i try to edit Sales Invoice in 'Journal Inquiry' tab, the bug is bellow:
DATABASE ERROR : document version retreival
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
sql that failed was : SELECT trans_no, version FROM 0_debtor_trans WHERE type='13' AND ()
this is a link to see this bug in demo version.
http://next.frontaccounting.eu/sales/customer_invoice.php?ModifyInvoice=33
How can i do to solve this.
Thanks,
14 07/06/2010 03:10:19 am
Topic: Sales and COGS of service Item is not found in inventory report (1 replies, posted in Items and Inventory)
Dear Project admin,
I create a inventory item and define it as service in "Item type" and do some sale on it. But I could not find it's Sales and COGS in Inventory Sale report or any other inventory report. Do I skip some steps? or Do I have to use dimension instead of doing this way.
Please show me how to solve this issue.
Many Thanks,
15 06/08/2010 10:17:02 am
Re: report in excel error (7 replies, posted in Banking and General Ledger)
Dear Joe,
What are various decoding functions in PHP? Could you show me so that i can try one by one please, because i am not good in coding.
Is there some way else to solve this?
Thanks
16 06/08/2010 07:48:50 am
Topic: report in excel error (7 replies, posted in Banking and General Ledger)
I run report to pdf is ok, but not for excel (contain unreadable characters), I used utf-8 for Vietnamese. Strange that it did well some day ago. but not now.
Please help.
I can send you the excel report sample but don't know what support email to send.
17 06/05/2010 02:28:51 am
Topic: exchange rate retrieve from google is not correct (1 replies, posted in Banking and General Ledger)
Dear Admin,
Iam newer of FA, I am trying apply FA for my Vietnamese company and I have issue with exchange rate:
1) I can not input exchange rate as typing 1/19000 at exchange rate then I only typing 0.0000526316 instead of 0.0000526315789473684. As you know exchange rate of VND against USD is very low and have much of decimal length.
2) When I retrieve ex. rt. from Google ( I set exactly some line as your guide) and the result of ex. rt. equal 10,000.00000000010004441720. It is not correct.
Could you please show me how to fix that.
Many Thanks