ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Item lookup by Customer Name
http://www.istechforum.com/YaBB.pl?num=1445947994

Message started by David Waldmann on 10/27/15 at 05:13:14

Title: Item lookup by Customer Name
Post by David Waldmann on 10/27/15 at 05:13:14

I was going to edit the grid so that I could sort by Customer Name, but that is not a field in BKICMSTR, which is what the INVENTORY grid uses.

I'm guessing I can use an External UDF on BKARCUST to link Customer ID to Customer Name, but not exactly sure how to do that. Is there a Wiki article or something somewhere?

Thanks,

Title: Re: Item lookup by Customer Name
Post by Lynn_Pantic on 10/27/15 at 11:42:58

It is an index in MTICMSTR and the Inventory grid maps to both files

Title: Re: Item lookup by Customer Name
Post by David Waldmann on 10/27/15 at 12:12:41

I guess I can't figure out how to access it.

In the Index part of the screen, the Key Name dropdown only has MTIC.PROD.CUST, not MTIC.PROD.CUSNM.

Title: Re: Item lookup by Customer Name
Post by Lynn_Pantic on 10/28/15 at 08:09:42

Never mind, I misread. You are right, Customer Code is an index, not Customer Name. If it is not on the dropdown in the index section, it is not an index. You can add it to the grid but not make it an index.

Title: Re: Item lookup by Customer Name
Post by David Waldmann on 10/28/15 at 08:18:56

Ok, well it is what it is then.

Thanks,