Open Forum

 View Only
  • 1.  Possible Bug found for Commission by Salesperson (40.750.00) report

    SILVER CONTRIBUTOR
    Posted Nov 04, 2021 11:58 AM
    I believe there is bug that shows in the Commission by Salesperson (40.750.00) report that will allow for multiples of the same invoice to show for a single salesperson. The SQL view used in the report is the vr_DMG_40750. In the FROM section there is a missing restriction on the first ARTran JOIN. The s.LineRef = t.ShipperLineRef  line (in Red) needs to be added to the view to correct the data. The issue has been there since at least 7.0 FP1 as I had just upgraded the client to 2018 CU6.

    INNER JOIN ARTran t ON
    d.CpnyID = t.CpnyID AND
    d.CustId = t.CustId AND
    s.ShipperID = t.ShipperID AND
    d.RefNbr = t.RefNbr AND
    s.LineRef = t.ShipperLineRef AND
    t.TranClass = 'N'
    LEFT OUTER JOIN ARTran ARTranDisc ON
    d.CpnyID = ARTranDisc.CpnyID AND
    d.CustId = ARTranDisc.CustId AND
    s.ShipperID = ARTranDisc.ShipperID AND
    s.LineRef = ARTranDisc.ShipperLineRef AND
    d.RefNbr = ARTranDisc.RefNbr AND
    ARTranDisc.TranClass = 'D'

    Just wanted to put this out there for all in case they have the same issue.

    ------------------------------
    David Safstrom
    Senior Consultant
    NexTec Group
    Houston, TX / Roswell GA
    ------------------------------


  • 2.  RE: Possible Bug found for Commission by Salesperson (40.750.00) report

    TOP CONTRIBUTOR
    Posted Nov 04, 2021 01:08 PM
    Yes, that's a known bug, ID 327834.

    ------------------------------
    Jonathan Van Houtte
    Architect
    XLstatements, LLC
    Clifton Park NY
    ------------------------------