ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> RTM Reports & Editing >> Inventory Listing RTM
http://www.istechforum.com/YaBB.pl?num=1327535424

Message started by carie on 01/25/12 at 16:50:24

Title: Inventory Listing RTM
Post by carie on 01/25/12 at 16:50:24

I need to put the Vendor Part number in this report - Anyone know which field it is?

~Carie

Title: Re: Inventory Listing RTM
Post by Lynn_Pantic on 01/25/12 at 18:42:54

It is in BKSBVEND which is not opened by IN-H because there can be many vendors assigned to a part.

Title: Re: Inventory Listing RTM
Post by Kelloggs on 01/26/12 at 12:32:43

:P

SELECT
BKICMSTR.BKIC_PROD_CODE,
BKICMSTR.BKIC_PROD_DESC,
BKICMSTR.BKIC_PROD_TYPE,
BKICMSTR.BKIC_PROD_UM,
BKICMSTR.BKIC_PROD_CAT,
BKICMSTR.BKIC_PROD_UOH,
BKAPVEND.BKAP_VENDNAME
FROM (BKICMSTR RIGHT JOIN BKSBVEND ON BKICMSTR.BKIC_PROD_CODE = BKSBVEND.BKSB_VEND_PROD)
LEFT JOIN BKAPVEND ON BKSBVEND.BKSB_VEND_VEND = BKAPVEND.BKAP_VENDCODE;

If you setup this report on ms access you can "group" the vendors for each part.

Kelloggs

Title: Re: Inventory Listing RTM
Post by carie on 01/26/12 at 13:03:30

The quick grid lookup - vendor-items with a filter on vendor was my easiest answer!

Thanks for the input though!

~Carie