Reports and Generic Inquires

Finding out an issue where the Header on my report does not cover all cells when I export to Excel.  This is my first attempt at updating/adjusting Excel formatting with Report Designer.How do I adjust a group or header to match the total cells on the report?  Or, is there some documentation on the Excel formatting and Report Designer?

I added a Attribute to my Vendors screen (AP303000).  I have that attribute called out in my report.  I have my Report Parameters calling Report.GetFieldSchema('Vendor.APOWNER_Attributes').  I am seeing the filed populate on the Reports Parameters on the screen for report and I an even select the desired result to filter agonist.  But when I pick one of the options and run the report, I still get all values for the Attribute, not the one selected.  Am I doing something wrong, or missing a step. 

Hi Community, I am trying to localize a purchase order print form (report) to Portuguese, it translated as expected but there is one textbook that contains one of the terms and conditions that has failed to translate even after surely translating it in the translation dictionaries as you can see in the first screenshot, is there anyone who has faced a similar problem and resolved it? your feedback will be greatly appreciated.As you can see in the last screenshot, the first two textboxes got translated as expected, apart from the last one.  

Has anyone been able to get .heic files to embed in an Acumatica report? We are using Daily Field Reports in the PM module to capture and communicate field activities.  Part of that is showing, in a concise format, images of what was done during the day.  Everything works great if our field personnel take pictures THROUGH the Acumatica mobile app (saves images as jpg), but sometimes they end up with a picture on their camera roll (HEIC file type) and want to upload it after the fact.  The problem we’ve found is that Acumatica Reports aren’t able to render the image(s) in the report.  I realize that you can just go to the report record and open each image, but it’s much less efficient and doesn’t capture all the value of being able to auto-distribute the information via e-mail. Below you can see that we uploaded 16 photos (our report is built with enough variables to display 8), but photos #3, 6 and 8 are showing that there’s data (by virtue of the created date/time), but the image does

Sharing in case anyone else gets stuck here - I setup a simple business event aimed at triggering an action. Each time I tried to setup the Action Execution I would get an error reading Error: Another process has added the 'ActionExecution' record. Your changes will be lost. After numerous attempts I noticed in the trace log that it also stated Cannot insert duplicate key row in object 'dbo.ActionExecution' with unique index 'ActionExecution_Name'.  which made me finally realized that we had an old Action Execution with the same SubscriberID in a test tenantThis wasn’t obvious, since both the Business event and Action Execution were new and totally unique, but after trying a new name on the subscriber ID I was able to save successfully   

Good morning community,I have been asked on the Transactions for Period report to set up the parameter to be able to search by the last 6 numbers of the subaccount ID. I have tried adding “Left” in the formula and 6 at the end and that is not working on the parameters or the formula field.Any best practices to get this to work? Search parameters   Thank you in advance for any pointers!Thank you,Trisha

When running the AR Aging report for some accounts it works while for some others it doesn’t.  I get this error: 6/4/2024 8:18:56 AM Error:Can't calculate expression node: 'pageHeaderSection2 (PX.Reports.Data.PageSectionNode) dataItem: '.  

HI, I have a client who is asking for this on the Sales Order printed form, SO641010.rpx:*T Total - Set a variable to accumulate the extended price for each line as it is processed with an initial value of 0. Increment value with the extended price for each line as lines are processed. If and when a line with Inventory ID = *T, the form should print the Transaction Description and the variable accumulated value in the extended price column. Reset the variable to 0.I have a variable that is the subtotal of the lines. The problem I am having is printing the variable and when it is getting reset. I have tried various things to get this to work.The Output is clearing the variable prior to the data being printed, see below. Here is a picture of the variable & how it is being reset.    

Hello,Does anyone experienced this issue. The report is looking fine when you hit Run reportHowever, when you click print we are receiving this error: 

Hi all, We’re a global company with 4 different buyer teams. While we have tried to standardize our forms, we’re still finding that some Branches need different information on their forms. For example, the last page of our forms have Ts & Cs need to be different per Branch. What is the best method to identify and use a form per Branch?

All, we have fields for a graphic’s width and height. In the results grid I have a formula to calculate the Square Inches; however, it’s rounding to 0 precision (no decimal places). How do I extend this Square inches calculation to 3 places? =CInt([InventoryItem.UsrCFCHeight] * [InventoryItem.UsrCFCWidth]) 

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