Notifications
Announcements
No record found.
Is there a way to run a macro on field exit?
*This post is locked for comments
Can you provide further details on the macro that you want to record ?
On the sales transaction entry screen, when I choose and order and tab through and it gives me a document number, then I tab to the customerid and when I type a customerid number there and hit tab I want my customer notes to pop up. It worked in gp10.0 using extender but gp2013 extender do not have macros anymore, so i'm looking for a work around.
So you want your Macro to open the Note window for the customer, type in a note and then get back to fill out the transaction details, right ?
correct
On recording the Macro, after choosing the customer number, just click on the note field and add the required attachment. Click attach which will load the original form of the Sales Transaction Entry window.
A sample is shown below as recorded randomly on Fabrikam test company,
# DEXVERSION=12.00.0270.000 2 2CheckActiveWin dictionary 'default' form 'SOP_Entry' window 'SOP_Entry' ClickHit field 'SOP Type' item 2 # 'Order' ClickHit field 'SOP Type' item 2 # 'Order' MoveTo field 'Document ID' MoveTo field 'SOP Number' MoveTo field 'Customer Number' CommandExec form BuiLtin command cmdEditPaste TypeTo field 'Customer Number' , 'ATMORERE0001' MoveTo field 'Customer Name' MoveTo field 'Note Array Absent - Window Area'[5] ClickHit field 'Note Array Absent - Window Area'[5]
NewActiveWin dictionary 'default' form 'Form_Note_1' window 'Form_Note_1' SelectChars field 'Text Field' ssel 0 esel 0 TypeTo field 'Text Field' , 'test' MoveTo field 'Attach Button' ClickHit field 'Attach Button' NewActiveWin dictionary 'default' form 'SOP_Entry' window 'SOP_Entry' ActivateWindow dictionary 'default' form 'SOP_Entry' window 'SOP_Entry'
MoveTo field 'Currency ID' # Key 1: MoveTo line 1 scrollwin 'Line_Scroll' field 'Item Number'
Please take into consideration that the note added on the customer level is attached to the customer entity and will be populated for further sales transactions.
Your feedback is highly appreciated,
not sure I explained it correctly the notes window i'm looking for was created with extender. So when there is a customerid entered I can go to additional and choose customer notes! which I created in extender. This is the window I want to come up once I put the customer id in and tab off of it.
1. Run a macro (Go to Tools-->Macro-->Record).
2. Select the customer id then go to additional menu and choose the notes.
3. Then stop the macro(Go to Tools-->Macro-->Stop).
4. Finally play for a test(Go to Tools-->Macro-->Play).
Hope this helps!!!
I got this to work, but I want set it up to play as soon as I table off the customerid window
Larry,
Start the recording at the required point, and play the point accordingly upon the required point. I believe you have never worked with Macros, and therefore, check the tutorial provided by Mr. Mark long time ago Dynamics GP - Macros
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1