Reports and Generic Inquires

When working in the Acumatica Report Designer, the Excel Grid button has become grayed out and unclickable. Strangely, this does not affect the actual Excel export functionality — my custom reports still export to Excel successfully. What would cause the Excel Grid button in Report Designer to be disabled, while report export to Excel remains fully functional? Can I fix it?

Hi everyone, I am creating a sales report where I would have another column to get the sum of previous years total (ARTran.CuryTranAmt) I tried using a subreport but could not figure out to get the @From or @To to have a value less than 1 year.  Any input is highly appreciated. Thank you. 

Greeting  I am getting the following error in my report designer when I try to open a report from a client's server. I have already uninstalled Acumatica and report designer on multiple occasions and it still persists.    error detail: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.Xml.XmlException: Root element is missing.   at System.Xml.XmlTextReaderImpl.Throw(Exception e)   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()   at System.Xml.XmlTextReaderImpl.Read()   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)   at System.Xml.XmlDocument.Load(XmlReader reader)   at System.Xml.XmlDocument.Load(String filename)   at PX.Reports.Design.ControlHelper.GetDataFromConfigFile(String filename, List`1 logins, List`1 urls)   at PX.Reports.Design.ControlHelper.ReadConnectionHistoryFromConfigFile(TextBox txtLogin, ComboBox cmbUrl)   at

Hi,I am trying to create a Journal Voucher report from the Journal Voucher (GL304000) screen.Inside the report, I wanted to see the GL Transaction, pulling it out from Journal Voucher > GL Transaction  My report details missing.  

Hi,We have a report that shows all of our labor transactions by order.  On that report, one of the first things it displays is the work order number.  The report could contain hundreds or thousands of work orders.  When viewing the report in Acumatica, all of the data is present, but when exporting to excel not all of the work order numbers will display.  We may be missing 1-5% of the work order numbers in excel..  Does anyone have any ideas why this may be?  I have messed around the with excel options in the report designer and have not been able to come up with anything. Thanks

Hi Everyone,In the GL620500 Report, I have added the variable in the DetailSection1 and would like to display Total Amount and Total Count in the Header but it is not working. Can you please review and provide your inputs.  

We are displaying the approver on our sales order report.  We bring this information in as follows: I have a situation where the same approver is in two approval maps rules (one inside of a workgroup and one as an individual).  So when he approves a document, it comes through twice. This is now causing the detail lines on the sales order print out to duplicate.  I would like to group by the key field here, which is RefNoteID, but I get errors when doing this because it is not a normal numerical ID.Any suggestions?  There might also be cases where there are two approvers who are not the same person, so grouping on Approver ID is probably not ideal, but maybe a work around for now because I only need to display one approver on the report.  Still wondering if there is a better way though?

We recently extended our default endpoint into a new endpoint for our Financial app partner Cube to use. Since some of the financial queries were so large, I ended up building a new GI to summarize transactions down to totals by period, by subaccount, by account for them to use.  The GI is working as expected, and I added a parameter to try and make it more ingestible by API. However, whenever our Cube dev tries to access the screen via API they get a 200 but null response, even though the screen when queried the same gets data. The webservice endpoint of this GI says to use a PUT method, though both PUT and GET have been attempted. Could someone please advise? Info:Webservice endpoint flag: Fields has the filter available: GI has OData permission, xml attached as well:GI loads as expected:GI XML (attached to ticket) API call attempted (getting 200, null)https://greatergood.acumatica.com/entity/Cube/24.200.001/CubeSubaccountGroup?$expand=CubeSubaccountGroupDetailsPUT{    "Parameters":

I would like to get a clarification regarding inventory transaction data in Acumatica. We are currently trying to identify whether there is a single table or a recommended data source that can be used to retrieve all types of inventory transactions, such as inventory issues, receipts, transfers, and adjustments, in a unified manner.From our understanding, tables like INTran, INRegister, and INTranSplit are involved in storing inventory-related data. However, we would like to confirm the following:Is INTran the correct and complete source to capture all inventory movements (issues, receipts, transfers, adjustments)? Are there any additional tables or views that should be considered to ensure no transactions are missed? Is there a recommended approach (or standard Generic Inquiry structure) to retrieve all inventory transactions accurately for reporting purposes? Are there any specific conditions, flags, or transaction types we should consider when filtering this data?Additionally, we ha

Hi everybody !  By any chance, does anyone have the AR631000.rpx in the Generics Inquiry?We’d like to add the AR value to our dashboards with the age date set to a specific date. Thank you in advance,

We have created a GI and we are calculating values in the Results Grid to come up with a Percentage Complete.  Formula is (ActualAmount / RevisedAmount)*100.   This should give us a Percentage Result.However,  The Calculation results are inconsistent.For Example, the Actual Amount is 2400 and the Revised Amount is 4800.  The Percentage Result is coming back at 100.  It should be 50%.Another Example, The Actual Amount is 52716 and the Revised Amount is 138000.  The percentage Result is coming back as 76%  it should be 38%.But then in another line example the calculation is correct.  The Actual amount is 7992 and the Revised Amount is 14800 and the resulting percentage is 54% and this is correct.We can not figure out why this calculation is incorrect and inconsistent.here is the actual line in the results grid.=CInt(IIF([BudgetRevenue.CuryRevisedAmount]=0,0  , ([BudgetRevenue.CuryActualAmount])/[BudgetRevenue.CuryRevisedAmount]*100))

