web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Prior Item Price
Microsoft Dynamics NAV (Archived)

Prior Item Price

(0) ShareShare
ReportReport
Posted on by DMV 1,042

Good Morning-

So, I thought this was going to be a simple question from my client but, I cannot find an answer.  They want to be able to run a report to find the price they previously charged a customer for a specific item.  They have special offline pricing for some customers and want to be able to look up that prior transaction sell price to ensure pricing consistency.

I'm looking for something like the Customer Order Detail report but, using posted invoices.  I cannot find any report or any way to do a lookup on this, without knowing the invoice number.  I know the sales invoice line table has the info.   Do we need to do a custom report here?  It just seems so basic that I feel like I am missing something.

They are on 7.0 SP1

Thanks,

Diane

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 49,097 Super User 2025 Season 2 on at
    RE: Prior Item Price

    You can filter on the Value Entry Data Item for the Document No. which is the invoice no.  even though it does not display on the report, you can filter and just modify the report to include the document no.

  • DMV Profile Picture
    DMV 1,042 on at
    RE: Prior Item Price

    Yeah, I guess that's what we need to do.

    thanks

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at
    RE: Prior Item Price

    best way will be a simple custom report on base of table sales invoice line, filtered by customer no. and posting date (range) to get the needed price info.

  • DMV Profile Picture
    DMV 1,042 on at
    RE: Prior Item Price

    Yes, I did see that and thought the same thing.  However, it doesn't even break it out by invoice-- just lumps them all together under one total amount.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 49,097 Super User 2025 Season 2 on at
    RE: Prior Item Price

    Check Customer/item Statistics report, it may not have the unit price but it gives the Amount and you can get the price by dividing by quantity or modify the report to include the price.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans