Query to show the name of the preferred vendor instead of the code

[Former Member]

I'm asking for a query to show the name of the preferred vendor instead of the code

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please try this query,

SELECT T0.[ItemCode], T0.[ItemName], T1.[CardName] FROM OITM T0  INNER JOIN OCRD T1 ON T0.[CardCode] = T1.[CardCode]

Thanks

[KennedyT21]

Hi Omar,

Do you mean to show the vendor name instead of the of the code in the item master data, then it is not possible by the standard you can create a udf and pull cardname using the FMS...

Cheers

[gaurav_bali]

Hi,

The query for Preferred vendors:

Select T0.ItemCode,T0.ItemName,T1.VendorCode,T2.CardName 'Prefered Vendor'

from OITM T0

inner join ITM2 T1 on T0.ItemCode = T1.ItemCode

inner join OCRD T2 on T1.VendorCode = T2.CardCode