Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Project Accounting - B...
Microsoft Dynamics GP (Archived)

Project Accounting - Billing Standard Invoice Templates

(0) ShareShare
ReportReport
Posted on by Abdo Khoury 14,849

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

  • Samantha0114 Profile Picture
    Samantha0114 195 on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Would you be able to e-mail me the SQL script also?  My e-mail is boden@verticalsol.com?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Good morning Sheri,

    I am a new controller for a small manufacturing company.  We have GP version 10. We do not invoice through it due to the challenges noted. I would love to see what solution you arrived for a useful invoice format.

    Appreciate it,

    Kelly

  • Sheri Ibbotson Profile Picture
    Sheri Ibbotson 712 on at
    RE: Project Accounting - Billing Standard Invoice Templates

    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

  • Sheri Ibbotson Profile Picture
    Sheri Ibbotson 712 on at
    RE: Project Accounting - Billing Standard Invoice Templates

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

  • Irfan.Rasheed Profile Picture
    Irfan.Rasheed 715 on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Hi Sandeep,

    Also share this query to me.

    Please note my e-mail id

    irf1978@live.com

    Regards.

  • C Todd Profile Picture
    C Todd 25 on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Could you share the SQL query with me?

    ctodd@intellitecsolutions.com

    Thanks!

    Cindi

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Accounting - Billing Standard Invoice Templates

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

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Hi Sandip,

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Can you please forward me the SQL script.

    Thanks

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Project Accounting - Billing Standard Invoice Templates

    Dear Sandip:

    Please with us SQL Script.....

    we need it to Integrate PA Bililng with SOP Billing

    email id: tauqirabbas786@hotmail.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans