You’re offline. This is a read only version of the page.
Can anyone offer advice on how to add PO Number to the Computer Checks Posting Journal?
I'm attempting to add the PO Number field to the Report Writer Computer Checks Posting Journal report.
I've already successfully removed the temp file that originally provided the body fields. I've replaced the body fields with fields from the PM Payment Apply To Work File (PM10201).
The problem that I've found is that the PM10201 file and numerous other files do not contain the PO Number data even though the field is present.
I've found that the PM Transaction Open File (PM20000) has what I need in it.
I would like to be able to pull in the PORDNMBR field from the PM20000 table but have not been successful.
I was able to add the table to the report by first adding the PM Key Master File.
I established restrictions for each PM Key Master File and PM Transaction Open File using Control Number and Voucher Number respectively.
When I produced the report, I still found there was no data in the field.
I've seen an example on the web of someone using the Paid History transaction file to provide the information, but that won't work for my purpose since I want the user to review this report prior to printing checks.
Any help would be greatly appreciated.
*This post is locked for comments
Sorry,
I hit the 'enter' key before I was done. Let me have a 'do over':
CaseyC,
What you are running into here is a limit of Report Writer and why you see such things as 'field 1' & 'field 2' as the field names. Report Writer will not let you add more than one 1-many relationship in a single branch. You are trying to join PM10300 to PM10201 AND PM10300 to PM10100. That's two 1 to many relationships. You can join PM10201 and PM20000 without a problem to get the pordnmbr field you need, but you would also get a complete set of distributions for each record in the PM10201 table that matched the PM10300 document.
What you need is a couple of sub-reports, which is what has happened behind the scenes - sort of. This is what you are trying to do, generally, that Report Writer does not support:
PM10300 (PM Pmt WORK - the checks)
PM10201 (PM Apply to WORK - the vouchers being paid) (1 to many with PM10300)
PM20000 (PM Trx Open - where the PO number lives) (1 to 1 with PM10201)
PM10100 (GL distributions) (1 to many with PM10300)
If you are willing to give up the information on the distributions, you can get your PO Number.
You would probably be better served to create a SQL view and then build a report using a different tool to give you the information you need.
Kind regards,
Leslie
CaseyC,
What you are running into here is a limit of Report Writer and why you see such things as 'field 1' & 'field 2' as the field names. Report Writer will not let you add more than one 1-many relationship in a single branch. You are trying to join PM10300 to PM10201 AND PM10300 to PM10100. That's two 1 to many relationships. You can join PM10201 and PM20000 without a problem to get the pordnmbr field you need, but you would also get a complete set of distributions for each record in the PM10201 table that matched the PM10300 document.
What you need is a couple of sub-reports, which is what has happened behind the scenes - sort of. This is what you are trying to do, generally, that Report Writer does not support:
PM10300 (PM Pmt WORK - the checks)
PM10201 (PM Apply to WORK - the vouchers being paid)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
