SQL -Multi-part identifier can't be found.

Hi EE,

I have the following query:

 SELECT     VENDPACKINGSLIPJOUR.ORDERACCOUNT, DIRPARTYTABLE.NAME, VENDPACKINGSLIPTRANS.ITEMID, VENDPACKINGSLIPTRANS.NAME AS ItemDescr,
                      VENDPACKINGSLIPTRANS.PURCHUNIT, SUM(VENDPACKINGSLIPTRANS.QTY) AS Aantal, SUM(VENDPACKINGSLIPTRANS.VALUEMST) AS Bedrag,
                      INVENTDIM.INVENTSIZEID, INVENTDIM.INVENTCOLORID
FROM         (VENDPACKINGSLIPJOUR INNER JOIN VENDPACKINGSLIPTRANS ON VENDPACKINGSLIPJOUR.PACKINGSLIPID = VENDPACKINGSLIPTRANS.PACKINGSLIPID
  INNER JOIN VENDTABLE ON VENDPACKINGSLIPJOUR.ORDERACCOUNT = VENDTABLE.ACCOUNTNUM AND
                  DIRPARTYTABLE.RECID = VENDTABLE.PARTY AND
                      VENDPACKINGSLIPTRANS.DATAAREAID = VENDTABLE.DATAAREAID AND
                      VENDPACKINGSLIPJOUR.DATAAREAID = VENDTABLE.DATAAREAID INNER JOIN
                      PURCHTABLE ON VENDTABLE.DATAAREAID = PURCHTABLE.DATAAREAID AND
                      VENDPACKINGSLIPJOUR.PURCHID = PURCHTABLE.PURCHID INNER JOIN
                      PURCHLINE ON PURCHTABLE.PURCHID = PURCHLINE.PURCHID AND VENDTABLE.DATAAREAID = PURCHLINE.DATAAREAID AND
                      VENDPACKINGSLIPJOUR.PURCHID = PURCHLINE.PURCHID INNER JOIN
                      INVENTDIM ON PURCHLINE.INVENTDIMID = INVENTDIM.INVENTDIMID AND VENDTABLE.DATAAREAID = INVENTDIM.DATAAREAID
WHERE     VENDPACKINGSLIPTRANS.DELIVERYDATE >= '2019-01-01' AND VENDPACKINGSLIPTRANS.DELIVERYDATE <= '2019-12-01'
GROUP BY VENDPACKINGSLIPTRANS.ITEMID, VENDTABLE.NAME, VENDPACKINGSLIPTRANS.NAME, VENDTABLE.DATAAREAID,
                      VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDPACKINGSLIPTRANS.PURCHUNIT, INVENTDIM.INVENTSIZEID, INVENTDIM.INVENTCOLORID

Select allOpen in new window

I am trying to include the   DIRPARTYTABLE.RECID = VENDTABLE.PARTY into the query but it's giving an error multi-part identifier can't be found.

Below is a query that I have managed to incorporate the  DIRPARTYTABLE.RECID = VENDTABLE.PARTY into successfully:

              SELECT distinct VENDTABLE.DATAAREAID ENTITY, VENDTABLE.ACCOUNTNUM, DIRPARTYTABLE.NAME,Address.ADDRESS ,
 VENDTABLE.CURRENCY ,VENDTABLE.VENDGROUP ,
 VENDTABLE.PAYMTERMID,VENDTABLE.TAXGROUP VATGROUP ,VENDTABLE.CASHDISC ,
 VendBankAccount.ACCOUNTID BankAccount ,VendBankAccount.NAME 'Bank Name' ,VendBankAccount.ACCOUNTNUM 'Bank account number',
 VendBankAccount.RegistrationNum 'Routing Number',VendBankAccount.SWIFTNo,VendBankAccount.BankIBAN
 from VENDTABLE left outer JOIN VendBankAccount ON VendBankAccount.VENDACCOUNT = VENDTABLE.ACCOUNTNUM --AND  VendBankAccount.ACCOUNTID = VENDTABLE.BANKACCOUNT
 left outer join DIRPARTYTABLE ON DIRPARTYTABLE.RECID = VENDTABLE.PARTY
 left outer join LOGISTICSPOSTALADDRESS AS Address ON Address.LOCATION = DIRPARTYTABLE.PRIMARYADDRESSLOCATION
  WHERE VENDTABLE.DATAAREAID IN ('EF') --and VENDTABLE.ACCOUNTNUM ='test033'
 Order by  VENDTABLE.DATAAREAID,VENDTABLE.ACCOUNTNUM

Select allOpen in new window

How can join the DIRPARTYTABLE.RECID = VENDTABLE.PARTY relationship into the first query?

Any assistance is appreciated.

Thank you