web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Project Accounting SQL...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Project Accounting SQL View

(1) ShareShare
ReportReport
Posted on by Jozy 393

Dear Community,

Hope all are doing great!

Can anyone guide where I can find sql view of project accounting which should include below column.

Customer ID#

Project No#

Project Name:

Billing

Billing with taxes

Revenue Recongnition

Cost

Material Cost

Account Receivables

Collection

Project Status

Thanks in Advance.

Jozy

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at

    In the GP company databases, by default, there are a number of SQL Views.

    For example, the PA01100 shows the CUSTNMBR, CUSTNAME, PAProject_Amount and more.

    The PAProjects view has the customer number also, contract and project IDs, project name and number, status, baseline total cost and more

    I would start with some of our default views and see if those work for you. If not, you can probably tie a couple of the view together and/or look at what tables those views are pulling information from, and create a custom SQL view pulling the information you need.

    The Community may also have some examples they have to suggest as well.

    Thanks

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

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. André Arnaud de Cal... 650 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Abhilash Warrier 287 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Martin Dráb 225 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans