web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / 7000 serial numbers on...
Microsoft Dynamics GP (Archived)

7000 serial numbers on 1 POP

(0) ShareShare
ReportReport
Posted on by Antony W 35

I have several Excel books which contain 7000 serial numbers to be received on one POP.

Is there a way to import these serial numbers directly from the Excel book? Copy / paste keystrokes will have us crippled!

*This post is locked for comments

I have the same question (0)
  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Are they all for the same pop line?

  • Antony W Profile Picture
    Antony W 35 on at

    Yes all for the same line

  • Antony W Profile Picture
    Antony W 35 on at

    We could split them down if that made it easier ?

  • Tim Wappat Profile Picture
    Tim Wappat 5,711 on at

    Sorry I didn't see that you had replied.

    I'm thinking you could use a GP macro to do it.

    Paste all the serial numbers into one sheet so you can see what you are doing. Then record a macro for one serial number, and mail merge the rest in.

    Search on web for GP mail merge macros for you tube and website general tutorials.

    I would have thought it will work for what you are trying to do.

    <<Edit>>

    Just tested it with 7k serial numbers, takes long time for word to mail merge and a fair while to chug through the entry of the serial numbers, but does work. 
    I would be tempted to break it down into 1000 at a time and run it seven times to make it all a bit more responsive.

    Tim.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    In order to double the speed of the macro, use the Advanced Macro Menu >Status and select the checkbox next to 'No User Interface Flash'. If you don't have the Advanced Macro Menu, add the switch

    ShowAdvancedMacroMenu=TRUE

    to your Dex.ini file. As Tim suggested, I would also definitely break it down into smaller batches. I've been told the macro will fail if you try to do it all at once. I also think 1000 at a time is a good number to use.

    Kind regards,

    Leslie

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans