Skip to Content
0
Aug 11, 2023 at 12:19 AM

SQL Arithmetic overflow error converting numeric to data type numeric SalesOrder(ORDR)

319 Views Last edit Aug 14, 2023 at 03:02 AM 2 rev

hello to all, dear,

I detail what happened next...

the message: Microsoft ODBC Driver 13 for SQL Server SQL Server Arithmetic overflow error converting numeric to data type numeric. Customer order / sales order (ORDR)image.png

the drawback with this message is that: It happens that the normal procedure is to place the no. of business partners, then the corresponding date, then place the article number plus the amount to be remitted. Now, when we want to create the order, the system notifies the error that is detailed at the bottom of the image.image.png

Important:
The sales order is managed by setting a price of $0, the price procedure was replicated, the same Business Partner, the same Item, the same quantity and we were able to create it on the TEST (DEMO) basis, but not on the productive one:

image.png

We were also comparing that article with other articles and they have similarity of characters that we are trying to detect which is the field that apparently is very wide and does not allow the document to be loaded

thanks in advance!

we stay tuned!

Attachments

image.png (11.4 kB)
image.png (54.5 kB)
image.png (60.4 kB)