Skip to main content

Reports and Generic Inquires

Reports, GIs, Dashboards, Pivots

  • 2,395 Topics
  • 9,603 Replies
2395 Topics
P
Semi-Pro II
podonnell11Semi-Pro II
asked in Reports and Generic Inquires
Print zero quantity item on pick list

Hello everyone, Is it possible to print items with zero quantities on a pick list? I am trying to get some non-stock items that have a distinct item description that act as line comments for the sales order. For example, I will have 10 lines of stock items with quantities and then 2 lines of non-stock items that act as description placeholders for the order itself, however they are at an order quantity of zero. I have tried to play around with the visibleexpr and simple iif statements to no avail. If anyone can point me in the right direction on this one that would be great.

2911
Gabriel Michaud
Captain II
S
Freshman I
shores6Freshman I
asked in Reports and Generic Inquires
Time Card Reporting

Hello, We are implementing time card in a client who does NOT use project, and finding that just basic time card reporting seems to be lacking. Has anyone created time card reports or inquiries they would be willing to share? Thanks!

970
S
Freshman I
J
Freshman I
jetzerb08Freshman I
asked in Reports and Generic Inquires
OData error when filtering on calculated GI data field

I’m setting up some Generic Inquiries that are exposed via OData for ingestion into a data warehouse.Some of the GIs are comprised of data from multiple tables (Customer + Address, for instance). In order to implement an incremental load strategy, I include a computed data field for Last Modified DateTime that looks like this: =Max([Table1.LastModifiedDateTime],[Table2.LastModifiedDateTime],etc,etc) But when I try to filter on that via an OData query such as this (where the actual date/time is filled in based on a previously captured value) $filter=ModifiedOn gt datetime'yyyy-mm-dd hh:mm:ss' I get an error message Error while copying content to a stream. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. However, if I include all of the LastModifiedDateTime values in the GI, I can successfully query data with a filter such as $filter=LastMod1 gt datetime'yyyy-mm-dd hh:mm:ss' or LastMod2 gt datetime'yyyy-mm-dd hh:mm:ss' or .

7008
J
Freshman I
W
Jr Varsity III
woodyg84Jr Varsity III
asked in Reports and Generic Inquires
Attributes for Project Task

I am having issue when using attributes for project tasks not allow default value. this is different compare with attributes in Case or other screens When sorting by attribute in one Generic inquiry, it generates the error. I then tested a GI with cases, it allows sorting on attribute there.

2481
Irina
Community Manager
D
Varsity I
donnadeskins55Varsity I
asked in Reports and Generic Inquires
Report Designer - display boolean field as a checkbox

Does anyone know how to display a boolean field as a checkbox on a report?

9445
D
Varsity I
TimRodman
Pro I
TimRodmanPro I
asked in Reports and Generic Inquires
Use Master Calendar checkbox on ARM Report

Does anyone know if this Use Master Calendar checkbox on the Report Definitions (CS206000) screen does anything? I have a Company where the Financial Period ID 11-2020 is mapped to the Master Calendar Period ID 02-2021 in the Company Financial Calendar (GL201100) screen: If I make an entry for $60 to period 11-2020: Then I create a report with the Use Master Calendar checkbox unchecked, the $60 appears when I run the report for period 11-2020 which is what I would expect: Then I check the Use Master Calendar checkbox and relaunch the report. But I get the same $60 result in period 11-2020. I was expecting it to be empty because I was expecting to have to run the report for period 02-2021 to see the $60. But when I run the report for period 02-2021, it’s empty which is not what I was expecting. It makes me wonder if the Use Master Calendar checkbox actually does anything or maybe it just got added to the screen with the functionality coming in a future version. I did my testing in Acuma

1851
TimRodman
Pro I
rodman
Freshman I
rodmanFreshman I
asked in Reports and Generic Inquires
Generic Inquiry HAVING SQL Clause

Does anyone have a clever way to use a Parameter in a Generic Inquiry to generate a HAVING clause in SQL right after the GROUP BY clause? It generates a WHERE clause which doesn't allow me to work with the aggregation results. I can do an on-the-fly filter, but I was hoping to use a Parameter.

7707
TimRodman
Pro I
R
Captain II
ray20Captain II
posted in Reports and Generic Inquires
An excel summary report for chain stores with multiple branches

Hello, We serve chain stores, and they are requiring a report every month like below: The cell value is the weekly usage of that single store store 1,2,3 is served by branch 1, store 4,5,6 is served by branch 2, store 7,8 is served by branch 3 Yes, this report can be done, if we run an inquiry by branch. And manually merge the data together to each colored section in excel. But my colleague is tired of doing the merge again and again. Is there a way to help him fill in the excel more quickly? I am thinking of “Pivot Table” or the “Excel Sync function” from different GI data sources, the problem is excel sync can not be parameterized. or “the report designer”, the problem is the layout Which way do you think is the best way to fulfill my need？ Or Can my need be fulfilled? Please advise. Thank you.

1433
R
Captain II
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
How to display 0 shipline on Invoice using Report designer?

Hello, I need your help. Previously I thought it is easy, but Now I did not find out a solution. As we know, the 0 shipment line would not turns into ARTran.So we might meet a situation like Shipline ARTran a b b c c d e line d and e is added by Advanced Direct Invoice Function. So they only have invoice#, no shipment# line a is shipped 0, so it did not turn into ARtran. My need is to display on the Printed out Paper invoice with all lines: although a is with 0 qty. like a b c d e I previously thought is a full join can get this done. But my problem is, if we are printing Invoice, we normally only know Ref# and Type. If I apply the Invoice ref# as the where condition, The line a will still be disappeared, Because a.ref is null. What should I do? Can anyone give me some ideas?

2205
R
Captain II
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
sub report layout ，how to make the sub report align to left

Hello， I put the sub report in the group header align to left, and set its text align to left But when I run , the sub report will still show in the middle of the master report Is there a way I can make the sub report to align left?

1492
R
Captain II
M
Freshman I
mrivera67Freshman I
asked in Reports and Generic Inquires
Specified Report Template per user

Hello Everyone, Just want to find out if we can specify a reprot template that can be used according to assigned role? e.g. when a Billing person runs a Sales Order report to be printed, it does not include the logo etc as they will be printing on a ‘pre-printed’ form and would only need the specific details like the item, price, tax etc. But if a Salesperson print the same Sales Order, it will printed everything including the logo etc. Thank you guys in advance. Kind regards, Mrivera69

1941
J
Varsity II
N
Semi-Pro I
NoahSemi-Pro I
asked in Reports and Generic Inquires
Shipment Confirmation Email is adding a line not in the Notification Template

When we send an email from our Shipment screen (SO302000) using Actions>Email Shipment, the emails that get generated are almost identical to the Notification Template it must be using (ID: ShipmentConfirmationNotification), except there is one line inserted “Track your shipment at [Tracking Link]”. Unfortunately, that [Tracking Link] placeholder doesn’t use the tracking number to populate. I can’t determine where it is getting this change to the template. It is the only Notification Template related to Shipping at all. There are no changes in the customer’s Mailing Settings or the Sales Order Preferences Mailing Settings. I’d like to delete that line, but can’t find it, plus you cannot alter the email before processing it. We are running 2020 R1 build 20.106.0005 with the Manufacturing Edition. Any help would be great! Thanks!

5703
R
Captain II
TimRodman
Pro I
TimRodmanPro I
asked in Reports and Generic Inquires
Data Access Class for POLandedCostSplit

I can retrieve data from the POLandedCostSplit table in the database: But I can’t find a Data Access Class that will allow me to retrieve the POLandedCostSplit data: I need to retrieve the data using a Generic Inquiry and I’m trying to avoid having to create a SQL View. Does anyone have any ideas?

2666
TimRodman
Pro I
TimRodman
Pro I
TimRodmanPro I
asked in Reports and Generic Inquires
LayerType field in the INCostStatus table

Does anyone what the difference is between the N and O LayerType values in the INCostStatus Data Access Class (DAC)? I’m also wondering if there are any possible values other than N and O. INCostStatus is the DAC that stores inventory costing layers and it’s used in the Inventory Valuation (IN615500) report.

1812
Naveen Boga
Captain II
N
Freshman I
nasimchowdhuryFreshman I
asked in Reports and Generic Inquires
Use of Expression editor in Report Designer

Hi, so i am new to ACM report designer. I am creating a report of payroll for our vendor, where every detail(job) done by the vendor is listed. Which includes job date, start time, finish time and different payment for the same job(officer pay, city fee, car fee). Report Now my report is grouped by job ID. And the information about the different payment is pull out a DAC called” APTran”, where the are stored in a table like below. But not all job includes all 3 form of payments .Some only have officer pay, some have officer pay and city fee and some have all three(and they are always stored in city fees, car fees, officer pay- in this order).There is a field called inventory id ,which includes the three payment method class. To get the officer pay information in the report row i used =Last(IIF([APTran.InventoryID]='OFFICERPAY',[APTran.LineAmt],Null)) Since its always the last one in the table. *“LineAmt” is for the Amount field. To get the city fee i used =First(IIF([APTran.InventoryID

6630
N
Freshman I
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
The "Is Null" in report designer visibility setting does not work, then how can I filter the data I want?

Hello,Thanks to Gabriel’s help. I can get the data I want in GI using a second filter. like below: The key in the join condition is that “INitemsitehistday” might only have qty in record，no sales record So if “left join” used， might get a joined line with INitemsitehistday.Sdate as Null. This filter out is working well in GI.However if I would like to apply the same kind of second filter by using the visibility section setting in report Designer. The “ Or [INItemSiteHistDay.SDate] Is Null” does not work. Then can somebody help me to get the data I want in Report designer? 1， Not sold in 90 days 2， never sold， which left join get a NULL value

14863
R
Captain II
scottm99
Freshman I
scottm99Freshman I
asked in Reports and Generic Inquires
I can't get the Pick List form to sort by the SOShipLine.InventoryID OR SOShipLineSplit.InventoryID

I am new to developing forms in Acumatica and in Acumatica in general, my coding knowledge might be just starting to hit intermediate level, although with C# I would say I am still basic. However my issue doesn’t seem to be code related it seems to be more of an issue of me not understanding HOW the sorting works in Acumatica. On the Pick List form on the Detail Section 1 area (not kits the next detail area) it has 2 fields that I want to sort by, SOShipLine.InventoryID OR SOShipLineSplit.InventoryID. I put those 2 fields in the Schema Builder in the Sorting area, however it completely IGNORES anything I seem to put there, I tried with the out of box form and our customized form and the sorting does literally NOTHING in BOTH cases so I clearly must not understand something, I will attach the relevant pictures. If someone could explain to me how I can get this form to sort by the InventoryID instead of the BIN location or anything else that is what I need. I thought this would be very s

5236
R
Captain II
C
Jr Varsity II
caseyh35Jr Varsity II
asked in Reports and Generic Inquires
Help with Dashboard Widget

Hello, I have a shipping dashboard setup to show a list of orders that need to be shipped. This contains a basic filter based off of warehouse (either MFG or RDD) and the status of the shipment (open). However, shipments seem to disappear from the widget, this seems to happen to older shipments. I have the record limit for the widget set to 30 for this widget, and I know that we are not having more than that many records listed on it at once. Here is the filter for the particular widget: shipping widget filter This is the list of shipments returned from the filter above, notice that #1346 and #1379 are missing. shipping widget On the acumatica shipments page you can see that shipments #1346 and #1379 both meet the criteria from the above filter, yet they are not shown on the widget. shipments screen I am hoping that someone can assist me in fixing this. I would greatly appreciate any input! This is happening currently in 2020R1, and was previously occurring in 19R2 as well.

2846
Vinay Koppula
Semi-Pro II
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
Can I pass parameters from GI's selection to its side panel screen?

Hello， I’d like to pass the parameters like date selection on GI to its side panel. Is there a way to do it? It looks like I can not put the “@DateFrom” as the navigation parameter.

3744
Naveen Boga
Captain II
Ehren_Dimitry
Freshman II
Ehren_DimitryFreshman II
posted in Reports and Generic Inquires
Generic Inquiry List/Report

I am trying to build a GI to list all Generic Inquiries in the system. The Site Map Title is not within the GIDesign table. I believe I need to tie the GIDesign table with the SiteMap table to get those details. Can’t seem to figure that out though… Has anyone been successful with this?

6084
porlov
Community Manager
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
Why Can the "Soshipline.openorderqty" NOT be found in GI? How can I filter the not shipped full item out?

Hello, We don’t generate “Back order” in business. That is, even if the soline is not shipped in full, the soline would become completed after shipment and the OPEN QTY on soline would become 0 But I checked, this item on its shipment line would remain open qty on screen. However, when I trying to make the conditions in GI, I can not find the SOShipline.OpenOrderQty field. Since GI does not support the condition in formula like: SOShipline.OrderQty - SOShipline.ShippedQty >0 How can I filter out the items that did not ship in full in daily business? Thank you

1223
R
Captain II
M
Freshman I
Mike CollinsFreshman I
asked in Reports and Generic Inquires
Unreleased AR Documents count

I’m in the process of creating an indicator for a client with all unreleased AR documents. Unfortunately it’s not a Generic Inquiry type screen I could just replicate and use in scorecard KPI dashboard widget. I tried to build a Generic Inquiry but linking ARInvoice with ARPayment brings no results. Is there any way of creating such an indicator for a dashbaord? Maybe I’m linking the DB tables just wrong.

1981
Gabriel Michaud
Captain II
M
Freshman I
Mike BaioFreshman I
posted in Reports and Generic Inquires
How to use variable values from a subreport in calculations with data from main report?

Haven’t had any luck finding more detailed instructions on being able use variables from a sub report in calculations back on the main report. I know you have to be able to do this and I can do it easily in Crystal reports. There are a few lines ive found in the help about using the subreport name in variable name to retrieve it but hasnt worked. If anyone has some samples to show that would be great, thank you!

8491
wfilipiak67
Captain II
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
Meet errors when open AR672000 (sales profitability by customer and so) from server

Hello, I tested in 2 environments, 1 is 2020R1 Build 20.105.0024, the other is 2020R2, Build 20.203.0028. Both meet the same errors. The report (AR672000 ) is running correctly, however, if I want to do a little modification and open the report from server, it shows errors in report designer, some like “textbox75” is duplicated stated, totally 4 errors, including “textbox75”,textbox76,textbox79,textbox80. If I did nothing, no changes, and just save this opened file back to server, it won’t display well, while it did display well before save this rpx back. So my large guess is the file is broken when opening. The line with doc.type= INV is missing data. which it did display data before. Can someone help me out?

531
R
Captain II
R
Captain II
ray20Captain II
asked in Reports and Generic Inquires
Is it possible to add more "aging days/periods" columns on report AR630500 (AR Aged Period Sensitive)

Hello, Correct me if I am wrong, I’ve studied the AR630500.rpx, and found actually the “aging days” are soured from statement cycle setting. However, on statement cycles, the split sections have been limited to 4. Supposing I would like to show columns like 1-15 days, 16-30days, 31-45 days, 45--90days, over 90 days is it possible to do it? Thank you.

3382
R
Captain II

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements
Product Downloads
Partner Forums and News

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved