Yes, the CVS Main trunk was updated yesterday. Affected file /admin/backups.php
/Joe
4,377 05/27/2009 07:15:52 am
Re: Balance sheet not formated according to IFRS and IAS (43 replies, posted in Reporting)
Strange, I have just looked at it at sourceforge.net. Release 1.194 of Main trunk is dated 26.05.2009. The files were uploaded yesterday.
Regarding the minus sign it is implemented in 2.2 unstable, due to we had to make an option in the classes on how to present the sign in BS and PL.
The 2.1 and 2.2 are not merged yet. The latest merge into 2.2 was with the release 2.1.2.
The sign setup can then be set as default in the COA when creating new companies.
We are planning to skip a release 2.1.3 soon, where the sublevel presentation will work.
/Joe
4,378 05/27/2009 07:06:00 am
Re: GL Account created by admin not available to accountant (2 replies, posted in Banking and General Ledger)
It seems to be also a bankaccount you have created. If so, it must be entered by Bank payment/deposits. Only admin has access to the bank accounts in Jornal Entry.
/Joe
4,379 05/27/2009 07:03:36 am
Re: Will FrontAccounting do this... (4 replies, posted in Setup)
It seems that you are a lucky man. FA manage all that. So dive into it and look for yourself.
/Joe
4,380 05/26/2009 04:14:01 pm
Re: Release 2.1 - Recurrent Invoices. How to? (31 replies, posted in Accounts Receivable)
I will have a look at this asap.
/Joe
4,381 05/26/2009 04:12:32 pm
Re: "wrong" selection returns empty PDF's (3 replies, posted in Report Bugs here)
This is a smart feature. Often you want to print the last invoices, so it is much easier to select them this way than scrolling all the way down, right?
/Joe
So this is a feature, not a bug!
4,382 05/26/2009 04:06:35 pm
Re: Balance sheet not formated according to IFRS and IAS (43 replies, posted in Reporting)
The correct sublevel presentation should now be working in reports COA, Monthly Breakdown, Balance Sheet and P&L Statements.
CVS Main (2.1.2) is updated. Look in CHANGELOG.txt for affected files.
/Joe
4,383 05/25/2009 03:31:48 pm
Re: expanding window (4 replies, posted in FA Modifications)
We currently stanp the backups as:
db-name_company-no_YYYYMMDD_HHMM.
The reason for this is some kind of security. Often clients download these backups and then it is easy to distinguise them from each other.
I would rather extend the fields a bit.
/Joe
4,384 05/25/2009 03:22:40 pm
Re: Setting Initial Stock, COGS, Balances etc (3 replies, posted in Setup)
1. Correct. You add the material value in the cost field and when saving the GL inventory is updated too.
2. Correct. You can enter this direct in the GL entry. But you will not get syncronised with the supplier ledger.
3. I guess it is better to setup your bank accounts and then use the GL Entry together with the rest of the Open Balance values. As an admin you have access to the bank-accounts also in GL Entries.
4. This is somewhat related to 2.
I guess there already exists a sticky topic on this but I can't really remember it.
Maybe somebody in the community that are a better accountant than me could give us some more ideas?
/Joe
4,385 05/25/2009 03:14:27 pm
Re: Item Adjustments (4 replies, posted in Items and Inventory)
It is taken from stock_master, material_cost + labour_cost + overhead_cost where material_cost is the average material cost. The other costs are often empty.
/Joe
4,386 05/25/2009 01:52:08 pm
Re: Can Dimensions be added later? (3 replies, posted in Dimensions)
Of course you can, Tom. But as you say, they will not be on any former transactions.
/Joe
4,387 05/25/2009 07:02:33 am
Re: The way of designing the general ledger , accounts , groups , classes (3 replies, posted in Banking and General Ledger)
No not exactly, but I am going to fix it today, so you can have multiple suplevels. There will only be a restriction that an account belonging to a type that is belonging to another type. A type that belongs to another type must belong to inside the same type no. F.i.
Type 10 Short terms assets Do not belong to another type
Type 12 Petty Cash. Belong to type 10.
Type 14 Cash Default Location. Belong to type 12.
Type 20 Long terms assets.
I hope you see the meaning of this. It is now reasonable simple to go through a level accumulating.
As I said, I will fix release 2.1.2 to manage this today. Hopefully it is ready during the day.
/Joe
4,388 05/23/2009 09:02:48 am
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
I don't understand why we can present the Excel export on the demo site (with Arabic Language) and you cannot. BTW the link you gave was broken.
Please, does anyone in the community have an explanation to this?
/Joe
4,389 05/23/2009 08:58:47 am
Re: Balance sheet not formated according to IFRS and IAS (43 replies, posted in Reporting)
Regarding the sign presentation, this is very different in various countries. Therefore we have fixed this in the next release, 2.2, that you can choose for yourself how the class should be presented in BS and PL statements.
Regarding the level of the retrieval of the accounts, you are right. We must include this sublevel too (if it is a sublevel of another group). We will have to change the SQL for this.
Thanks.
/Joe
4,390 05/23/2009 08:52:17 am
Re: Journal Entry start with No. 18 not No. 1 (1 replies, posted in Banking and General Ledger)
No, the problem is in the SQL script for a new company. The AUTOINCREMENT counter should start with number 1. I guess it states no. 18 now and this has to be changed ASAP.
/Joe
4,391 05/23/2009 08:50:00 am
Re: The way of designing the general ledger , accounts , groups , classes (3 replies, posted in Banking and General Ledger)
Hello,
I don't see the problem here. When retrieving the SQL it will only get the appropriate date. F.i. a Balance
sheet will only show accounts that are belonging to a group that are belonging to a class that are belonging to a balance sheet.
/Joe
4,392 05/22/2009 01:49:14 pm
Re: Setup:Maintenance: Attach Documents (3 replies, posted in Setup)
Yes, tom but this was on the wish list a year ago and we decided to implement it. One option was to scan supplier invoices. When processing a supplier invoice you are asked if you want to attach a scanned document.
But of course, you should be aware of the spce required.
/Joe
4,393 05/21/2009 08:50:17 pm
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
I hope you will find a solution. I'm afraid I can't help you with this. As you see it works on the demo server. The download filename is in English. I guess you will need some local expert help.
/Joe
4,394 05/21/2009 08:07:06 am
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
Fyi I just uploaded the last Arabic translations (also on sourceforge.net/projects/frontaccounting) from you to the Linux demo server . The Arabic language is set to utf-8. There is no problem downloading to Excel from here. If you have blocked for download, you may have to try twice to get the download. But no problems triggering the download.
Try for yourselves
/Joe
4,395 05/21/2009 07:17:12 am
Re: Exporting reports to excel when using Arabic Language failed (7 replies, posted in Reporting)
Hello, Yes you are right. It doesn't trigger a download. At present I have no idea of why.
I don't know if setting $go_debug in config.php would detect errors or warnings, but you could try. You will not see normal reports but the internal PDF code if you use $go_debug.
Please also try the alternative XML interface, that can be dwonloaded from the Website.
/Joe
4,396 05/20/2009 09:32:15 pm
Re: P&L Reports aren't filtering dimensions (9 replies, posted in Reporting)
When trying at the demo site, did you get the desired result?
There must be something here that is out of sync. Eventually try a new installation with a fresh downloaded setup installation from 2.1.2.
/Joe
4,397 05/20/2009 09:24:39 pm
Re: More controle accounts must be added to system and gl setup (1 replies, posted in Misc. Charts of Accounts)
infotechaccountant wrote:
there is some thing strange here , I know that there are some common practices when designing a software , one of them is the controlling accounts which is placed in system and gl setup windows , but really I surprised when I tried to make a new template for new company with new chart of accounts and some nominal accounts , when I opened the script related to my template I found that there is four accounts not mentioned there in the windows system and gl setup as the following:
1- Goods Received Clearing Account (1430)
2- Retained Earnings (2050)
3- Purchase Price Variance (4220)
4- Direct Labour (5000)why the developers not add those accounts to the windows of system and gl setup ?
These accounts were obsolete in release 2.1. Was original inplemented for future release. In release 2.2 some of them are used when closing fiscal years (automatic creating a balanced year). The Purchase price variance and the labour are not used at present.
infotechaccountant wrote:
what is the accounting cycle with the transactions ( must be published to know what is happening behind sense )
We are planning in future version to clean transactions when deleting fiscal years. Convert the deleted years transactions into Open Balances. Also cleaning other transactions.
infotechaccountant wrote:
what is the accounting system followed here is periodic inventory system or perpetual inventory system ?
if we are about manufacturing solution where is the costing methods of inventory like FIFO , LIFO , Weighted or Moving Average Method , Specific Identification Method ?
The Inventory system and the manufacturing solution are based on the average methods.
/Joe
4,398 05/20/2009 02:50:27 pm
Re: P&L Reports aren't filtering dimensions (9 replies, posted in Reporting)
It seems to me that something is out of sync. Please set the $go_debug flag in fonfig.php to 1. You will not see the report with this debug flag, but the internal PDF code. But eventually eooros or warnings will show up on the page.
/Joe
4,399 05/20/2009 10:33:56 am
Re: Module : Chequing Accounts & Cheque Issue / Print (10 replies, posted in Modules Add-on's)
Please set the $go_debug flag in file config.php. This well catch eventually errors or warnings.
/Joe
4,400 05/19/2009 08:51:17 pm
Re: P&L Reports aren't filtering dimensions (9 replies, posted in Reporting)
This should not be a problem.
Did you enter the correct period? Did you enter the dimension on a line with an income/costs type account?
Something must have been done wrong.
/Joe