Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

Commission By Sales Person report is tripling results in SL 2015

Posted on by 4,757

The default 40750i report is tripling results when run. It worked fine in SL 7 this system was upgraded from.

I have tried clicking the Select Distinct Records option in the Crystal report but that doesn't fix it. Any ideas?

  • jcb Profile Picture
    jcb 85 on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    I'm experiencing this problem in SL 2015 CU2.  Was there a fix?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    Has anyone else stumbled upon this problem with the OM Commission report tripling the number of lines in SL2011 fp1? One of our customers tried using the 40750C report format, and is having the same problem described in this thread. Most of their orders involve partial shipments, which I believe is the identified issue with the view VR_DMG_40750 that is used by all of the commission report formats. I haven't located an answer to this problem -- still searching the forums for an answer.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    :) Stating the obvious here, but you have verified that the underlying view is also tripling the records correct?  I.E. it is a data problem at the view level as opposed to a problem with the Crystal Report?

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    I appreciate your time on it Gregory. I'm torn between wishing you saw something obvious and glad you didn't :)

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    Elaine, I am able to reproduce it with the data in a test environment and just me logged in.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    Butch,

    See if you get the same results if no one else  is log into SL.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    I ran a transaction with multiple shippers and a consolidated invoice and it seems to work correctly.  See the screen shot below:

    As you can see the last invoice has 2 records but the amounts are correct and no duplication. 

    The only other difference I found in the view is that the 2015 version has Set ANSI_NULL On where the version 7 was set off.  But I doubt if that impacts it. 

    Because the old view works, the problem would have to be related to the new view but I'm at a loss what it could be. 

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    No - unfortunately it isn't checked.

    I'm am going to beat on it some to though.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    Look at OM setup Invoicing Tab and see if Consolidated Invoicing Available is checked.  That would allow multiple shippers on a single invoice.  If so I believe that would create that situation.

    I am testing it now.

  • Butch Adams Profile Picture
    Butch Adams 4,757 on at
    RE: Commission By Sales Person report is tripling results in SL 2015

    I just looked at a few pages and it seemed like it was three. After my first post I did notice one that had four.

    I am a replacement VAR for this client so I am new to their process, but I can't think of any reason they would have multiple shippers based on how they run things. I need to investigate that further.

    I saw an FP1 bug that described this problem similar to what you saw in that view, but when I compare the 2011 FP1 hotfix view to the 2015 stock view, they turned out to be the same.

    I'm going to review their OM data to see if this multiple shippers idea has legs.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans