Announcements
No record found.
Hi,
Given the invoice document number how could I retrieve the invoice pdf, corresponding project, and line item entries.
It's a ReceivableInvoice and the main table in GP is dbo.ReqRecvDocHeader. I'm assuming for the PDF will be generating a report.
My preference for retrieving the data is either through eConnect or the tables directly.
Thanks in advance.
Hello,
When you drill back on the Receivables invoice, do you see the information you want? If you can include a screenprint of the GP window highlighting the information you want, I can find the SQL table that field is stored in.
The RM invoice is in these tables for an open transaction ( but not limited to these):
-RM20101 - open transaction
-RM10101 - open/work distributions
-RM20201 - open/work apply records
Cheryl
Microsoft Support
You can find the costs billed on the T&M project in the PA23203 table.
Hope that is what you needed.
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 510 Most Valuable Professional
André Arnaud de Cal... 302 Super User 2026 Season 2
CU-1234529-002 197
