4,476 Reply by joe

(5 replies, posted in Items and Inventory)

Sorry henry,
Wrong name for the table. It should be X_stock_moves, where X_ is the table prefix. If this is your only company, then it could be 0_stock_moves.

/Joe

Go to forum: Items and Inventory

4,477 Reply by joe

(23 replies, posted in Misc. Charts of Accounts)

Hello Pete,
Please use joe (dot) hunt (dot) consulting (at) gmail (dot) com. Sorry, I am a little afraid of email harvesting.

Regards
Joe

Go to forum: Misc. Charts of Accounts

4,478 Reply by joe

(14 replies, posted in FA Modifications)

Thanks Tim,
I was just about to write something similar, but have asked my partner, Janusz, to do it instead. I had the same feeling as you have. Yes, I have the feeling too, that we both push forward the cause of open source. Nice to hear that we are on the same wavelength. I also think that the clients should examine the projects extensively before planning to do something dramatic.

/Joe

Go to forum: FA Modifications

4,479 Reply by joe

(5 replies, posted in Report Bugs here)

OK, but I think the way it is implemented is more correctly. You are selling the same items / services to a bunch of people. It is up to you to place the correct sales groups on the branches and check that the correct sales types are used or accept the differencies.

/Joe

Go to forum: Report Bugs here

4,480 Reply by joe

(1 replies, posted in Installation)

You can only create new companies when you are logged in as Administrator on the first company you created (super admin).
When you create a new company, you enter the Company name, the database details, choose a script (chart of accounts etc) from sql folder, and in the last text box you enter the password for the admin user (as it says). This admin user is created automatically.
You can later create other users for the company.

/Joe

Go to forum: Installation

4,481 Reply by joe

(4 replies, posted in Installation)

The database functions for MySQL is wrapped in the files /includes/db/connect_db.inc and /includes/db/sql_functions.inc (transactions), so there should be no hard-coded mysql-functions.
But we cannot guarantee that all SQL sentenses will work in either PostgreSQL or Oracle. And we do not maintain any support on this topic.

/Joe

Go to forum: Installation

4,482 Reply by joe

(5 replies, posted in Report Bugs here)

Thanks, yes the prices cannot be taken from the template due to that the customers can be of different sales types /currencies.
The amount from the template is merely to help idenfying the template. I will add that there must be a price set for the items in the sales prices.

/Joe

Go to forum: Report Bugs here

4,483 Reply by joe

(5 replies, posted in Report Bugs here)

As stated in the sticky topic in the forum accounts receivable, it is important to set the price factor in company setup before using the recurrent invoices for a sales group.

/Joe

Go to forum: Report Bugs here

4,484 Reply by joe

(5 replies, posted in Installation)

I guess you should use iso-8859-1 for Gernany. It consumes less memory and I guess you could run them simultaneous.

/Joe

Go to forum: Installation

4,485 Reply by joe

(5 replies, posted in Installation)

Yes, we had a bug in the first 2.1 beta. Fixed in 2.1 beta 2. The bug was inside en_US-demo.sql.
You can download the theme modern for 2.1 from the website. Unpack and copy it into themes directory. Then it should work.
You could also use phpMyAdmin and change the theme in 0_users to 'default'.

The class renderer is themes related, so these errors may be a result from the former.

/Joe

Go to forum: Installation

4,486 Reply by joe

(6 replies, posted in Reporting)

Hello,
Well I don't think the page break is a major topic, so, unless you have a more detailed proposal, we will just leave it here.

A pity that you dedn't monitor the error message. Without it make it impossible to trace it.

/Joe

Go to forum: Reporting

4,487 Reply by joe

(4 replies, posted in Wish List)

I don't know what you mean by position numbers. We have reference number series on every transaction type. You can define the start yourself in Setup, form setup.

You are the first to complain for non presented customer/supplier codes. BTW, the codes could not be changed at the moment. Are there other wanting this possibility?

/Joe

Go to forum: Wish List

4,488 Reply by joe

(9 replies, posted in Items and Inventory)

In release 2.1 we have kit sets and item alias, but I guess you mean some kind of SKU. No, this is not implemented.

/Joe

Go to forum: Items and Inventory

4,489 Reply by joe

(6 replies, posted in Reporting)

Look in the file /reporting/includes/header2.inc. There are some examples on how to print centered.
You can experiment a bit with the bottom borders (where it checks for new page). One line difference make it change to new page.

/Joe

Go to forum: Reporting

4,490 Topic by joe

(2 replies, posted in Banking and General Ledger)

We will put some examples and tips on Quick Entries here. You are welcome to contribute if you have done some smart ones.

Let us start with a simple one. You want to make a Quick Entry for phone bills.

First go into Quick Entries and create a new Quick Entry. Select Bank Payment and call it f.i. Phone. 
Don't set a fixed amount. Save it and select it again. Create 2 Quick Entry Lines.
1. Select 'Tax included, reduce base. Select the relevant tax type.
2. Select 'Remainder' and select the expense account for Phone bills.

If you don't use tax, then omit the first line.

Go into Bank Payments, select Quick Entries and select the Phone. Add the amount from the bill and press go.
Your lines should be there ready for processing.

Here is a more advanced one. If you only have a few employees you probably don't have a payroll program. You can preset a couple of Quick entries for that.

Say your employee has a sallary of $2,000. The payroll tax is 11.02% and the withholding tax is 15%.
First create a Quick Entry, Type: Bank Payment. Call it Salary X. Eventually preset the amount $2,000. And 
some entry lines:
1. % amount, select a Salary account (or create one, expense), 100%, Save
2. % amount, select an account for accrued payroll tax (or create one, liability), -11.02%, Save.
3. % amount, select a payroll tax account (or create one, expense), 11.02%, Save.
4. % amount, select an account for withholding tax (or create one, liability), -15%, Save.

If you have a fixed amount of tax, you could instead have choosen Amount, and the amount (negative).

Go into Bank Payments, select Quick Entries and select the Salary X. Select Go and your lines are ready for processing.

OBS

2009-08-19. The new change to Tax Type instead of Item Tax Type has now been done and committed to CVS Main.

Please remember to change your Quick Entries including tax to the above.

If more lines with other Tax Types are needed, group them together and use the same action.

Go to forum: Banking and General Ledger

4,491 Reply by joe

(9 replies, posted in Items and Inventory)

Thanks for your nice words.
1. To my knowledge, there are no ongoing Italian translating. Please start with 2.1 beta. You can use the empty.po file in /lang/new_ language_template. Just create a folder it_IT like the other lang folders and a subfolder LC_MESSAGES and put your empty.po file here. Rename it to it_IT.po. Use the poEdit program to translate. It is very easy to work with this program.
2. Please read the readme.txt file in the module. It should explain which fields should be included.
3. The INNOdb part of MySql is used for transactions. If you are using multiuser access to your script, then transactions are needed to secure updating of several tables. There are also some performance issues with the INNOdb. So if you run without INNOdb, then do not access the script with more than one user at the time.
4. I hope somebody in the community will answer this question for you. We are concentrating on the core of FA.

Best regards
Joe

Go to forum: Items and Inventory

4,492 Reply by joe

(2 replies, posted in Report Bugs here)

Thanks Jenifer,
This has been reproduced and will be fixed in CVS repository asap.

/Joe

Go to forum: Report Bugs here

4,493 Reply by joe

(2 replies, posted in Translations)

Thanks roblaus for your nice words. I hope a lot of German speaking users will help you smile

/Joe

Go to forum: Translations

4,494 Reply by joe

(24 replies, posted in Report Bugs here)

Hello,
Which release are you running?

/Joe

Go to forum: Report Bugs here

4,495 Reply by joe

(19 replies, posted in Setup)

I'm not quite sure about this, I guess I will ask Janusz to comment on that.

/Joe

Go to forum: Setup

4,496 Topic by joe

(2 replies, posted in Wish List)

Hello dear friends,

Our initial plans were to release 2.1 beta with the AGPLv3 license.

After following the discussion regarding AGPLv3 vs. GPLv3 in the license thread on the Whish-List forum, and after getting loads of emails,
and after talking with people around us, we found that too many were afraid of the AGPLv3 license. We have therefore decided to release 2.1 beta with a GPLv3 license.

This was not an easy decision to make and the authors were not agreed either. We had to find a concensus and it was the GPLv3.

We are aware of that we are not satisfying all parties with this decision, but nevertheless the only difference between these two licenses
is the ASP (Saas) loophole for networked scripts. The license is subject to change in next release if we find better solution satisfactory for all
interested parties.

Many debaters in various forums feel that the AGPLv3 license is what the GPLv3 should have been. Maybe it will end here somewhere in the future.

So we are now releasing 2.1 beta again under the license GPLv3. As soon as the headers are ready this release (and utilities) will be available
for download.


The Development Team
FrontAccounting

Go to forum: Wish List

4,497 Reply by joe

(19 replies, posted in Setup)

The admin that created company no. 0 is the superadmin. Only he can create new companies (=page level 20) and should be logged into company no. 0.

/Joe

Go to forum: Setup

4,498 Reply by joe

(2 replies, posted in Report Bugs here)

Thanks, I will ask Janusz to fix it.

/Joe

Go to forum: Report Bugs here

4,499 Reply by joe

(1 replies, posted in Report Bugs here)

Something strange has happened. Could you please set the variable $go_debug in the file config.php to 1. This will catch more warnings or errors.

/Joe

Go to forum: Report Bugs here

4,500 Reply by joe

(2 replies, posted in Report Bugs here)

Hello,
you should create a new supplier (not customer) when you want to make purchase orders (they are sent to your supplier).

/Joe

Go to forum: Report Bugs here