I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro?
I want to put it in the message box for the user.
I wrote a simple macro in VBA that enters an order and then posts it. On post, SAGE 300 assigns the next order number. How do I return that order number to the macro?
I want to put it in the message box for the user.
you will notice that the new order once posted remains on the screen in Sage 300 with the order number filled in
that means that the data remains in the views after posting
just show oeordh.fields("ORDNUMBER")
*Community Hub is the new name for Sage City