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 Generic I...
 
Notifications
Clear all

Acumatica Generic Inquiries & Pivot Tables

Questions or knowledge sharing about Generic Inquiries in Acumatica, including Pivot Tables and database schema discussions.
RSS
Page 1 / 9 Next
Status
Author
Topics
Forum
Replies
Views
Last Post 
Brynn Rutherford
Questions Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
By Brynn Rutherford, Jan 13 
Topic Tags:  Issue after upgrade to 20 , GI won't export ,
  Acumatica Generic Inquiries & Pivot Tables
2
184
Brynn Rutherford
By Brynn Rutherfo...
3 weeks ago
VJW
Questions Generic inquiry with information from Audit history(CT301000)
By VJW, Dec 12, 18 
  Acumatica Generic Inquiries & Pivot Tables
10
6,102
Tim Rodman
By Tim Rodman
4 months ago
Hazen Metro
Questions Generic Inquiry Screenid changes to ScreenId=00000000
By Hazen Metro, Feb 26, 19 
  Acumatica Generic Inquiries & Pivot Tables
18
8,499
matthewjames
By matthewjames
6 months ago
Stewart Williams
Questions Generic Inquiry into Business Event to monitor Import Scenarios
By Stewart Williams, May 04, 22 
  Acumatica Generic Inquiries & Pivot Tables
3
2,146
Paul Lambert
By Paul Lambert
7 months ago
Kimberly Wise
Questions [SOOrder.Status] = 'Open' always returns false
By Kimberly Wise, Jun 09, 19 
  Acumatica Generic Inquiries & Pivot Tables
8
3,377
Tim Laird
By Tim Laird
7 months ago
Tim Rodman
#AcumaticaTnT Attaching Notes in a Generic Inquiry
By Tim Rodman, Feb 18, 21 
  Acumatica Generic Inquiries & Pivot Tables
8
3,174
Julie Baker
By Julie Baker
9 months ago
Jake Hickey
Questions Cash by Period
By Jake Hickey, Aug 06, 18 
  Acumatica Generic Inquiries & Pivot Tables
4
2,587
Seda
By Seda
9 months ago
Guilherme Zica
Questions Sales by customer per year/year to date
By Guilherme Zica, Oct 18, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
716
Tim Rodman
By Tim Rodman
11 months ago
Nicholas Scyoc
Questions Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"
By Nicholas Scyoc, Dec 22, 22 
Topic Tags:  Generic Inquiry , CuryUnappliedBal , Unapplied Balance , Help , Question ,
  Acumatica Generic Inquiries & Pivot Tables
10
2,398
Lunar Windbloom
By Lunar Windbloo...
1 year ago
Ben Meyer
Questions Possible to Create Trial Balance GI?
By Ben Meyer, Mar 12, 25 
  Acumatica Generic Inquiries & Pivot Tables
0
807
Ben Meyer
By Ben Meyer
1 year ago
Kristin Christian
Questions Show Credit Memos as Negative Amounts
By Kristin Christian, Jan 07, 19 
  Acumatica Generic Inquiries & Pivot Tables
10
7,563
Andy Katz
By Andy Katz
1 year ago
Royce Lithgo
Questions Appearance of Notes and Attachment action icons in query results
By Royce Lithgo, Oct 02, 18 
  Acumatica Generic Inquiries & Pivot Tables
10
5,564
Andy Katz
By Andy Katz
1 year ago
Tim Rodman
#AcumaticaTnT Tell Acumatica not to run a query when you open a Generic Inquiry so you can add a filter
By Tim Rodman, Dec 03, 24 
  Acumatica Generic Inquiries & Pivot Tables
0
961
Tim Rodman
By Tim Rodman
1 year ago
Dominic Albrecht
Questions Accessing GI's through MS Power Automate or Azure Data factory
By Dominic Albrecht, Nov 13, 24 
Topic Tags:  MS Power Automate , Azure Data Factory ,
  Acumatica Generic Inquiries & Pivot Tables
0
916
Dominic Albrecht
By Dominic Albrec...
1 year ago
jmmarasco
Questions Item Usage by Customer Default Warehouse
By jmmarasco, Nov 08, 24 
  Acumatica Generic Inquiries & Pivot Tables
0
766
jmmarasco
By jmmarasco
1 year ago
Guilherme Zica
Questions Inventory Management GI
By Guilherme Zica, Jul 19, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
924
Tim Rodman
By Tim Rodman
1 year ago
Tim Rodman
Questions Joining from GLTran to INTran
By Tim Rodman, Mar 15, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
3,471
GraemeLM
By GraemeLM
1 year ago
Raj Jasani
Questions Timecard Transactions not Pulled into Project Transactions Inquiry
By Raj Jasani, Jul 03, 24 
Topic Tags:  Project Transaction Detai , GI , Time Activities ,
  Acumatica Generic Inquiries & Pivot Tables
2
1,167
Raj Jasani
By Raj Jasani
2 years ago
Travis
Questions Equivalent to Excel Post-Special, "transpose"
By Travis, Jun 28, 24 
Topic Tags:  Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
10
1,248
Travis
By Travis
2 years ago
Kim OFlaherty
Questions Generic Inquiry - Last Modified On Date Change
By Kim OFlaherty, Jun 27, 24 
Topic Tags:  Generic Inquiry , Audit History ,
  Acumatica Generic Inquiries & Pivot Tables
1
1,307
Tim Rodman
By Tim Rodman
2 years ago
Dominic Boullé
Questions Simple Business event not triggering
By Dominic Boullé, Jun 25, 24 
Topic Tags:  business events , business event , automation , notification template ,
  Acumatica Generic Inquiries & Pivot Tables
4
1,705
Dominic Boullé
By Dominic Boullé
2 years ago
Harsha Sarjapur
Questions GI with 2 or more different values
By Harsha Sarjapur, Dec 26, 19 
Topic Tags:  #GI ,
  Acumatica Generic Inquiries & Pivot Tables
27
8,256
Kurt Keating
By Kurt Keating
2 years ago
Anne Trockman
Questions Linking File attachment comments to a GI
By Anne Trockman, Jun 13, 24 
  Acumatica Generic Inquiries & Pivot Tables
2
1,134
Anne Trockman
By Anne Trockman
2 years ago
Ben Grassi
Questions Generic Inquiry, pulling data from two unrelated sources
By Ben Grassi, Jun 05, 24 
Topic Tags:  Generic Inquiry , reporting ,
  Acumatica Generic Inquiries & Pivot Tables
2
2,263
Tim Rodman
By Tim Rodman
2 years ago
Dominic Boullé
Questions GI column providing results from WCID/Operation that was not specified
By Dominic Boullé, Jan 24, 24 
Topic Tags:  GI , manufacturing , AMProdMatl , Production Orders ,
  Acumatica Generic Inquiries & Pivot Tables
2
816
Dominic Boullé
By Dominic Boullé
2 years ago
wpratley
Questions Generic Inquiry - Select Data based on Max Total Aggregate Function
By wpratley, May 03, 24 
  Acumatica Generic Inquiries & Pivot Tables
3
1,204
Dominic Boullé
By Dominic Boullé
2 years ago
claytonsummers
Questions Need to sum up GL account totals over a range of dates or periods
By claytonsummers, Apr 19, 24 
Topic Tags:  GL , account sums ,
  Acumatica Generic Inquiries & Pivot Tables
2
1,111
claytonsummers
By claytonsummers
2 years ago
mredamon
Questions A monster problem - ARPayment.CuryUnappliedBal
By mredamon, Apr 04, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
1,130
Tim Rodman
By Tim Rodman
2 years ago
Felipe Garcia
Questions Inventory Usage reporting based on previous system reports
By Felipe Garcia, Apr 02, 24 
Topic Tags:  GI , Inventory , Forecast ,
  Acumatica Generic Inquiries & Pivot Tables
1
1,404
Tim Rodman
By Tim Rodman
2 years ago
Ben Meyer
Questions Adding Override Contact Info to GI Results
By Ben Meyer, Mar 14, 24 
Topic Tags:  Question , Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
1
905
Tim Rodman
By Tim Rodman
2 years ago
Travis
Questions GI to compare FIFO last cost to stock item last cost
By Travis, Mar 13, 24 
Topic Tags:  Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
1
1,504
Travis
By Travis
2 years ago
Shaun Zaleski
Questions Opportunity Screen - Relation to Sales Order Number
By Shaun Zaleski, Apr 24, 19 
Topic Tags:  Opportunity , Generic Inquiry , GI , Relations , Tables ,
  Acumatica Generic Inquiries & Pivot Tables
11
5,342
Debbie Reed
By Debbie Reed
2 years ago
Raymond Porter
Questions Acumatica Generic Inquiry Navigation Sidebar Title
By Raymond Porter, Feb 07, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
1,038
Tim Rodman
By Tim Rodman
2 years ago
Travis
Questions Business Event Triggering from Scheduled GI not updating via Import Scenario
By Travis, Feb 29, 24 
Topic Tags:  business event ,
  Acumatica Generic Inquiries & Pivot Tables
4
1,349
Amir Friedman
By Amir Friedman
2 years ago
Guilherme Zica
Questions Line item-level report of Invoices
By Guilherme Zica, Feb 23, 24 
Topic Tags:  invoice , Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
3
1,310
Rico Ybanez
By Rico Ybanez
2 years ago
SQLRunner
Questions GLHistory Dates vs period
By SQLRunner, Feb 14, 24 
Topic Tags:  glhistory , periods , DAC ,
  Acumatica Generic Inquiries & Pivot Tables
0
1,210
SQLRunner
By SQLRunner
2 years ago
Michelle Necaise
Questions ARInvoice and PMRevenueTotal Needed on Same GI
By Michelle Necaise, Jan 09, 24 
Topic Tags:  Construction , Progress Billing , Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
8
1,325
Michelle Necaise
By Michelle Necai...
2 years ago
Travis
Questions Coverting attribute to decimal and doing math - wrong result (1 viewing)
By Travis, Jan 15, 24 
Topic Tags:  conversions , GI , Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
7
1,719
Travis
By Travis
2 years ago
Jacky Mao
Questions Custom Processes Scree
By Jacky Mao, Dec 12, 23 
  Acumatica Generic Inquiries & Pivot Tables
3
897
Tim Rodman
By Tim Rodman
2 years ago
Greg Polsky
Questions Pulling Revenue Year to Date (YTD) figures from GLHistory for Dashboard Scorecard
By Greg Polsky, Apr 08, 19 
  Acumatica Generic Inquiries & Pivot Tables
8
5,948
Tim Rodman
By Tim Rodman
2 years ago
Nancy Kenney
Questions Adding Calculated Columns – Example #1 Multipart identifier could not be bound
By Nancy Kenney, Nov 21, 23 
  Acumatica Generic Inquiries & Pivot Tables
1
1,026
Tim Rodman
By Tim Rodman
2 years ago
Brett Clark
Questions Generic Inquiry to Show Where GI's are Used in Dashboards
By Brett Clark, Oct 27, 23 
Topic Tags:  Generic Inquiry , widgets ,
  Acumatica Generic Inquiries & Pivot Tables
3
1,692
Tim Rodman
By Tim Rodman
2 years ago
Mduduzi Tsabedze
Questions Import scenario processed via Business failing initially.
By Mduduzi Tsabedze, Oct 19, 23 
  Acumatica Generic Inquiries & Pivot Tables
2
926
Mduduzi Tsabedze
By Mduduzi Tsabed...
2 years ago
Michael Freeman
Questions Auto Incrementing Number Based on Grouping
By Michael Freeman, Jul 26, 23 
  Acumatica Generic Inquiries & Pivot Tables
1
1,021
Tim Rodman
By Tim Rodman
2 years ago
Tim Rodman
#AcumaticaTnT Default Vendor for an Item
By Tim Rodman, Jun 19, 20 
  Acumatica Generic Inquiries & Pivot Tables
4
3,767
Tim Rodman
By Tim Rodman
2 years ago
Ellie
Questions Formula for GI caption
By Ellie, Aug 24, 18 
  Acumatica Generic Inquiries & Pivot Tables
5
3,963
Tim Rodman
By Tim Rodman
2 years ago
VJW
Questions Show week in year for a date
By VJW, Aug 30, 18 
  Acumatica Generic Inquiries & Pivot Tables
6
5,640
Tim Rodman
By Tim Rodman
2 years ago
mna10
Questions Sorting on pivot table
By mna10, Feb 02, 23 
  Acumatica Generic Inquiries & Pivot Tables
1
1,433
Tim Rodman
By Tim Rodman
2 years ago
Alec Axelblom
Questions Adding an empty editable cell to a generic inquiry?
By Alec Axelblom, Mar 14, 22 
  Acumatica Generic Inquiries & Pivot Tables
7
2,368
Tim Rodman
By Tim Rodman
2 years ago
Lorne W.
Questions Trying to create GI that shows where SOLine.BranchId does not equal SOOrder.BranchId
By Lorne W., Sep 01, 22 
  Acumatica Generic Inquiries & Pivot Tables
1
1,279
Tim Rodman
By Tim Rodman
2 years ago
Page 1 / 9 Next
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 58 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Limited or no support from Acumatica?
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.

‹›×

    ‹›×