Reports and Generic Inquires

Hello,I am building a GI screen specifically meant for our merchandising team to be able to review matrix/stock items of a certain status, to see if the item status needs updating. The main intent would be for archiving/deactivating products or otherwise moving them out of active status if they meet the criteria. The struggle I’m having is looking for a filter solution around attributes, since we only retire, reorder, etc full color or design lines as a group. The use case example would be:On a t-shirt product, which has “color” and “size” attributes– when all of the matrix SKUs of the same color under the same template id have sold out, that color line should be reviewed to see if that color specifically should be archived, reordered, not reordered, etc. (So if t-shirt BLUE size small is sold out, but t-shirt BLUE size large still has a lot of inventory, we don’t want the BLUE matrix/stock items to show up in the review. Only when the whole color line is sold out.) I am puzzled how to

I'm trying to target open AP invoices in a Generic Inquiry, but no matter what I try, the formula always defaults to the else condition. =IIF([APInvoice.Status] = 'Open', 0, 1) =IIF([APInvoice.Status] = 'O', 0, 1) =IIF([APInvoice.Status] = 'o', 0, 1) =IIF([APInvoice.Status] = 1, 0, 1)   =IIF([APRegister.Status] = 'Open', 0, 1) =IIF([APRegister.Status] = 'O', 0, 1) =IIF([APRegister.Status] = 'o', 0, 1) =IIF([APRegister.Status] = 1, 0, 1)I’ve also confirmed that my conditions are limited to open and closed invoices, yet the formula always returns the result for the else part.Any insight on how the status field is actually stored or how to get this to work would be appreciated Thanks!

I can’t figure out where the access rights to share a filter on a GI is located in the permission settings. 

How to wrap text in acumatica report designer for excel sheet 

I’ve made a GI that is using the INLocationStatus table.  It is not joined to any other tables.  The GI returns the Location ID, Inventory ID, Inventory Description, QtyOnHand and QtyAvail.  I have this GI exposed to the Mobile Applicaiton. When I look at the GI on the desktop, I see the following:When I look at the GI in the mobile app, I see the following:In the mobile app, I am not getting the numeric value of the Inventory ID.  I can’t figure out why I am not getting the expected results. Any ideas?  Anyone else see this issue?

Hello - when I attempt to download the Report Designer for 2024 R2, I am getting this below error message, and am not seeing IIS 7 on the directory as an option anywhere. Do you know where I can get the report designer for 2024 R2 24.211.0024?  

How do I modify the format in Report Designer to only print 2 decimal places when using formula’s.  It’s currently showing 4 decimal places.  We recently upgraded to 2024R1.So far in the Format field I’ve tried “N2”, “#,##0.#0”, “###,##0.#0”.  Any other suggestions? 

What is the best way to add a dollar sign in front of a dollar amount (e.g. Unit Price)? I’m looking through all of the community posts and I’m not seeing a direct answer. Here is what I have tried:Added '$'+ to the front of the field name. That made the Unit Price 5 decimals instead of 2.  Added the Unit Price as the Format. This made it 5 decimals instead of 2.It seems like there should be a very easy way to do this, but I’m not seeing it. Thanks in advance for your help!

Hello everyone,I'm working on an Acumatica Report Designer report and need some assistance with displaying an image from Stock Item attachments.Here's my scenario: I have two image files attached to a single Stock Item record in the Acumatica UI (under the Files tab). I want to display only one specific image on my report for each Stock Item. Currently, the image that appears on the report is the last uploaded file (which happens to be a QR code image). The image I want to display is typically the first uploaded file for that item, and it can be identified by its filename: it does NOT contain the word "qrcode". The QR code image, conversely, always contains "qrcode" in its filename.  

Hello!I have a scenario where a user has requested a few reports (2 templates of the same report to be more specific) be automated to send weekly on Monday mornings. These templates have a Start and End Date parameter that need to be set to reflect data from the previous week.Playing around with the updated template scheduling in 2025 R1, I can’t seem to find a way to have those dates be dynamic (i.e. Today and Today-7). Is there a “proper” way to set a date field to not be a static date in the email template?

I’m attempted to run a formula to find out how long it took to produce 1 item via a production order.The formula I am using so far is:=iif([AMMTran.Qty]=0,round(0,0),round([AMProdTotal.ActualLaborTime]/[AMMTran.Qty],2))But I’m now seeing an infinite number of 0s after the rounding, and I only want to see 2 decimal places worth. 

