Sage 100

Anyone know if it's possible to create a UDF in AR Customer to link to another AR Customer.  This is just as a reference point.  Customer has a billing relationship (no National Accounts) and just wants a good way to reference it.  Currently using Notes, therefore no good way to report. May do a UDT, but thought if we could link right to AR Customer it may be an option. 

Thanks in advance

------------------------------
John Wilder
Technology Integrators
------------------------------

Are you looking to create the UDF so it can do a lookup of all the customers?  If not, you can either do a UDT Table but if only 2 customers involved, just do a string UDF called 'Parent' or whatever and key in the Related Customer Number.
N

------------------------------
Nancy Hanson
Blytheco LLC
Eagan MN
------------------------------

Shadow table / UDT, if you need the lookup.  Scripted validation would work if you only need to ensure accurate data.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

If you don't mind a UI Post Load script, you can use the script I posted in the following thread to dynamically add a lookup icon to your udf, eliminating the need for a shadow table.
https://community.90minds.com/communities/community-home/digestviewer/viewthread?MessageKey=c7862932-dd09-401b-af9a-d591fb40fe49&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer#bmad4654e3-a580-4be9-94cb-064288150c82

I recommend reading the entire thread from beginning to end.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------