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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Issue in Scrolling window

(0) ShareShare
ReportReport
Posted on by

Hi all,

I have an issue in scrolling window (With Adds enabled). For example, I have the records in my TEMP table (Id is Primary Key) as below:

Id   name   age 

1    ABC      23

2   CBA       25

Initially when i fill the scrolling window,it will display as it is in the table (FYI, I am displaying Id also in the scrolling window and its not editable).

Now i want to insert a new line in between Id 1 and 2. 

To do that, In the LINE_INSERT event, I am first updating the Id=2 to 3 in the temp table. Now I am inserting the new record with Id=2 and  fields name,age empty and saving to the temp table(FYI, I am not using Fill window statement in LINE_INSERT event as mentioned in Dex help file that it gets called automatically with redraw option).

After LINE_INSERT code execution completes..the data in table is correct as shown below:

Id  name  age

1   ABC      23

2   

3  CBA       25

But in scrolling window it is displayed as below (Focus is on Line 2 to indicate user to enter name and age.The error here is Line 3 is showing 'Id' as 2 instead of 3)

Id  name  age

1   ABC      23

2                     

2  CBA       25

If i clear and fill the window the data will display correctly but the focus will be taken away from line 2 which is not desired.

Dont know if Dex Scrolling window supports this scenario. I am on Dexterity version 11.0.337.

Thanks,

Kiran

*This post is locked for comments

I have the same question (0)
  • Naga Kiran Profile Picture
    on at

    --------

  • Verified answer
    Dave Dusek Profile Picture
    on at

    If you are changing the key field in the table, you will need to refill the scrolling window because the table buffer isn't in synch with the window anymore.  However, you can use the fill from current so it will position your newly inserted record at the top of the scrolling window and the user will be on it.

    If you don't want to do that, then you have to key on a field that isn't Id, you would have to have a sequence number or something like that and it would not be displayed in the scrolling window.  Then instead of changing the key field, you would leave a gap of numbers between sequence, then you can use a new number instead of changing keys.  Similar to what we do in the sop entry scrolling window.  

    Dave

  • Verified answer
    Naga Kiran Profile Picture
    on at

    Hi Dave, Thanks for your reply.

    The second one you suggested definitely works as its is the one GP follows.

    After some R&D I found a solution for the scenario when the Key field is changing.

    I wrote the 'fill window' statement with redraw option in LINE_PRE event of the scrolling window which gets called after every Insert/Delete. By this way a new line gets inserted and focus will be on new line and 'Id' field gets updated as per the table.

    Once again thanks for your response.

    Kiran

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…

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