web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Is there a maximum num...
Microsoft Dynamics CRM (Archived)

Is there a maximum number of "opportunity products" per "opportunity"

(0) ShareShare
ReportReport
Posted on by devinestorm 312

Hi all,

I'm having issues when importing to "opportunity products".  I'm analysing the opportunities with the issue and they all have a larger number of opportunity products than the ones that succeeded and was wondering it there was a maximum number of lines?

THANKS

*This post is locked for comments

I have the same question (0)
  • jlattimer Profile Picture
    jlattimer 24,564 on at

    There shouldn't be any maximum amount of lines you can associate with an opportunity. What is the exact error you are receiving?

  • devinestorm Profile Picture
    devinestorm 312 on at

    Hey Jason,

    Thanks for replying.  The message is "Error:  400:  Bad Request: Syntax error '%' at position 16".  But cant see anything different with this data......

    THANKS

  • devinestorm Profile Picture
    devinestorm 312 on at

    Hi again,

    So I had an opportunity with 40 lines, I input 10 manually and fine, once I got to the 11th (51 lines) it came up with the above error.  Any idea how to fix this?

    THANKS

  • jlattimer Profile Picture
    jlattimer 24,564 on at

    I'd try a test maybe with just the one line that is failing - starting with the minimum amount of fields to create the record and that adding additional fields. Hopefully this approach will flush out the issue - I suspect it is related somehow to the data.

  • devinestorm Profile Picture
    devinestorm 312 on at

    Hi again,

    That is pretty much what I did, I just added 11 "test" lines, with minimal data.  And when it got to 51 it came up with the error. I'm going to do a few more tests importing all the same data for various product lines, testing under 50 and over 50 to see if this is definitely the issue.

    THANKS

  • devinestorm Profile Picture
    devinestorm 312 on at

    Hey,

    So I setup 4 test opportunities that are exactly the same.  Then imported 49, 50, 51, 52 lines to the 4 ops (all lines exactly the same).  The first 2 were ok (49 and 50 lines), but the 2nd 2 failed with the error message mentioned above.

    THANKS

  • jlattimer Profile Picture
    jlattimer 24,564 on at

    I just tried a test and was able to import 74 lines to an Opportunity.

    What I did was create the Opportunity and than added 1 write in product. Exported the 1 line and copied it a bunch of times, changing the write in product name for each, and added a column for the Opportunity topic. Saved as a tab delimited file and then ran the import. All items succeeded.

    Are you using existing products or write in products? Do the lines beyond 50 work if you make them say lines 1 or 2?

  • devinestorm Profile Picture
    devinestorm 312 on at

    Hi,

    Thanks for all your help with this.

    We have bespoke elements and we dont actually use the product table.  Therefore we dont have any existing products.  Not sure what you mean by "write in" products.

    You can add more than 50 lines to the opportunity and save it, but you cannot recalculate and every time you open you get the error message, until you delete a line

    THANKS

  • devinestorm Profile Picture
    devinestorm 312 on at

    Hi again,

    It seems to be the recalculate opportunity that is causing the issue.  It doesnt like doing this for more than 50 product lines.  Does your one with 74 lines recalculate?

    THANKS

  • Verified answer
    jlattimer Profile Picture
    jlattimer 24,564 on at

    I was able to recalculate that Opportunity. Do you have any custom plugins registered against the Opportunity entity that might be interfering?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans