Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

import SQL ERROR 22...
 
Notifications
Clear all

import SQL ERROR 22003 when importing negative value

7 Posts
2 Users
0 Reactions
2,920 Views
(@loicr)
Posts: 125
Active Member
Topic starter
 
[#8473]

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

 

Why bloking negative ? 

Thanks

LR


 
Posted : 07 Sep 2022 10H31
(@babynus)
Posts: 14952
Member Admin
 

An Order with negative value ?


 
Posted : 07 Sep 2022 11H45
(@loicr)
Posts: 125
Active Member
Topic starter
 

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


 
Posted : 07 Sep 2022 11H54
(@loicr)
Posts: 125
Active Member
Topic starter
 

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

LR


 
Posted : 07 Sep 2022 11H55
(@loicr)
Posts: 125
Active Member
Topic starter
 

What it stranger is that sometimes it works :

 

???
LR


 
Posted : 07 Sep 2022 11H56
(@babynus)
Posts: 14952
Member Admin
 

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


 
Posted : 08 Sep 2022 20H18
(@loicr)
Posts: 125
Active Member
Topic starter
 

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 ?? )


 
Posted : 08 Sep 2022 20H38
Share:

Scroll to Top