1 Reply by janvl

(6 replies, posted in Reporting)

Hi,

thanks for the reply.

I just checked the languagefile and found


Content information for package 'de_DE'

Charset encoding     iso-8859-1


So I will have to check the mo and po files, can it be that only the PDF's are involved?

I will use po-edit and check that the languagefile is utf8, after that i will notify.


Regards,
Jan

Go to forum: Reporting

2 Topic by janvl

(6 replies, posted in Reporting)

Hi,

i have not done much with FA lately.
So i installed 2.4.6 to demonstrate.

I have 1 problem for which i need a hint where to search on how to solve it.

The complete system runs on utf8.

just the reports generated as PDFs do not show ä ö or ü right.

Anyone an idea where i have to search for a solution?

any hint is welcome.

Regards,
Jan

Go to forum: Reporting

3 Reply by janvl

(18 replies, posted in Modules Add-on's)

Hi,

I had a closer look and will first try the transactions module in combination with Chromispos.
This module is new to me and looks very good, thanks apmuthu!

Kind regards,
Jan

Go to forum: Modules Add-on's

4 Reply by janvl

(18 replies, posted in Modules Add-on's)

Hi,

I know Unicenta/Chromis very well and the MySQL-DB is well described. I know exactly where transactions are stored and what records get changed. I might be of help there.
I have been looking for a way to connect the two for years now and am in contact with Talend, that however seems an enormous overkill.

A fairly simple POS is "OS POS" or "pos_on" which is all PHP/MySQL.

Where do I start when I want to contribute in integrating a pos-solution?

Regards,
Jan

Go to forum: Modules Add-on's

5 Reply by janvl

(4 replies, posted in Translations)

Hi,

I have done all (767) but the abbriviations, I will first check these with a financial expert so it will fit the german language.

After that I will run it in 2.4.3 again (it looks good already).

Then I will send it to you apmuthu.

Regards,
Jan

Go to forum: Translations

6 Reply by janvl

(4 replies, posted in Translations)

Thank you very much!

I am under 250 strings to translate. After that I can update from 2.3.2 to 2.4.3.

Regards,
Jan

Go to forum: Translations

7 Topic by janvl

(4 replies, posted in Translations)

Hi,

I am on my way to make/correct the translation with www.deepl.com which does a very good job.
The only thing that makes me trouble is the following list of abbriviations.

Could someone please give me the full text for it?

GJ -
BP -
BD -
BT -
SI -
CN -
CP -
LS -
IT -
IA -
PO -
PI -
PC -
SP -
GRN - Goods Received Note
WO -
WI -
WP -
SO -
SQ -
CU -

Thanks in advance,
Jan

Go to forum: Translations

8 Topic by janvl

(1 replies, posted in Items and Inventory)

Hi,

I have a customer where during the import itemcodes with a space in it came in the DB.

I want to change that by taking the spaces out of the itemcodes in the following tables

item_codes -- fields item_code and stock_id
loc_stock -- fields stock_id
prices -- fields stock_id
sales_order_details -- fields stk_code
stock_master -- fields stock_id
stock_moves -- fields stock_id

The itemcode without the space is unique.

Question:
If I disable the foreign key, change all tables and enable the foreign key again will this do the job?

Kind regards,
Jan

Go to forum: Items and Inventory

9 Reply by janvl

(6 replies, posted in Jobs wanted/offered, non-free offers)

If you want a good open source pos look at chromispos.

Also Mysql but not integrated.

I would like to start working on an integration, together with some other people, who is interrested.

regards,
Jan

Go to forum: Jobs wanted/offered, non-free offers

10 Topic by janvl

(1 replies, posted in Installation)

One can make more companies in FA, in the DB you get a number for the set of tables.

I am wondering how many can be made 10 or even more?

What is an acceptable number.

Regards,
Jan

Go to forum: Installation

11 Reply by janvl

(1 replies, posted in Installation)

It is no problem with the dutch DOA.
I will solve this with a bookkeeper and notify.

Regards,
Jan

Go to forum: Installation

12 Reply by janvl

(4 replies, posted in Setup)

Hi does anyone know if there is successor for anterp, the site does not seem to be right.

Regards,
Jan

Go to forum: Setup

13 Topic by janvl

(1 replies, posted in Installation)

Hi,

I do not seem to be able to track the cause of the following error.

The Retained Earnings Account should be a Balance Account or the Profit and Loss Year Account should be an Expense Account (preferred the last one in the Expense Class)

It is a fresh install 2.3.25 with the austrian DOA.

I guess I am not enough bookkeeper and not smart enough to find it.

Does someone have a hint please how I solve this?

Kind regards,
Jan

Go to forum: Installation

14 Topic by janvl

(0 replies, posted in Installation)

Hi,

I have FA (2.3.24) installed on a webserver running LAMP.
The users use Firefox (latest version) on Windows 7.

When we start a direct invoice and enter in the field for quantity the amount of 3,
hit tab then 30 is in the field.

Does anyone have an idea how to solve this?

Yes, i found it.

If you put the article in "foreign item codes" and you put the quantity on 10 then this is what you get.
changed it to 1 and all is fine now.


Kind regards,
Jan

Go to forum: Installation

15 Reply by janvl

(5 replies, posted in Reporting)

Hi,

thanks, we have the old application running in a VM but there is no support and it is getting unstable.
I converted the data to FA, had the customer test FA for free for several month.

We have just started to use it life.

I think you are right that the customerfilter lacks invoices in my test-install.

I will first concentrate on a new german translation, I contacted ISCON yesterday but they do not do anything anymore with FA. Maybe it should be removed as a partner.

Just to be sure, can I merge the po-file for version 2.28 with the empty one for 2.3.22, I have just installed poedit.

Kind regards,
Jan

Go to forum: Reporting

16 Reply by janvl

(5 replies, posted in Reporting)

Hi

Thanks for the quick reply!

Still the customer filter is unclear to me. I can put a range in the first 2 fields.
I do not seem to grasp the idea of the lower field "Customer filter".
Where can I define such a filter?

For the translation, I searched on "Print Invoices" that is not found, with the ampersand it is found.
What is the ampersand used for?
[edit] found it, keyboard shortcuts!

We just started using FA at a local retailer, after his 12 year old 16/32-bit programm did not work anymore on win 7 64 bit.

Kind regards,
Jan

Go to forum: Reporting

17 Topic by janvl

(5 replies, posted in Reporting)

Hi,
when I choose
"Customer and sales reports"
"Customer"
"Print invoices"

Then I see on the right side:

Customer:
No customerfilter

My first question, where can I define somethng like a customerfilter and what does it do?

My second question, can I select just the invoices for customers with a valid VAT-Number?

My third question, where can one translate "Print Invoices" (reports_main.php) it is not in the .po file.

Kind regards,
Jan

Go to forum: Reporting

18 Reply by janvl

(2 replies, posted in Accounts Receivable)

I have been thinking about this item.
But what my customer askes is not very logical.

For example an invoice with 100 position where 2 positions get canceled.
Why on earth whould one cancel 98 valid postions?
It would be nice to have a posibility to cancel a complete invoice at once but that should not be necessary.

I guess I have bumped into a organisational problem rather then an it-problem.

Kind regards,
Jan

Go to forum: Accounts Receivable

19 Topic by janvl

(2 replies, posted in Accounts Receivable)

Hi

is it possible to arrange the following workflow in FA

make an offer/order/delivery/invoice

then cancel the invoice but keep the order to change the lines on the order
and produce a new invoice.

The only thing I could find is "Credit all or part of an Invoice" where you can credit the one or the other line.
I do not see how to credit all-at-once.

BTW I am working on the german translation, some translations seem not to good. So I change to english to post in the forum.

Kind regards,
Jan

Go to forum: Accounts Receivable

20 Reply by janvl

(2 replies, posted in Dimensions)

Thanks Joe,

so I understand dimensions . . .

we are just starting with FA for this retailer (my customer).
Most "problems" are the result of a workflow that is not exactly structured.

Kind regards,
Jan

Go to forum: Dimensions

21 Topic by janvl

(2 replies, posted in Dimensions)

I need to bundle certain sales and revenues depending on the area the customers live in and the kind of customer.

I can see that a dimension type 1 puts a "marker" on everything that belongs to these customers.

Is it sufficient to
1. define the dimension (regional tourism)
2. mark the customers that belong to this dimension

Can I then list the sales/ revenues that were made for this kind of customers?

Kind regards,
Jan

Go to forum: Dimensions

22 Topic by janvl

(0 replies, posted in Installation)

Hi,

I have imported customers and customer-branches, that is OK now.
I have figured out that for importing products you need to fill 6 tables (or 7)
in a coherent way.

stock_master
item_codes
purch_data
prices
stock_moves
loc_stock

Now if I want 1000 pieces of a product in stock I must put that in stock_moves.

I am not sure that I have to put something in gl_trans

since there is no connection to the productnumber there, with wat is it connected then
and am I obliged to put a -1000 and +1000 line in there?

Kind regards,
Jan

Go to forum: Installation

23 Reply by janvl

(5 replies, posted in Modules Add-on's)

Hi tm

I am very interested in your solution.

I just installed FA and am now busy in figuring out how to get the data from an ancient programm (2000 and never updated) into FA. Just found a way to extract the data, the programm running on a 10 year old laptop.
The people that will use it have an Openbravopos (linux/mysql local PC) which is the predecessor of Unicenta, I have written on discus how one can do the update. So that I can manage that.

We also plan to move to presta, the shop they run now is a dead end.

Kind regards,

Jan

Go to forum: Modules Add-on's

24 Topic by janvl

(0 replies, posted in Installation)

Hi

has anyone imported more data then just items?

I mean directly with mysql, like customers, manufacterers etc.
Is there a link with some info?

Kind regards,
Jan

Go to forum: Installation

25 Reply by janvl

(1 replies, posted in Installation)

use PHPmyadmin to export as an sql-file and then import in your DB.

Kind regards,
Jan

Go to forum: Installation