Hello all,
I want to display the customer ID/Name from a project record into the report but the report is not able to display it:
Also tried by using Alias for the child table, but it displays the same result.
Project Customer ID/name not displaying in Report
+18
Hello,
- Please look at the details in the following post. The post below is very similar to what you are asking above, and the answers will be similar.
-
- Which Acumatica reports did you compare? Any Acumatica report that shows Project and Customer data is likely to use the same tables and joins that you need in the above report. Did you open similar reports and compare the Tables & Joins to your report?
For example, try Projects report PM631000:
Laura
+18
Hello,
I had more time to open Projects report, and oops, it does not include the customer table! I’m sorry about that, the report I suggested will not work.
I found an earlier post answered by Megan Friesen, where she demonstrates the steps of joining the customer table to a projects table.
If her ideas don’t work, a report writing expert will come along to help you. Good luck!
Laura
Userlevel 5
Hi
You should be able to pull the customer name from the BAccountR.AcctName field.
Userlevel 5
If the field is always appearing blank, then there is likely an issue with the other Table Relations pointing to the PMProject Table. In your scenario, there may be an issue on the POLine → PMProject relation.
+18
Hello,
I wonder if the issue is related to conditions? What happens if you remove the filter on your report (include only PO order type of RS)?
Laura
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.