web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,853 on at
    Trying to see historic sales prices in Customer Data
    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,182 Super User 2025 Season 2 on at
    Trying to see historic sales prices in Customer Data
    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
    93,135 Super User 2025 Season 2 on at
    Trying to see historic sales prices in Customer Data
    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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,761

#2
Sumit Singh Profile Picture

Sumit Singh 2,611

#3
YUN ZHU Profile Picture

YUN ZHU 1,975 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans