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 
Hazen Metro
Questions Generic Inquiry Screenid changes to ScreenId=00000000
By Hazen Metro, Feb 26, 19 
  Acumatica Generic Inquiries & Pivot Tables
18
7,139
matthewjames
By matthewjames
3 weeks 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,805
Paul Lambert
By Paul Lambert
2 months ago
Kimberly Wise
Questions [SOOrder.Status] = 'Open' always returns false
By Kimberly Wise, Jun 09, 19 
  Acumatica Generic Inquiries & Pivot Tables
8
2,979
Tim Laird
By Tim Laird
2 months ago
Tim Rodman
#AcumaticaTnT Attaching Notes in a Generic Inquiry
By Tim Rodman, Feb 18, 21 
  Acumatica Generic Inquiries & Pivot Tables
8
2,638
Julie Baker
By Julie Baker
4 months ago
Jake Hickey
Questions Cash by Period
By Jake Hickey, Aug 06, 18 
  Acumatica Generic Inquiries & Pivot Tables
4
2,309
Seda
By Seda
4 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
466
Tim Rodman
By Tim Rodman
6 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
1,951
Lunar Windbloom
By Lunar Windbloo...
7 months ago
Ben Meyer
Possible to Create Trial Balance GI?
By Ben Meyer, Mar 12 
  Acumatica Generic Inquiries & Pivot Tables
0
579
Ben Meyer
By Ben Meyer
8 months ago
Kristin Christian
Questions Show Credit Memos as Negative Amounts
By Kristin Christian, Jan 07, 19 
  Acumatica Generic Inquiries & Pivot Tables
10
6,455
Andy Katz
By Andy Katz
8 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
4,983
Andy Katz
By Andy Katz
8 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 
  Acumatica Generic Inquiries & Pivot Tables
0
751
Tim Rodman
By Tim Rodman
11 months ago
Dominic Albrecht
Accessing GI's through MS Power Automate or Azure Data factory
By Dominic Albrecht, Nov 13 
Topic Tags:  MS Power Automate , Azure Data Factory ,
  Acumatica Generic Inquiries & Pivot Tables
0
731
Dominic Albrecht
By Dominic Albrec...
12 months ago
jmmarasco
Questions Item Usage by Customer Default Warehouse
By jmmarasco, Nov 08 
  Acumatica Generic Inquiries & Pivot Tables
0
591
jmmarasco
By jmmarasco
12 months ago
Guilherme Zica
Questions Inventory Management GI
By Guilherme Zica, Jul 19, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
696
Tim Rodman
By Tim Rodman
12 months ago
Tim Rodman
Questions Joining from GLTran to INTran
By Tim Rodman, Mar 15, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
2,778
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
886
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
973
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,064
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,309
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,320
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
871
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,609
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
630
Dominic Boullé
By Dominic Boullé
1 year ago
wpratley
Questions Generic Inquiry - Select Data based on Max Total Aggregate Function
By wpratley, May 03, 24 
  Acumatica Generic Inquiries & Pivot Tables
3
920
Dominic Boullé
By Dominic Boullé
1 year 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
821
claytonsummers
By claytonsummers
1 year ago
mredamon
Questions A monster problem - ARPayment.CuryUnappliedBal
By mredamon, Apr 04, 24 
  Acumatica Generic Inquiries & Pivot Tables
1
899
Tim Rodman
By Tim Rodman
1 year 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,143
Tim Rodman
By Tim Rodman
1 year 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
772
Tim Rodman
By Tim Rodman
1 year 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,200
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,720
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
903
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,088
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,062
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
982
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
975
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,362
Travis
By Travis
2 years ago
Jacky Mao
Questions Custom Processes Scree
By Jacky Mao, Dec 12, 23 
  Acumatica Generic Inquiries & Pivot Tables
3
708
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,325
Tim Rodman
By Tim Rodman
2 years ago
VJW
Questions Generic inquiry with information from Audit history(CT301000)
By VJW, Dec 12, 18 
  Acumatica Generic Inquiries & Pivot Tables
8
5,091
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
882
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,402
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
775
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
853
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,353
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,653
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,176
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,123
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,086
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,152
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,096
Melissa Lutrick
By Melissa Lutric...
2 years ago
Page 1 / 9 Next
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 19 Online
  • 2,405 Members
Our newest member: Brittany Bartman
Latest Post: Importing Acumatica User Roles / User Security Permissions from Excel
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.

‹›×

    ‹›×