4,026 Reply by joe

(7 replies, posted in Banking and General Ledger)

I guess you already have observed that an account belongs to a group (type). A group (type) belongs to a class.
Depending on how your country wants to present the balance sheets and profit and loss statements, you can build these rules with help of groups (types) and classes.

When a balance sheet is printed it is sorted on 1. class, 2. group(type) and last the account itself.
As you see the accounts are not necessarily printed out in account number order.
First the Title for the first Class is printed, Then the Title for the first Group is printed. Then the accounts within this group are printed. When a new group is coming, the totals within the old group group is printed before the title of the next group is printed.
The same thing happens when a new class is coming. The total for the old class is printed and the title of the new class is printed and so on.
By arranging the groups you can present your balance sheets and PL statements your own way.
By also using sub-groups (a group belonging to another group) you can create even more sophisticated aggregators. But this is more acvanced.

This sticky topic explains how you make a rearrangement of new groups and classes, should you need more space between the group/class id's.

/Joe

Go to forum: Banking and General Ledger

4,027 Topic by joe

(0 replies, posted in Banking and General Ledger)

While we still use ECB as our stable exchange rates provider, we are, however, avare of that the coverage is not good for South America, Africa and Asia, so we have implemented it so that it is possible to swap provider.
In CVS Main, a file called /gl/includes/db/gl_db_rates.inc has been updated so it is possible to use YAHOO or GOOGLE instead of ECB.
Both YAHOO and GOOGLE have almost all currency rates in the world. These changes are going to release 2.2.2, but if you want this to be available in your 2.2 you will have to download this file from the CVS repository.

And you will have to create the following locale.inc file and place it in the /lang/xx_YY folder, where xx is the language and YY is the country. F.i. en_US.


<?php

class Hooks {
    function retrieve_exrate($curr, $date)
    {
        return get_extern_rate($curr, 'YAHOO', $date);
        //return get_extern_rate($curr, 'GOOGLE', $date);
    }
}

?>

This will use YAHOO instead of ECB. Comment the YAHOO line and uncomment the GOOGLE line if you want to use GOOGLE instead.
We do not guarantee that the currency rates are provided correctly, but I guess this is better than nothing for countries not served by ECB.

/Joe

Go to forum: Banking and General Ledger

4,028 Reply by joe

(7 replies, posted in Wish List)

Hello cenc,

We still use ECB as our stable exchange rates provider, however, we are avare of that the coverage is not good for South America, Africa and Asia, so we have implemented it so that it is possible to swap provider.
In CVS Main, a file called /gl/includes/db/gl_db_rates.inc has been updated so it is possible to use YAHOO or GOOGLE instead of ECB.
Both YAHOO and GOOGLE have almost all currency rates in the world. These changes are going to release 2.2.2, but if you want this to be available in your 2.2 you will have to download this file from the CVS repository.

And you will have to create the following locale.inc file and place it in the /lang/xx_YY folder, where xx is the language and YY is the country. F.i. en_US.

<?php

class Hooks {
    function retrieve_exrate($curr, $date)
    {
        return get_extern_rate($curr, 'YAHOO', $date);
        //return get_extern_rate($curr, 'GOOGLE', $date);
    }
}

?>

This will use YAHOO instead of ECB. Comment the YAHOO line and uncomment the GOOGLE line if you want to use GOOGLE instead.
We do not guarantee that the currency rates are provided correctly, but I guess this is better than nothing for countries not served by ECB.

/Joe

Go to forum: Wish List

4,029 Reply by joe

(7 replies, posted in Wish List)

If other sources have the option to deliver exchange rates via some kind of service (xml) and with more currency rates to deliver than ECB it will certainly be of interest for us. Will you check this for us, please?

/Joe

Go to forum: Wish List

4,030 Reply by joe

(27 replies, posted in Dimensions)

Please, sajjad, it has been explained both here and in the setup forum. Please read it ones more. If you still don't get a habit of it, maybe you just don't need them now and you can wait until you need them. You can switch them of in company setup.

/Joe

Go to forum: Dimensions

4,031 Reply by joe

(2 replies, posted in Setup)

If it is a new install of FA you can choose to not populate the database you create at the beginning of the install.
If you create a new company, you can choose en_US-new.sql instead as chart of accounts when you create a new company.
It is too time consuming to get rid of the demo data, because it is tied together so much.

/Joe

Go to forum: Setup

4,032 Reply by joe

(11 replies, posted in Setup)

If you have a new company (no transactions) where the fiscal year is ranging from 01 jan 09 to 31 dec 09 and want it to be a fiscal year from 01 July09  to ??? you will have to first create a fiscal year 01 jan 08 to 31 dec 08 and set your company to use this year.

Delete the fiscal year 01 jan 09 to 31 12 09. Now you have to create a 'dummy' short year from 01 jan 09 to 30 jun 09. And now your correct new fiscal year from 01 july to ???.
After you set this new year on your company, you can delete the earlier unwanted fiscal years if there are no transactions here.

The reason for these operations is that there must be no gaps between the fiscal years.

/Joe

Go to forum: Setup

4,033 Reply by joe

(5 replies, posted in Report Bugs here)

