Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Data Management error:...
Finance | Project Operations, Human Resources, ...
Unanswered

Data Management error: Mix and match number should be positive

(0) ShareShare
ReportReport
Posted on by Community member 4
I got the following error when uploading a CSV file through Data Management, can someone help me to fix this? Thank you in advance!
 
I am using Finance and Operations, Microsoft 365, Web Version
  • Community member Profile Picture
    Community member 4 on at
    Data Management error: Mix and match number should be positive
    Hi Martin, I did not put in a number for the field, following the instructions and sample Excel files from the previous person, I put in the letter "C" for the field, which stands for 3 "Number of products needed" in the "mix and match line groups" setting. From the previous recording, the person put in a letter for the field and successfully uploaded the Excel file, however, I can't make it work following her steps...
  • Martin Dráb Profile Picture
    Martin Dráb 230,188 Most Valuable Professional on at
    Data Management error: Mix and match number should be positive
    All right, so it seems to be about MixAndMatchNumberOfItemsNeeded field of RetailDiscountLineEntity.
    It indeed doesn't accept negative values. Is your intention doing so or are you using a negative value there by mistake?
  • Community member Profile Picture
    Community member 4 on at
    Data Management error: Mix and match number should be positive
    Hi Martin, thank you for the correction. I am using the "Periodic discount line" entity. The same entity for the "Unit (UnitOfMeasureSymbol)" error in the previous post. Thank you!
  • Martin Dráb Profile Picture
    Martin Dráb 230,188 Most Valuable Professional on at
    Data Management error: Mix and match number should be positive
    I've moved your thread to the right forum (is about F&O, not about D365 in general) and made the title less vague.
     
    Now please tell us more about the problem. Most importantly, which entity are you using?
     
    The same applies to your previous thread.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans