Skip to Content
0
Former Member
Aug 16, 2016 at 01:07 PM

Multi-part identifier "T1.ItemCode" could not be bound. '' (SWEI)

343 Views

Hi Experts,

I have created a report as below: and it was resulting as: "[Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "T1.ItemCode" could not be bound. '' (SWEI)"

SELECT T1.[ItemCode], T1.[Dscription]'Product Name', T0.

[CardName]'Supplier', T1.[U_VSPSLPCK], ROUND(T3.

[Quantity],1)'Analysis Qty', T1.[Quantity]'Final Ordr Qty', T1.

[U_VSPCKMRK]'Packing', T6.[U_VSPSPSHCT]'No. of units Per

carton', T1.[U_VSPTOTCT]'Tot No. of Cartons', T1.[Price]'PO

Price', T0.[DocTotal]'Total Amount', T1.[U_VSPCTDMN], T1.

[U_VSPCBMCTN]'CBM', T0.[DocNum]'PO No.' ,T5.[Quantity], 'GRPO

QTy', ROUND(T8.[Quantity],5)'Dispatched Qty', T0.[U_VSPINVNO]

FROM [dbo].[OPOR] T0 INNER JOIN [dbo].[POR1] T1 ON T0.

[DocEntry] = T1.[DocEntry], [dbo].[OPQT] T2 INNER JOIN [dbo].

[PQT1] T3 ON T2.[DocEntry] = T3.[DocEntry], [dbo].[OPDN] T4

INNER JOIN [dbo].[PDN1] T5 ON T4.[DocEntry] = T5.[DocEntry]

INNER JOIN [dbo].[OITM] T6 ON T1.[ItemCode] = T6.[ItemCode],

ODLN T7 INNER JOIN DLN1 T8 ON T7.[DocEntry] = T8.[DocEntry]

WHERE T0.[DocNum] = [%0]

Please find the mistake where i have done and help me out to execute it

Hope you will do needful

Thanks & Regards,

GRT |