Skip to main content

Notifications

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

Price List

Posted on by 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? 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,296 Super User 2024 Season 2 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans