Reports and Generic Inquires

Hello!I have a Parameter set up as @SiteID. I am attempting to make a cell on my report designer only visible if @SiteID parameter is null. Can this be done?    Maybe to explain a bit further. At the top; I’d like this to show up only when @SiteID is usedI’d then like the “warehouse” and “Waukegan” below it on the right column to only show when @SiteID IsNull I’ve looked online and done a bunch of AI chats and i only seem to error out every iteration i use. 

I am trying to create a GI that links the project quote to the project (to compare values).  I’m getting this error when I run it.  I have tried two different ways of linking the two tables: I’ve attached my GI.  Any ideas what is the best way to link these two tables?

exception has been thrown by the target of an invocationunable to cast object of type 'System.Byte[][]' to type 'PX.Reports.Web.WebReport'

Hey! We’re seeing a weird issue with one of our invoice email templates.If we open the PDF preview and click Send, everything works and the email draft opens as expected. But if we’re on the Invoices screen (AR.30.10.00) and use the Email action, it fails every time with this error (Trace-Log):at PX.Data.PXViewCollection.get_Item(String key) in C:\build\code_repo\NetTools\PX.Data\Graph\Collection.cs:line 1489 at PX.Data.Wiki.Parser.ParseContext.SetForeachIterator(String viewName, IDictionary2 parameters, String sortby) in C:\build\code_repo\NetTools\PX.Data\Wiki\Parser\Output\ParseContext.cs:line 123 at PX.Data.Wiki.Parser.ForeachTagProcessor.PX.Data.Wiki.Parser.PXHtmlParser.TagProcessor.Process(String tagName, String content, List1 attributes, WikiArticle result, PXWikiParserContext settings) in C:\build\code_repo\NetTools\PX.Data\Wiki\Parser\BlockParsers\XmlTags\ForeachTagProcessor.cs:line 115 at PX.Data.Wiki.Parser.PXHtmlParser.DoParse(ParseContext context, WikiArticle result) in C:

I’m trying to track who is set to get emails from our templates on various reports.Use-Case: “User A” exits the company, remove them from all outbound emails from all templates.I’d love to make a Generic Inquiry that shows me every report with every template saved for that report and then the TO and CC fields for that template. Which table has this data? Thanks!

Hi.         I would like to include additional levels to the original Dunning letter but I’m unsure of the syntax in report designer. Initially, I would like four levels. Also, include a column for the late fees and interest for each document and a total for the late fees and interest.

Hello,I am trying to create a report in Acumatica Report Designer where I need to first group records from one table, and only after the grouping, use the result to join with another table.Is it possible to implement this in Report Designer? Does Report Designer support virtual tables or nested tables that would allow such a workflow?Any guidance or examples would be greatly appreciated.Thank you!

Hi guys, I created a report showing the invoices and credit memos. There is a total. I need the invoices to add and the credit memos to be subtracted.How do I show the values as negative in a report designer?

I create a new report. And i need set visible group header by some condition When i set =$LaborReport_RowsCount>0  in visibleExpr this headers was not visible. But i have rows in Labor Report.

When add table in schema builder have this error. I reopen report designer and I have this problem again.  

I have field Description or other and i need wrap text with label for this field. How I can do this? For example i have this structure And in report my field description stuck other field, but label description not. 

I set vendor access by user. I want to filter the data by the vendor or employee when running the report in Report Designer. I remember that in customer access, I only needed to link another table to the Customer table, and the data was filtered automatically. But for vendor access, I don’t know how to make it work. Please guide me

I was having an issue with getting my new saved report getting into the site map.  At the time of writing this report I was able to get it to work by “Open report from server - load report lists” and saving it as a new report.I was not able to get it to show up from editing the saved report and saving it to the server.Problem solved, has anyone else had this issue?

I created GI that pulls all appointments that are past today’s date but have the status of not started. Now I am trying to set the appointments that are over 60 days to one color and the ones over 30 days to another color. I am having issues with the date in the formula to set the row colors.  In the conditions it lets me use the @today-30 or -60 function but it doesn’t like the @ today in the results grid to setup the color.  I tried the today() function but then it gives me a syntax error.   =IIf([FSAppointment.ScheduledDateTimeBegin]<((today())-60),'red', (IIf([FSAppointment.ScheduledDateTimeBegin]<((today())-30),'orange', 'default'))) Any ideas on how I can accomplish this? I know the issue is integer versus date but I am not sure how to fix this.

How to filter records by current user branch GI

