Data Management error: Mix and match number should be positive

(0) Share

Report

Posted on by DZ-27040918-0

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

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Martin Dráb 240,045 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DZ-27040918-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Martin Dráb 240,045 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
DZ-27040918-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No