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...
Finding the Equival...
 
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 [Solved] Finding the Equivalent Generic Inquiry Data

Acumatica Report Designer
Last Post by Jwright 1 month ago
3 Posts
2 Users
1 Likes
89 Views
RSS
Jwright
Posts: 6
 Jwright
Topic starter
December 15, 2022 11:56 am
(@jwright)
Member
Joined: 9 months ago

What is the best way to find the same data in a report designer printed report when building new Generic Inquiries? While we are at it, any recommendations of doing the same with SQL queries in the Database and translating into a Generic Inquiry.

 

An example:

In a report designer printed report I have the table.field: ItemHistCurr.FinYtdCost

I would like that same value in a GI. I have dug through a few tables including INItemCost, INItemCostHist, and INItemCostHistByPeriod. (And when applicable filtering down to the current FinPeriodID). These values still don't align between the two data sources though.

Topic Tags
Generic Inquiry report designer
2 Replies
ncantral
Posts: 21
 ncantral
December 15, 2022 1:58 pm
(@ncantral)
Member
Joined: 3 years ago

After you run a report or pull up a GI you can look at the trace to see the actual query used to pull the data (from the screen or request profiler). They certainly aren't the prettiest, especially when a DAC value like NetSales is a calculated on the fly.

image

There may be newer/better options out there, but I've been using the Apex SQL Refactor recommended in the Developers Blog to format queries for years.
SQL Formating Tools - Acumatica Developers Blog .........

Is that ItemHistCurr table from the report aliased? I'd also check to see if the aliased table has any specific conditions in the join to filter the results down.

image
Reply
Tim Rodman reacted
Jwright
Posts: 6
 Jwright
Topic starter
December 20, 2022 3:11 pm
(@jwright)
Member
Joined: 9 months ago

Good catch. I didn't realize tables could be renamed in a join within the report builder. Thanks!

Reply
Forum Jump:
  Previous Topic
Related Topics
  • Why do I still get a top margin when I print AP Check Form with Remittance?
    10 months ago
  • Customizing AP Checks
    1 year ago
  • Alternate ID Issue
    2 years ago
  • Report from Inquiry Screen
    2 years ago
  • Sub Report Issue (Hiding A Line That Has No Data)
    2 years ago
Topic Tags:  Generic Inquiry (22) , report designer (31) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 3 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
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

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.

‹›×

    ‹›×