Hi,
I need to make a report that shows all inventory items in the warehouse, they need the unit of measure (UOM), Vendor name, description, location. Please advise me what tables I should look into.
Below is the extract from one of my reports that shows all items of each vendor/supplier . However it doesn't have UOM.
SELECT MyItem.SEARCHNAME AS Search_Item_Name, MyVendorItem.EXTERNALITEMID AS Vendor_Item_No, MyVendorItem.ITEMID AS Item_No,
MyItemDesc.NAME AS Item_Name, MyItemDesc.DESCRIPTION AS Item_Description, MyVendorItem.EXTERNALITEMTXT AS Vendor_Item_Name,
MyVendorItem.CUSTVENDRELATION AS Vendor_ID, MyGenVendorInfo.NAME AS Vendor_Name
FROM CUSTVENDEXTERNALITEM AS MyVendorItem
INNER JOIN ECORESPRODUCT AS MyItem ON MyItem.DISPLAYPRODUCTNUMBER = MyVendorItem.ITEMID
INNER JOIN ECORESPRODUCTTRANSLATION AS MyItemDesc ON MyItemDesc.PRODUCT = MyItem.RECID
INNER JOIN VENDTABLE AS MyVendor ON MyVendor.ACCOUNTNUM = MyVendorItem.CUSTVENDRELATION
INNER JOIN DIRPARTYTABLE AS MyGenVendorInfo ON MyVendor.PARTY = MyGenVendorInfo.RECID
Thanks
Thai
