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

7

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:

Business Central

Business Central

Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,698 Super User 2024 Season 2 on at

Like (0)

Report

Price List

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans