Can you trigger a script to open Customer Inquiry when clicking on Totals tab in SO Invoice Data Entry?

Question

I am not well versed in scripting, but I know it can do a lot of wonderful things. I'm hoping this will be possible. 
 I have a customer that creates credit memos but they do not always apply them. They would like a way to checking their customer's invoices at the time they are doing invoices. 
 I was thinking there might be a way of triggering the Customer Inquiry screen (opened to the Invoices tab for the customer being invoiced) when you go to the Totals tab in SO Invoice Data entry, sort of the way it works when you click on the Customer button from Invoice Data entry. 
 If it can't be done when going to the totals tab, maybe I can create a button that would trigger it? Is it possible?

David Speck · Accepted Answer

Sage 100's scripts can only interact with the UI within the context of it's task. So as soon as you call oARCust.Process, any code after that is not going to execute until you close the "Process"ed task. Which is obviously too late for your requirements. 
 What you can do though is use the oSession's ScriptObject's SetStorageVar method to set a "flag" prior to calling oARCust.Process that can be retrieved using the oSession's ScriptObject's GetStorageVar method in a post load script attached to DMain of the AR_Customer.M4L library panel. If the flag is set, then invoke the pInvoice panel, otherwise do nothing,

Kevin M · Answer

Easiest way is to set up a PreTotals script (filtered to SO Invoice Entry) to invoke the pHeader button, then that CustomerNo button. If you've never scripted in Sage 100 before, writing a query as I mentioned above is probably not a good place to start.

Sage 100

Can you trigger a script to open Customer Inquiry when clicking on Totals tab in SO Invoice Data Entry?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING