Project Customer ID/name not displaying in Report

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)?

@dcomerford 

Laura

@Mondeddula Madhu Venkat Reddy  - I’m not sure that you need another table... I see now that you shared there is already a Customer Account Name field on the PMProject Table.

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. 

Hi @Mondeddula Madhu Venkat Reddy  - Please see the attached screenshot. It seems as though other reports are pulling it directly from the Business Account (BAccountR) table.

You should be able to pull the customer name from the BAccountR.AcctName field. 

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

Hello,

1. 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.

2.  

3. 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