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 4 / 9 Prev Next
Status
Author
Topics
Forum
Replies
Views
Last Post 
georgydas
Questions "error Converting data type varchar to numeric" on GI that is filtering on UDF TRUE checkbox value
By georgydas, Sep 30, 21 
  Acumatica Generic Inquiries & Pivot Tables
0
1,961
georgydas
By georgydas
5 years ago
Mark O’Meara
Questions Cannot filter TimeCards based on EPTimeCard.TimeCardType in GI
By Mark O’Meara, Sep 07, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
2,058
Mark O’Meara
By Mark O’Meara
5 years ago
jemstonz
Questions Pulling data from one GI to another - possible?
By jemstonz, Aug 24, 21 
  Acumatica Generic Inquiries & Pivot Tables
3
2,230
Tim Rodman
By Tim Rodman
5 years ago
mstanczak
Questions NO Sales on Stock Inventory Items
By mstanczak, Jun 30, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
1,126
mstanczak
By mstanczak
5 years ago
mstanczak
Questions Combine QTYOnHand between Warehouse/Locations
By mstanczak, Apr 28, 21 
  Acumatica Generic Inquiries & Pivot Tables
5
2,028
Tim Rodman
By Tim Rodman
5 years ago
lrains
Questions Days Past Due
By lrains, Jul 25, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
2,643
Leanne Manley
By Leanne Manley
5 years ago
Stacey Brown
Questions Problem With Drop-Ship Invoicing Locked "drop ship lines on PO are not linked to any sales order lines"
By Stacey Brown, Jul 28, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
3,686
Stacey Brown
By Stacey Brown
5 years ago
Ryan Brown @xByte Hosting
Questions Easy way to convert body of tasks to readable text for GI
By Ryan Brown @xByte Hosting, Jun 13, 19 
  Acumatica Generic Inquiries & Pivot Tables
10
5,842
Ian Cook
By Ian Cook
5 years ago
GraemeLM
Questions Access Rights - Generic Inquiry (1 viewing)
By GraemeLM, Jul 14, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
2,728
ATC
By ATC
5 years ago
sbgmedia
Questions Formulas in Generic Inquiry
By sbgmedia, Jun 17, 21 
  Acumatica Generic Inquiries & Pivot Tables
5
3,938
Tim Rodman
By Tim Rodman
5 years ago
Shawn Hughes
Questions Shipping and Fulfillment
By Shawn Hughes, Jul 01, 21 
  Acumatica Generic Inquiries & Pivot Tables
0
1,797
Shawn Hughes
By Shawn Hughes
5 years ago
lauraj46
#AcumaticaTnT Finding production order operations that have NO transactions
By lauraj46, Jun 25, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
2,029
Tim Rodman
By Tim Rodman
5 years ago
lauraj46
#AcumaticaTnT Tips and Tricks - Finding missing data in Acumatica using a Generic Inquiry
By lauraj46, Jun 24, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,301
Tim Rodman
By Tim Rodman
5 years ago
bob.beardsley
Questions Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020
By bob.beardsley, Oct 05, 20 
  Acumatica Generic Inquiries & Pivot Tables
3
918
JustPaul
By JustPaul
5 years ago
Royce Lithgo
Questions DateTime field only showing date in Results
By Royce Lithgo, Dec 18, 18 
  Acumatica Generic Inquiries & Pivot Tables
10
6,857
FamousMortimer
By FamousMortimer
5 years ago
JustinL
Questions Pivot Table Filter
By JustinL, Jun 08, 21 
  Acumatica Generic Inquiries & Pivot Tables
0
1,880
JustinL
By JustinL
5 years ago
Royce Lithgo
Questions @MonthStart & @MonthEnd not working under 2019.1
By Royce Lithgo, Oct 21, 19 
  Acumatica Generic Inquiries & Pivot Tables
6
2,902
Brian McMillin
By Brian McMillin
5 years ago
TRA_User
Questions HELP - Addition in nested if statements
By TRA_User, Jun 03, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
2,737
TRA_User
By TRA_User
5 years ago
KrysMcGinn
Questions How to add a column that displays the product of another column?
By KrysMcGinn, May 21, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
2,135
TRA_User
By TRA_User
5 years ago
cielo.zipagan
Questions Generic Inquiry in Acumatica
By cielo.zipagan, May 24, 21 
  Acumatica Generic Inquiries & Pivot Tables
3
1,380
nperez
By nperez
5 years ago
Jswartz
Questions Forecast Inventory Report
By Jswartz, Mar 03, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
1,725
Jswartz
By Jswartz
5 years ago
Tim Rodman
#AcumaticaTnT Default Sorting on Aggregate Results
By Tim Rodman, May 17, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
3,460
Jeffrey Patch
By Jeffrey Patch
5 years ago
Tim Rodman
#AcumaticaTnT Joining to DateInfo Table
By Tim Rodman, Apr 22, 21 
  Acumatica Generic Inquiries & Pivot Tables
5
2,942
lauraj46
By lauraj46
5 years ago
mjcoman
Questions Files on record.
By mjcoman, Jun 10, 20 
Topic Tags:  Quotes , notifications , files ,
  Acumatica Generic Inquiries & Pivot Tables
5
2,946
nperez
By nperez
5 years ago
redrum
Questions Business Event with GI and Formula in Import Scenario
By redrum, Apr 19, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,332
Tim Rodman
By Tim Rodman
5 years ago
dave.ziskind
Questions Expenses being approved upon submission, but can't see by whom
By dave.ziskind, Apr 01, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
977
Tim Rodman
By Tim Rodman
5 years ago
MichaelHansen
Questions Mass Update PO Dates
By MichaelHansen, Apr 19, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,734
Tim Rodman
By Tim Rodman
5 years ago
Questions Adding Running Total to Accrual Balance by Trans Date
By meaginmarie, Jun 07, 19 
  Acumatica Generic Inquiries & Pivot Tables
10
4,520
Tim Rodman
By Tim Rodman
5 years ago
lrains
Questions Shipments Picked and Packed Per Day
By lrains, Mar 08, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,265
Tim Rodman
By Tim Rodman
5 years ago
Tim Rodman
#AcumaticaTnT Acumatica 2020 R2 OwnerID Field
By Tim Rodman, Sep 30, 20 
  Acumatica Generic Inquiries & Pivot Tables
4
4,219
adam.carri
By adam.carri
5 years ago
byates
Questions Expected Monthly Sales Report
By byates, May 03, 21 
  Acumatica Generic Inquiries & Pivot Tables
3
1,325
byates
By byates
5 years ago
ranjith.es
Questions Acumatica Compatibility for ME
By ranjith.es, May 06, 21 
  Acumatica Generic Inquiries & Pivot Tables
0
1,571
ranjith.es
By ranjith.es
5 years ago
mbrown
Questions Lot/Batch traceability
By mbrown, May 05, 21 
  Acumatica Generic Inquiries & Pivot Tables
0
627
mbrown
By mbrown
5 years ago
peremiller
Questions Left Join w/filter on right table
By peremiller, May 04, 21 
  Acumatica Generic Inquiries & Pivot Tables
0
1,794
peremiller
By peremiller
5 years ago
mstanczak
Questions GI Sales Order History - by any given timeframe - end user filter Date Range
By mstanczak, May 03, 21 
  Acumatica Generic Inquiries & Pivot Tables
3
1,618
mstanczak
By mstanczak
5 years ago
byates
Questions GI Results Duplicating
By byates, May 03, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,767
byates
By byates
5 years ago
Michael Triffon
Questions Tricky filter and/or formula
By Michael Triffon, Apr 13, 21 
  Acumatica Generic Inquiries & Pivot Tables
5
1,657
Tim Rodman
By Tim Rodman
5 years ago
Tim Rodman
#AcumaticaTnT Restrict Export to Excel
By Tim Rodman, Dec 12, 18 
  Acumatica Generic Inquiries & Pivot Tables
2
4,104
Tim Rodman
By Tim Rodman
5 years ago
Royce Lithgo
Questions System was not able to get record count warning
By Royce Lithgo, Apr 11, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
2,707
Royce Lithgo
By Royce Lithgo
5 years ago
Chris RB
Questions Need to create a generic inquiry to list information from the cross reference tab on inventory items
By Chris RB, Apr 06, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,675
Idrus
By Idrus
5 years ago
SusanK17
Questions Show payment applied to order to Sales Order in a generic inquiry that has the SOOrder information
By SusanK17, Dec 18, 20 
  Acumatica Generic Inquiries & Pivot Tables
4
2,921
Tim Rodman
By Tim Rodman
5 years ago
SteveM79
Questions Getting around Row Level Security in Generic Inquiry
By SteveM79, Mar 21, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
1,328
SteveM79
By SteveM79
5 years ago
dteirney
Questions Reversing a JournalTransaction using the Rest API
By dteirney, Feb 09, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,989
Tim Rodman
By Tim Rodman
5 years ago
Michael Roszkowski
Questions Link EPApproval to APInvoice
By Michael Roszkowski, Jan 19, 21 
  Acumatica Generic Inquiries & Pivot Tables
1
1,412
Tim Rodman
By Tim Rodman
5 years ago
FamousMortimer
Questions Referencing @Me in CRActivity on 2020R2
By FamousMortimer, Jan 11, 21 
  Acumatica Generic Inquiries & Pivot Tables
2
2,373
Tim Rodman
By Tim Rodman
5 years ago
Dan Wilkins
Questions Generic Inquiry using Parameters with Inventory Attributes
By Dan Wilkins, Dec 22, 20 
  Acumatica Generic Inquiries & Pivot Tables
2
3,335
Dan Wilkins
By Dan Wilkins
5 years ago
FamousMortimer
Questions 'Formula' in GI Conditions
By FamousMortimer, Feb 04, 21 
  Acumatica Generic Inquiries & Pivot Tables
4
3,461
Tim Rodman
By Tim Rodman
5 years ago
ne
Questions Generic Inquires not showing up in business event import scenario
By ne, Dec 25, 20 
  Acumatica Generic Inquiries & Pivot Tables
2
797
Tim Rodman
By Tim Rodman
5 years ago
Nec
Questions IN Functionality
By Nec, Dec 17, 20 
  Acumatica Generic Inquiries & Pivot Tables
1
1,047
Tim Rodman
By Tim Rodman
5 years ago
mhoss
Questions Generic Inquiry - Sorting if files are attached
By mhoss, Nov 08, 18 
  Acumatica Generic Inquiries & Pivot Tables
7
5,459
Tim Rodman
By Tim Rodman
5 years ago
Page 4 / 9 Prev Next
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 60 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Limited or no support from Acumatica?
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.

‹›×

    ‹›×