Hello,trying to copy an existing report by rebuilding it so i understand. My parameters do not seem to be working. I can fill the data fields out with variables, but it seems to just default to how the GI is configured. For CustomerID i’ve tried to use ARInvoice.CustomerID which is what i have declared; but doesn't work. the string in the screen grab works on the reference form even though INTran was not declared anywhere.  For date; that’s a pure copy pasta. It works on the reference report and google fu told me this would be one way to go about doing it, but it doesn’t seem to work. i guess i dont understand, I was thinking report designer would use my reference GI and need data sets that that GI uses. 

Is it possible in a Generic Inquiry to generate a result that lists every calendar day between two dates?For example, I have StartDate and EndDate, and I need the GI to show each date within that range, even if there are no records for those days in the underlying table.

 Hello Experts, i am getting stuck in one of the GI where branch Parameter is not getting null if i am opening GI by default branch is getting selected, i need to have branch parameter null so that user can select its branch and filter out the result. And if in default value keeping as null its showing me error message. Please have a look on the parameter and the condition applied. GI looks like this branch by default is coming 

Hello, On a Sales order screen, we recently experienced this error message:   The trace log doesn’t seem to show which column is causing the error. I’ve looked into the fields of the generic inquiry and not sure what to do next. This GI was working fine last week. Any help is much appreciated! I’ve attached the XML of the generic inquiry here, as well. 

Hey Community, Does anyone know how to hide the “customization” button on the top right of the GI entry screen (even if only from certain user roles)? 

Hello!I am reaching out to seek your expertise on addressing a customer requirement. The customer operates within the Acumatica SaaS environment and creates kits directly from the (Kit Assembly - IN307000) screen. These kits are controlled by lot number, and the process involves using the Acumatica app to handle the entire pick, pack, and ship workflow.A key requirement is to generate labels for the kits at the time of their creation. For instance, if 20 kits are created, the system needs to generate 20 corresponding labels, one for each kit.  I am encountering a challenge with generating labels for a kit product because the quantity and product information are located in the document header. Specifically, I need to generate detailed labels for each kit (e.g., 20 labels for a quantity of 20 kits) based on this information.Could you advise on the best approach to achieve this in Acumatica Report Designer? Are there specific techniques or configurations that would allow me to replicate t

Hi all,I am looking to create a report where I want to see all lines related to each bill.Such as if a bill has 5 line rows, I want this data so is there a way to get this? Thank youAmar

SO, in this designer report the item line is not picking from the correct path that is SoShipLine.TranDesc. The Soshipline was not in it so i join it to the table of SoShipment. I try adding it but the result was duplicating itself on every linethis was the formual that was puling the item.=IIf([SOPickerListEntry.LotSerialNbr]<>Null, Format('{0} {1} {2}', [SOPickerListEntry.InventoryID], [SOPickerListEntry.LotSerialNbr],[SOPickerListEntry.InventoryID_description]), Format('{0} {1}', [SOPickerListEntry.InventoryID], [SOPickerListEntry.InventoryID_description])) This is after I join SoShipLine to get TranDesc this is the formula i used=IIf(    [SOPickerListEntry.LotSerialNbr]<>Null,    Format(        '{0} {1} {2} {3}',        [SOPickerListEntry.InventoryID],        [SOPickerListEntry.LotSerialNbr],        [SOPickerListEntry.InventoryID_description],        [SOShipLine.TranDesc]    ),    Format(        '{0} {1} {2}',        [SOPickerListEntry.InventoryID],        [SOPickerList

I’m trying to create a Generic Inquiry table that has all the inventory balance by location and serial number. There’s been several different tables presented on this site that can get qty by location (attached below) however, whenever I add Serial Number to them, the serial number gets attached to everything of the same part, producing duplicate results (and grouping isn’t smart enough to match deal with that). Is there a way to get the serial number to link only to the qty it belongs to?

In Acumatica version 24R2, I deployed the customer portal. I want an email notification to be sent to my team whenever a ticket is created on the portal. I haven’t found a simple solution. So I created a generic inquiry on all tickets, then a business event based on this inquiry that triggers for any inserted record with status “New” and the screen ID of the portal. I linked an email notification to the event.The event triggers perfectly well. But when a ticket is created on the portal, the event does trigger, yet it doesn’t send an email (the email isn’t even created in the “All Emails” view). However, the event history doesn’t show any failure and indicates that the action was executed.Finally, when I create a ticket directly in the ERP, it works fine and I do receive the email.Does anyone have an idea?