web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Price List

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

Suggested Answer

Price List

(0) Share

Report

Report

Posted on by Henrique_Mendes

38

Is there a way to match products on price lists based on the manufacturer reference?

As part of my business, we receive massive excel lists that are updated once or twice a year for the products we buy from our manufacturers. Updating these lists on BC is a nightmare.

Would be great to have a column with the manufacturer reference and allow the table (new price experience) to be edited from an excel.

Is this posible?

Categories:

Dynamics 365 Business Central

Dynamics 365 Business Central

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 102,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, have you tried the Edit in Excel function?

https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel#edit-in-excel
If you need to add new fields, you can refer to the following way, and you can add some logic you need in validate trigger.

Dynamics 365 Business Central: How to add custom fields in Edit in Excel: https://yzhums.com/39254/

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

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

#1

OussamaSabbouh 694 Super User 2026 Season 1

#2

YUN ZHU 481 Super User 2026 Season 1

#3

Khushbu Rajvi. 328 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans