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

[MPaoloni]

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?

[jjensen · Accepted 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?view=sql-server-ver15

HTH,

Joseph