Welcome, Guest. Please Login.
05/11/25 at 14:26:17
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Item lookup by Customer Name (Read 1014 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Item lookup by Customer Name
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,
Back to top
 
 
David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Item lookup by Customer Name
Reply #1 - 10/27/15 at 11:42:58  
It is an index in MTICMSTR and the Inventory grid maps to both files
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Item lookup by Customer Name
Reply #2 - 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.
Back to top
 
 
David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Item lookup by Customer Name
Reply #3 - 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.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Item lookup by Customer Name
Reply #4 - 10/28/15 at 08:18:56  
Ok, well it is what it is then.
 
Thanks,
Back to top
 
 
David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge