How to add records to the serial entry grid?

(0) Share

Report

Posted on by Buitre

Dear fellows:

I am developing a GP 2013 VBA customization in order to populate the list of serial numbers in POP_Serial_Entry window with records that come from a custom table. (The image is in Spanish).

With a button in this window I am able to call another windows where I select the items I want from that table.

After confirmation, I want to populate the grid with those serial numbers.

My problem is I don't know how to add records to it nor can I see the name of the control inside the form.

Any help would be very appreciated,

Thank you very much,

Gustavo

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Your screenshot did not display. You must insert it from a physical file - copy and paste does not work.

Was this reply helpful? Yes No
Buitre 95 on at

Like (0)

Report
Copy link

Link copied!

Sorry, here it is the image.

Adn another one with what I see at the VBA Project:

Thank you,

Gustavo

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

The 'control' you are speaking of is a scrolling window. GP scrolling windows do not act like the grid control you might be accustomed to in VB or VBA. The scrolling window is attached directly to a table, in this case I believe the table to be the IV00200 table. Here's a piece of wisdom from David Musgrave:

The usual method of filling a scrolling window is to use VBA to run the button or field script that contains the Dexterity fill window

command.

For example: You can run the Redisplay Button, or store the key field and run Clear Button and enter the key field value back to re-

load the record and re-fill the scrolling window.

You can also look at the unsupported method of running pass through sanscript via the continuum library to issue a fill window

command.

So you see, doing what you are trying to do with VBA is quite challenging. Have you considered doing this using Dexterity? It would be much easier.

Kind regards,

Leslie

Was this reply helpful? Yes No
Buitre 95 on at

Like (0)

Report
Copy link

Link copied!

Thank you, Leslie.

I was hoping there were a way to do it in VBA, but as you say it seems to be quite difficult.

I will then try with Dexterity.

Best regards,

Gustavo

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

You need to insert the values to Attache Table of serial number scrolling window and call the Redisplay button script. It will work.

Hope this helps!!!

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Yes, this will work,

All you are doing here is writing to the database table and refreshing the window to read from the table. I thought he wanted to display it on the window after he entered it on the transaction so that the regular business logic would run.

I'm probably wrong about that - thanks for the input. :)

Kind regards,

Leslie

Was this reply helpful? Yes No