I upgraded my system from 25R1 to 25R2, and I have a snapshot of the old 25R1 system.In 25R1, on the Invoice and Memos screen, when I printed a report, it used the report ID from the Customer Class.Now, in the new version, it always uses the standard ‘AR641000’ and does not pick up any other report.I verified that my custom report ‘AR641001’ works correctly. It also works properly when printing from the SO Invoice screen.

I’m trying to condition a GI to only show shipments that were confirmed yesterday.Originally I was using ShipDate and was able to achieve this by using the following formula:SOShipment.ShipDate Equals =DateAdd(Today(), 'd', -1)But using the SOShipment.ConfirmedDateTime does not give me the same results (it actually gives me no results). 

Good day, I have Generic Inquiry that pulls data from Customer and Activities including email subject.  I have ten different Branches for the time being.  I am going to have more than 100 as some point.  I don’t want to create a different GI and then set them to the individual branch security roles.  The customer are set to Restrict Visibility for the customer account.  We don’t the Branch manager to see the other branch activities.  Any ideas?Thank you.Evam  

I am currently working on printing the Purchase Order in line sequence based on Sort Order instead of Line Number.I attempted to use POLine.SortOrder with ascending sorting in the report; however, the sorting does not appear to be working as expected.Could you please advise if there are any additional configurations required or if there are any limitations with using SortOrder for this purpose?Thank you in advance for your guidance. 

Hello,Curious if other folks are noticing the same issues with Acumatica Updates and Upgrades overwriting customized reports?  Historically, we haven’t had issues with this, but it appears in the newer updates and released that stock forms that have been previously tweaked/changed (i.e. the check form) are not printing correctly after updates?Thanks,Megan

Hello, I created this year over year variance report for qty sold of a stock item. As you will see in the screen shot below, the calculations in the QTY % VAR column are correct. However, the manager would like to see it as follows: Row 1 (for the 021 stock item) the % VAR shows -62.86 (round to 63). He would like to see it as 37% instead of -63%. Is there any way to accomplish this? Here is the formula used for the % VAR column: =IIf(     Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)) = 0,      0,      (Sum(IIf(Year([ARTran.TranDate]) = Year(Today()), [ARTran.Qty], 0)) - Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)))      /      Sum(IIf(Year([ARTran.TranDate]) = Year(Today()) - 1, [ARTran.Qty], 0)) )*100  

Anyone know how I can format date/time field in a GI to hide seconds? (e.g. 11:42 AM instead of 11:42:06 AM)I tried function shown below in the style column but it doesn’t change anything…  

Hello,We sale our items both singularly and in master packs. I have identified and converted the qty of EA into CS (master pack). I have created a custom label that prints out master pack barcodes but am having troubles in report designer for barcode selection. Each stock item has 2 barcodes, one with the UOM of EA and one with the UOM of CS. I want this report to only show CS barcodes, so I used a filter to only show barcodes that have a CS as a UOM, but it is not displaying any data with this filter. Any ideas how to display on the barcodes with CS as the UOM?  

Here are the relevant fields [ToDate] +1 logic doesn’t work on report designer ,Any workaround.

I am having issues with number alignment in the Data Tables Widgets when using Modern UI.  All columns appear to be left aligned.  Any suggestions?

Good day,See the attached GI.  I want to set up the Navigation to open the Subject/Email associated with the subject on the Customer Activity tabs.  (Trying to avoid having to open the Customer Profile).I can get the hyperlink on the field, but it does not open the email. See example.Any ideas?  I had to publish today but I want to add this feature so the user can review the Note on the generic inquiry.Thank you.  

Hi,I couldn’t find a complete guide on how to create a GI that used Audit History, so I wanted to share my success with creating one, in case it helps someone out there looking for something similar. Our business scenario is that we would like to create a report that lists all of the changes made to suppliers’ bank accounts as a control. To do this, we created a GI that listed all the changes made to the “Account Number” field within the “Payment” tab of the AP303000 form. Note: We already had the audit history functionality enabled for the field: To do this, a join was done on the AuditHistory table and AP.Vendor tables. Because the AuditHistory table only has the “CombinedKey” field as the Key, the join required filtering out the bAccountID (first 5 characters) from the Combined Key and joining it with bAccountID from the Vendor table: Note: If you added the CombinedKey field to the GI it would come up something like this:Which if you then looked at the Audit History screen, you’d be

 ​@lauraj46 Looking for assistance with placement of the attached sub-report within the main report so that all the fields line up within the main report. Still trying to navigate all the data fields accurately, so always welcome to better ideas. I could whip this out easier in even an older version of SSRS.

I am trying to create a GI that lists invoices that need to be printed or emailed to the customer.  The list should be any invoice that doesn’t have the printed or emailed or don’t email button checked.  Basically if any of those are true then it should be pulling them on the inquiry. As you can see below, its still pulling invoices where those columns are checked. It should only be pulling invoices where none of the 3 columns for printed, emailed or don’t email are checked. Its completely ignoring all of the conditions in the last paratheses.  Where am I going wrong with the logic/format on this?