AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Report De...
Exported generic in...
 
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,173 Views
RSS
Mike Collins
Posts: 16
 Mike Collins
Topic starter
June 4, 2024 4: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
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
June 4, 2024 6:57 pm
(@timrodman)
Famed Member
Joined: 10 years ago

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


Reply
Mike Collins
Posts: 16
 Mike Collins
Topic starter
June 5, 2024 7:17 am
(@mike_collins)
Eminent Member
Joined: 5 years ago
image

Reply
mcraig
Posts: 65
 mcraig
June 5, 2024 4:27 pm
(@mcraig)
Estimable Member
Joined: 6 years ago

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


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 50 Online
  • 2,413 Members
Our newest member: psteichen
Latest Post: Credit Reference Report Needed
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×