— The Forums are now read-only —

— All new activity now takes place here: —

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

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

Acumatica Generic Inquiries & Pivot Tables

453

By tmac

3 months ago

Questions Generic inquiry with information from Audit history(CT301000)

By VJW, Dec 12, 18

Acumatica Generic Inquiries & Pivot Tables

7,144

By Tim Rodman

7 months ago

Questions Generic Inquiry Screenid changes to ScreenId=00000000

By Hazen Metro, Feb 26, 19

Acumatica Generic Inquiries & Pivot Tables

10.2 K

By matthewjames

9 months ago

Questions Generic Inquiry into Business Event to monitor Import Scenarios

By Stewart Williams, May 04, 22

Acumatica Generic Inquiries & Pivot Tables

2,679

By Paul Lambert

10 months ago

Questions [SOOrder.Status] = 'Open' always returns false

By Kimberly Wise, Jun 09, 19

Acumatica Generic Inquiries & Pivot Tables

3,961

By Tim Laird

11 months ago

#AcumaticaTnT Attaching Notes in a Generic Inquiry

By Tim Rodman, Feb 18, 21

Acumatica Generic Inquiries & Pivot Tables

3,910

By Julie Baker

12 months ago

Questions Cash by Period

By Jake Hickey, Aug 06, 18

Acumatica Generic Inquiries & Pivot Tables

3,148

By Seda

1 year ago

Questions Sales by customer per year/year to date

By Guilherme Zica, Oct 18, 24

Acumatica Generic Inquiries & Pivot Tables

1,287

By Tim Rodman

1 year ago

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

2,982

By Lunar Windbloo...

1 year ago

Questions Possible to Create Trial Balance GI?

By Ben Meyer, Mar 12, 25

Acumatica Generic Inquiries & Pivot Tables

1,262

By Ben Meyer

1 year ago

Questions Show Credit Memos as Negative Amounts

By Kristin Christian, Jan 07, 19

Acumatica Generic Inquiries & Pivot Tables

8,487

By Andy Katz

1 year ago

Questions Appearance of Notes and Attachment action icons in query results

By Royce Lithgo, Oct 02, 18

Acumatica Generic Inquiries & Pivot Tables

5,879

By Andy Katz

1 year ago

#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

1,163

By Tim Rodman

2 years ago

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

1,039

By Dominic Albrec...

2 years ago

Questions Item Usage by Customer Default Warehouse

By jmmarasco, Nov 08, 24

Acumatica Generic Inquiries & Pivot Tables

937

By jmmarasco

2 years ago

Questions Inventory Management GI

By Guilherme Zica, Jul 19, 24

Acumatica Generic Inquiries & Pivot Tables

1,073

By Tim Rodman

2 years ago

Questions Joining from GLTran to INTran

By Tim Rodman, Mar 15, 21

Acumatica Generic Inquiries & Pivot Tables

4,095

By GraemeLM

2 years ago

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

1,359

By Raj Jasani

2 years ago

Questions Equivalent to Excel Post-Special, "transpose"

By Travis, Jun 28, 24

Topic Tags: Generic Inquiry ,

Acumatica Generic Inquiries & Pivot Tables

1,531

By Travis

2 years ago

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,466

By Tim Rodman

2 years ago

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

2,101

By Dominic Boullé

2 years ago

Questions GI with 2 or more different values

By Harsha Sarjapur, Dec 26, 19

Topic Tags: #GI ,

Acumatica Generic Inquiries & Pivot Tables

9,033

By Kurt Keating

2 years ago

Questions Linking File attachment comments to a GI

By Anne Trockman, Jun 13, 24

Acumatica Generic Inquiries & Pivot Tables

1,351

By Anne Trockman

2 years ago

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,738

By Tim Rodman

2 years ago

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

1,014

By Dominic Boullé

2 years ago

Questions Generic Inquiry - Select Data based on Max Total Aggregate Function

By wpratley, May 03, 24

Acumatica Generic Inquiries & Pivot Tables

1,391

By Dominic Boullé

2 years ago

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

1,247

By claytonsummers

2 years ago

Questions A monster problem - ARPayment.CuryUnappliedBal

By mredamon, Apr 04, 24

Acumatica Generic Inquiries & Pivot Tables

1,378

By Tim Rodman

2 years ago

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,540

By Tim Rodman

2 years ago

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,101

By Tim Rodman

2 years ago

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,742

By Travis

2 years ago

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

5,897

By Debbie Reed

2 years ago

Questions Acumatica Generic Inquiry Navigation Sidebar Title

By Raymond Porter, Feb 07, 24

Acumatica Generic Inquiries & Pivot Tables

1,215

By Tim Rodman

2 years ago

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

1,627

By Amir Friedman

2 years ago

Questions Line item-level report of Invoices

By Guilherme Zica, Feb 23, 24

Topic Tags: invoice , Generic Inquiry ,

Acumatica Generic Inquiries & Pivot Tables

1,546

By Rico Ybanez

2 years ago

Questions GLHistory Dates vs period

By SQLRunner, Feb 14, 24

Topic Tags: glhistory , periods , DAC ,

Acumatica Generic Inquiries & Pivot Tables

1,390

By SQLRunner

2 years ago

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

1,553

By Michelle Necai...

2 years ago

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

2,019

By Travis

2 years ago

Questions Custom Processes Scree

By Jacky Mao, Dec 12, 23

Acumatica Generic Inquiries & Pivot Tables

1,042

By Tim Rodman

3 years ago

Questions Pulling Revenue Year to Date (YTD) figures from GLHistory for Dashboard Scorecard

By Greg Polsky, Apr 08, 19

Acumatica Generic Inquiries & Pivot Tables

6,384

By Tim Rodman

3 years ago

Questions Adding Calculated Columns – Example #1 Multipart identifier could not be bound

By Nancy Kenney, Nov 21, 23

Acumatica Generic Inquiries & Pivot Tables

1,146

By Tim Rodman

3 years ago

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

1,911

By Tim Rodman

3 years ago

Questions Import scenario processed via Business failing initially.

By Mduduzi Tsabedze, Oct 19, 23

Acumatica Generic Inquiries & Pivot Tables

1,075

By Mduduzi Tsabed...

3 years ago

Questions Auto Incrementing Number Based on Grouping

By Michael Freeman, Jul 26, 23

Acumatica Generic Inquiries & Pivot Tables

1,164

By Tim Rodman

3 years ago

#AcumaticaTnT Default Vendor for an Item

By Tim Rodman, Jun 19, 20

Acumatica Generic Inquiries & Pivot Tables

4,118

By Tim Rodman

3 years ago

Questions Formula for GI caption

By Ellie, Aug 24, 18

Acumatica Generic Inquiries & Pivot Tables

4,124

By Tim Rodman

3 years ago

Questions Show week in year for a date

By VJW, Aug 30, 18

Acumatica Generic Inquiries & Pivot Tables

5,936

By Tim Rodman

3 years ago

Questions Sorting on pivot table

By mna10, Feb 02, 23

Acumatica Generic Inquiries & Pivot Tables

1,602

By Tim Rodman

3 years ago

Questions Adding an empty editable cell to a generic inquiry?

By Alec Axelblom, Mar 14, 22

Acumatica Generic Inquiries & Pivot Tables

2,629

By Tim Rodman

3 years ago

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,456

By Tim Rodman

3 years ago

Page 1 / 9 Next

12 Forums
2,533 Topics
11 K Posts
35 Online
2,438 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)