Hello Alvin,
Please read this topic. You might find some info here.



/Joe

Go to forum: Report Bugs here

4,034 Reply by joe

(7 replies, posted in Reporting)

We are working on a complete new report extension manager, but you will have to wait until release 2.2.2 at least for this.
In the mean-time you can copy the report rep706.php into the folder /company/X/reporting where X stands for the company number.
If there is a rep706.php (or any other report) here, FA will select this instead of the ordinary ones. Then you can experiment.
But again, wait with serious reporting until we are ready with this new extension.

/Joe

Go to forum: Reporting

4,035 Reply by joe

(5 replies, posted in Setup)

Check that these variables are there too:

$def_coy = 0;

$tb_pref_counter = 2;

The $def_coy tells which company should be presented as default when logging in. The $tb_pref_counter is the next prefix to use in front of the tables.

/Joe

Go to forum: Setup

4,036 Reply by joe

(3 replies, posted in Modules Add-on's)

I am not sure if these modules are up to date. It says that there is a new release for 2.1, but. You may try and if it doesn't work, you can uninstall it again.
You are right. In 2.2 the menu is Install/Activate Extensions. You use this for installing.

/Joe

Go to forum: Modules Add-on's

4,037 Reply by joe

(3 replies, posted in Dimensions)

Yes, just put them on the transactionline in that order you want the end results. Remember there are only the head account, then level1 dimension and then level2 dimension. You can always take reports for a dimension isolated, but by having the level1 you can keep track of a department or so. Level1 is higher in the organization. You can only select level1 and no level2 filter, or you can select level1 and a level2 filter.
Later in the 2.2.X history we are also introducing the account and dimension tags to filter reports even more. Exciting!

/Joe

Go to forum: Dimensions

4,038 Reply by joe

(3 replies, posted in Dimensions)

You have to manuelly take care of the using of level 1 and level 2. You may help yourself by naming them accordingly.

/Joe

Go to forum: Dimensions

4,039 Reply by joe

(4 replies, posted in Installation)

Often when problems sounds weird, it helps emptying the browsers internet cache. Empty everything and start up again.
And do not have 2 instances of FA running on the same computer.

/Joe

Go to forum: Installation

4,040 Reply by joe

(8 replies, posted in Installation)

Often when problems sounds weird, it helps emptying the browsers internet cache. Empty everything and start up again.
And do not have 2 instances of FA running on the same computer.

/Joe

Go to forum: Installation

4,041 Reply by joe

(25 replies, posted in Items and Inventory)

Thanks Chaitanya for pointing this out. Will be fixed and committed to CVS Main ASAP.

/Joe

Go to forum: Items and Inventory

4,042 Reply by joe

(25 replies, posted in Items and Inventory)

Hello chaitanya,
When you are entering the purchase order, the items and price are in our meassures. Internally the purchase orders are following our standard, but if you print the purchase order, you will see it converted into the suppliers quantities and meassures.

/Joe

Go to forum: Items and Inventory

4,043 Reply by joe

(7 replies, posted in Reporting)

Hello,

1. Achieved stands for how much column 1 has reached column 2 in percent.
2. YTD stands for Year To Day

/Joe

Go to forum: Reporting

4,044 Reply by joe

(3 replies, posted in Report Bugs here)

This is now fixed in CVS Main repository on https:/sourceforge.net/projects/frontaccounting.
Affected file /reporting/includes/header2.inc

When printing of documents and the global variable $print_invoice_no is set to 0, then the reference number is printed instead of the internal number. The refer to deliveries and sales orders also print reference numbers now.

/Joe

Go to forum: Report Bugs here

4,045 Reply by joe

(2 replies, posted in Report Bugs here)

Fixed in CVS Main repository on
Affected file /admin/company_preferences.php

/Joe

Go to forum: Report Bugs here

4,046 Reply by joe

(2 replies, posted in Report Bugs here)

Thanks for pointing this out. Will be fixed asap.

/Joe

Go to forum: Report Bugs here

4,047 Reply by joe

(3 replies, posted in Report Bugs here)

I guess you are right. If the global variable $print_invoice_no is 0 in config.php then the references are printed instead of the internal numbers. This is the fact for both sales orders, delivery notes, invoices and credit notes.
We have, though, a small problem when creating direct invoices. These creates deliveries with the reference 'auto'.
I will have to correct it so it prints correct reference numbers when the $print_invoice_no is set to 0. And when the reference is 'auto' the field should be empty.

/Joe

Go to forum: Report Bugs here

4,048 Reply by joe

(2 replies, posted in Reporting)

You can find more info about FrontAccounting Wiki in the Announcements Forums.

/Joe

Go to forum: Reporting

4,049 Reply by joe

(3 replies, posted in Reporting)

Check the Display Setup (or Preferences) that the printing support is set to Browser Printing Support (It might have been set to a printer by mistake). These printers will only work with network printers.
The Browser Printing Support uses a PDF reader for presenting the reports. They can be printed from here.

/Joe

Go to forum: Reporting

4,050 Reply by joe

(9 replies, posted in Translations)

Hey, did you miss the info in the Announcement Forum regarding FrontAccounting Wiki?

/Joe

Go to forum: Translations