You’re offline. This is a read only version of the page.
385
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (