I think that an opening balance at the first line is a good idea. I don't think that one more line is a problem
2 04/30/2009 12:44:01 pm
Re: Customer / Supplier Balances (7 replies, posted in Reporting)
Hello
I have a problem in the Supplier balance report. It shows invoices or payments from previous fiscal year.
Is it possible to restrict the list to the current fiscal year?
3 04/03/2009 10:03:49 am
Re: table item_codes (4 replies, posted in Installation)
I think that I've found the problem. One of my old item descriptions in table stock master contains (') symbol.
I changed it and it works.
Thanks
David
4 04/03/2009 09:40:30 am
Re: Lost of bank transaction history after update to 2.1 from 2.0 (3 replies, posted in Installation)
After force upgrade it works!
Thanks
I've previously executed the alter2.1.sql script but I did not think that the homonymous php file contained all the scripts for data migration from old to new tables.
Sorry for that
David
5 04/03/2009 09:22:37 am
Re: table item_codes (4 replies, posted in Installation)
I got this error when force upgrade
SQL script execution failed in line 66: Incorrect table definition; there can be only one auto column and it must be defined as a key
Cannot insert stock id into item_codes
6 04/02/2009 08:18:20 pm
Topic: Lost of bank transaction history after update to 2.1 from 2.0 (3 replies, posted in Installation)
Hello
After updating to last version, the system cannot retrieve the data of bank_trans table. You can see this when displaying bank statements.
Any fix?
David
7 04/02/2009 08:00:49 pm
Topic: table item_codes (4 replies, posted in Installation)
Hello
I've been upgrading FA from version 2.0 to 2.1 AS the table item_codes is new, i've lost all the items that i've previously created. They are in table grn_items.
Is there any sql statement to fill up the new table item_codes using the data of grn_items and grn_batch?
Thanks
David
8 03/26/2009 03:20:25 pm
Re: Frence fr_FR (4 replies, posted in Translations)
hello
I have translated front accounting for french up to 80% for 2.1 and 2.0.X
The remaining texts are long error messages or production-related
You can print french sales invoices without problems.
I can send it to you or tell Joe to publish my partial transalation
David
9 09/22/2008 12:42:58 pm
Topic: Add permanet text to forms (1 replies, posted in Wish List)
Hello
I need to put some legal infomation in all my invoices. Something like what hapens if my customer don't pay my invoices in time, etc.
Today I have to put each time the text as a comment when I print the invoice.
It should be time saver if I can put the text globaly by company or by customer and then get the text in the invoice.
10 07/31/2008 01:51:52 pm
Topic: Asset Accounting (1 replies, posted in Wish List)
Asset accounting is a mayor accounting task each month or year. A lot of taxes are involved.
A asset is like an expensive long-life item that can be depreciated following certains rules.
Two mayor types are needed: Asset under construction and final asset. Only the final assets are depreciated.
An asset has a period of life of 2 or more years.
Each asset needs :
- a balance account for the first expense or investment,
- another balance account to track the depreciations done each period and
- a third account (profit and lost) to track the expense of each month/year.
At this moment, I don't have to follow a lot of assets using Front accounting. For each asset I have to do all the calclations manually and enter the results as journal entries.
Thanks for your help
David
11 07/31/2008 01:36:04 pm
Topic: GL dimensions (1 replies, posted in Wish List)
Hello
If you link a GL account or item to a given dimension and then you enter an invoice item, you have to select once again the corresponding dimension.
It should be friendly if the dimension linked to the gl account commes automatically selected.
Thanks
David
12 06/16/2008 10:12:13 am
Topic: Customer's Purchase Order réference in our Invoices (1 replies, posted in Reporting)
Hello
I think it will be very usefull to everyone if you include the customer's ref purchase order (stored in our sales order) in the sales invoice report.
It helps our customers to retrieve their purchase order and allocate our invoice.
Is it possible?
Thank you
David