Sage 100

Best method to add populate a ""shadow"" table? Want to create a UDT that contains the vendor numbers & names for validation in AR Invoice Line Detail. Client wants to make AP Invoices from an AR Invoice history export and the vendor will be determined from the AR invoice line. We plan to validate the field using a vendor number table. Any suggestions on how to keep the table populated?

I'd cut out the middle man and script validation to the live table. Detail table pre-write, get the UDF values, use them for a lookup in AP_Vendor. Record not found >> SetError...

My first thought was to export out the vendor info and import into the UDT on a nightly basis. Difficult to use a script approach like you described? Haven't personally done much with script language.

For an experienced script writer, I'd think it would be about an hour's work to implement. (Alnoor's scripting class is gold!).