Highlighted
Flexera beginner

Effective quantity on a purchase showing "2147483647" instead of correct quantity

Jump to solution

Hello. We have a purchase with a "Purchase quantity" of 10 and a "Quantity per unit" of 500,000,000, and the "Effective quantity" field shows 2147483647. Is there a reason the effective quantity can't calculate past that number?

1 Solution

Accepted Solutions
Highlighted
Flexera
Flexera

Re: Effective quantity on a purchase showing "2147483647" instead of correct quantity

Jump to solution

Hello @MPaoloni,

This is most likely due to the fact that an int (integer) data type in SQL Server has an upper limit of 2,147,483,647.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?v...

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post

1 Reply
Highlighted
Flexera
Flexera

Re: Effective quantity on a purchase showing "2147483647" instead of correct quantity

Jump to solution

Hello @MPaoloni,

This is most likely due to the fact that an int (integer) data type in SQL Server has an upper limit of 2,147,483,647.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?v...

HTH,

Joseph

If my response answered your question satisfactorily, please click "ACCEPT AS SOLUTION" to heighten visibility for future customers!

View solution in original post