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 / Finance | Project Operations, Human Resources, ... / SOP Transaction Entry ...
Finance | Project Operations, Human Resources, ...
Answered

SOP Transaction Entry : Qty and Unit Price automatically changed to default 1 with default price when I scroll on Line Items (GRID)

(0) ShareShare
ReportReport
Posted on by Atul Patel 45

Hi,

I have customized Sales Transaction Entry form.  When Entry Details form (GRID) has vertical scrollbar and i follow below scenarios, QTY/Unit Price set automatically to default. (Qty :1 and Unit Price: item price)

  • Created quote with 10 line items
  • Open existing quote
  • Select Item Number in first line item in scrolling window (GRID) (Currently Cursor focus on Line 1 item number: e.g. Line 1 has Qty :50 and Price : $199)
  • scrolling down using Mouse Scroll wheel or clicking on down arrow from grid vertical scrollbars
  • Once scroll down, item 1 gets hidden
  • Click on Item number on line 9 (GRID)
  • Qty and unit price updated automatically to default on Line 1 item number. (e.g Qty : 1 and unit price default: $120)

This issue is happened when i manually scroll down/up using Mouse Scrolling wheel or clicking on Up/Down Arrow of Vertical Scroll bars. If I navigate through tab or up/down key, everything is working fine.

I have attached my issue below. 

2020_2D00_07_2D00_17_5F00_14_2D00_45_2D00_54.gif

How can i resolve this issue? Please help

For the customization, SOP entry form has two custom fields. One is on Sales Transaction Entry Form and another is on Sales Transaction Entry Detail form (GRID). Field at GRID level shows margin % on the fly while field at Entry form level shows margin % coming from database using VBA code.

Thanks,

Atul

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Verified answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Hi Atul,

    Would it be possible for you to post the VBA code here ?

    This is quite a difficult question to answer here without seeing the entire customization and the underlying code.

  • Verified answer
    bgajjar Profile Picture
    bgajjar 150 on at

    Hi Atul,

    It must be something wrong in your VBA code and GP AddIn code. switch to GP's default form and see if you get same issue.

    -Bharat

  • Atul Patel Profile Picture
    Atul Patel 45 on at

    Thanks for the reply. I have figured out the root cause. It happened because of those two custom fields and related to their VBA code.

  • Atul Patel Profile Picture
    Atul Patel 45 on at

    Thanks for your reply! I already checked with default form and works fine.

    I have figured out the Issue. Because of those two custom fields and their VBA code, it happened.

  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at

    Glad you figured it out.

    It was likely the VBA code that would not refresh some parts of the GRID portion, but hard to confirm without seeing the code :-)

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 490 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 429 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans