Sage 100

2014 Premium. I have a UDF checkbox in AR InvoiceHistoryHeader. I would like to have a user be able to modify the checkbox in AR Invoice History Inquiry. I can change it using SQL Server MGMT Studio. What are my other options?

We do have an enhancement http://www.dsdinc.com/enhancement/ar-invoice-history-edit/

Thanks Nicole. They don't need to modify this that often so trying to avoid a source code mod. Maybe free dfdm or possibly a script?

Either of those are both options. Maybe add a button script to change the field. Personally - I'd just change it directly in SQL.

We've created a button script many years ago to update the sql data. The client was coming from a custom system and needed to have the ability to update payment status comments in history records.

We've made button scripts that trigger SQL stored procedures.

Perhaps this post might help you with this. https://90minds-com.socialcast.com/messages/36360060?ref=stream

@DavidSpeckII Thank you!! Exactly what I am looking for.

I have a Sage 100 Adv client who needs something like this, as an ongoing process for a decent volume of data.  I'm going with a VI import since that seems like it's feasible for their need, unless they prefer the DSD enhancement.

------------------------------
- Brett
------------------------------

Original Message:
Sent: 11-08-2017 07:14
From: Doug Higgs
Subject: 2014 Premium. I have a UDF checkbox in AR InvoiceH

@DavidSpeckII Thank you!! Exactly what I am looking for.