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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Extended Price Table
Microsoft Dynamics GP (Archived)

Extended Price Table

(0) ShareShare
ReportReport
Posted on by Nazim Syed 180

Hi there,

Which table has the information about Extended Product Price, Customer assigned to that price list.how are they linked?. basically i want to create a view where i can see the pricelist, customer, fromdate,todate,Product and Price .

Another question, does Sales Invoice records the information about the pricelist price at that time, if so which table and field has this info.

 


*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    The Extended Price tables are SOP407x

    When a sales transaction is first created, the system retrieves prices from the price tables.  These can be edited by the user and are not updated again by the system.

  • Nazim Syed Profile Picture
    Nazim Syed 180 on at

    Thanks for your response.

    But is the Pricelist Price recorded anywhere like the Cost , if so how can i know the PriceList price for a invoice of previous date. Which table records this info?

     

     

     

     

     

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    There is a set of pricelist tables that are applied to the sales transactions.  However, as changes are made to these tables, there is no historical price table to show what the prices were when a transaction was created.

  • Community Member Profile Picture
    Community Member on at

    Hello All,

    I have setup extended pricing and i was able to assign it to sales invoice(Inv01) successfully. Is there
    any table having the details of a price sheet or book assigned to a particular Sales invoice(Inv01).

    My setup is a simple extended pricing and not related to any promo free items.

    Any help is widely apprecated.

    Thanks,
    Arun.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Price Sheets and Price Books are assigned to Customers, so there is no direct link between a Price Sheet and an invoice.  Price Sheet Details are found in IV10401 and IV10402.  Customer Price Sheet assignments are found in RM00500.  You could write a query on the SOP transaction table with joins to RM00500 and IV10402 to derive the info you are looking for.

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans