389
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
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
#1
André Arnaud de Cal...
293,207
Super User 2025 Season 1
#2
Martin Dráb
231,923
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
