How to add PM20000 table to the AP Check with stub on top and bottom graphical

(0) Share

Report

Posted on by Peggy L. Aitken

246

I need to add the Shipping Method field to the default AP Check with Stub on Top and Bottom. It's not available in in any of the tables that already exist AP Check but is available in the PM20000 table. I'm having trouble adding that table to the existing AP Check format in Report Writer. Hope there's someone that can tell me how to add the table.

Thank you in advance for your help!

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (2)

Peggy L. Aitken 246 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

I have Defined a relationship between the PM Payment Work and the PM Transaction Open so I'm was able to add the Shipping Method to the Check. However, the field doesn't print on the report. The data does exist on the I verified the data type is Data and the shipping method does exist on the invoice for which I'm printing a check. Must be something wrong with the relationship I've created. Below are print screens of the relationship details.

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

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Does your client realize that since a single check can pay off many invoices, the shipping method is not tied one-to-one to a check. Have you got any idea of what your client wants there report to look like? Or do you just want to add the PM20000 table to the check with Stub on Top and Bottom? Does she pay each invoice with one check? We can make the relationship, but it may not give you the desired results if they ever use one check to pay off two or more invoices

Was this reply helpful? Yes No
Peggy L. Aitken 246 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Leslie,

Thank you so much for your quick reply!

I intend to place the Shipping Method in the Body with the Doc # and Amt Paid. We will only have one Shipping Method per invoice so I believe it should work. The relationship I created ended up with MANY errors so I had to delete the reports.dic and import my package file before I messed it up.

We are out of fields and need to store a TYPE in the Shipping Method field. From what I see the PM20000 is the only table I can pull it from. And, as I said all I did was really screw it up. Sure hope it can be done!

Thanks again for your help.

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

Like (1)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Peggy,

Aren't you local to me? I think I remember meeting you about 15 years ago. You lived North of me, but I'm wondering if it was you? If yes, you've been in the channel a long time. You must remember the early days. I'll take a look at this tomorrow unless someone else answers it. In any event, please let me know if it is you that I'm thinking of, every time I see your name, it dusts up memories. Until later

Leslie

Was this reply helpful? Yes No
Peggy L. Aitken 246 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Leslie, WOW, do you have a GREAT memory!!! I did just see that you're in Dallas and yes, I'm a neighbor to the north in Denton. I've been working with GP since about 92 and Dynamics since it was launched in 95ish? Good to see another original and going strong at that! Don't think there are too many of us left from back in the day! I sure would appreciate your help if possible. If it's too involved, I can open a case with GP. I just didn't think it was going to be that hard..lol

Thanks again for your help!!!

Peggy

Was this reply helpful? Yes No
Verified answer

Mick Egan 3,561 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Peggy,

I did a similar function a while back, and created a trigger on the PM10300 table that updates the COMMENT1 field with a value from the PM20000 table.

If you would like the example for testing let me know.

Mick

Was this reply helpful? Yes No
Peggy L. Aitken 246 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Hey Mick! Thanks for chiming in here. Are you saying you successfully linked the PM Transaction Open with the PM Payment Work in the AP Check with stub on top and bottom-graphical? The field I need to access is the Shipping Method in the PM Transaction Open. If so, I'd LOVE if you can shed some light on how you did it successfully!

Thanks Again!!!!

Was this reply helpful? Yes No
Verified answer

Mick Egan 3,561 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Peggy,

I sent you a private message with the code.

Mick

Was this reply helpful? Yes No
Peggy L. Aitken 246 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Ok Mick, I think you're a lifesaver! It didn't work for the first few times I tested it but I think I needed to relaunch GP for it to work. I'll do some more testing a bit later but can't imagine anything would pop up.

Don't want to over step but I have a couple more questions if you don't mind. What will happen when I upgrade to 2015 and beyond? Will I need to do anything additional? Thinking is should be fine unless the tables change?

THANK YOU SO MUCH for your help!!!

Was this reply helpful? Yes No
Mick Egan 3,561 on at

Like (0)

Report

RE: How to add PM20000 table to the AP Check with stub on top and bottom graphical

Peggy,

The code was actually developed on GP2010 a few years back, and I updated for you on GP2016, and there were no changes to be concerned.

Add a step in your upgrade documentation to check the code still exists after an upgrade, sometimes an upgrade can remove custom triggers, which is why we run queries on the database to see what custom code might be in place.

As you can see, the code is looking for the Batch Source to match "XPM_Cchecks".

Mick

Was this reply helpful? Yes No