Sage 100

Is there a way to add or change data in a UDF from the Inquiry Screens. Customer wants to add a ""Problem Code"" in Sales Order & Quote History Inquiry to orders for which customers complained about upon receiving their package. I can add the UDF and display it but cannot change or add anything because it is in Inquiry mode. Don't want to use VI either, just want to pull up the order, select the appropriate code and save the changes. TIA

Quick thought but could you change the Maintenance panels to not allow any changes except to the UDF? (Really quick thought....)

Therese, can't pull up the order in Maintenance. Order is invoiced and processed already. Only exists in the history files

Just had an idea, I guess I can create a UDT with 2 fields for Order Number and Problem Code and link to Sales Order History to get any reports they need. Just wondering if there is a better way.

You could also create a button script to prompt for the problem code. Something like: Input = """" Input = InputBox(""Enter problem code here"") AR_InvoiceHistoryInquiry_bus_UDF_Code = Input

I wonder if CRM is better suited for these types of requests. Seems like there can be a long thread of communications regarding an order after delivery, and an ERP system may not be best suited for the task.

You can add memos via AR Invoice History Inquiry. I wonder if security would allow the script to update the Invoice rec.

Thanks everyone. @MichaelNottoli I'm not much of a scripter, can the input box be a drop-down with a list of codes to select from? @LeeGraham we need to do reporting on this data and I'm not sure memo's are as easy to create crystal reports from.

Drop down boxes in vbscript seem difficult. Here's a link from stack overflow. I've used the ""solution"" form tmdean before. Clunky but it works. http://stackoverflow.com/questions/923503/how-to-create-options-dialog-with-vbscript

I've done something similar to this where I had to reset a UDF numeric to zero in A/R customer inquiry. I had to write some providex code to use the ""Implied write"" function after I do the reset. Not sure if it can be done via custom office scripting but I've done it.

For giving a list of choices in a script, I've used a list and buttons...