By using this website, you agree to our Terms of Use (click here) Overview Member List All-Stars Stats Recent Posts Help Forums AUG Forums Acumatica Generic I... Notifications Clear all Acumatica Generic Inquiries Questions or knowledge sharing about Generic Inquiries in Acumatica, including Pivot Tables and database schema discussions. | RSS Page 1 / 5 1 2 3 4 5 Next Status Topics Replies Views Users Date Pulling Revenue Year to Date (YTD) figures from GLHistory for Dashboard Scorecard 4 1,346 5 days ago 5 days ago Employee Time Cards 0 16 6 days ago 6 days ago Generic Inquiry with a Parameter for an Export Scenario 0 27 Nov 24 Nov 24 Is the Parameter Schema Field Mandatory? 0 20 Nov 24 Nov 24 Filter by Current UserID 8 3,239 Nov 23 Nov 23 Appearance of Notes and Attachment action icons in query results 7 1,047 Nov 12 Nov 12 GI for Restriction Groups 10 453 Nov 10 Nov 10 Payment and Application Type - Customer Refund 0 54 Nov 10 Nov 10 Saving a GI as a table to use in a separate GI 0 42 Nov 05 Nov 05 How do you link a SO to a PO AFTER the PO is created? 0 18 Nov 04 Nov 04 Opportunity and Sales Order Join - Missing Data Topic Tags: opportunities, sales orders, Generic Inquiry, 1 70 Oct 30 Oct 30 Concat function - how to add an apostrophe to a string? 7 138 Oct 27 Oct 27 Calculating Initial Response Time (Cases GI) 1 52 Oct 27 Oct 27 Using « start with » unstead of « contrains » 0 16 Oct 25 Oct 25 German VAT 2 40 Oct 23 Oct 23 Opportunity Screen - Relation to Sales Order Number Topic Tags: Opportunity, Generic Inquiry, GI, Relations, Tables, 8 925 Oct 20 Oct 20 Convert String to Date? 2 104 Oct 16 Oct 16 SQL Sub Query through Generic Inquiry UI? 3 81 Oct 16 Oct 16 Product Configurator - GI Inventory Item List with Attributes as parameters 4 131 Oct 15 Oct 15 Generic Inquiries 3 136 Oct 14 Oct 14 Generic Inquiry to select customer who have made purchases between certain date ranges 0 38 Oct 11 Oct 11 Add total to a GI 12 2,061 Oct 07 Oct 07 Format any date to 8 characters i.e. 10/5/2020 as 10052020 or 9/1/2020 as 09012020 1 54 Oct 05 Oct 05 Pages that look like generic inquiries but don't seem to be generic inquiries 1 89 Oct 05 Oct 05 Attribute assignment to Inventory Items via Generic Inquiry through Mass Update Fields 1 64 Oct 02 Oct 02 Discrepancy between Trial Balance and Inventory valuation 0 41 Oct 02 Oct 02 Default Column Sequence 0 38 Oct 01 Oct 01 Easy way to convert body of tasks to readable text for GI 9 698 Sep 30 Sep 30 Formatting the numbers in a column 17 3,481 Sep 30 Sep 30 Acumatica 2020 R2 OwnerID Field 1 64 Sep 30 Sep 30 Novice Question - Adding Invoice # field to Sales Orders GI? Topic Tags: invoice, sales orders, Generic Inquiry, 4 149 Sep 28 Sep 28 Push Notifications Topic Tags: Push Notifications, Acumatica, integration, JSON, 1 146 Sep 22 Sep 22 Dynamic Column Headings in Generic Inquiries Topic Tags: dynamic captions, 5 144 Sep 13 Sep 13 Sort by and IIF Functions Topic Tags: iif, aggregate, sorting, 7 147 Sep 03 Sep 03 Convert Last Day of Month from a Financial Period 10 834 Aug 17 Aug 17 Modifying Generic Inquiries in Self-Serve Portal Topic Tags: portal, generic inquiry, 0 112 Aug 06 Aug 06 Default Vendor for an Item 2 181 Aug 02 Aug 02 Highlighting of Generic Inquiry Rows or Columns in Data Table Widgets 17 780 Jul 13 Jul 13 Files on record. Topic Tags: Quotes, notifications, files, 2 127 Jul 13 Jul 13 Project Budget Forecast - Inquiry that only shows latest revision 2 250 Jul 06 Jul 06 Cash On-Hand Topic Tags: GI, Dashboard, Cash, Balance, 2 229 Jun 24 Jun 24 Adding Ship To Address to Invoice Data 3 1,182 Jun 05 Jun 05 Find date sales order status is marked complete 4 167 May 28 May 28 Find Bill-To Contact and Bill-To Address 1 117 May 28 May 28 Show week in year for a date 4 1,310 May 26 May 26 1. Displaying Record Created Date/Time - Summit 2019 Session Examples Topic Tags: acumatica user group, 8 1,159 May 20 May 20 OK....Maybe I missed this? Merged DB Structure (SM402000) 1 187 May 16 May 16 Designing A Generic Inquiry that I can find average days before payment is received by customer with. 7 2,385 May 15 May 15 Getting Sort Order to work in GI 15 684 May 15 May 15 [SOOrder.Status] = 'Open' always returns false 6 646 Apr 17 Apr 17 Page 1 / 5 1 2 3 4 5 Next Share: Online Members
