Fetch all entries on SalesPrice page via OData

(0) Share

Report

Posted on by NicholasJackson16

I have created an OData feed to the page "Sales Prices" (7002). This page lists all sales prices for all items, but can be filtered.

However, when accessing the page via OData, it saves the last filters I used to visit the page in the UI. For example, if I go to an view the Item card for item "1001" then > Prices & Discounts > Sales Prices, close the page in BC, and refresh the OData query, I am returned only entries for item 1001. Same applies if I access it from "Customer Pricing Groups".

I have tried every combination of filter on the OData query that I can think of, but I am unable to clear the filters set from my last UI session.

Any ideas on how I can access all entries in the Sales Price table from OData? Perhaps there's another page/query/codeunit I could query that returns the information?

Thanks!

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

NicholasJackson16 80 on at

Like (0)

Report

I found the resolution!

Page 7007 lists all Sales Price Lines with no filtering.

Was this reply helpful? Yes No
Verified answer

Marco Mels on at

Like (0)

Report

Thank you for sharing final outcome!

Was this reply helpful? Yes No
Massimo1968 10 on at

Like (0)

Report

Sorry, what's the solution?

Was this reply helpful? Yes No
Massimo1968 10 on at

Like (0)

Report

Do not consider I had not read correctly.

Was this reply helpful? Yes No