40
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.
Hi,
You can find the costs billed on the T&M project in the PA23203 table.
Hope that is what you needed.
Thanks
Cheryl
Microsoft Support
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
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...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (