Microsoft Dynamics GP (Archived)

Project Accounting - Billing Standard Invoice Templates

(0) Share

Report

Posted on by Abdo Khoury

14,855

Dear

None of the Standard Billing invoice templates in GP are even remotely close to a invoice format.

(unlike the standard SOP invoice, which at least resembles a normal invoice)

And when i run report modifier to modify the invoice template of the Billing Formats available in GP 10, i don't find at the least the minimum information that i need to build a normal invoice.

to work around this , i had to build my own SQL query to retrieve all the data i need in my invoice.

Is everybody faced with this challenge when invoicing/billing from Project Accounting?

Regards

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Verified answer

sandipdjadhav 18,306 on at

Like (0)

Report

ABDO,

We have created SQL Report for Project Accounting Invoice.

Let me know I will be happy to share sql query for same.

Thanks

Was this reply helpful? Yes No
Dave S 5 on at

Like (0)

Report

Did this work. We are having the same issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dear Sandip:

Please with us SQL Script.....

we need it to Integrate PA Bililng with SOP Billing

email id: tauqirabbas786@hotmail.com

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you please forward me the SQL script.

Thanks

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Sandip,

Can you please share the SQL query for PA Invoice. Thanks for your help in advance. my email babubaskaran@outlook.com.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Can you send me the script? kworley@randgrp.com

Was this reply helpful? Yes No
C Todd 25 on at

Like (0)

Report

Could you share the SQL query with me?

ctodd@intellitecsolutions.com

Thanks!

Cindi

Was this reply helpful? Yes No
Irfan.Rasheed 717 on at

Like (0)

Report

Hi Sandeep,

Also share this query to me.

Please note my e-mail id

irf1978@live.com

Regards.

Was this reply helpful? Yes No
Sheri Ibbotson 712 on at

Like (0)

Report

If possible could I obtain a copy of your sql sop billing view as well?

Was this reply helpful? Yes No
Sheri Ibbotson 712 on at

Like (0)

Report

I have a sop blank invoice project billing format I built. I will provide the package file for import into gp via customization maintenance window. Let me know if you would like a copy emailed to you

Was this reply helpful? Yes No