Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Issue in navigate to n...
Finance | Project Operations, Human Resources, ...
Answered

Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

(0) ShareShare
ReportReport
Posted on by Atul Patel 45

Hi,

we have upgraded our GP from GP 10 to GP 2018. Before upgrade, our users were able to navigate to next/previous/first/last document or change document number from Find by Document Number window on Sales Transaction Entry Form. See marked section of attached screenshot.  After upgrade, when our users try to navigate to next/previous/first/last  or change document from the Find by Document Number window, GP gives an alert message like Save your changes in scrolling window line before continuing. They are not making any changes before they perform this action. See below error screenshot

Scrolling-Error.png

Because of above error message, they are frustrating because this is necessity of their daily routine work. I tried to find a root cause but didn't get it and didn't find any solution. There is a way to avoid that error but this is an additional step and that is annoying to do every time. The way is that I click on last empty row generated by GP and then perform mentioned action. It works fine without above message.

Please help me to resolve this issue and make my users happy.

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Atul Patel Profile Picture
    Atul Patel 45 on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    Hi Derek, finally i have resolved this issue. Issue was in VBA customization.  Thanks for your help!

  • Atul Patel Profile Picture
    Atul Patel 45 on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    Yes after this upgrade that VBA customization doesn't work. I need to change the logic of customization.  Thanks Derek

  • Verified answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    That may be true, but when upgrading from GP 10 to GP 2018, I'm sure you've changed Windows OS versions, SQL Server versions, Office versions as well as the Dynamics GP versions, so there's a lot of changes there that could potentially cause your modifications and/or VBA on this window to not work in the new version where it worked originally.

  • Atul Patel Profile Picture
    Atul Patel 45 on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    Derek, Old GP has the same modified/VBA version of Sales Trx Entry window. We just upgraded Dynamics GP along with all customized forms and reports. We didn't make any changes in this form. I will look into VBA/modifier of this form and will update you.

    Thanks for your response!

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    If you've verified that the issue is related to the modified/VBA version of the Sales Trx Entry window and it worked prior to upgrading Dynamics GP, I'd imagine you would need to look at whether it is the VBA or modification that is failing/causing this type of error message and then fix it for the new version of GP.

    Not sure if anyone will be able to say exactly since it is your custom form/window.

    Thanks

  • Atul Patel Profile Picture
    Atul Patel 45 on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    Thanks Derek!

    Yes this form is modified with VBA. I got the same message 'Do you want to save or delete the document?' when I made a changes in the line item of a document and attempted to navigation buttons.

    I applied your solution and assigned default version of Sales Transaction Entry Window. It works fine. No issue found in navigation.

    This modified version of form was working before we upgraded our GP. Even I tried to reproduce this issue in our old environment (GP 10) and didn't get the message, worked perfectly fine.

    Please suggest what else can cause this.

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Issue in navigate to next/previous/first/last document / change document in Sales Transaction Entry Form

    On my Dynamics GP 2018 R2 environment, when I bring up the Sales Transaction Entry window, I can still use the First, Previous, Next, Last navigation buttons at the bottom LH corner of the window using the 'By Document No.' , whether I have a document number / information showing in the window or not.

    From your screenshot, I noticed that your Sales Transaction Entry window is a modified window with VBA on it.

    As a test, if you setup your user to use the default/canned version of the Sales Transaction Entry window, do you still get the message about 'Save your changes in scrolling window line before continuing'?

    Even when I make a change in the line item of a document, then attempt to click one of the  First, Previous, Next, Last navigation buttons, I don't get the message you're seeing, but instead get a 'Do you want to save or delete the document?' message with options of Save, Delete and Cancel.

    Let us know what you find.

    Thank you,

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans