123
I am trying to write a Crystal report comparing actual costs to the total budgeted revenues by job. I can find values for budgets and actual in the table PJPTDSUM, but this doesn't have or seem to have the accounting period in that.
I was unsuccessful in combing amounts from PJTRAN and PJPTDSUM. Does anyone have any ideas on ohow to do this?
Another question, does anyone know where the budgets are kept besides PJPTDSUM?
Coto Joe
*This post is locked for comments
Thanks Scott,
Depending on how SL is being used, you may find that PJBudSum and PJBudRol tables are not populated. I have found that the PJRev... tables to be more dependable based on budget revision documents. The PjActSumm and Rol tables are quite usefull if you don't want to track the full detail. Often though, many want to be able to drill down to the actual detail lines as well. I do like the idea of tying the PJTran and PjAct tables together though.
Thanks
Merry Christmas,
-Joe
Aloha Joe,
Budgets by Period are stored in the PJBudSum and PJBudRol tables.
Actuals by Period are stored in the PJActSum and PJActRol tables.
Hope this helps.
Mahalo,
-Scott
I would be interested in learning more, beleive me. I don't know those SQL reporting services, but may need some help in that area.
How can we touch base?
My e-mail if you need it is jmorris@cibolasystems.com
This is something that we view in a third party software in a dashboard format. It is a great tool and extremely usefull. If I was to write this myself, I would use SQL Reporting Services not Crystal as it is much simpler to deploy and create the data sources you will need. You are correct in using the PJTRAN and PJPTDSUM tables. You will find budget sin PJRev.
If you are interested and in need of more help on this, feel free to contact me.
Joe
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (