By using this website, you agree to our Terms of Use (click 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

184

By Brynn Rutherfo...

3 weeks ago

Questions Generic inquiry with information from Audit history(CT301000)

By VJW, Dec 12, 18

Acumatica Generic Inquiries & Pivot Tables

6,102

By Tim Rodman

4 months ago

Questions Generic Inquiry Screenid changes to ScreenId=00000000

By Hazen Metro, Feb 26, 19

Acumatica Generic Inquiries & Pivot Tables

8,499

By matthewjames

6 months ago

Questions Generic Inquiry into Business Event to monitor Import Scenarios

By Stewart Williams, May 04, 22

Acumatica Generic Inquiries & Pivot Tables

2,146

By Paul Lambert

7 months ago

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

By Kimberly Wise, Jun 09, 19

Acumatica Generic Inquiries & Pivot Tables

3,377

By Tim Laird

7 months ago

#AcumaticaTnT Attaching Notes in a Generic Inquiry

By Tim Rodman, Feb 18, 21

Acumatica Generic Inquiries & Pivot Tables

3,174

By Julie Baker

9 months ago

Questions Cash by Period

By Jake Hickey, Aug 06, 18

Acumatica Generic Inquiries & Pivot Tables

2,587

By Seda

9 months ago

Questions Sales by customer per year/year to date

By Guilherme Zica, Oct 18, 24

Acumatica Generic Inquiries & Pivot Tables

716

By Tim Rodman

11 months 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,398

By Lunar Windbloo...

1 year ago

Questions Possible to Create Trial Balance GI?

By Ben Meyer, Mar 12, 25

Acumatica Generic Inquiries & Pivot Tables

807

By Ben Meyer

1 year ago

Questions Show Credit Memos as Negative Amounts

By Kristin Christian, Jan 07, 19

Acumatica Generic Inquiries & Pivot Tables

7,563

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

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

961

By Tim Rodman

1 year 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

916

By Dominic Albrec...

1 year ago

Questions Item Usage by Customer Default Warehouse

By jmmarasco, Nov 08, 24

Acumatica Generic Inquiries & Pivot Tables

766

By jmmarasco

1 year ago

Questions Inventory Management GI

By Guilherme Zica, Jul 19, 24

Acumatica Generic Inquiries & Pivot Tables

924

By Tim Rodman

1 year ago

Questions Joining from GLTran to INTran

By Tim Rodman, Mar 15, 21

Acumatica Generic Inquiries & Pivot Tables

3,471

By GraemeLM

1 year 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,167

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

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

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

1,705

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

8,256

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

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

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

816

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

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

By claytonsummers

2 years ago

Questions A monster problem - ARPayment.CuryUnappliedBal

By mredamon, Apr 04, 24

Acumatica Generic Inquiries & Pivot Tables

1,130

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

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

905

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

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

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

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

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

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

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

By Michelle Necai...

2 years ago

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

1,719

By Travis

2 years ago

Questions Custom Processes Scree

By Jacky Mao, Dec 12, 23

Acumatica Generic Inquiries & Pivot Tables

897

By Tim Rodman

2 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

5,948

By Tim Rodman

2 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,026

By Tim Rodman

2 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,692

By Tim Rodman

2 years ago

Questions Import scenario processed via Business failing initially.

By Mduduzi Tsabedze, Oct 19, 23

Acumatica Generic Inquiries & Pivot Tables

926

By Mduduzi Tsabed...

2 years ago

Questions Auto Incrementing Number Based on Grouping

By Michael Freeman, Jul 26, 23

Acumatica Generic Inquiries & Pivot Tables

1,021

By Tim Rodman

2 years ago

#AcumaticaTnT Default Vendor for an Item

By Tim Rodman, Jun 19, 20

Acumatica Generic Inquiries & Pivot Tables

3,767

By Tim Rodman

2 years ago

Questions Formula for GI caption

By Ellie, Aug 24, 18

Acumatica Generic Inquiries & Pivot Tables

3,963

By Tim Rodman

2 years ago

Questions Show week in year for a date

By VJW, Aug 30, 18

Acumatica Generic Inquiries & Pivot Tables

5,640

By Tim Rodman

2 years ago

Questions Sorting on pivot table

By mna10, Feb 02, 23

Acumatica Generic Inquiries & Pivot Tables

1,433

By Tim Rodman

2 years ago

Questions Adding an empty editable cell to a generic inquiry?

By Alec Axelblom, Mar 14, 22

Acumatica Generic Inquiries & Pivot Tables

2,368

By Tim Rodman

2 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,279

By Tim Rodman

2 years ago

Page 1 / 9 Next

12 Forums
2,532 Topics
11 K Posts
58 Online
2,418 Members

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

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

Acumatica Generic Inquiries & Pivot Tables

Online Members