Small and medium business | Business Central, N...

Best Price Sales Analysis -

(0) Share

Report

Posted on by Tattylashes

Hi,

Is the PRICE LIST or DISCOUNT source of the 'Best Price' charged an available report in sales analysis?

I'd like to mass analyse sales history and analyse sales by the origin of Best Price, by DATE ,ITEM Group or CUSTType /Disc,and a tag or code that identifies the price calculation method would be very insightful

Using excel to cross ref this would be far too complex, so I was wondering if I am missing something in the Sales Order Line tables?

Thanks

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 84,318 Super User 2025 Season 1 on at

Like (0)

Report

RE: Best Price Sales Analysis -

Hi, you can submit your idea to Dynamics 365 Application Ideas site. If it receives a lot of votes, Microsoft will consider adding it to a standard feature.

https://experience.dynamics.com/ideas/categories/?forum=e288ef32-82ed-e611-8101-5065f38b21f1&forumName=Dynamics%20365%20Business%20Central

Hope this helps.

Thanks.

ZHU
Tattylashes 5 on at

Like (0)

Report

RE: Best Price Sales Analysis -

Thanks, for replying.

If the PRICE LIST CODE name was available from where the BEST PRICE was picked up from, that would probably be sufficient. I could make my own report in Excel.

I'm assuming the 'item price list code' used to calculate the 'Sales Amount' on the ITEM LEDGER ENTRY table isn't linkable from anywhere is it?

Or coming at it the other way, posted sales lines by Price List, maybe via 'SALES STATISTCS'

Best wishes

Jane
Suggested answer

Dallefeld 175 User Group Leader on at

Like (0)

Report

RE: Best Price Sales Analysis -

It is not an available report but I like your thought process and a report would be an awesome tool.