SUM and JOIN 2 columns with different tables but did not SUM Qty

• Site Owners

  SSC Guru

  Points: 80412

  More actions

  September 11, 2020 at 9:10 am

  #3787811

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Cebisa

  SSC Enthusiast

  Points: 151

  More actions

  September 11, 2020 at 10:15 am

  Answer

  #3787822

  You have 2 left join statements for BBI$Item ledger entry.

  I would take the second reference out

  Change your where clause to

  (

  (MS.[Entry Type]='1' AND

  MS.[Document No_] LIKE 'MSales%' )

  OR

  MS[Entry Type]='2')

   

   

  <!--more-->