Skip to Content
author's profile photo
Former Member

Get Price from Sales Order Items

Hi All,

In SDK, I try to get the Item Price. However, the value returned is the amount and the currency (USD 50.00). How do I get just the amount (50.00)?

The code i'm using is as follows (where oItem is the matrix on the form):

..

Set oMatrix = oItem.Specific

Set oCols = oMatrix.Columns

sPrice = oCols.Item("17").Cells(i).Specific.String

Please help!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 07, 2005 at 09:55 AM

    The SDK provides access to the string only (that's why you are getting the currency as well).

    There is a solution though - there is always a space between the currency and price. so discard everything before the space (space included) and you have the price.

    (You can use a simple substring function to achieve this)

    Add comment
    10|10000 characters needed characters exceeded