Hi everyone,I'm working on a report in Acumatica Report Designer that pulls data from the InventoryItem table, specifically from the Cross Reference tab (i.e., the INItemXRef table). My goal is to display up to three rows from the cross-reference tab for each item, and show them side-by-side as three separate columns in the report. I’ve attached pictures of:The report Where the cross-reference can be found A view of the cross-reference tabHere’s the structure I'm aiming for:| InventoryID | CrossRef1 | CrossRef2 | CrossRef3 ||-----------------|----------------|----------------|----------------|| A100           | ABC001     | DEF002     | XYZ003     |Is there any reliable way in Acumatica Report Designer to extract row #1, row #2, and row #3 from a repeating dataset (like INItemXRef), and display each one as a column — even when there’s no distinct identifier on each row?Thanks for any insight! And please let me know if I can clarify further!  

Hello all, I’m in the process of testing our instance of Acumatica that we are upgrading from 2022 R1 to 2025 R1.  In my testing, I’m getting an error when trying to process a Import Scenario that we have been using for years related to creating new Produciton Orders and those Production Orders are released.  Here is the Import ScenarioWhen I try to process the Import, I get an error on the first record that says ‘BaseTotalQtyRequired’ cannot be empty.When looking at the screen, that field isn’t exposed.  Do I need to modify my screen to capture this field?  Or am I missing something in my Import Scenario?

Hello Experts, I Was looking to create a GI for lot& serial tracked item which is having expiry date . Please have a look to this GI is any thing i missed out please comment it .  

My data sources from GIs have been automatically updating a PowerBI sheet. However, today one of them broke, and only one of them, with the error:“DataSource.Error: We couldn't parse OData response result.  Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.Details:    DataSourceKind=OData  DataSourcePath=https://company.acumatica.com/odata/Production/Sales%20Profitability%20Analysis%20Detailed.” I’ve attached the GI that’s causing the issue.

Hi, I’m trying to add note information to the footer so it will print on all pages. when I print it shows all wording but when I export to PDF it cuts it off. see screenshots below.I have the can shrink to true. any other suggestions on how to fix? 

Missing Connection to show Customer Class Fields on Business Account GI - Must be missing something- Even using the Customer Class table- I’m trying to show Sales reps their own New AR Accts (vs Cash type), which only works with business accounts for the @me connected to the User PKID. Other fields seem to pull over fine, but I’m not getting the vast majority of the Customer class to Show in the results grid correctly. Any suggestions for connections or existing examples?

I cannot seem to get the relations working on this table, and im baffled since it seems like it should be as simple as simple gets.Case: I am making a nested GI, all the sub-GI’s work fine. they consist of a date column and a column showing the needed value for the item in question.The issue is each day will only have one or two columns of data, so as a foundation/starting point for the nested GI im using the SM.DateInfo table, then making relations to the sub-GI’s using a left join. This connection simply will not work. I tried using just the DateInfo and SOOrder table and doing a similar left join, hoping a stock table would work, and nothing. I even tried to convert the date on other tables to an integer and join with the DateInfo.DateInt field to no avail.As a separate test i made a GI with just the DateInfo table, have the results grid show just the date field, and tried to put conditions on it to pare down the results. Between Today()-400 and Today(). i get no results. Again, no

 Hello everyone,I need to add a filter to my report so that I can filter it by OpportunityID.Below are my screenshots showing the steps I’ve taken so far.Can someone please help me with this?Thanks in advance,Pantea 

Hello every oneI am currently working on a report containing bank information. These are encrypted . How can I get them decrypted in a report?I found a thread about a function:  PX.Objects.CA.Descriptor.ReportFunctions.GetBut I really do not know where to build this function in the report.Thanks

I have multiple companies set up as branches under the same tenant in Acumatica. I need to ensure that a user can only see and transact within their assigned company and not access others.

Hi everyone,I'm looking for a way to audit a specific user's activity in Acumatica. Ideally, I want to view a detailed history or trail that includes all screens the user interacted with and any changes they made across the system (such as record updates, document edits, field-level changes, etc.).Is there a Generic Inquiry or report that provides this kind of audit trail? Or is there a recommended approach or customization to capture this level of detail?I’m using 2024R1

The Additional Sorting condition does not seem to be working.  To explain further, here is the sorting/ grouping done in the report designer. However, when we tried to use the ‘Sales Order.Sched. Shipment’ in the Additional Sort and Filters: Additional Sorting Condition which doesn’t seem to be working. I even tried to output the Sched. Shipment Date in the report itself. I hope you can help Identify what I am doing wrong. I have attached the actual report just in case you may want to take a deep dive on the report. Thank you so much for your time in looking in to this. 

hello,i’ve created a RD report and i was expecting the tree view to work, however it is not showing up. I found a post mentioning that finance reports are based on the unit set, and non-finance reports use the groups.   i have several groupings in the report, for customer, salesperson and invoice. I have tried different settings with the Navigation depth:  It’s just not popping up...does anyone have any insight into this?  Cheers

Hi,Is it normal to have twice row with the same keys combination?Do I miss something?Thanks