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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Select from scrolling ...
Microsoft Dynamics GP (Archived)

Select from scrolling window

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am trying to read all documents that have been selected from the apply payables documents scroll window in order to print them on a report. Is it possible to get these directly from the window using dexterity?

 thank you

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    Re: Select from scrolling window

    There is no way from Dexterity to programmatically scroll from one line to the next, you are always stuck with the record the user has selected, so it is not possible to read all the records  from the scrolling window directly.

    However, alternatively you could try reading off the table buffer and this is what most of us do instead.

  • Rashid Farooq Profile Picture
    Rashid Farooq 1,000 on at
    Re: Select from scrolling window

    I think you are having FlexGrid control concept in your mind, but scrolling window is much different than FlexGrid, you have to play with Table buffer.

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: Select from scrolling window

    IamET,

     You can get all selected records from PM_Apply_To_OPEN_OPEN(PM20100) table with Key Source is "Apply_XPMUserID" for particular vendor id. 

    you should read the data from that table before you click the OK of form apply payables documents. After click the OK button Key source will changed to REMITTANCE.

    Regards

    Jeganeedhi

     

     

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Select from scrolling window

    I was actually looking at PM20100 right now and the answer seems to be there. Thanks everyone

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Select from scrolling window

    An easy way to determine the Key Source is to get it directly from the Apply Window. It is a hidden field.

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Select from scrolling window

    I am not sure if i should get my data before or after the OK button is hit. I've noticed that upon selecting a document from the list the line is not always inserted in PM20100 (i think the last selected document is missing) so I think I have to get the data after the OK is hit.

    Also clicking OK changes the Keysource to Remmitance only if the payment has been posted.  If not posted the keysource is like Payment number plus a 6 at the end and remains the same even if OK is hit. I want to print the applied documents no matter if the payment has been posted or not which i can still do since I have the payment ID and Document Number, I don't see why the keysource is needed.

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Re: Select from scrolling window

    Yes you definitely don't need the Key Source in that case. There are many ways to do it, and that is why my original reply was general because I cannot assume the specific details of your requirement. The important thing is that you grasp the concept and you were able to use it to meet your goal.

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Re: Re: Select from scrolling window

    thanks everyone

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans