Data Management error: Mix and match number should be positive

(0) Share

Report

Posted on by Community member

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

All responses (4)

Answers (0)

Community member 4 on at

Like (0)

Report

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 230,488 Most Valuable Professional on at

Like (0)

Report

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 4 on at

Like (0)

Report

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 230,488 Most Valuable Professional on at

Like (0)

Report

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.