Reports and Generic Inquires

Hi, I am getting duplicates when printing a credit memo. What’s weird is it not happening to all credit memos and invoices. Only happens to some of them. I’ve attached the report file. Thanks for your help!  

Hi all,I have a simple report that has a parameter date range, StartDate (defaults to @MonthStart) and EndDate (defaults to @Today). This reports sums the total of orders for that range:=sum([ARTran.NetSalesAmount])The filter is a simple range like this:(ARTran.TranDate >= @StartDate and ARTran.TranDate <= @EndDate)But now I’ve been tasked to turn this into a 6 year range… essentially, A-F date ranges.I thought I could use something like this for the other ranges to pull the numbers:=Sum( IIf( [ARTran.TranDate] >= DateAdd(@StartDate, 'y', -1) AND [ARTran.TranDate] <= DateAdd(@EndDate, 'y', -1), [ARTran.NetSalesAmount], 0 ))But nothing pulls… and I realized it’s because my primary filter is still set to >=@StartDate and <=@EndDate.At this point I’m just confused. I’d prefer to just have one data range parameter and then base the other 5 off the primary (-1 year, -2 year, etc). But it might be simpler to just have 6 date range parameters and wire that up (

Has anyone else noticed this new limitation in 26R1?  I can’t have a local copy of Acumatica ERP and Acumatica Tools installed on the same computer?  Does anyone know why this limitation has been introduced?  As a partner and consultant, the need to have both installed locally is important for multiple reasons. 

Our Item Class has two levels, for example: 01-01, 01-02... 10-01, 10-02, 10-03... 90-01, 90-02.In reality, there are spaces in the value, the actual format is like 01 -01, 01 -02, etc.In the Report Designer, I want to group data by the main Item Class. I used this expression in the Group settings:=Left(Trim([InventoryItem.ItemClassID]), 2)Strangely, most Item Classes are grouped correctly, but 01-01 and 01-02 are still split into two separate groups.Moreover, I tested the condition Left(Trim([InventoryItem.ItemClassID]), 2)='01' and it returns True for both records, which is very odd.What is the cause of this issue? Or if I need to group by the main class, what other methods can I try?

Hello,I was tasked with creating a DSO inquiry for us to use. After building one myself (see XML attached) I found one our VAR created (also attached). Here’s where i came across a few issues.Mine is built off of invoices and memos from the ARInvoice module. To get this to line up the same as how the VAR lined up theirs I had to group and SUM all of my invoices. All numbers line up except for 04-2026 invoices. I assume those will match up once we close out the period since all past period match exactly. (i verified these numbers by going to the AR module and filtering by only Invoices or credit memos and matching total at bottom of page)None of then numbers on the one that the VAR created match the one I created nor do they match what the AR module says when i filter down the types. Their DSO equation also seems to be broken beyond my knowledge to repair. That or it’s missing something or seeing a zero i don’t in order to pull in a NULL value. I’d like to get some more smarter eyes on

Hello! I created a business event to trigger based on record inserted into a generic inquiry. The goal is to notify case owners when there is a comment submitted on the customer portal. The generic inquiry is only showing customer portal comments, so ideally when a record is inserted, then the business event would fire and send an email. Currently the GI is working as I see new records being inserted each time a new comment is submitted from the portal. But when I look in the business event history, nothing has fired, there is no history… The GI is also published to all user roles. And the email used in the subscriber is an active working email. Any idea why this is happening? 

I have an Appointment GI that I am wanting to show the Date  + Time in the results.  If I add the field directly to the results grid it only shows a Date.  If I do: =[FSAppointment.CreatedDateTime], it does show the Date and Time in the GI but in UTC.  Is there a standard way to show the time in a GI for this field or am I required to do the dateadd feature to adjust. ThanksChris Lower

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…