How do you add the vendor address to the check remittance in GP 2010. They have changed the underlying table structure for this report and the addresses are no longer available.
*This post is locked for comments
Ian, I followed your instructions to add vendor's address. When I go to generate the remittance form I get an error message stating "Resources not found in Dictionary". What am I doing wrong?
Thank you
Lenny
We couldn't believe it when we discovered the change that had been made. At both my last company and current one, every single client had the vendor address on the remittance so we needed to rework every check remittance when we came to upgrade them.
Thanks Ian. I think they have to balance efficiency versus function. Who cares how efficient something is if it does not work.
Hi Richard,
No, it is exactly the same in GP 2013. I've read somewhere that the change was made to make the code more efficient.
You're on the right lines in how you were going to tackle this; you need to add a new relationship to have the PM Payment Work table available for the report: www.azurecurve.co.uk/.../adding-the-vendors-address-to-the-check-remittance
I will wait Ian for your post. I had tried adding that table in RW but when I clicked on pmRemittanceTemp there were no additional tables listed. My next step was to create a new relationship. Do you know if this has been corrected in GP 2013?
Hi Richard,
I've previously done this using VBA, but you can ad a relationship to PM_Payment_WORk to the pmRemittanceTemp table via the Tables button in Report Writer and then add the table to the Check Remittance modified report.
I'm in the middle of prepping a post on this for Monday with a step-by-step guide if you need further detail.
Ian
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,430
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
