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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Commission By Sales Pe...
Microsoft Dynamics SL (Archived)

Commission By Sales Person report is tripling results in SL 2015

(0) ShareShare
ReportReport
Posted on by Butch Adams 4,763

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?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    When you say you are getting "tripling results" does that mean that the amounts are tripled or you are getting 3 records when you should get 1?

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

    Multiple copies of every record, like a bad join.

    I replaced the view and the report from the SL7 system and they are back to work, but obviously that is not the right solution.

  • Community Member Profile Picture
    Community Member on at

    I took a look at the view (VR_DMG_40750) and compared it between DSL 7, 2011 and DSL 2015.  In 2015 they added a shipper ID from the SOShipLineSplit table to the select statement and to the Group By Statement.  That is the only change and the joins on the view are the same.

    I can't confirm this, but if there are multiple shippers for a single order line, this would create a separate record in the view for each shipper/Line combination.   Because and the report itself is displaying detail records, they would look like duplicates.

    I don't know why it would be 3 though.  It would seem to me that there would be duplicates based upon the number of shippers for the line item.  Are you looking at a limited sample size?  

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

    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.

  • Community Member Profile Picture
    Community Member on at

    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,763 on at

    No - unfortunately it isn't checked.

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

  • Community Member Profile Picture
    Community Member on at

    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. 

  • Community Member Profile Picture
    Community Member on at

    Butch,

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

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

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

  • Butch Adams Profile Picture
    Butch Adams 4,763 on at

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans