Issue with VAT in vendor invoice

Using my Dolibarr Financial modules
, ,
1

Hi,

I make upgrade on V12.0.4, but when i want to add some product in vendor invoice with 18% VAT, i get this error "Unknown column ‘18ДДВ’ in ‘field list’ " - actually it not accept Cyrillic font.

I hope for some solution about this problem.

Best Regard,
Martin

2

Hi @martin54
I think you issue seems to be very close than this one:


you can have a quick workaround changing VAT codes in dictionnary and avoiding in it “_” and “-” characters.
If you want, you could try also my patch …
3

Hi @Zuiko,

Thnak you for your answare, but this is not the problem in my case… i don’t have “_” or “-” in name…

4

@martin54
you can see that this instruction (with my patch)
in function price2num in htdocs/core/lib/functions.lib.php
$amount = preg_replace(’/[a-zA-Z/\*()<>_-]/’, ‘’, $amount);
is dedicated to eliminate all no-numerical charaters in the argument.
I fear that it does not work for cyrillic characters… My patch is not perfect and I didn’t think to that eventuality.
So I suggest you, if your constants contains some, to change your TVA constants for pure latin characters (a-z A-Z) to try.

5

Hi @Zuiko

Yes, i made that change yesterday, but before upgrade it works and with Cyrillic characters…

6

@martin54
What was your previous functionnal version, please ?

7

@Zuiko

Previous was V12.0.1

8

@martin54
Thanks, it’s interesting to know which was the last functionnal code…

9

@Zuiko
Sure, if you need other information, i can send you. :slight_smile:

10

@martin54
if you fixed your issue changing your VAT code to latin characters, this confirms to me that I’m on the good track :wink:

11

@Zuiko

I can send you and images if you need haha :slight_smile:
I hope that you will find the issue and fix it :slight_smile:

12

Issue written here #16015
and fix proposed here for V12 #16016
Here for V13 #16017

1 Like
13

It works :slight_smile:

Thank you very much

14

@martin54
be careful to take the last code because I made a little mistake this night (it was too late to have all my ideas clear :wink:).

15

@Zuiko
haha i take the last, i try and it works, so it is ok, thank you again :slight_smile:

16

@Zuiko

I found new problem after make changes on functions.lib.php.
When i create customer order i can’t use decimals for unit price (etc. 4,1) i must use rounded number (etc. 4).

I back the default code and it works, but it not works with Cyrillic characters VAT.

17

Thanks, I check this…

In a customer order…
Before change:

image
image1062×59 5.78 KB

Typing the change:
image
image718×97 4.91 KB

Result:
image
image1077×58 5.39 KB

So, for me it works and normally I didn’t touch to decimal in my patch because only non numeric strings are concerned in it and I think quantities are directly numeric in the current case.

1 Like