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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Trying to see historic sales prices in Customer Data

(1) ShareShare
ReportReport
Posted on by 2
When I pull up a Customer Card and look under the /Prices & Discounts >> Prices/ tab, there is no data in there. We need this data to properly quote new work to our customers. How do I get the data from old invoices to populate in here so that I can create quotes quickly? Maybe there's another way to quickly create quotes for customers using what we charged them before? Just for background, we don't have a set price list, but each customer has different prices for different products. We both have unique SKUs for customers, but also have unique pricing. We know this adds complexity, but clients /design/ the product(s) they want in their first order and then order those same product(s) over and over again. And depending on when they started, the price for a very similar product can be very different. We need some way of quickly providing a quote using what they paid last time as the baseline for their repeat orders. Any ideas would be much appreciated!
I have the same question (0)
  • Suggested answer
    Renato Fajdiga Profile Picture
    1,855 on at
    Hi,
     
    there is an option to copy document on sales quote which will do exactly what you need.
     
    If you turn off Recalculate lines it should copy what was on previous document.
     
  • Suggested answer
    Jun Wang Profile Picture
    8,210 Moderator on at
    the price and discount could contain historic data if user set up a date range for different prices and discounts. But if user change prices on the fly, then you won't find info there.
     
    what you could do is use item ledger entries and get the historical prices from there
     
    Jun Wang
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,559 Super User 2026 Season 1 on at
    Or, using Recurring Sales Lines feature.
     
    Hope this helps as well.
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,028 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,121 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 669 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans