cancel
Showing results for 
Search instead for 
Did you mean: 

Error : multi part identifier

Former Member
0 Kudos

hi kings

when i using this query in crystal report sql command and excute its through the error --- multi part identifier "oitm"."ItemCode" could not be bound.

SELECT '61', '', GetDate(), 'TOTAL', "wor1"."ItemCode", Sum("wor1"."IssuedQty"),Sum( Convert(numeric(20,3),("wor1"."BaseQty""owor"."CmpltQty"))) 'Consumed Qty', Sum(Convert(numeric(20,3),("wor1"."IssuedQty" - ("wor1"."BaseQty""owor"."CmpltQty")))) 'Pending Qty', Sum("wor1"."U_UBundletoKg"), "oitm"."invntryuom", "ocrd"."cardname", "T0.Warehouse" FROM "OWOR" INNER JOIN "WOR1" ON "owor".DocEntry = "wor1"."DocEntry" INNER JOIN "OITM" T2 ON "wor1"."ItemCode" = "oitm"."ItemCode" inner join "ocrd" on "owor"."U_subcontractor" = "ocrd"."cardcode" ...

Thanks & best regards

B.Narain

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

-When we made any changes in database structure and then old report points to the old structure,at this time you may get this error.

-Other possibility is the specified field doesn't get the matching criteria(oitm).

-Check with the data type of Item Code and oitm.

Answers to these question will help us to move ahead.

Regards

Asha.

Former Member
0 Kudos

i solve that problem

Former Member
0 Kudos

Please,

how du you solved the problem?

Answers (0)