— The Forums are now read-only —

— All new activity now takes place here: —

Notifications

Clear all

Questions Exported generic inquiry: table correlation error in report

Acumatica Report Designer

Last Post by mcraig 2 years ago

4 Posts

3 Users

0 Reactions

1,454 Views

RSS

Posts: 16

Mike Collins

Topic starter

June 4, 2024 5:09 am

(@mike_collins)

Eminent Member

Joined: 5 years ago

Hi All,

I built a Generic Inquiry that gives me proper results (tested with the records in the DB).

After exporting that as a report and adding same fields as the GI, I'm getting the following error

The correlation name TableName is specified multiple times in a FROM clause

I think it's worth mentioning that the GI links custom tables made in the database to the default ones.

What could cause the issue?

Thanks,

Mike

3 Replies

Posts: 3204

Tim Rodman

Admin

June 4, 2024 7:57 pm

(@timrodman)

Famed Member

Joined: 11 years ago

Can you take a screenshot of the table relationships in the build schema area?

Posts: 16

Mike Collins

Topic starter

June 5, 2024 8:17 am

(@mike_collins)

Eminent Member

Joined: 5 years ago

Posts: 65

mcraig

June 5, 2024 5:27 pm

(@mcraig)

Estimable Member

Joined: 6 years ago

Maybe you should be using an Alais on each different join to CSSRemittanceDetail

12 Forums
2,533 Topics
11 K Posts
52 Online
2,439 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)