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)

gonchristopher 40 on at

Like (0)

Report

RE: Exporting Cycle Bill Invoice Data

Perfect. Thank you for your help.
Cheryl Waswick on at

Like (0)

Report

RE: Exporting Cycle Bill Invoice Data

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

Like (0)

Report

RE: Exporting Cycle Bill Invoice Data

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?
Verified answer

Cheryl Waswick on at

Like (0)

Report

RE: Exporting Cycle Bill Invoice Data

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