Notifications
Announcements
No record found.
Hi, I have round one thousand new serialized items that I want to create in Great Plains. How can I use macro for that?
*This post is locked for comments
You need to uses SQL to do this. You create a select script based on your item numbers and descriptions. I would start by start recording a macro and then use Notepad to see what is in the macro file. Then create the SQL script based on what is in that file. When you run the script you then save the results as the macro and run the macro.
Hi Richard, Can you please clarify how this will work? Below is one of the item#, Description, Item Class and Serial#
* Item# ATE001VC
* Description Vault Copy
* Item Class Vault
* Serial# 001
Have you ever worked with GP macros before? You will start by going to Cards->Inventory->Item Maintenance. Then you start recording the macro and then enter the part number, description, class and anything else you need and then finally the serial number. Then you can stop the macro and save it. Using Notepad you can view the macro file. The hard part with be reading and interpreting what is in that file and then translating that into a SQL script. You can also modify the script to create as many S/N's as you need. This is not going to be a simple task so you will need to balance the time it will take to create this versus the time to enter the information.
I was able to create macro for one item and then through mail merge I was able to create the code for all the items.
Thanks,
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
