Sage 100

Updating records in AR_InvoiceHistoryHeader A client needs to update values in a UDF for records in AR_InvoiceHistoryHeader. I don't think this can be done in #VisualIntegrator -- can this be done with #Scripting, or is there another solution? Thanks in advance. #solved

I've VI'd them before.

Easy to do. You do need the Invoice # AND the header sequence record as part of the import.

Very good. Thanks @BethBowers and @JeffSchwenk.

This can also be done in scripting, however the if script is on an inquiry panel then a message is generated that indicates that the change cannot happen, but it does! Maybe someone else could tell me how to avoid that message. Otherwise an external BOI script can write directly to the history table, but one should think about the implications of overwriting the history table. Leaving an audit trail with UDF's containing the user id and date changed would be prudent.

In BOI, we have worked around this problem with a UDT with the key (invoice and hdr seq) and UDFs. This table can then be joined for reporting.