Hi robinbuzios,

To get an updated csv-file with all tables, you can make an export of your DB with PhpMyadmin.
If you make first time, made them from the demo-company to see sample data in all sheets (Think you setup a demo-company). Or put in the demo one customer with all the related data, to find in the xls-file better the relations between all the tables.

Select there "all tables", "xls", and "Put fields names in the first row".

Modify each sheet you need in the xls-file with your data.
Save them as csv-file, and import the csv-file with PhpMyAdmin in your DB (the table where you import data should be empty).

In this way you could import all data in the new company, not only your customers.

Best regards,
ferre

Hi Joe,

For mysql-tables I have utf-8
_SERVER["HTTP_ACCEPT_CHARSET"]    ISO-8859-1,utf-8;q=0.7,*;q=0.7

Mhh, seems I have now figured out. The troublemaker was mysql 5.5.8.
For the tables I use always utf8.

I changed now in the my.ini-file:
character-set-server = latin1
collation-server = latin1_general_ci

This is not working:
#character-set-server = utf8
#collation-server = utf8_unicode_ci
Still not logic for me, because with the old version it was working.

Was not the only problem, the setup of the demo-company was also not possible.
I had to change TYPE=...... to ENGINE=..... but this was easy to find out.

Think the update of mysql was not a good idea :-)

Thank you & best regards,
ferre

Hi,
I don't know where to search further to solve the problem.
The encoding of the DB is the same as with version 2.3.0
Other web-apps on the same server are working, I'm able to enter the letters é,ö etc.

Thank you & best regards
ferre

Hi,

Version 2.3.6
If I enter in fields "é,ö,ä and press save - the letter "ö" and the following ones are deleted.
If I put them directly in the database, the text is not shown correct.

There are no errors in log the files.

The look and feel of the trial balance is now an other one, where I can change not to show the class and group?


Thank you and best regards,
ferre

Hi Janusz,

Is this now working for non-inventory items?

This is what I'm searching for too, to be able to put a line on the "invoice" with "-", which is not related to an invoiced item.
The total amount will be not negative, it is still an invoice.
If a special discount is not already deducted on the invoice, you will create admin-work (people forget to deduct, pay the wrong amount, ask for the special credit, you have to pay back the diff., or they don't see the sep. credit and ask for a new invoice etc.)

Thanks,
ernie

Hi,
I'm not sure, but if I remember right, in the prior versions, if I voided a direct invoice, the PO and the delivery was also voided.

To void the direct invoice was working.
The PO and the delivery now are still in the books.

To void a PO is not working -->
Void a Transaction - PO
DATABASE ERROR : Error reading record set
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' t.order_no) FROM 6_purch_orders t LEFT JOIN 6_voided v ON t.order_no=v.id AND v' at line 1
sql that failed was : SELECT COUNT(DISTINCT t., t.order_no) FROM 6_purch_orders t LEFT JOIN 6_voided v ON t.order_no=v.id AND v.type=18 WHERE (ISNULL(v.`memo_`))

I could only remove:
Via "enter supplier invoice", and then "remove" each line.

Is this behaviour normal?
For me should be logic, if I void a direct invoice, everything will be voided, but maybe I'm wrong.

And if a PO could not be voided via "void a transaction", why "PO" is listed in the drop-down list?

Thanks,
ernie

7

(1 replies, posted in Setup)

Hi,
Version 2.3
Has this changed to prior versions?
I'm missing the fields below the listed installed extensions (name, folder, register etc.)
I'm logged in as Admin, access-rights ok.
Thanks
ernie

Hi,
I tried to register at mantis, but I never get an email back, but my email is valid.
But the user will now exist, when I try "lost password" - but I don't get mail either.
ernie

9

(5 replies, posted in Setup)

Hi Janusz,
No I had not access anymore to the first company.
But I copied now files from a backup where the login was working to the folder themes on the serves, all themes excluding the three default ones.
Then the login was working again, and I updated again the themes.
Seems now it is working, till now :-)

