Exporting Cycle Bill Invoice Data

(0) Share

Report

Posted on by gonchristopher

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.

Categories:

Microsoft Dynamics GP

All responses (4)

Answers (1)

Sort by

Verified answer

Cheryl Waswick Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
gonchristopher 40 on at

Like (0)

Report
Copy link

Link copied!

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?
Cheryl Waswick Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The employee ID should be in one of the first few columns. PACOSTOWNER I believe.
gonchristopher 40 on at

Like (0)

Report
Copy link

Link copied!

Perfect. Thank you for your help.