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 |