Commerce Server Currency Limit (241954)


The information in this article 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.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbpending kbprb KB241954
©2004 Microsoft Corporation. All rights reserved.