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
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
0
114
Brynn Rutherford
By Brynn Rutherfo...
1 month ago
VJW
Questions Generic inquiry with information from Audit history(CT301000)
By VJW, Dec 12, 18 
  Acumatica Generic Inquiries & Pivot Tables
10
5,814
Tim Rodman
By Tim Rodman
2 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,066
matthewjames
By matthewjames
4 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,089
Paul Lambert
By Paul Lambert
5 months ago
Kimberly Wise
Questions [SOOrder.Status] = 'Open' always returns false
By Kimberly Wise, Jun 09, 19 
  Acumatica Generic Inquiries & Pivot Tables
8
3,301
Tim Laird
By Tim Laird
6 months ago
Tim Rodman
#AcumaticaTnT Attaching Notes in a Generic Inquiry
By Tim Rodman, Feb 18, 21 
  Acumatica Generic Inquiries & Pivot Tables
8
3,071
Julie Baker
By Julie Baker
7 months ago
Jake Hickey
Questions Cash by Period
By Jake Hickey, Aug 06, 18 
  Acumatica Generic Inquiries & Pivot Tables
4
2,471
Seda
By Seda
8 months ago
Guilherme Zica
Questions Sales by customer per year/year to date
By Guilherme Zica, Oct 17, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
660
Tim Rodman
By Tim Rodman
9 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,295
Lunar Windbloom
By Lunar Windbloo...
11 months ago
Ben Meyer
Questions Possible to Create Trial Balance GI?
By Ben Meyer, Mar 12 
  Acumatica Generic Inquiries & Pivot Tables
0
776
Ben Meyer
By Ben Meyer
11 months ago
Kristin Christian
Questions Show Credit Memos as Negative Amounts
By Kristin Christian, Jan 07, 19 
  Acumatica Generic Inquiries & Pivot Tables
10
7,220
Andy Katz
By Andy Katz
12 months 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,422
Andy Katz
By Andy Katz
12 months 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
913
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
890
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
743
jmmarasco
By jmmarasco
1 year ago
Guilherme Zica
Questions Inventory Management GI
By Guilherme Zica, Jul 19, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
877
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,302
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,124
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,195
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,260
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,623
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,025
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,046
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,102
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
772
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,129
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,063
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,060
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,365
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
879
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,432
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,191
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,005
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,292
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,275
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,171
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,261
Michelle Necaise
By Michelle Necai...
2 years ago
Travis
Questions Coverting attribute to decimal and doing math - wrong result
By Travis, Jan 15, 24 
Topic Tags:  conversions , GI , Generic Inquiry ,
  Acumatica Generic Inquiries & Pivot Tables
7
1,624
Travis
By Travis
2 years ago
Jacky Mao
Questions Custom Processes Scree
By Jacky Mao, Dec 12, 23 
  Acumatica Generic Inquiries & Pivot Tables
3
882
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,810
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
997
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,626
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
905
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,000
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,670
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,896
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,486
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,387
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,275
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,252
Tim Rodman
By Tim Rodman
2 years ago
Page 1 / 9 Next
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 15 Online
  • 2,414 Members
Our newest member: Megan Pawlowski
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.

‹›×

    ‹›×