Skip to main content
Solved

Project Customer Description not getting displayed

M
Jr Varsity II
Forum|alt.badge.img

Hello,
My report doesn’t display the Customer ID & description in the report created. 
 

Fields to display in report either Customer data fields or the Account name

Dac Schema Browser:
 


Tried the below join:
 

But not getting displayed.
How to do this?

Best answer by dcomerford

@Mondeddula Madhu Venkat Reddy I would remove all the tables you dont need from the report and get the basics working and then add the joins and check then as you go.by adding a field from each table to check the results are right. There is nothing wrong with the fields the joins are causing the issue you are getting either too many or no records because of the user of Left and inner joins

View original
Madhu
Did this topic help you find an answer to your question?

7 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 639 replies
  • November 15, 2023

Your joins look correct the field can you show me the fields on the report.

Dermot Comerford
M
1 person likes this
  • M
    Mondeddula Madhu Venkat Reddy
M
Jr Varsity II
Forum|alt.badge.img
dcomerford wrote:

Your joins look correct the field can you show me the fields on the report.

Hello @dcomerford , this is what I am using:
 

 

Madhu
dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 639 replies
  • November 15, 2023

Weird sent me the report and I will put test it on my local dataset

Dermot Comerford
M
1 person likes this
  • M
    Mondeddula Madhu Venkat Reddy
M
Jr Varsity II
Forum|alt.badge.img

Have attached the report.

1 Attachments
Madhu
dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 639 replies
  • November 15, 2023

The issue is the filter on the report. If you dont have a Purchase Order of type RS linked to the project you are running it for you wont get any results i changed it to an Or as i dont have that order type

 

Dermot Comerford
M
1 person likes this
  • M
    Mondeddula Madhu Venkat Reddy
M
Jr Varsity II
Forum|alt.badge.img
dcomerford wrote:

The issue is the filter on the report. If you dont have a Purchase Order of type RS linked to the project you are running it for you wont get any results i changed it to an Or as i dont have that order type

 

Hey @dcomerford ,
Thank you for your guidance, but the Order Type = RS is the mandatory filter that I am looking to apply, since I want to only display the subcontract records. Also, I followed your guidance, but the system is displaying incorrect, as shown below:
 

 

Madhu
dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • 639 replies
  • Answer
  • November 16, 2023

@Mondeddula Madhu Venkat Reddy I would remove all the tables you dont need from the report and get the basics working and then add the joins and check then as you go.by adding a field from each table to check the results are right. There is nothing wrong with the fields the joins are causing the issue you are getting either too many or no records because of the user of Left and inner joins

Dermot Comerford
Chris Hackett
M
2 people like this
  • Chris Hackett
    Chris Hackett
  • M
    Mondeddula Madhu Venkat Reddy

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved