My Products
Help
Snuffsis
CONTRIBUTOR ***

Get customer priceclass

by Snuffsis

We're trying to get a specific article price for a specific priceclass. But it doesn't seem like we have found it (is it possible?) yet. 

 

Using "CustomerSalesPrice" to get a specific articles priceclasses doesn't give us the name of the priceclass itself, nor the name of any customers using that priceclass.

Using "customer" and checking "PriceClass" object will tell us which priceclass that customer has associated with it. But we have yet to find any way to use this value to find the articles in that priceclass and for that customer for example.

Using "Inventory" and retrieving an inventoryitem only tells us of a "PriceClassID" that isn't the name of any priceclasses that we have created.

 

So the question would then be. How exactly, if it is possible, would we go about getting a specific articles prices in a priceclass along with the name of that priceclass so we can identify which customer etc that price is associated with?

3 REPLIES 3
Yıldırım
VISMA

by Yıldırım (Updated ‎01-12-2021 16:51 by Yıldırım VISMA )

This can be inquired via GET > https://integration.visma.net/API/controller/api/v1/customerSalesPrice  based on Sales Prices <ScreenId=AR202000>

 

"Sales Prices" can be created only with one of the following types, 

Price Type Price Code
Base Empty (Check ItemID)
Customer Customer ID
Customer price class
Customer Price Class ID

 

salesPrices.jpg

In this way,

  • If the "Price Type" is e.g. "Customer" then the Price Code will be "CustomerID" and it'll be populated together with ItemId & Price etc. in the GET Response. 
  • If the "Price Type" is "Customer Price Class" then the Price Code will be "Customer price class ID" which is referring to <ScreenId=AR208000> 
    CustomerPriceClass.jpg

Then, if you'd like to get all the sales prices defined for the inventories, GET .../api/v1/customerSalesPrice without any filtering parameter will return the full list.

 

In addition to that, if you'd like to get the "Customers" only have "PriceClassID=xxx", unfortunately this is currently not exposed via the GET Customer endpoint. To be able to do that, "PriceClassID" should be added to the Customer endpoint as a filtering parameter. 

 

If this is what you'd like to have, we recommend creating an improvement case in the "Ideas" section in the community.

Yıldırım
VISMA

by Yıldırım (Updated ‎01-12-2021 13:31 by Yıldırım VISMA )

Hello Jimmy,

 

could you please inform us about the specific module <screenID>  / Built-in report etc. that is available in the Financials ERP UI if you can receive the data as requested ? 

Snuffsis
CONTRIBUTOR ***

by Snuffsis

The ScreenID in question is ScreenId=AR202010

 

which will list all the articles in a priceclass and their prices for that specific priceclass