4,801

(8 replies, posted in Items and Inventory)

You can set the AR account in the Customers Branch to a cash account instead of the AR account. But you shouldn't do allocations on it. But this is an ackward solution. You end up with wrong customer balances.
It will work, however, if you use the normal AR Account, and immediately afterwards make a deposit (or daily), and allocate the deposit for the invoice(s).

Joe

You point out something here. We will have an internal discussion about this. Could you probably use a dimension for a Location to keep track of it?

/Joe

4,803

(1 replies, posted in Setup)

There are links to 0_gl_trans from Customer Transactions, Supplier Transactions, Item adjustments etc. You will not be able to follow these links if you delete the GL trans.
You can see in the ER Diagram which tables are related. It can be found on the download document page.

/Joe

Hello again,
The account for the product over-writes the branch account for sales.

/Joe

We will have a closer look into this.

Strange with the Date Picker. We haven't heard of problems here before.

Which release are you running?

/Joe

4,806

(8 replies, posted in Items and Inventory)

Hello,
It turned out to be difficult to move this item, but ti doesn't matter. Most visitors are looking in most forums, after all.
I don't think it will be that much work to write such a module. The only problem I see is, that we do not have the resources internally to do this. Maybe there are some skilled developers out there that are interested. Hopefully.

/Joe

Hello Alvin,
We have been involved in developing Accounting Systems for a long while, both for small companies as well as medium scaled companies. We have used both approaches. With both buy rates and sell rates and with only one rate. When you end up in your accounting you get some currency exchange costs and income, but overall your accounting shows you the outcome of your company. We really don't think it is a big deal to keep it so detailled.
We don't show the currency symbol, because we don't know if this field is available, but we show the ISO abbreviation (USD, GTQ). in the documents as we also shows which currency that are presenting in the inquiries.

Joe

Yes, you are right regarding the accounts, we will look at this during the RC period.
Rasmus, the search boxes in the BP selections are only used if you check the 'no_customer_list' or 'no_supplier_list' in the company setup. It's there if you have more than, let's say 100 BP's. Then you have the option to enable the search boxes.
Otherwise it works just like a normal listbox.
Hopefully we can publish the RC1 tomorrow. We have had some work to fix the Ajax stuff.

/Joe

4,809

(3 replies, posted in Report Bugs here)

Yes, we are currently fixing some late bugs. So the RC1 is postponed a while when fixing this.

/Joe

4,810

(2 replies, posted in Setup)

Hello Rob,
You could also just enter the budgets for the first month in very 4:th month. F.i. January 20000, May 15000, September 25000 (= total year 60000).
If you use the same periods in the P/L you get it right!

/Joe

4,811

(1 replies, posted in Report Bugs here)

Please do a new cvs update. This was fixed about 11 hours ago.

/Joe

4,812

(2 replies, posted in Translations)

Hello Bibi,
It should be sufficient to save the language in the User Setup (Display Setup is only running during the session and nothing is saved to the database).
Then logout and login again. This way the language should change.

What language are you translating to?

/Joe

4,813

(2 replies, posted in Setup)

Hello Rob,
We are about testing the version 2.0. We still have some items to fix, but stay tuned. It will be released as soon as we got these items fixed.
We do not have plans to change the DB further. If so, it will be found in a alter2.sql file. These alter files can be run by a utility, called update_db.php in the root folder.

/Joe

4,814

(11 replies, posted in Translations)

Hello Héctor,
Yes, please send me the files as an attachment. I will then prepare them for download. When the 2.0 Beta is finally released I will also put the downloads on the Website download page.

/Joe

4,815

(11 replies, posted in Translations)

Hi Héctor,
For FA 2.0 Beta you should use the one that is at the download section at https:/sourceforge.net/projects/frontaccounting. It is located under frontaccounting-languages. You have to expand the versions.
The MO file is automatically created when you save the project to PO file in poEdit.
This es_MX2 that is on sourceforge is based on version 1.16 but all the new strings are extracted, ready to translate.
I am not aware of anybody translating to Mexican at present.

/Joe

4,816

(4 replies, posted in Setup)

I've seen this error before, but can't recall what the problem is. Why do you have to change this? It is normally only needed when running Windows IIS. Maybe someonw out there can help us. I don't have the time to investigate this at present.

/Joe

4,817

(4 replies, posted in Reporting)

Well, I guess this is a special size of paper, that is not supported by our PDF routines. It would require an add-on module, I guess. Maybe some other has a comment on this.

Joe

4,818

(1 replies, posted in Report Bugs here)

Hello,
In comfig.php there is a variable, $go_debug. Set this to 1, this will eventually show you what the problem is. Otherwise, look in the apache_error.log. Here you also can get some additional hints of what is wrong.

/Joe

4,819

(3 replies, posted in Reporting)

At first I thought that you had the $go_debug flag set to 1 in config.php, but you say when running in English you have no problems. I am not that good at farsi, can anybody with this experience please help.

/Joe

Hello alvin,

There is a file in the sql folder called alter.sql. At the top it should contain 2 ALTER TABLE statements, the first one is the company table, the other one is the sales_types table. You can run the script update_db.php which is in the root folder, and select this alter.sql file from your local computer. It will bail out after the 2 alter tables, which means that the rest already have been run. This is done for all your companies.

Best regards
Joe

4,821

(1 replies, posted in Report Bugs here)

The currency is fetched from The European Central Bank, and not all currencies are here. In this case you should enter your rates manuelly.

/Joe

4,822

(27 replies, posted in Dimensions)

Yes you can, and this is the purpose of dimensions. You can even track this in a two dimensional way, like cost centres inside departments, should that be needed. Default FrontAccounting can be used with one level of dimensions, but in the setup tab, company setup this can be set to 0, 1 or 2 levels.

/Joe

While you can create unlimited companies, uou can only use FA for one legal company unit with one Tax Id. If you want to keep track of sub-units like departments, cost-centres, projects or such like, you can use FrontAccountings dimensions. There is more information in the Dimension forum about how to use these.

/Joe

4,824

(4 replies, posted in Manufactoring)

Again, the GL transactions are created on delivery and invoicing. Up to this point there are no GL transactions created, unless you have set additional costs either on the Work Order or the Item. There is really no added values in the inventory account for the assembled item.
So all the neccessary GL transactions will be done on delivery and invoicing.

/Joe

4,825

(13 replies, posted in Wish List)

At present we search on Item ID, Category or Description (part or all). This is when the No Item List is checked in the Company Setup. We have no fields for SKU or barcode either at present. Do anybody else need this? We are open for discussion.

/Joe