Announcements
Hi,
We have a process where we upload time sheet data, cycle bill, and it generates an invoice for each project the employee is associated to. This is an ReceivablesInvoice. I would like to know, given a document number(invoice number) how could I retrieve the invoice line items(employee name, hours, rates, cost).
My preference is to retrieve the data programmatically either via eConnect or tables. If there is other options I'm open to suggestions as well.
thanks in advance.
Perfect. Thank you for your help.
The employee ID should be in one of the first few columns. PACOSTOWNER I believe.
Yes, this is what I was looking for. It get's me to the line items. From here, how do I get to the EMPLOYID each row is for?
Hello,
For Time & Materials projects, you can find the detail in the 'PA Billing Sub-Detail - Open TM' table (PA23203). This table holds all the costs that are being billed on that invoice.
Thanks
Cheryl W
Microsoft support
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156