AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Custom DAC table, G...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Custom DAC table, Generic Inquiry, Report Designer Issue

Acumatica Report Designer
Last Post by Tim Rodman 1 month ago
3 Posts
3 Users
2 Likes
46 Views
RSS
Rosie Loetterle
Posts: 2
 Rosie Loetterle
Topic starter
February 13, 2023 1:34 pm
(@rloetterle)
Member
Joined: 5 months ago

I am building a report comprised of 4 sub reports.

For the data within one sub report we are calling a GI that uses a custom DAC table.

When the data is pulled into the report, the data being called is duplicated. This is not the case in the GI.

Has anyone had issues with custom DAC tables in ARD before?

Topic Tags
report designer custom reports Generic Inquiry DAC
2 Replies
ncantral
Posts: 24
 ncantral
February 13, 2023 3:06 pm
(@ncantral)
Member
Joined: 3 years ago

My first instinct would be to check joins (particularly around CompanyID/SiteID/etc if it's a custom table) or if the subreport is being passed the correct parameters.

Reply
Rosie Loetterle reacted
Tim Rodman
Posts: 2969
 Tim Rodman
Admin
February 13, 2023 11:16 pm
(@timrodman)
Member
Joined: 8 years ago

I've experienced this before when you don't mark the Primary Key fields with IsKey. For some reason Report Designer gets confused. Search for "IsKey" in this post for some sample code:

https://www.augforums.com/importing-historical-data-acumatica-cool-twist

Reply
Rosie Loetterle reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Finding the Equivalent Generic Inquiry Data
    3 months ago
  • Why do I still get a top margin when I print AP Check Form with Remittance?
    12 months ago
  • Customizing AP Checks
    1 year ago
  • Alternate ID Issue
    2 years ago
  • Report from Inquiry Screen
    2 years ago
Topic Tags:  report designer (32) , custom reports (3) , Generic Inquiry (26) , DAC (3) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,268 Topics
  • 9,982 Posts
  • 1 Online
  • 1,834 Members
Our newest member: Derek Wong
Latest Post: Change the number of rows in the check remittance field
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 © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×