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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
