web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Sales Prices and Line ...
Small and medium business | Business Central, N...
Suggested Answer

Sales Prices and Line Discount OData

(0) ShareShare
ReportReport
Posted on by ERPMan 70

Hi BC Guru's,

We are trying to pull OData for Sales Prices and Line Discounts Page (1345) but the page is filtered and only temporary.

We were able to pull data from Sales Prices table (7002), but we were not able to pull data from Sales Discount (7004). 

Is there a table we can pull from that displays all the Sales Discount data that is not filtered or temporary? 

Thanks! 

I have the same question (0)
  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,043 on at

    hi

    pls refer for more information.

    pastedimage1663175461135v1.png

    Regards

    Amit Sharma

    www.erpconsultors.com

  • ERPMan Profile Picture
    ERPMan 70 on at

    We have tried this table but looks like it is still filtered. 

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at

    Is it all data for a specific customer price group / customer discount group you want to publish in the API?

    Are you on prem or in cloud and what version are you running if you are on prem?

  • ERPMan Profile Picture
    ERPMan 70 on at

    This would be for all data for all customers we would like to publish in the API.

    We are in cloud and are running 20.4

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 102,361 Super User 2026 Season 1 on at

    Hi, It is recommended that you create a new page and publish it in the Web Service, or create the API page directly. Using a standard page will cause bad performance and this addition of standard filters.

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 Moderator on at
    [quote user="ERPMan"]

    This would be for all data for all customers we would like to publish in the API.

    We are in cloud and are running 20.4

    [/quote]

    Then i totally support the approach Zhu suggested to you.

  • ERPMan Profile Picture
    ERPMan 70 on at

    Thank you,

    How do you create a new page?

  • Suggested answer
    Amit Baru Profile Picture
    Amit Baru 3,043 on at

    Hi,

    Pls refer the below link:-

    https://erpconsultors.com/page-creation-in-microsoft-dynamics-365-bc/

    Regards

    Amit Sharma

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 621 Super User 2026 Season 1

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 445 Most Valuable Professional

#3
YUN ZHU Profile Picture

YUN ZHU 366 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans