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

Item Price List Report (BC16) By Customer Sales Price Only

(0) Share

Report

Posted on by Peter Waugh

145

Report - when printing a "Item Price list" , (report 7050)
> Price Cal Method - Lowest Price
> BC V16
> Assign to Type - Customer

is there a way to only show the prices listed in the "Sales Price List " assigned to that specific customer Filter out items not listed in the "sales price list"

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

Hi, I simply checked the standard code, and unfortunately, I haven't found a simpler way to do it. Report Extension is available since BC18 and It seems that you are using the On-Premise version. I think you can copy the original report and develop a new one.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Peter Waugh 145 on at

Like (0)

Report

Hi ZHU,

Apologies BC Version 19.5.36567.36634 (online)
Price Cal V16, as only option

Correct, the RDLC report filters to the Customers Price list Amounts, but in addition includes all items in the list
It would be good to option "show only price list items"

This is available function in RDLC reporter to make this type of filter !

PWW

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (1)

Report

A work around for this is to go to the customer that you want to report the prices for.

Chose sales prices.

The page that is shown then will only show item with a customer specific price then you can open that page in excel

Then you will have a customer specific sales price list in excel.

The other option is to create a specific customized report for this.

Was this reply helpful? Yes No