See the list of all customers and the special prices that they have and export it to excel.

(0) Share

Report

Posted on by Nertila Tila12

Hi all ,

Is that possible to see the list of all customers and they special prices on bussines central?

Then i want to export it on excel.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

Bilal Haider 485 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Have not you tried the Price List report (You have already asked about this). Using that you will get special prices for all customers and you can use excel as output and can transfer to it.

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 485 on at

Like (1)

Report
Copy link

Link copied!

On the report request page change the Sales Type to All Customers and then you will see for special prices for all of the customers.

Was this reply helpful? Yes No
Nertila Tila12 85 on at

Like (1)

Report
Copy link

Link copied!

Hi Bilal,

Yeah i tried, but when i filter like this, only for sales type customer is shows me this:

So to be runed this report needs to select one customer, in fact i want the list of all customer, and special prices. Those special prices are the same for all the products that customers buys,so if i look the name at the debitorcard I'd say the customer and his price group. How can i do that?

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 485 on at

Like (1)

Report
Copy link

Link copied!

In my previous reply i have shown in image to change the sales type to all customers. The option that is marked in black box.

Was this reply helpful? Yes No
Nertila Tila12 85 on at

Like (0)

Report
Copy link

Link copied!

On this report is not shows even the name of Customer, this report has only those fields:

(Sorry for clicking the "Actions" without purpuse)

Was this reply helpful? Yes No
Nertila Tila12 85 on at

Like (0)

Report
Copy link

Link copied!

I need to know what's the price the customer has. (Customer and the special price)

for example some pay 23.- for everything and some have special prices of 20.-

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 485 on at

Like (1)

Report
Copy link

Link copied!

It means your current company has no data in sales price table. Open Sales Price page and see if it has any records.

Also check if you are using any other filters on report.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,613 on at

Like (1)

Report
Copy link

Link copied!

Hi

Maybe try the following method

Search for "Customer Price Group" then Navigate and Sales Price

Then make sure "Sales Type Filter" set to "None" and "Sales Code Filter" is blank. Then you should be able to see all special prices. Then from Page -> Open in Excel take them to Excel.

Was this reply helpful? Yes No