Hi,
I am trying to get some data into report writer on Dynamics GP 10 (Project Accounting) module in which I need to view the names of the contract manager and project manager which are created as employees in the system.
The issue is that I am not able to find the best way to link the contract management table to the payroll master table and using which key.
Hope to get some hints in this matter...
Thank you in advance.
*This post is locked for comments
Good to know Joseph :)
Thanks a lot for the update...
Actually, now it is working perfectly and the error is gone; however I had to remove the report from the modified section then add it again...
So, case is closed.
Have an excellent day.
Please check if your expression matches similar to the below expression for PA Inquiry Contract report. ( please note I used MS paint to show the complete expression for your reference).
Hi Joseph,
I tried it myself by modifying PA Inquiry Contract report where I replaced 'Project Manager ID' with the calculated field 'Project Manager Name' with the steps I mentioned above. Below is the screen shot of the report printed. I would like to see a screen capture of the calculated field definition you created. I possible could you post.that.
Hi,
Actually I have added the parameter, however I am getting the below error:
Undefined Symbol 'F00168D01212FirstName'
Sorry Joseph that I missed an additional parameter to this. Its a Boolean parameter which if true will display Last Name first. You need to add either 1 or 0 for the expression at the end. I added 1 at the end for my previous expression and added the screen shot. Hope this helps.
Hi Naga,
As an update to your equation, kindly note that at the time of running the report, we are getting an error in equation...
Could it be there is any additional parameters that should be passed to the function RW_Get_Employee_Name. noting that the calculated field was created the same way that you have mentioned above...
Thank you in advance.
Try PA01201.PAprojmngrid = UPR00100.EMPLOYID
Excellent answer...thanks a lot
Hi Joseph,
I would use 2 calculated fields (One for Contract Manager ID and other for Project Manager ID) instead of linking the Payroll Master in your scenario. Report writer script "RW_Get_Employee_Name" is used in the calculated field definition window. Below steps followed by screen hot are for creating calculated field for Contract Manager ID.
1. Open your report layout and select 'Calculated Fields' in the Tool box and click on New Button to open the calculated field definition window.
2. Enter Name: Contract Manager Name. Result Type: String.
3. Go To Functions tab, Select 'User Defined Option' , Core : "Payroll" and select Function: "RW_Get_Employee_Name" from the dropdown and click on Add.
4. Now select 'Fields' tab and choose the Contract Manager Field ID in the Contract Master table and click on Add (Please note that the focus should be on ')' in the calculated field expression before you add Contract manager ID as parameter to this function). Your calculated field definition should look as mentioned below.
5. Click on OK to save the definition.
6. Add this calculated field to the report layout where you want to display the 'Contract Manager Name'.
Hope this helps.
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 (