Acumatica Forums

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

Notifications

Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Acumatica Generic Inquiries & Pivot Tables

Questions or knowledge sharing about Generic Inquiries in Acumatica, including Pivot Tables and database schema discussions.

Page 1 / 8 Next

Status

Topics

Replies

Views

Users

Date

Activities (emails, messages etc.)

1

21

2 days ago

2 days ago

Questions How to calculate weeks of supply

1

48

Sep 11

Sep 11

Questions Trying to create GI that shows where SOLine.BranchId does not equal SOOrder.BranchId

0

39

Sep 01

Sep 01

Questions Trying to subtract credit (amount) from sales dollars in a GI based on the ARTran table

3

41

Sep 01

Sep 01

#AcumaticaTnT Generic Inquiry to Export Scenario

5

115

Aug 28

Aug 28

#AcumaticaTnT Generic Inquiries with an =null default parameter value causing errors after upgrade to 2022R1

5

130

Aug 25

Aug 25

Questions saved filters for certain users only

3

145

Aug 16

Aug 16

Questions Want to create a Generic Inquiry to manage files that are attached to sales orders

4

69

Aug 11

Aug 11

Questions GI Last Execution Time/Date

1

53

Aug 09

Aug 09

Questions Alternate ID for a purchase receipt

2

1,907

Jul 29

Jul 29

Questions IsPrimary field on contact not working in GI results

3

115

Jul 21

Jul 21

Questions Generic Inquiry - Use subqueries for a field

5

3,546

Jul 19

Jul 19

Questions Filter by Notes

7

2,015

Jul 18

Jul 18

Questions Exclude Sales Orders where one line is a certain Inventory Item

4

106

Jul 13

Jul 13

Questions Add Record Number to GI Results

0

205

Jul 13

Jul 13

Questions Return Fields from Most Recent Record

8

131

Jul 12

Jul 12

#AcumaticaTnT GI and Notification Templates to Automatically E-mail Released Invoices

5

347

Jul 12

Jul 12

Questions Row Style Help

2

263

Jul 11

Jul 11

Questions Slow Moving Inventory

2

185

Jul 07

Jul 07

Questions Problem sharing a pivot table

2

197

Jul 07

Jul 07

Questions Can I use the same entry screen in two different generic inquiries

2

90

Jul 06

Jul 06

Questions Sorting Pivot Table by Month

2

69

Jun 30

Jun 30

Questions GI with 2 or more different values

Topic Tags: #GI,

26

2,530

Jun 24

Jun 24

#AcumaticaTnT Activity Start Date field and End Time field displaying as 1 day earlier in GI

1

171

Jun 23

Jun 23

Questions Boolean Field Values in Results Grid

5

258

Jun 22

Jun 22

Questions Recurring Sales Orders based on Customer Attributes

3

264

Jun 22

Jun 22

Questions Appearance of Notes and Attachment action icons in query results

8

2,501

Jun 16

Jun 16

Questions Adding navigation to CRActivity.Source field in GI

0

163

Jun 14

Jun 14

Questions Pass Dashboard Parameter through to GI formula?

0

169

Jun 14

Jun 14

Questions Highlighting of Generic Inquiry Rows or Columns in Data Table Widgets

22

2,234

Jun 10

Jun 10

Questions Adding Drop Ship PO # to Sales Orders GI

2

167

Jun 06

Jun 06

Questions add current month + previous month balance in generic Inquiry

0

79

Jun 05

Jun 05

Questions Service Management - GI for Profit

1

175

Jun 02

Jun 02

Questions GI with Sales & Inventory

13

2,768

Jun 02

Jun 02

Questions Generic inquiry with information from Audit history(CT301000)

7

2,273

May 30

May 30

Questions Finding Date / Time for Order Date

3

210

May 26

May 26

Questions Building Generic Inquiries & Pivot Tables Course Feedback

54

1,485

May 25

May 25

Questions Pivot Table takes a long time to load

4

186

May 25

May 25

Questions Nested iif statements issue

2

300

May 11

May 11

Questions An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details.

4

502

May 09

May 09

Questions GI for Active Users

1

185

May 05

May 05

Questions Generic Inquiry into Business Event to monitor Import Scenarios

0

197

May 04

May 04

Questions Different Forms for different Branches

3

332

Apr 11

Apr 11

Questions How to display an image in a side panel

2

293

Apr 10

Apr 10

Questions Adding Formulas to Results Columns

6

505

Mar 28

Mar 28

Questions Adding an empty editable cell to a generic inquiry?

5

355

Mar 22

Mar 22

Questions Updating Existing Items in Sales Prices

1

288

Mar 21

Mar 21

Questions Adding an empty column to a Generic Inquiry

5

225

Mar 20

Mar 20

Questions Percentage Calculation not outputting the correct percentages.

0

313

Mar 14

Mar 14

Questions Novice Question Capture multiple order pick-up on same day by same customer

0

117

Mar 09

Mar 09

Page 1 / 8 Next

Forum Statistics

11 Forums

2,170 Topics

9,619 Posts

3 Online

1,724 Members

Latest Post: Email Statements with Associated Invoices? Our newest member: Alexis Espino Recent Posts Unread Posts

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

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

Acumatica Forums