Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
BethanyW 7/23/2010 9:08:12 AM

VBA bug in the PM Batches window

I believe I've found a small VBA bug in theGP 10 PM Batches window. I'll document it here for the community, and because I'm hoping for that really huge reward that you get for things like this <smiles>

In VBA, if the batch number has 15 characters, the 'batch changed' event will not fire. It only happens when selecting the batch from the lookup. It fires correctly when navigating using the 'VCR' buttons at the bottom of the screen.

Steps to recreate:

Go to the PM Batches window (Purchasing > Batches)

Add the window to VBA

Add the BATCH ID field to vba

In VBA, add the BATCHID_CHANGED event

in the event, add:


Open the VBA Immediate window to see the DEBUG effects

Create two batches, one with 14 or less characters, and one with 15 characters, and select them using the lookup button, observe that the 15 character batch does not fire (note that the event always fires to clear the BATCHID, and not to repopulate)

Navigate using the VCR buttons at the bottom of the form, note that all batches fire correctly.

Version: Unknown or N/A
Section: VBA

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables