Sage 100

I have a customer that wants a duplicate Vendor lookup in Inventory Maintenance. i need to be able to add another lookup field into AP Vendor Master and be able to select a vendor and store it in that UDF field. I vaguely remember making a shadow table or something that will work without exporting or importing into another UDF. Anything you can help with is great. Sage 100 V5.0/to

First create a UDT (you can call it Vendor Shadow) and populate it with the applicable vendors. Next create a UDF in CI_Item and validate it to the UDT. The UDF will then have a lookup with the vendors in the UDT. You can feel free to e-mail or call me with follow up.

OK, but not seeing where i can have it lookup Vendor Master without manually populating the UDT field values?

Create a VI import to update the UDT

The UDT doesn't look up to vendor master. It is its own table. There are some scripts that Steve Malmgren wrote to maintain a shadow table for new records, edits and deletes. But it's not a shadow in the sense that it's a lookup to the original master.

yes but then customer needs vi and you would need to update it manually. i just need another lookup just like the primary vendor lookup but another one.

scripts sound cool. Are they anywhere i can get my hands on them?

I'll email them to you tomorrow.

Didn't I just watch a video where a button was added to the screen that could be linked to a MAS task so the task could be opened from that screen and users didn't have to venture? Yes I did. That is if a button to link to the Vendor Inquiry screen would suffice. Much simpler than maintaining a UDT should it meet the customer's needs. (Again documented by our wonderful 'Professor' Steve Melgram). I have the video marked in YouTube.

I am wondering if one couldn't just put a check box UDF labeled ""Secondary"" and a Secondary Vendor UDF field by the Primary Vendor field then use a script to trap the vendor change. If the check box is set then update the secondary vendor UDF from the Primary Vendor and restore the Primary Vendor changed by the look up. (saving the Primary Vendor could be done on the table post read event.) Voila secondary vendor using the primary vendor look up!

@MichaelNottoli - Michael - could you post the scripts here, as I was looking for them recently as well. Thx.

Here's two scripts from Steve Malmgren's Summit session. BT_SyncItemShadow is a button script that can be put in Item Maintenance. It loops through CI_Item and adds applicable items to the UDT. CI_Item_Post_Write is a script that is triggered on the table's post write. It adds new items to the UDT. I've modified these examples multiple times to create shadow tables for AR_Customer, AP_Vendor, etc.

Thanks!