I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.
Essentially, instead of the user typing the invoice # they would type the sales order # into the invoice # field and then click the button script. The script is supposed to then perform a reverse lookup from the SO_InvoiceHeader table, but I can't figure out how to create an object that points to this table and performs the lookup.
Typing in the SO # and then clicking the button would then pull up the actual invoice # that has been assigned to the sales order. Sure, using the search button works as well but our users have to perform this search frequently for various reasons and I am just trying to make the process go a little smoother.
While I've tried many different methods that I was able to find online, here's the final one that I've attempted that (still) isn't working:
To my knowledge, SO_Invoice_Svc only contains the details for the current invoice and cannot be used to locate other invoices, so I just need a way to link to the appropriate data source and perform the lookup.
You all have been a great help before and I really do appreciate your time and effort!