Microsoft KB Archive/241954

= Commerce Server Currency Limit =

Article ID: 241954

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Site Server 3.0 Commerce Edition

-



This article was previously published under Q241954



SYMPTOMS
In Site Server 3.0, Commerce Edition, the maximum value for product prices and product totals is limited. For US currency, this limit is 21474836.48.



WORKAROUND
Scaling down the monetary values used on the pipeline and database (for instance by 0.01) is the easiest way to work around this limit. Using your own replacement code for the ASP money formatting code allows you to scale them back up for display.



MORE INFORMATION
Commerce Server uses the following two conventions to manipulate prices:
 * Prices are manipulated using int data (VT_I4 OLE type). For example, all basket-related pipelines provided by Microsoft use integers to store and retrieve product prices and totals from the purchase dictionary.
 * Prices are stored in the database and in the purchase dictionary using the lower units for the currency. The currency used is defined at shop creation time. For example, with US currency, one US dollar product is stored as 100 cents. All ASP pages generated by Commerce wizards uses money formatting code that relies on this convention.

Keywords: kbprb kbpending KB241954

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.