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) / How to deal with scrol...
Microsoft Dynamics GP (Archived)

How to deal with scroll-bar windows when using macros

(0) ShareShare
ReportReport
Posted on by ICH BIN ICH 55

Im running a macro to update inventory in our system 

its over 300 lines its getting stuck by row number 39 because the window need to scroll is there any way to make the window should scroll down 

I don't know SQL just regular macros in GP I think its GP 2010

Thanks

*This post is locked for comments

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    You can absolutely use the macro language to scroll the window down. If you have 39 records visible, someone must have increased the height of the window.

    On my system, the default number of records displayed is five (I expanded the rows to display both lines of the record). Given these assumptions, my macro will only be able to refer to records 1 through 5 and then it will need to scroll down to display the next line. In this scenario, each newly exposed line will still be record 5. For example, when you finish populating the 4th record, the following code will be included in your macro to advance to record 5:

          TransLinePrepare scrollwin 'IV_Transaction_Scroll'

    When you get to line 5 (the last record displayed) you will need to scroll down to display the next record. This new record will also be record 5, but to get the window to scroll down, you would need to include code such as this:

         TransLinePrepare scrollwin 'IV_Transaction_Scroll'

         ScrollByLine down scrollwin 'IV_Transaction_Scroll'  

    The secret is to include the words "  ScrollByLine down scrollwin 'IV_Transaction_Scroll' " in order to bring a new record into the scrolling window.

    Kind regards,

    Leslie

  • ICH BIN ICH Profile Picture
    ICH BIN ICH 55 on at

    Thanks Leslie Vail

    it worked

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans