Forum

import SQL ERROR 22...
 
Notifications
Retirer tout

import SQL ERROR 22003 when importing negative value

7 Posts
2 Utilisateurs
0 Reactions
2,919 Vu
(@loicr)
Posts: 125
Active Member
Début du sujet
 
[#8473]

When important i see that i've got error on ProviderOrder when value contain negative value :

 

Why bloking negative ? 

Thanks

LR


 
Posté : 7 Sep AM 10:099
(@babynus)
Posts: 14952
Membre Admin
 

An Order with negative value ?


 
Posté : 7 Sep AM 11:099
(@loicr)
Posts: 125
Active Member
Début du sujet
 

For easiest integration i import order lines ( i've got more details than order & details lines ) and sometimes i've got discount lines ... ).
But you're right ... it is good to have feed back ... my idea is probably not a good one 🙂

I'll deleted negatives lines before import !!!

Thanks

LR


 
Posté : 7 Sep AM 11:099
(@loicr)
Posts: 125
Active Member
Début du sujet
 

But if i do that my global cost will be wrong ... !!! ???

LR


 
Posté : 7 Sep AM 11:099
(@loicr)
Posts: 125
Active Member
Début du sujet
 

What it stranger is that sometimes it works :

 

???
LR


 
Posté : 7 Sep AM 11:099
(@babynus)
Posts: 14952
Membre Admin
 

You show expense where negative values are allowed.
It's different from Provider Order when negative values are not allowed


 
Posté : 8 Sep PM 20:099
(@loicr)
Posts: 125
Active Member
Début du sujet
 

You're wright, i import supplier order command lines instead of global order wich is not negative ... i should modify to import order and after to add command lines ... ( negative authorised i supose ?? )


 
Posté : 8 Sep PM 20:099
Share:
Retour en haut