Reports and Generic Inquires

hello all,I have been trying to process reports via Send Reports (SM205060) processing screen but have not been able to. Can anyone let me know how shall I make use of this screen? What are the steps to process? Thanks in advance

Hi all, we’re currently upgrading to 23R2 and we’re testing it in a sandbox.In Production Order Maintenance (current/live site), the Order Type parameter menu is empty/no default. In the 23R2 sandbox (green header), the Order Type defaults to RO.How can I edit the GI to change this? I don’t see a default value listed. 

Hello,I understand this might not be a recommended approach, but we would like to attach a report to the user profile that includes a QR code containing the user's password. Is there a way to print the actual password in the report? I've tried using Users as a DAC and "Password" as the Field, but it only displays hidden text instead of the actual password.

I am trying to add an attribute that I added to all of my vendors called VENDORTYPE to the Purchase Order Generic Inquiry as an additional column. I am trying to add in the Vendor table and join it so the attribute will be available to pull into the inquiry, however when looking for the attribute in the Results Grid options, it isn’t appearing.I think I must be adding in the table wrong or joining it incorrectly. Any help here would be greatly appreciated! 

Please help me to get total of quantity for the same inventoy id from shipment line 

How do i make the files i have attached to Change Requests or Change Orders print on the CR or CO report form?

Hello all, I have an issue working with Charts on Report Designer.In this moment I can show Charts on Acumatica showing the data in the Footer and in the header report. You can see the example:Footer: I have the same info working with the header.But If I want to show the chart in the detail section, I have an error from the Report Design.I created the charts on the detail section in the same way like the charts on footer and header but I have a general error saying this: “Response is not well-formed XML.How can create the charts in the detail section?Thanks in advance and best regards.

I am trying to reduce the space between printed lines on a report. On the physical report it seems like there is no space to reduce between the detail section and the next.   The space between the detail lines on the report are shown as below. Is there a font setting or something to reduce this?Extra spaces marked in red​​​​​The last second page of the report is completed blank. only having the totals and signature. 

Hello team,I’m working on customizing the project history details report (cs600010.rpx) and need assistance setting up a visibility expression. My goal is to configure the report to only display invoices for the billed (Revenue) account group, excluding the unbilled ones.Could someone guide me on how to write an appropriate visibility expression to achieve this? Any detailed steps and examples would be greatly appreciated.I have tried using the below expression and yes it does hide the columns, but for everything. =IIf([PMAccountGroup.GroupCD] = 'Revenue', True, False)  Thank you,Catherine

Looking for a Template for Land/Sea and Air DGN (Dangerous Goods Note) Templates to Import into our Tenant.  I have located PDF version of the IATA official forms, but I can not find something that can be uploaded to the Report Writer in Acumatica.If someone has some advise or know of a way to accomplish this, I would be grateful for any help!  :)

Hello,I am passing a variable from a subreport back to the main report.This is working with one problem.If the subreport has no records to report, the variable being passed back to the main report is wrong.The variable should always report the value from the subreport for the current record.The subreport itself prints correctly, but the variable appears to be from the previous record’s subreport value. 

Hello, I created a large report that required row codes, hidden calculated columns, and summed columns. Unfortunately, I am having trouble being able to SUM the percentage and division columns in my second image. Is there a certain formula or way to be able to SUM the calculated percentages? I think I’m having trouble because these are “Calc” columns. Any assistance would be very appreciated!! Column SetNeeding SUM**​​​​​​Regards,Brandon McIlhargey

Is it possible to pull in the currently selected report template into the report designer? Goal is to dynamically set the exported excel\pdf file names to the selected template\date. Any idea if this is possible?  

My new GI has a calculated numeric value which the view displays as a decimal (19,4).  I would like the value to display as a currency with 2 decimal places and comma separators.Probably because I am new also, I can’t figure out how to alter the presentation in the view.Thank you! Tom Morris  

I would like to have the notes associated with a transaction to print on the same line on the reconciliation statement report. Which field would I have to include on the report to achieve this?   

Working on a project where I created a new workspace and categories to the menu.  Then we created some new GIs that pointed to this Workspace and new Categories.  I then added those GIs and Site Map changes to a Customization Package.  When I published that Customization into a different test tenant, I can find the Workspaces/Categories being created, but the GIs do not populate and I cannot make changes to the GIs to make them populate.  But, I can assign a different GI to the new Workspace/Category to populate.What am I missing or doing wrong?  Is there a best practice?

My GI is showing some Credits as negative numbers, but a lot more numbers are not negative, showing as positive. I have included the coding to account for negative numbers but it appears to not be consistent across the inquiry.

Hi everyone, we are looking to present data on costs of goods sold to show the average costs of components included in the average costs of finished goods. Our raw materials are average cost, which are then used to produce WIP items (average costs) using production orders, which are then converted to FG (average costs) upon the addition of final components. It seems like this might be possible by drilling down into production orders that led to the final cost of the goods sold. I know average costs complicates this and it might be easier under the specific cost method, but does anyone have any experience with this particular scenario or any ideas to share? Thanks!

We just upgraded to 2023R2, and the connection to Power BI drops after about 2 hours.   We reconnect, everything works great, but then later it reverts back to the “This content isn’t available” tile and we get the attached error.   

Hello,I've been trying to figure out how to count pages per Sales Order when printing in Batch, but I haven't had any luck so far.Printing individually works fine. However, when printing in Batch (via Print/Email Orders), the 'Page Of' count aggregates all the Sales Orders instead of counting them individually.For example, Order #5 has 11 pages, and Order #8 has 1 page. So when printing in Batch, Order #5 should show 'Page 1 of 11,' and Order #8 should show 'Page 1 of 1.I attempted to update the value of ResetPageNumber to 'True'. It functions correctly if the order has only one page. However, if the order spans multiple pages, it will print '1 of 1' for all the pages. 

Hello all,I have been trying to build out a report and i have the User ID set as parameter . So if any user ID is selected under this parameter and the report is run, the full name of the selected User ID isn’t getting displayed. Kindly let me know what is it that i am doing incorrect.    Thanks in advance.

Hello TeamWe have a requirement like get the next thursday date based on the current Date in GI. Tried in the SQL like below and it is working fine, Can you please provide Equivalent syntax in GI.DECLARE in SQL @GivenDate DATE = '2024-05-15';  SELECT DATEADD(DAY, (4 - DATEPART(WEEKDAY, @GivenDate) + 7) % 7, @GivenDate) AS NextThursday;Could someone please help on this.Thank you.  

When the report executes, I want to get the Current Available Credit value of the Customer to the Customer Statement MC report. Please check the below screenshot. But when inspecting the relevant DAC(CustomerBalanceSummary) shown in the above, it is Non-existent in the DB. Please check the below screenshot. So can i know how to get this detail to the Customer Statement MC report? Thank you.

We have created a generic inquiry which calculates the difference between the last user password change date and today() to get a number. This works.We now want to use that number to filter the records.e.g daysSincePWChange is greater than 0. The filter works if we use EQUAL or STARTS WITH and a given number, which means the result is being treated as a string. What can we do to ensure the calculated results are treated as numbers? Regards 

Hello everyone,I'm working on a report in Acumatica Report Designer and have encountered a challenge. My report includes multiple records grouped by a specific field, and I need to display only the first record of each group.I’ve been exploring the options in Acumatica Report Designer, but I haven’t been able to figure out how to accomplish this. Could someone guide me through the steps or provide a solution to achieve this?Any detailed instructions, tips, or code snippets would be greatly appreciated! Thank you!