Solved

Join PMSiteAddress to PMProject in the report writer

  • 10 January 2022
  • 12 replies
  • 145 views
M
Rank
Userlevel 1
Badge

We are trying to join project addresses to each project in a report.  We have done it GI without a problem using the PMProject.projectid and PmSiteAddress.contractid fields in each table.

But when we go to report writer we are not able to see the same fields.

We tried PMProject.Locationid = PmsiteAddress.addressid without success.  Has anyone done this in report writer successfully?

Thanks

icon

Best answer by mcoman 18 January 2022, 14:57

View original
Michael Coman

12 replies

C
Rank
Userlevel 7
Badge +9

Hi @mcoman Would you please share the report to take look and suggest the joins.

Thanks

Chandra M
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @mcoman  Have you checked below condition and verified?

PMSiteAddress.addressID = PMProject.siteAddressID

Naveen B
M
Rank
Userlevel 1
Badge

I guess that is what I am having a problem doing.  I cannot see the pmproject.siteaddressid in the report writer.

1 Attachment
Michael Coman
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @mcoman I see that those fields are available. Please find the screenshot for reference.

Can you please let me know, which version you working on?

 

 

Naveen B
M
Rank
Userlevel 1
Badge

Interestingly enough I dont see that

 

 

Michael Coman
Naveen Boga
Rank
Userlevel 7
Badge +17

@mcoman Can you please let me know which version you are working on ?

Naveen B
M
Rank
Userlevel 1
Badge

20.210.0044 is the version.

Michael Coman
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @mcoman Sure, let me check on the 20 R2 version and let you know.

Naveen B
M
Rank
Userlevel 1
Badge

Still having no luck finding out how to get this link in the report designer.  Any suggestions would be helpful.  Version is 2020r2

Michael Coman
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi @mcoman  I have checked this in the 2020 R2 version and I can able to see the  PMSiteAddress.addressID = PMProject.siteAddressID. 

Please find the screenshot for your reference.

 

In your report, can you please click on the Load Schema button and Refresh ALL and verify once from your end.

 

 

Naveen B
M
Rank
Userlevel 1
Badge

Yes, I see it there myself.  Its on the schema page but its not on the relationship page.  Why would that be?

 

 

Michael Coman
M
Rank
Userlevel 1
Badge

Naveen,

Thank you!!  I appreciate your patience.  I kept having to load schema and refresh.  But eventually it worked.  

Michael Coman

Reply


Terms & ConditionsCookie 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