Adding item UOM prices on SAP 9 programmatically

[Former Member]

Good day ! I am creating a SAP 9 integration with other application and I want to post the item UOM prices to SAP on table (ITM9) programmatically. is it possible to post item UOM prices to sap 9 ?

need your help. thanks

[Former Member]

Thanks for your replies eric and Silambu,

Hi silambu, but this scipt is for specifying item prices only. but I'm thinking to create/post a master data of all UoM prices per item from other application to SAP.

Thanks for your Ideas

Regards,

Regual

[silambarasan_rajendran]

Hi,

It is possible. Eric told the same Items_Prices you have to use.

Items_Prices is a child object of the Items object that represents the items' prices in the Inventory and Production module. This object enables you to specify prices for various price lists.

Here the sample SDK from VB.net :

        Dim lErrCode As Long
        Dim sErrMsg As String
        Dim bRetVal As Boolean
        Dim oItems As SAPbobsCOM.Items
        Dim oItemPrice As SAPbobsCOM.Items_Prices
        Dim i As Integer

        'Retrieve Items object
        oItems = oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oItems)

        'Retrieve specific item
        bRetVal = oItems.GetByKey("X0004")

        'Check errors
        If Not bRetVal Then
            oCompany.GetLastError(lErrCode, sErrMsg)
            MsgBox("Failed to Retrieve the record " & lErrCode & " " & sErrMsg)
            Exit Sub
        End If

        'get item price object
        oItemPrice = oItems.PriceList

        'print price lists names and prices
        For i = 0 To oItemPrice.Count - 1
            oItemPrice.SetCurrentLine(i)
            'print price list name
            Debug.WriteLine(oItemPrice.PriceListName())
            'print the items price
            Debug.WriteLine(oItemPrice.Price())
        Next

        'change the price of the item in the last price list
        oItemPrice.Price = 600

        'save changes
        oItems.Update()

Thanks & Regards,

Silambu

[Former Member]

Hi Regual,

This is a subobject of Items.Items_Prices (UoMPrices).

Regards,

Eric