4,501 Reply by joe

(3 replies, posted in Installation)

There will be no database change during the 2.1.X releases. Only bugfixes.

/Joe

Go to forum: Installation

4,502 Reply by joe

(20 replies, posted in Setup)

Hello again,
Now this is fixed. The CVS repository is updated. Only one file affected. /gl/includes/db/gl_db_banking.inc

Thanks again MozMan

/Joe

Go to forum: Setup

4,503 Reply by joe

(20 replies, posted in Setup)

Oops!

Thank you so much for finding this bug. We did some change in the Bank Account and transaction tables to release 2.1.0, and this bug slipped through.
I will be back when the CVS repository is updated.

/Joe

Go to forum: Setup

4,504 Reply by joe

(3 replies, posted in Accounts Receivable)

In release 1.16 you will have to set the user item decimals in the display setup in Setup tab. This will be for all units.

/Joe

Go to forum: Accounts Receivable

4,505 Reply by joe

(4 replies, posted in Wish List)

There is already a table, X_purch_data, in the database. This table contains all the information regarding the suppliers data, so this should be very simple to implement. Today these entries are updated every time GRNs and Supplier Invoices are entered.
In the beginning, however, the items have to inserted in some way with the whole list of items. But with a flag in setup, you might be able to select that you only want the supplier's items.
So, yes, this is a candidate for 2.2.

Go to forum: Wish List

4,506 Reply by joe

(3 replies, posted in Accounts Receivable)

Hi,

It is quite easy. Go into tab Items and Inventory. Select Units of Measure. Change the decimals to 1 for the item unit you are using on the item. That's it.

/Joe

Go to forum: Accounts Receivable

4,507 Reply by joe

(4 replies, posted in Items and Inventory)

Are you referring to release 2.0.X or 2.1.0 beta 2?
You can enter up to 20 characters in the stock id field, so this should be ok. I guess others have used this approach too.
I cannot tell you why nothing shows up. Haven't heard of any problems here.
You can temporary set the $go_debug flag in config.php to 1 to try to catch some errors or warnings.

/Joe

Go to forum: Items and Inventory

4,508 Reply by joe

(5 replies, posted in Items and Inventory)

Hello,
This is the type relating to systypes. You can see the types in file /includes/types.inc

/Joe

Go to forum: Items and Inventory

4,509 Reply by joe

(12 replies, posted in Accounts Receivable)

Hello and thanks.
The trans_no is an auto_incremented value for the debtor_trans table. This auto_incremental value, that should get you the next number, is probably set wrong in the table.
You can fix that in phpMyAdmin.
If you by trans_no = 5 mean, that the next reference number is 5, then you can move the next reference number in Setup tab, form setup.

Go to forum: Accounts Receivable

4,510 Reply by joe

(6 replies, posted in Wish List)

Personly, I don't like the PEAR approach. I have been looking at a SF project called Excel Writer (XML) for PHP.
This is was they claim:

Set of classes for PHP that allow Excel XML files to be generated dynamically. Nearly a full implementation of the MS XML architecture. Requires PHP 5+ Does not require any XML libraries

It is very small and elegant. It is written in PHP 5.0 but as it is very small it is easy to fix so it runs in both 4 and 5.
It creates XML files, which of course is a good thing, especially for the XBRML standard. A standard for Accounting applications. This implementation is also for the future.
And it is easy to later create a class like pdf_report.inc, where similar routines are created. Then we only have to switch to the right include pdf_report or excel_report.
This is what I think we should do.
I will do some further research on this one. Please have a look and comment on this.

/Joe

Go to forum: Wish List

4,511 Reply by joe

(3 replies, posted in Setup)

To create new companies and languages you must be superadmin. A superadmin is the admin of the first company you created, f.i. Training Co. So you must login on this company as admin to do the operation.

/Joe

Go to forum: Setup

4,512 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,513 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,514 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,515 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,516 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,517 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,518 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,519 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,520 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,521 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,522 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,523 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,524 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,525 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