I think that you guys means different things here.
Khaled wants a combo selector where he only wants to see the accounts belonging to an expanded type (group) for easier selection, especially if the COA is very big.
And you Chaitanya wants a drill down BS or PL.
Both whishes seem to be fair. Only that the link you presented, Khaled, contains source that are proprietary (not open source).
We will have to rely on our JS expert, Janusz. Maybe he can find someting useful. Unfortunately he is very overloaded with business at present.
Maybe we can move this discussiont to the FA Wiki, Developers section, Wishlist and future development directions for next major releases.
We could then set the planning to go into release 2.3.

This discussion will be inside the current discussion.

/Joe

On a costumer / supplier you can set a prompt payment percent. If the customer has a 2 percents deduction and he pays let us say $98 instead of expected $100 for an invoice. You will see in the Customer Payment that the customer has a 2% deduction. You can now decide to set the payment to $98 and the discount to $2. Btw. you can always do this operation despite the discount set on the customer.
The total amount of $100 is going into the accounts receivable, but only $98 into the bank account. The $2 is going into the account for customer prompt payments.
The same thing happens on the Supplier Payment, only the other way around.

/Joe

I think this is a brilliant idea. Starting with the classes. Then the groups (types), Then the accounts and finally the transactions (with an option to look at the Journal Entry).
It could, as you say, be done in two parts. A BS and a PL.
I guess we need some kind of a Javascript helper to do that, right?

/Joe

4,004

(4 replies, posted in FA Modifications)

Hello Chaitanya,
The ability to edit SO even after an invoice is created was implemented some time ago and was done by Janusz. So far there haven't been reported any problems with this, but let us hope that Janusz will comment on this too.

/Joe

4,005

(1 replies, posted in Setup)

If the addon's are to be used in release 2.2.X then you must follow the new syntax. You should download some of the more simpler modules like accruals22.zip to see how they are built. It is quite simple and by using the new access roles it is easy to setup the addon's for existing and new users of the company.

/Joe

4,006

(2 replies, posted in Reporting)

This issue was related to the module 'Report Generator'. A new version has been uploaded to the Website - Download - Modules section.

/Joe

This issue has been fixed. CVS Main repository updated. Affected file /purchasing/po_entry_items.php

/Joe

4,008

(7 replies, posted in Setup)

In Setup tab, Install/Update Companies, you can set the default company. Then this company will always be default in the listbox when logging in.

/Joe

4,009

(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,012

(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,013

(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,017

(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,020

(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,021

(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,023

(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,025

(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