AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • 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 1 year ago
4 Posts
3 Users
0 Reactions
1,060 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: 3193
 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: 5 years ago

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


Reply
Forum Jump:
  Previous Topic
Next Topic  

Currently viewing this topic 1 guest.

Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 26 Online
  • 2,410 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
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

  • Steven Fuller
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×