I had changed the theme before update to default for admin, but as I saw in the DB an other user had still fancy, seems that the problem was coming from there.


In the error-file I see new this:
[11-Dec-2010 15:19:08] 0::config.php:61: date() [<a href='function.date'>function.date</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead
[11-Dec-2010 15:19:09] 0::date_functions.inc:22: date_default_timezone_get() [<a href='function.date-default-timezone-get'>function.date-default-timezone-get</a>]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CET/1.0/no DST' instead

These two lines are repeated on more then 200 lines ....
Mhh - what I must change?
With the RFC version I did not had this message, and I only updated, I have not changed any configuration beside theme and language.

ernie

10

(5 replies, posted in Setup)

Hi Janusz,
Could it maybe a language problem?
Befor the update I could remember it was English, but after the update I changed to English (US), because I could not find a related language-file to English (without anything else).
Any other configuration I have not changed.

ernie

11

(5 replies, posted in Setup)

Hi Janusz,

I have done update 2.3
Once I was able to login into company 0 as admin, everything was working fine.
But after logout and try to login in to an other company I had white screen.
After this I was not able to login again to company 0.
Now I'm a little bit lost ....

ernie

12

(5 replies, posted in Setup)

Hi,
Version 2.3RC3
Don't know what I have done wrong, but after the update of available themes, I have in FF a white screen, and could not login anymore.
What could be the reason?
If I copy now the old themes from a backup on the server, and change the config-file, will this work?

ernie

Hi Joe,
I will put on the invoice as last row, and not issue a separate credit-note.

ernie

Hi,
Don't know how people will make their payments, but in our country (and others too) most of the people will do electronic.

Supplier:
At the supplier you must be able to enter the bank-details (bank-name, address, Bank-clearing code and new IBAN-number) and account-no and IBAN-No of the supplier, and the information how you will pay the invoices (which kind of electronic-transaction - which is a norm).
The supplier will send you a payment-slip with a ref-number, and this ref-number you must enter with each invoice (manual or with a reader). This ref-number will contain the information for the payment (they are different, depends which bank you will have, max 27 digits long).
In this way you are able to handle each payment, all over the world.
For payments outside of the country you must be able
In Europe we have now also SEPA, but not all banks will participate.

To create the file:
You can do automatically via proposal-payment within a choosen due-date, and then you can overwork manually, or you will book each payment manually and choose the payment-type "electronic".
If everything is done, you will run the booking - and the file will be generated, and this file you will send to your bank.
As long the payments are not debited, the payments are flagged as temporary bookings, and after you get the debit from the bank, you will control and book definitive. If something is not debited, you are able to delete the payment.
In this way you are also able to handle periodical payments once a year.
On the reports you can choose included temporary bookings or not, for the outlook and cash-flow it is practical.
Not all systems will handle via temp-bookings. And if something is not debited from the bank, you have to correct manually.

The supplier will receive an electronic file, and will import to his system, and if no errors, everything is booked automatically.
He could identify the payment with the reference-number.
If errors, maybe credit-notes are deducted, or the amount was changed, you must correct on the account manually, but you can identify who paid with the ref-no.

Customer:
You must be able to enter at the customer bank-information (like at the supplier) for "electronic payment", will work in the same way like the payments to suppliers, only an other transaction-type.

You must be able to generate with the invoice a payment-slip with the reference-number. This is a must, otherwise you have to pay more payment-fees. During next year anyway only one type must be used.

when you get payments, you can download a file from the bank, and then you will import to the system, check and book.

This way of payments we can do here since 20 years, only the way how you send the file has changed.
Now with SEPA and IBAN as standard in most of the countries it works the same way.

I could only provide the information how this work, and how the files must look, but I can not make such changes to the program.

How could something implemented? As add-on? It is not in each region the same. But SEPA is for Europe the same, and IBAN in the future I think too (I could clear this point).

For the administration it will really save you time.
And how it works now, you have to enter data twice, in the system and at the bank.

ernie

Hi,
-menu supplier invoice
after finished - attach document
here "back" button is not working with the theme fancy (with for ex. it is).

Theme elegant:
If you choose a menu, the curser will stay on the left side at the shortcut menu, and will not move to the first field where you enter data.
If you use fancy, the curser will be at the first field.

Where I can change this behaviour?

Thanks,
ernie

Hi,
How I'm able to enter a credit-not which is not related to an item.
For ex. a coupon with a special value?
As I see now, I could only enter credit notes related to an item.
(anyway if accounts receivable or payable, could be both)

I'm able to enter items for credit-notes?
When I tried, it was not possible to enter "-".

Thanks,
ernie

Hi,

I'm searching for a way to "store" in the system accounting-relevant documents, and documents you will need for the end-year audit.
For example contracts, agreements, guarantees etc.
End year I need an overview of all these documents (date, name, duration, value etc.), and a copy of the document.
And during the year it could be nice to have this list handy.
For ex. rent infrastructure, you must not attach to each booking a copy, it is enough to have the valid contract once.

If I have not overseen something, it is possible to attach documents only to an entry.

At the moment I will try via journal entry.
Opened a class statistik, and opened accounts outside/at the end of the normal chart-of-account structure.
Enter a booking 1+/- and attach the relevant document.
In this way the document is in the system, and you have an overview.

Is not very comfortable, but it works as I see at the moment.
Problem, the report you get via general ledger is not very "readable", not all needed information on the pdf, the lines are too short.

Is there a better way to handle this?

Or maybe I can solve to create a report for this.
But how I could create an own report?

Thank you in advance.

ernie

18

(1 replies, posted in Setup)

Hi,
Question regarding the filetype.

It was always attached from the same user and with FF

Once is written:
application/force-download
application/x-download
application/pdf
application/x-pdf

Why is it not always the same?
Could this give once problems

Thanks and best regards,
ernie

Hi,

Version 2.3RC3 (browser FF)
/purchasing/manage/suppliers - tab contacts

Maybe I'm doing something wrong, but I'm not possible to edit the contact or add further contacts.

best regards,
ernie

Hi Janusz,
It is now working, I missed to set "Use Item COGS/Inventory Account".
The other reason why it was not working, was - I have done a mistake with the import do the DB.
Thanks for you help.

best regards,
ernie

21

(4 replies, posted in Wish List)

Question regarding CashFlow reports - was this once started, I haven't found any information.
For a simple solution, you can add an additional code to the GL-account, and built then a report.
You can also export data to a Reporting-Tool and create outside, what I'm doing now, but this is not so comfortable and not everybody is able to get access.

best regards,
ernie

Hi,
How much effort is it to add an additional account code for cash-flow reporting?
The actual account2 I'm already using for something else.
Where must be changed things to add a new field, and to be able to generate reports?
Thanks

ernie

Hi Janusz,

Mhh, I tried, but as long I have an GL-account entered at the supplier-general data, it is not working.

ernie

Hi Janusz,
Ok, will try to express more clear.

A.- Tab purchase, suppliers
Here are the general setting to the supplier, address, and also the accounts: Accounts Payable, Purchase Account, Purchase Discount Account.
I had already put in here the main account (80% of the delivery will be booked there).

B.- Tab purchase, purchase order entry
Here I entered the orders with the several items. Each item have the correct GL-accounts and dimensions.

C.-Then I wanted to enter the received payable-invoice
Tab purchase, Supplier invoice
Then I selected the several "items received yet to be invoices" and add then I proceeded to book the invoice.
Now it appears, that the GL acoounts from "A-general setting supplier" is taken, and not the GL-COGS-account from the items.

Hope I expressed now better understandable.

ernie

Think I found out from where the account is taken (for booking and display ..)

I was entering via supplier invoice, and then I added purchase orders.
The GL account is taken from the supplier account, because everything is booked to this account, anyway what is entered at the item.
Means, the account at the supplier will overwrite the item-account.
But why is it doing that way, is not logic for me.
You can only enter at the supplier an GL purchase account, if you will never have items with different GL accounts?

ernie