Reports and Generic Inquires

I am designing a report to spit out a label I think I have all the joins correct and the parameters appears like I want them to but all I am getting on the actual report is blanks instead of actual data. I am not certain what I am not doing correctly here.I am trying to get these 3 things to show our Item Number, the description for the item, and what Location the item is in for the Warehouse. I have 2 parameters the item number and which warehouse we are looking at but all i get in return is the Text box you can see in this screenshot none of the actual data I entered or the Location display. Any help or advice here would be great I feel like I am just missing one small thing to make this work. 

Hello,We are experiencing some issues on our development machines.I open a report from the live tenant. Then I modify it and save it as new version in test tenant. The report is saved as new version in the live tenant.Client’s Acumatica version: 24.108.0034My Report Designer version: 24.207.0011Does anyone know what may be causing this issue? Any help will be appreciated. :)

Hello,I am trying to have a GI show the value for ARSalesPrice.PriceCode and I keep getting no results.We have two codes (Default and Westcoast).  The “Sales Prices” screen (AR202000) shows them perfectly fine.  But it requires the user to choose from all of the filters. I have tried all kinds of joins and conditions, yet they just will not display.  I have attached the GI and any help would be greatly appreciated.

Hi all, I am trying to build a generic inquiry to show all the inventory items regardless if it has transaction history however I am getting multiple result by inventory ID but when I tried grouping it with inventoryID I am losing inventoryID that do not have transaction history. The ff are my main DAC I used:PX.Objects.IN.INItemSitePX.Objects.IN.INItemSiteHistDayPX.Objects.IN.INSiteStatusPX.Objects.AR.ARTran I have also attached the extracted GI incase anyone of you have any input how to make the inventory ID unique in the result. Thank you.   

Hey Acumatica community!We are planning to move to Acumatica 24r2, and I just notice some of my filter settings with @me is not working anymore, which used to work on the Acumatica 23r2. Does anyone knows what changes on the filter setting? 

How to keep show header if data subreport in page 2?Invoice is subreport page 1 Page 2

I have a GI that is pulling another GI in as a data source.  Both GIs have a similar Formulated field that is just the code for the month.“=Year([SOOrder.OrderDate]) * 100 + Month([SOOrder.OrderDate])” which should return something like this: 202506  meaning 06 2025 (June). And they both do this on their own correctly.  But when I try to bring the other GI in as a data source, the formulated field is not an option in the relations tab which I believe is normal, so I re-enter the expression into the active relations:=Year([SOOrder.OrderDate]) * 100 + Month([SOOrder.OrderDate])   equals  =Year([AMBatch.CreatedDateTime]) * 100 + Month([AMBatch.CreatedDateTime]) But for some reason, the system can’t find [AMBatch.CreatedDateTime] as an actual field? Which doesn’t make any sense because I can pick the [AMBatch.CreatedDateTime] as a field by itself, but when it’s in this expression it cannot find it?  The idea for this is, I want to have a simple GI that is grouped by month, with a column fo

How to set parameter from relation?in report designer for now customer location id showing all data but I want filtering data customer location ID from customer ID.please help me, im stuck 

Hi everyone,I'm having an issue with translating item positions in the Report Designer.Even though both the German and English descriptions are provided, the translation is not applied in the document when switching the language to English.   Can anyone help me with this?Could this possibly be related to the Translation Operator in Acumatica? It’s currently not working on my end, and I’m unable to maintain vocabulary translations there.I keep getting timeout errors that completely prevent me from continuing my work.  Thanks in advance!Best regards

An employee accidentally delete a customer from the receivables. How can I recover that customer?  

Best regardsIs there a possibility within report designer to let them know a Record Per page amount to process?since at the time of running it takes longer than estimated and that it is harming the operation the amount of time that is taken to upload the data.  

I am trying to create a report on sew tag, which requires page break. However, on inspection, there is no page break feature available in my Acumatica Report Designer. Is this a system glitch or is the feature available and I can configure it. And if rightfully so, please guide me on how to do the same.Thank you

Hi,I am trying to handle null values in GI and giving this formula=IIf(  IsNull([DemandSalesW1.ARTran_Formula13bfa5591de24380bcd5cdb1f24fe59a]) Or   [DemandSalesW1.ARTran_Formula13bfa5591de24380bcd5cdb1f24fe59a] >= [DemandSalesW2.ARTran_Formulaa0b3cfd923094f969a59fb9fa0093818] And   [DemandSalesW1.ARTran_Formula13bfa5591de24380bcd5cdb1f24fe59a] >= [DemandSalesW3.ARTran_Formula07567adb968540ba95a4e8dd42fa0655],  [DemandSalesW1.ARTran_Formula13bfa5591de24380bcd5cdb1f24fe59a],  IIf(    IsNull([DemandSalesW2.ARTran_Formulaa0b3cfd923094f969a59fb9fa0093818]) Or     [DemandSalesW2.ARTran_Formulaa0b3cfd923094f969a59fb9fa0093818] >= [DemandSalesW3.ARTran_Formula07567adb968540ba95a4e8dd42fa0655],    [DemandSalesW2.ARTran_Formulaa0b3cfd923094f969a59fb9fa0093818],    [DemandSalesW3.ARTran_Formula07567adb968540ba95a4e8dd42fa0655]  ))This the GI is raising an error “Index was outside the bounds of the array”.Can any one guide me whats wrong in the formula. I am trying to achive max values o

We have a subreport for an Invoice that is working fine for the most part. The issue is that sometimes we have a duplicate item, qty of 1, that is listed as “Free”, gets a LotSerialNbr of it’s own. When we have this type of scenario, the LotSerialNbr’s from both get printed with each other. I have attached a Word document and the rpx of the subreport. I’m thinking that it has to do with the linenbr(s) from the subreport, but unable to narrow down as to the why. I’ve already tried passing the main report line numbers to the subreport as a parameter, and in that case all of the lotserialnbrs went away, even the one number that is assigned to the item in line 2.

 A client wants to print a message on continued pages of a form but not the first page. They want the message to say something along the lines of. For Page 2: This is a continuation from page 1 For Page 2:  This is a continuation from page 2 I can get the group to print on each page but I am struggling to get a calculation of the prior page number in a group that is not the page header. The [PageIndex] is not correct outside of the Page Header & footer sections. I have tried setting a variable in various groups to no avail. Is there a way to accomplish this?Thank you in advance. 

Hello everyone,I'm trying to create a calculated field in the Report Designer, but it's not working as expected.Could someone please help me?What I'm trying to achieve is the following:Depending on the warehouse location (SiteID) and whether the item is accredited (UsrAkkreditiert = True or False), I want to mark the items with different numbers of asterisks (*).Each warehouse has its own rule:For internal warehouses (TESTSHH or TESTSNMS), only non-accredited items should be marked with a single asterisk (*). For external warehouses (EXTERNHH or EXTERNNMS), I want to mark:   Accredited items with two asterisks (**),  Non-accredited items with three asterisks (***). If the conditions don't match any of the above, the field should remain blank.Any ideas why this expression isn’t working, or suggestions on how I can correct it?Here is the expression I'm currently using:=IIf(    [SOLine.SiteID] = 'TESTSHH' Or [SOLine.SiteID] = 'TESTSNMS',        IIf([InventoryItem.UsrAkkreditiert] = Fals

Cannot resolve the table name: [PX.Objects.Localizations.CA.TX.TaxRegistration] Getting this error on trying to print SOInvoices

I amended an existing GL and am trying to set it up in Acu. I saved to server with a new report name (GL633002), added it into the site map. Updated the site map URL.Here’s my problem - It won’t show up on Acu’s menu and when I try to nav to the report Screen ID, it boots me to the home page.I can save a different version within the existing GL report and it populates/runs properly. But I can’t get a new report to generate on our menu/within our software. Anyone know how to fix this? I watched the S150 Report Designer 2025 R1 training on Acu & Johann had the same issue but he skipped over the fix. 

Link to GI Fields in Mobile Notification Message and to dropdown?

Hi everyone i need one help very important. There is one report which is called as" Sales profitability by Item class and Item(Detailed). In this report customer told me to add one column as Qty. I have added but it not working as a date time period For ex:- From -13/06/2023             To - 1/07/2024              Qty - 604,69.00             Net Sales - 674,69.00             It Should be Same as Net Sales I have tried by adding INItemSiteHistDay using table and added the relation "InventoryID - InventoryID" Plz help me how can i fix this and show proper data in the Qty field.

      In 2024R2, we customized a report based on Acumatica's built-in Inventory Balance (IN615000) page. The main change was to group by a custom field of the stock item and then count the quantity of each group.           I added a variable here. Strangely, only the value of the first group was correctly summed. The values of the next two groups were both 0.Can anyone give me some guidance?The customized report is attached.

        We are long-time users of Acumatica. Users have gotten used to the Dark theme style of print forms in the past. After we upgraded to 24R2, one of the print forms started throwing an error, and I don’t know how to fix it. The only way to make printing work normally was to delete the customized version and enable the default version—but this uses the Light theme style, and our clients still prefer the previous Dark theme style.    Is there a way to switch themes quickly? Or do we have to manually modify the styles one by one?

I recently upgraded my work PC and downloaded Report Designer first thing after receiving it- we are utilizing SaaS, not a local instance. Every since getting the new laptop, I cannot open reports from Server in Report Designer, despite using the exact credentials that I used before. I am truly at a loss and cannot figure out what is wrong. Any help would be appreciated! I am getting the following error: “Authentication failed. The user with the given login and password was not found in the system.” For URL, I still use https://xxx.acumatica.comFor Username I use login@Tenant NamePassword is simply the password.  I have even attempted to create a new user, with Report Designer as the only User Role granted, and it still gives me the same error.  

When I create variable in page header and want to use in group section or detail section, It show zero value. but if I create variable in group section and use with other section or detail section. It show value.

Hi everyone,I am setting up a business event that sends the Inventory Valuation Report in Excel format by email at the end of each month. I have already configured the generic inquiry, the business event, and the automation schedule, and I have tested the report several times.When I run the report directly without any parameters and select the summary option, it prints all eleven warehouses together as expected. But when the email is sent out, it includes eleven attachments. Each one looks the same, except a different warehouse is highlighted in each file.I have tried updating the generic inquiry and adjusting the email template parameters, but I still get the same result. Has anyone seen this before or know how to fix it?Thank you!