News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Historic Sales Prices

Business Central forum

Answered

Historic Sales Prices

(0) Share

Report

Report

Posted on by KHayston

76

Hi

I am looking for somewhere that I can look up a list of sales prices used in the past for an item.

If I go and check the Item Ledger Entries (via Inventory on Item card) it will give me the total sales for the number of items sold on the orders.

We can see we sold 25 of an item for a total price of x.

We want to see what the x/25 was - for all my past orders.

And I have the funny feeling that the reply will be: customisation.

Thanks for all your help.

Katarina

Categories:

Financial Management

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

KasparsSemjonovs 3,649 Super User 2024 Season 2 on at

Like (0)

Report

Historic Sales Prices

You can open: "Posted Sales Invoice Lines" page, and there You can filter out for specific Item. You will see the Unit Price column there, and also Line Discount % column. But the Final price is still only shown for the whole Quantity in column Amount or Amount Incl. VAT.

If You want to see the sales prices with the Discount amount together- easiest way would be to export to Excel this list or Item Ledger Entries and add a new column Amount / Qty.

Helpful resources

News and Announcements

New Dynamics 365 Community Call! (ERP Edition)

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,107 Super User 2024 Season 2

#2

Martin Dráb 227,969 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans