Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / New Price list using c...
Small and medium business | Business Central, N...
Suggested answer

New Price list using configuration package

(1) ShareShare
ReportReport
Posted on by MB-21100936-0 12
We are uploading the current sales price list using a configuration package, tables 7000 and 7001 for lines.  When we try to apply the new lines, we’re receiving an error message for all lines as  the source No field is empty or zero, actually  is informed in the  Excel .

Please, if somebody find out to solve this error, and share the solution I will appreciate
 
Categories:
Business Central
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 4,615 on at
    New Price list using configuration package
    This issue typically arises from missing or improperly formatted data in your Excel file. To resolve this, ensure that the "Source No" field is filled with valid values, verify that the data is correctly mapped to tables 7000 and 7001, and check for any data validation errors in the Excel file.
  • Suggested answer
    Tech_BC_Gokul Profile Picture
    Tech_BC_Gokul 295 on at
    New Price list using configuration package
    Hi

    Could you try this feature, Price worksheet approach, which can help you in editing existing pricelist with reopening and making the changes in all the price list together, 
     
    hope that helps resolving this query 
     
     
    Please review and mark this as answered if it resolves your query. 
     
    Thanks 
    Gokul
  • Suggested answer
    MB-21100936-0 Profile Picture
    MB-21100936-0 12 on at
    New Price list using configuration package
    Hi
     
    Thanks for your quick reaction, I did before, but , is a high risk to remove the validation check ? Or if I keep validation active on items and customers, and personalized deactivated, I understand as all values will be validated
     
    I will check it adding a wrong item code
     
    Rgds!!
  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    New Price list using configuration package
    This means BC is asking for the source no, related fields for your package. My suggestion is to include those if you haven't, If you already did, try to turn off the validation for the fields and see if it helps. 

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans