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 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 
VJW
Questions Generic inquiry with information from Audit history(CT301000)
By VJW, Dec 12, 18 
  Acumatica Generic Inquiries & Pivot Tables
10
5,395
Tim Rodman
By Tim Rodman
5 days ago
Hazen Metro
Questions Generic Inquiry Screenid changes to ScreenId=00000000
By Hazen Metro, Feb 26, 19 
  Acumatica Generic Inquiries & Pivot Tables
18
7,467
matthewjames
By matthewjames
2 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
1,922
Paul Lambert
By Paul Lambert
3 months ago
Kimberly Wise
Questions [SOOrder.Status] = 'Open' always returns false
By Kimberly Wise, Jun 09, 19 
  Acumatica Generic Inquiries & Pivot Tables
8
3,170
Tim Laird
By Tim Laird
4 months ago
Tim Rodman
#AcumaticaTnT Attaching Notes in a Generic Inquiry
By Tim Rodman, Feb 18, 21 
  Acumatica Generic Inquiries & Pivot Tables
8
2,794
Julie Baker
By Julie Baker
5 months ago
Jake Hickey
Questions Cash by Period
By Jake Hickey, Aug 06, 18 
  Acumatica Generic Inquiries & Pivot Tables
4
2,373
Seda
By Seda
5 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
530
Tim Rodman
By Tim Rodman
7 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,067
Lunar Windbloom
By Lunar Windbloo...
9 months ago
Ben Meyer
Possible to Create Trial Balance GI?
By Ben Meyer, Mar 12 
  Acumatica Generic Inquiries & Pivot Tables
0
662
Ben Meyer
By Ben Meyer
9 months ago
Kristin Christian
Questions Show Credit Memos as Negative Amounts
By Kristin Christian, Jan 07, 19 
  Acumatica Generic Inquiries & Pivot Tables
10
6,735
Andy Katz
By Andy Katz
10 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,206
Andy Katz
By Andy Katz
10 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
829
Tim Rodman
By Tim Rodman
1 year ago
Dominic Albrecht
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
800
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
642
jmmarasco
By jmmarasco
1 year ago
Guilherme Zica
Questions Inventory Management GI
By Guilherme Zica, Jul 19, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
753
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
2,929
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,040
Raj Jasani
By Raj Jasani
1 year 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,049
Travis
By Travis
1 year 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,142
Tim Rodman
By Tim Rodman
1 year 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,399
Dominic Boullé
By Dominic Boullé
1 year 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
7,561
Kurt Keating
By Kurt Keating
1 year ago
Anne Trockman
Questions Linking File attachment comments to a GI
By Anne Trockman, Jun 13, 24 
  Acumatica Generic Inquiries & Pivot Tables
2
933
Anne Trockman
By Anne Trockman
1 year 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
1,794
Tim Rodman
By Tim Rodman
1 year 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
703
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
982
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
950
claytonsummers
By claytonsummers
2 years ago
mredamon
Questions A monster problem - ARPayment.CuryUnappliedBal
By mredamon, Apr 04, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
950
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,229
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
831
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,296
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
4,921
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
947
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,181
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,162
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,057
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,122
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,434
Travis
By Travis
2 years ago
Jacky Mao
Questions Custom Processes Scree
By Jacky Mao, Dec 12, 23 
  Acumatica Generic Inquiries & Pivot Tables
3
815
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,526
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
934
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,498
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
836
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
907
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,477
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,782
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,288
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,280
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,174
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,197
Tim Rodman
By Tim Rodman
2 years ago
Tonya Sey
Questions GI to show Time Cards with Materials Only (no time entries)
By Tonya Sey, Sep 19, 23 
  Acumatica Generic Inquiries & Pivot Tables
1
1,187
Melissa Lutrick
By Melissa Lutric...
2 years ago
Page 1 / 9 Next
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,527 Topics
  • 10.9 K Posts
  • 15 Online
  • 2,411 Members
Our newest member: thollings
Latest Post: Invoice subreport for line-level tax breakdown not tieing to taxes subtotal
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 © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×