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 / 7 Next

Status

Topics

Replies

Views

Users

Date

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

3

24

11 hours ago

11 hours ago

Questions Formatting the numbers in a column

21

5,654

4 days ago

4 days ago

Questions How to count multi-select attribute values individually?

0

26

Jan 11

Jan 11

Questions Designing A Generic Inquiry that I can find average days before payment is received by customer with.

8

3,526

Jan 11

Jan 11

Questions Date Difference in year and month

4

59

Jan 05

Jan 05

Questions Business Event Trigerred but do nothing : BE & PO Create after a request validation

1

92

Jan 05

Jan 05

Questions ODATA server error

2

88

Dec 15

Dec 15

Questions How to get the Margin Percentage in a Pivot

0

53

Dec 12

Dec 12

Questions Non-Stock Kit Stock Availability

6

230

Nov 29

Nov 29

Questions GI with 2 or more different values

Topic Tags: #GI,

11

1,565

Nov 29

Nov 29

Questions SOLine - Margin i %

2

140

Nov 22

Nov 22

Questions APInvoice_refNbr isn't shown on email notification from business event

1

106

Nov 01

Nov 01

Questions Historical Goods in Transit?

2

261

Oct 15

Oct 15

Questions EDI Solutions

8

257

Oct 15

Oct 15

#AcumaticaTnT SQL Behind Customers (AR3030PL) Screen

0

106

Oct 13

Oct 13

Questions Adding GL Account info to Vendor Generic Inquiry

2

401

Oct 01

Oct 01

Questions "error Converting data type varchar to numeric" on GI that is filtering on UDF TRUE checkbox value

0

185

Sep 30

Sep 30

Questions Cannot filter TimeCards based on EPTimeCard.TimeCardType in GI

2

212

Sep 29

Sep 29

Questions Time Card GI Decimal Hours from Time Spent

3

263

Sep 06

Sep 06

Questions Pulling data from one GI to another - possible?

3

356

Sep 01

Sep 01

Questions NO Sales on Stock Inventory Items

2

173

Aug 23

Aug 23

Questions Combine QTYOnHand between Warehouse/Locations

5

215

Aug 12

Aug 12

Questions Days Past Due

1

390

Aug 11

Aug 11

Questions Problem With Drop-Ship Invoicing Locked "drop ship lines on PO are not linked to any sales order lines"

2

350

Aug 06

Aug 06

Questions Easy way to convert body of tasks to readable text for GI

10

1,576

Jul 14

Jul 14

Questions Access Rights - Generic Inquiry

1

353

Jul 14

Jul 14

Questions Formulas in Generic Inquiry

5

540

Jul 10

Jul 10

Questions Shipping and Fulfillment

0

258

Jul 01

Jul 01

#AcumaticaTnT Finding production order operations that have NO transactions

1

323

Jun 25

Jun 25

#AcumaticaTnT Tips and Tricks - Finding missing data in Acumatica using a Generic Inquiry

1

208

Jun 25

Jun 25

Questions Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020

3

225

Jun 24

Jun 24

Questions DateTime field only showing date in Results

10

2,937

Jun 16

Jun 16

Questions Pivot Table Filter

0

245

Jun 08

Jun 08

Questions @MonthStart & @MonthEnd not working under 2019.1

6

867

Jun 03

Jun 03

Questions HELP - Addition in nested if statements

2

389

Jun 03

Jun 03

Questions How to add a column that displays the product of another column?

2

420

May 24

May 24

Questions Generic Inquiry in Acumatica

3

356

May 24

May 24

Questions Forecast Inventory Report

2

431

May 18

May 18

#AcumaticaTnT Default Sorting on Aggregate Results

2

442

May 17

May 17

#AcumaticaTnT Joining to DateInfo Table

5

533

May 17

May 17

Questions Files on record.

Topic Tags: Quotes, notifications, files,

5

795

May 17

May 17

Questions Business Event with GI and Formula in Import Scenario

1

200

May 15

May 15

Questions Expenses being approved upon submission, but can't see by whom

1

164

May 15

May 15

Questions Mass Update PO Dates

1

289

May 15

May 15

Questions Adding Running Total to Accrual Balance by Trans Date

Topic Tags: Accrual Balance, Generic Inquiry, Employee, Time,

10

1,580

May 14

May 14

Questions Shipments Picked and Packed Per Day

1

160

May 14

May 14

#AcumaticaTnT Acumatica 2020 R2 OwnerID Field (1 viewing)

4

1,295

May 11

May 11

Questions Expected Monthly Sales Report

3

163

May 06

May 06

Questions Acumatica Compatibility for ME

0

283

May 06

May 06

Questions Lot/Batch traceability

0

113

May 05

May 05

Page 1 / 7 Next

Forum Statistics

11 Forums

1,996 Topics

8,983 Posts

11 Online

1,476 Members

Latest Post: An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details. Our newest member: Mehmet Yagci 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