Reports and Generic Inquires

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?

 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.

I have this kind bug/issue, when I add a group then undo it (ctrl + z), it still creates a white space. Even there is no group. Therefore, I can’t find where the area/group is if there is white space. How to fix this kind of problem also, the fields CanGrow = FalseThe white space is between Footer 6 and Footer 9 (Group 1)

Hello - I am attempting to pull in both the Vendor Email Address listed under Additional Information, as well as the Primary Contact Email Address into a Generic Inquiry, I was able to get the Additional Information Email Address field to pull in with the below relations, however I cant seem to get the Primary Contact Email to pull. Here is the working Inquiry:However, when I attempt to pull in this field for Primary Contact, I cant seem to get it to work.   

Hello Acumatica Support Team,I'm having trouble getting the email addresses from our customer screen to show up when sending invoices through email templates.Here's what I'm trying to do: When we send invoices by email, I want to use the email addresses that are set up in the customer screen under "Send & Print" These email addresses should go to the correct fields: To, Cc, or Bcc Here's what I set up in Report Designer:For the "To" field:= IsNull([BillingContact.Email],'')   + IIf([NotificationSource.SetupID] = 'INVOICE' And [NotificationRecipient.AddTo] = 'An', '; ' + [NotificationRecipient.Email], '')For the "Cc" field:=IIf(    [NotificationSource.SetupID] = 'INVOICE' And [NotificationRecipient.AddTo] = 'Cc',    [NotificationRecipient.Email] + '; ',    '')For the "Bcc" field:=IIf(    [NotificationSource.SetupID] = 'INVOICE' And [NotificationRecipient.AddTo] = 'Bcc',    [NotificationRecipient.Email] + '; ',    '')The problem: Only the main customer email address works The add

I have GI. I need dispaly value in this format. How i can do this? 

I’m having a hard time building a GI that will show an original payment reference number and any corresponding refunds associated with that payment reference number. The  ARTranPostBal is referenced but it’s a hidden table and not able to be used for reporting.How else can I bridge these two transactions?

When i update grid I have this error.   

Hi Acumatica People,I was looking at the body of generic Inquiries and report designer reports associated with booking. For us, the order register report looks like the closest thing to a starting point for a booking data. Some ERPs provide some report snapshotting (e.g. Oracle Applications has Period End Inventory reporting feature which you can set-up inventory snapshotting as an end user). I don't see anything such as this that is out of the box? We already have Power BI configured and licensed for our legacy ERP and a small warehouse. I don’t think we missed anything and we will continue going down the road of setting up/configuring our small data warehouse for Acumatica (e.g. configure data retrieval using OData).Is there any out of the box reporting feature one can configure for snapshotting? 

GI question - trying to pull both ytd and mtd sales from ARTran.  I can filter ytd in GI conditions, can I then filter the MTD on the results grid?   Do you have an example of the result grind filter somewhere for this ?