Query regarding the Sales Price of an Item?

[Former Member]

Hi Friends,

I need to extract all the master details from SAP B1.

In that,i extracted the Item master details also..

while i extracting the Item details,In the Item XML,i din't get the exact Selling price of an item.In that XML,the Item Prices got listed no field containing the exact Sales Price..<b>Which node containing the Sales Price?</b>

Please help me to have a clear idea about that.

Thanks in Advance

regards

sooriyakala.P

[Former Member]

Hello Sooriya,

What application are you using in extracting data in SAP?

[Former Member]

Hi,

I m in ETL product ,Now we are extarcting data from SAP for our Local Product.

[Former Member]

What Gilbert is asking about is how you get the XML data.

Do you do it by coding? If yes, post the code to have a look.

Regards,

Ibai Peñ

[Former Member]

Hi..

Items Itms=(Items)comp.GetBusinessObject(BoObjectTypes.oItems);

Itms.GetByKey("A00001");

Itms.SaveToFile(@"d:\items.xml");

In the code above writen in C# ,Which node contains the Sales price of an item? I can see the list of PriceLists and not a single Sales price.Can u tell me how to predict the Sales price using the oItems object

Thanks in Adavance

regards

sooriyakala.P

[AdKerremans]

Hi Sooria,

The sales price can depend on the number of item, and hte customer, you can get the sales price for a specific/customer combinaition by using the sbobob function GetItemPrice.

If you want to have the standard salesprice from the xml you have to know wich pricelist to use.

Regards

Ad