Reports and Generic Inquires

Hello,We have a custom PO form that was printing properly.  After an upgrade to 24R2, is prints smaller and does not use the entire page.  There are other reports doing this, I’m just using the PO as an example.  I opened and saved to server using the new 24R2 report designer without making any changes, but that made no difference.Wondering if anyone else has experienced this.Thanks,Larry

its duplicating the ordernbrso how can i join the SOOrder and SOline, and make it pull from both side 

Unable to open the report designer for a only for specific URL. I’m trying to do this in a upgrade sandbox and facing this issue. Even I have reportdesigner access in the access rights.  

I successfully created a data provider for an external SQL database and can retrieve data using an import scenario. However, I’m struggling to build a Generic Inquiry (GI) that combines data from both the external database and Acumatica tables.My goal is to create a GI that pulls accounts on hold from our external production management system and compares them to the same account numbers in Acumatica. This would help our accounting team identify which accounts need to be placed on hold in Acumatica—an initial step toward future automation.Given that import scenarios can access external data, I would expect this to be a straightforward task. Any guidance on how to achieve this would be greatly appreciated.Thanks in advance!

Hi! I have an attribute that is using the EPEmployee Owner ID field. The schema field does not have an option to select owner description. This attribute is being used in business account, when selecting on the business account record, the owner name displays, example is Device Hub here: But in the generic inquiry, the attribute field is only pulling the ownerID number and not the name: Is there a way to link the employee owner ID to the owner name so the GI display the actual name not numbers?Thanks!

Hey,I have a inventory balance GI. I’ve introduced some batch tracking to specific products, I’d like these to display on GI in the same way they do on an Inventory Balance report.Im close, but i cannot seem to get the Grouping/Conditions right to link the qty to the correct batch number. I just get duplicates indicating i have the total amount over two batch numbers.My GIIf anyone could assist or walk me through howto, i would appreciate that alot.

I want to create Generic Inquiry for Vendor Name, Account Name and ReportID 

Hi community,I need some help with a formatting issue. In a Sales Order report, I am using a subreport to fetch VAT and SVAT values, and the values are being retrieved correctly. However, there is a formatting issue. The numbers are displayed like 1669.18, but I want them to be formatted with thousand separators, like 1,669.18. I tried using ‘#,##0.00’ and ‘SOLine.OrderQty.Format’ to change the value format, but it didn’t work. Does anyone have a solution to fix this.  

Hi Everyone,I am currently making modifications to the lot/serial number report to display project IDs and tasks. However, I cannot seem to find the correct table to relate to INLotSerialStatusByCostLayerType in order to display the project data. I have tried using INTran and INCostCenter, but I keep encountering duplicates. Can anyone provide guidance on how to correctly relate these tables?

I need to dynamically break the page in a report based on transaction volume. The default printing height is 20 cm. When the transaction volume exceeds 20 cm, the report should break after the end of all transactions. Similarly, if the transaction volume is below 20 cm, the report should break after the end of the last transaction before reaching 20 cm.How is this possible?

We have a Call Sales Report in Report Designer that shows all of the notes/comments a sales rep has entered based on a date range. When the report is put into production and brought up as an axd the full report does not show. Clicking on the HTML also reveals that a major portion of the report is missing as the report should be several pages long, but only one page shows up. Even exporting the report as a PDF has missing parts of the report. In the Report Designer → Common Settings, PdfCompressed = TRUE, PDFFontEmbedded = TRUE, PrintAllPages = TRUE, ViewPDF = TRUE. I’ve tried using the ConvertHtmlToText = False, that cut off the headers (headers have the account number and business name for each visit) for each days entrys. CanGrow = True, CanShrink = True, CanSplit=True. Any suggestions as to how this can be fixed will be appreciated.

anytime i  join and validate this statement it good.but when i save and try to people the sales order tab this show upi am trying to put the statement on the statuse column to get different colors.i need help?

When creating a sales order, if I click the magnifying glass next to the customer search box, is there a way to add a searchable field in that pop up window? We would like to be able to search by Primary Contact Name in that pop-up box.

Is there any documentation coming out of Acumatica Summit 2025 on the upcoming GIQL Editor? I have a few notes that are all very intriguing and I’m looking for information even in Beta. From my notes I have, “If you have an SQL background you will love it. “ We’ll see helpers, auto-complete, and tools be integrated into the GI forms. Thank you!

HI All,In my default IN3010PL, I have join INTran with INRegisterand add Conditionswith purpose of showing only transaction of current branch.However, all the transaction are disappeared. I have attached my generic inquiry for your review.Please advise me if you see anything is missedThanks in advance

Hi,I have recently increased the character limit of the description fields to 4000for the Tasks, Revenue and Cost Budget tabs in the Projects screen, and I am wanting to replicate this in the report that pulls in these description fields.Is it possible to increase the amount of characters that a field can hold in the report designer? Or is it set to a maximum that isn’t able to be changed?Kind regards,Andrew

Hello Everyone,Are the standard Inventory Item Labels in any particular standard label format? (e.g. Avery 5160)Thanks,Luke

Hi all, I know that’s possible to write a generic inquiry and pull in a note from say a Customer or a Sales Order Line.But I would like to be able to add a note that is specific to a generic inquiry itself. For instance, I just wrote a GI for our team that identifies potential issues (undercharged on a sales order, for instance). But I don’t want to use the notes attached to the sales order, because many of the notes attached to the so are important and don’t want them overwritten.Basically, I’m looking for a way so our team can ‘tag’ or highlight a row result in a GI (ie, a tage could mean ‘investigate further’ or ‘ignore’).Maybe I could create a user-defined field called “mark” and then could the end user somehow glag that UDF from the GI? 

I want o build a dashboard, how can I show the sales orders with credit hold 

This is how the report looks like when I run it now:  I’m trying to get the report to run without duplicating the header of every inventory item separately. I had previously grouped by first the Vendor, and then grouped them by inventory ID so multiple purchases of the same product sums up and we see the total amount.  How can I remove the header from showing up before each inventory item?

Hi all,I’m calculating labor cost for a generic inquiry using this:=Round( CInt( [AMProdTotal.ActualLaborTime] ) /60.00 , 2 ) * 47.33But, I would like change that default rate if the following user names are true:=iif(InStr([CreatedByUser.Username], 'barcode')>0 or InStr([CreatedByUser.Username], 'slitter')>0, Cint([AMMTran.LaborTime]), 0)Is there a way to say, labor rate is 94.66 if username contains “X” or “Y”, otherwise labor rate is 47.33? Also, I’m trying to calculate the labor time here based on username, converting the minutes into hours, but I have this messed up! (probably the parentheses!) Any ideas?Thanks for any input!

I created a simple business event with trigger condition that whenever my GI has new line, it should send email notification. I created a simple GI to test it but somehow it is not triggering no matter how I change the GI or BE condition. My GI has the following fields, with condition that only when a field is not blank, the record will only be inserted into the GIFields in my GICondition when record should be inserted My Business Event Trigger Condition 

When I go to our Storage Details By Item Warehouse Location GI I initially get a list of all of the stock items as seen below But when I filter by warehouse, no stock items are found. II think the GI just got edited and messed up I wasn’t sure if there is an easy way to get the default settings for this GI?

Hello! I am required to remove Export to Excel option from Customers (AR3030PL) screen. Is there any possibility of doing this?Best Regards

I have a GI that when I “View Inquiry” on the production server I get the results I want, but when I export it as a report, I receive the following error message: “Response is not well-formed XML”. I verified that I’m using the correct credentials when logging in through the report designer.  How are GI altered when exporting as a report?