Reports and Generic Inquires

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.

I’m trying to create a report that produces a excel sheet with cell borders. However, I can’t figure out how to get the borders to display in Excel. Is there a way to format the excel cells in Report Designer?

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?

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.

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.

Hi Everyone,In the GL620500 Report, I have added the variable in the DetailSection1 and would like to display Total Amount and Total Count in the Header but it is not working. Can you please review and provide your inputs.  

How to filter records by current user branch GI

Hi All,Is it possible to add a line number as a field item and use it to format the output of the GI? For e.g., I have a GI that lists 10 rows but I had like to use the line number to change the background color of each alternate row, which is not based on any conditiion. Since, the Row Number is available only for display, how to get a row number for any GI (not a report)?Manish

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. 

I am creating a GI and need to pull for a Date, however the field i need to use is a DATETIME field.  I feel like it should be easy to convert it to a DATE field only but it doesn’t seem to be.  Any hints?  I’ve tried every scenario that i can think of and google...I’ve added things to the Data Field, Schema Field, Style etc.  i can do a LEFT(Start Date,11) but then when i try to add a condition that it pulls @Today, nothing will show.  I am assuming it’s b/c of the timestamp attached to the Date.  

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

Hello everybody,I have the following scenario:A set consists of two components: a certificate, a 20-item box, which can contain one or more lot/serial numbers. In the delivery note, the information should be displayed as follows: Line for the certificate Line for the item (20-item box) Below the item line, a list of all associated lot/serial numbers should appear – regardless of whether there is one or multiple lots. The lot/serial numbers come from the field:[SOShipLineSplit.LotSerialNbr]Problem:When I use a separate detail section for the lot/serial numbers in the report, Acumatica repeats the item line for each lot/serial number. This causes duplicate or multiple item lines, which

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 

Hi,I’ve added the relevant tables and joins in the Customer master GI to display the customer’s bank account number. However, instead of the actual values, the GI is showing 0000000000.Refer to below screenshot.      

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?

 I have a requirement where I want to highlight the Sales Order Generic Enquiry data when the Sales Order is created by a certain user and the Sales Order Pick List has been printed. How do I extract the status of the print, and other information like date of print, printed by whom etc.