4,001

(9 replies, posted in Setup)

Hello Chaitanya,
I haven't tried this myself, so I can not advise very much in this matter. Maybe Janusz or somebody else can help us.

/Joe

Hello Kalido,
We are looking into this. Will be fixed soon. We are short of developers right now, but early next week it should be fixed.

/Joe

Is the system locale, in_id.utf-8, installed on your server?

/Joe

4,004

(3 replies, posted in Accounts Receivable)

When your customers send you a payment (or you send payments to suppliers), you don't need to (but you can) allocate the payments at once. Allocations means routing the payments to various invoices.
So you can accumulate the payments and when there are funds enough you can allocate your invoices.

/Joe

4,005

(8 replies, posted in Report Bugs here)

Yes you are right that the tax system is somewhat complex due to differencies in various legislations. However, FA is flexible enough to handle them all. Before setting up your tax system you should ask an expert for help if you have any doubts.

I will not tell about all the rules around the Globe. It would require several pages of explanation without being complete.

/Joe

Ah, I was sure it worked here. I tested it in Items and it worked here.
I tried to implement it in /includes/ui/ui_list.inc for Sales Order/delivery/invoice to test if there were side-effects when entering Sales Kit codes or Foreign Item Codes (bar codes or so). It wasn't, so the change is going to release 2.2.2. If you need it now you can download a copy of /includes/ui/ui_lists.inc from the CVS Main repository.


/Joe

You can also search for fragment of a Category to only get items with these category(ies)

Very powerful.

/Joe

Please download the file once again from the Website. the download file has been replaced.
The problem was that there were 2 javascript windows with the same name. This is now fixed and it works ok again.
The file creating the error was repgen_create.php

/Joe

4,009

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

Please download the file once again from the Website. the download file has been replaced.
The problem was that there were 2 javascript windows with the same name. This is now fixed and it works ok again.
The file creating the error was repgen_create.php

/Joe

The security areas are defined in /includes/access_levels.inc. Because of a new security system implented in 2.2 we have to support a small file with one or more security area, depending of differences in access-levels.
And you also need to place a function call in all *.php files that has a $page_security set. This function is called:
add_access_extensions();
This should be placed after the include of file /includes/session.inc

But you can also just wait a couple of hours. I am about to upload the Report Generator and the Check Print fascility for release 2.2 to the Website, download section.

/Joe

I think it needs some fine-tuning, but not sure. The new access-roles has to be considered too.
We don't have resources at present to update it. Maybe you can help.

/Joe

4,012

(1 replies, posted in Accounts Receivable)

You have established the search fascility on the company. If you don't want this you can unmark this in company setup. Unmark 'Search Item List', 'Search Customer List' and 'Search supplier List'. After that the cusomers, Items and suppliers appear again.
If you have the search fascility established, you can get all the items by pressing a space in the item list and then a * and tab. Then you get all the items. You can also press the first characters or som other matching characters then you will only get the items that matches the search.
These search lists are more for those having a bunch of customers/items/suppliers.

/Joe

4,013

(1 replies, posted in Setup)

If you don't want this to print, you will have to use a text-editor and enter the file /reporting/includes/pdf_report.inc.
Search for the member-function Info($params, $cols, $headers, $aligns, ...
Inside this function there is a member variable called $this->host = $_SERVER['SERVER_NAME'];
Replace this with $this->host = "what-ever-you-like" or just an empty string "".

If you use the excel reports, do the same thing in excel_report.inc.
Remember to backup your files, if you later update FrontAccounting. Then you can easily update this again.


/Joe

The standard costing is the average purchase price over time.

/Joe

4,015

(4 replies, posted in Items and Inventory)

Yes, there is a table, called X_loc_stock, where X stands for the table prefix.
This table will give you the re_order levels for a location and a stock id. You can do a join with the X_stock_master table to get the stock name as well.
Example
SELECT * FROM 0_loc_stock WHERE stock_id='XXXXXX'. If you only have one location, you don't need to select this.
And you can put a name from the stock master
SELECT 0_loc_stock.*, description FROM 0_loc_stock, 0_stock_master WHERE 0_stock_master.stock_id='XXXXXX' AND 0_loc_stock.stock_id=0_stock_master.stock_id.
And so on.

/Joe

The invoices are presented in decreasing order with the Customer name in the list.
Another way of easily finding the customer invoice, is in Customer Transactions. Select the Customer here, and print the invoice directly.

/Joe

4,017

(4 replies, posted in Items and Inventory)

No, not really. There is an on screen report. But there are 2 other reports that give you a good view of your stock.
The Inventory Planning Report and Stock Check Sheet.

Also remember that you can setup so emails are going to the stock location if stock is below reorder level.
In config.php about line 104, change this value to 1:

    $loc_notification = 0;

Put an email on the stock location in Items and Inventory, and the location gets an email if stock is below reorder level.

/Joe

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

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

4,020

(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

4,021

(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

4,022

(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

4,023

(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

4,024

(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

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



/Joe