Skip to main content

I want to know how to get the Sales Price List by API.

 

When registering a Customer Orders in the migration job, I want to use the API to retrieve the sales price from the sales price list.

 

Because the migration job does not appear to be referencing the sales price list.

I think this could be done through the standard IFS Cloud API.
You might check entities like SalesPriceList, SalesPriceListLine, or CustomerOrderPricing in the API Explorer.
Possibly, a GET request with a filter such as $filter=PriceListNo eq 'XYZ' could return the price you need.
My guess is that the migration job doesn’t automatically reference the price list, so fetching it manually through the API might work.


Hi. ​@Mehmetkilivan 

Please advise me on how to find the API.

I have conducted the following investigations so far, but I have been unable to locate the API.

  1. I investigated the API called when the “Product” and “Sales Quantity” fields in the order details are changed.I confirmed it uses the Customer_Order_Pricing_API.Get_Order_Line_Price_Info. However, it was specified as a PROCEDURE function that does not return a value.
     
  2. Regarding the price retrieval portion for the sales price list called within Get_Order_Line_Price_Info,

    it was using Sales_Price_List_API.Find_Price_On_Pricelist, which was also a PROCEDURE function.

    The API specified as the default for migration jobs is assumed to be a FUNCTION with a return value.

    Therefore, I determined it is not suitable for use.
     

  3. I checked to see if there were any other functions available in the Customer_Order_Pricing_API and Sales_Price_List_API, but it seems there aren't any.

Regards,
Wataben


hello ​@WATABEN 

is the price list linked to your customer please?


Hello ​@N.GEORGI 

 

is the price list linked to your customer please?

Yes,so I  was able to register customer orders at the prices listed in the price list in IFS.