Reports and Generic Inquires

I have created a generic inquiry to track the last time stock was counted (this is to identify items that have not recently been counted).  It works well until I activate the parameter for warehouse.  If the user captures a warehouse, the parameter value automatically becomes cleared after you capture it.  Has anybody experienced this before?  I’ve attached the generic inquiry.Version:  2024R1Build: 24.109.0016

I have a business event that gets fired off a GI and I'm running across a issue that the event won’t fire because it says the ScreenID for that particular GI is not available in the system monitor. I have re-created that GI and given it a different screenID but that GI still won’t fire.I have checked the sitemap to confirm that GI is showing up and it is. I can run that GI without any issues or the newly created one with zero issues and my results are displayed.Is this a bug in a older version of Acumatica or any other recommendations?ContextScreenId = GI992709ContextUserIdentity = adminCurrentCompany = CompanyNameEventID = Scheduler_SchedulerThrewExceptionEventIdSourceContext = SchedulerException =PX.Data.PXException: Error: This generic inquiry does not exist anymore.   at PX.Data.PXGenericInqGrph.PrepareCaches(String id, String name, Dictionary`2 parameters, Boolean fetchSchema)   at PX.Data.PXGenericInqGrph.CreateInstance(PXSiteMapNode node, Boolean fetchSchema, String prefix)   at

Hello experts, Does anyone know how I can have the GI defaulted to a specific tab programmatically when it is executed? I have a GI that I am running it through an action with some default parameters. The GI has a PivotTable on it called “Employee Activity by Day” displaying Employees in Rows and Days of the Week in Columns. I would like when GI is executed through the custom action, is defaulted to this Pivot Table instead of the granular time activity of the default result tab.How can I do that?​@Dmitrii Naumov 

Hello Acumatica Support Team,We are encountering an issue with inventory label printing misalignment when using DeviceHub to send print jobs to Zebra thermal printers. The labels are triggered from Acumatica during the inventory receiving process and are based on custom reports designed in Acumatica Report Designer.Label Specifications:We have created three custom reports with the following label sizes and formatting: Large Label: 3.00” x 4.00” Medium Label: 1.25” x 2.75” Small Label: 1.00” x 1.50” All layouts include spacing of 1/16” from the top and 1/8” from the bottom, with no left or right margins, to match our physical label stock and printing requirements.Issue Description: When previewed as PDF within Acumatica, the labels render correctly and align perfectly with the defined dimensions. However, when printed via DeviceHub to Zebra printers: The output is vertically misaligned (e.g., content printing too high or too low) There is noticeable deviation from expected

I am trying to create a printable report with  Service Contract information. I am specifically trying to filter the data in the FSContractPeriodDet table by CreatedScreenID. I am able to filter this data from EDIT REPORT after the report is open, but I can not get a filter to work for this directly in the report it’s self. The ScreenID I am trying to filter is FS.30.57.00. I am assuming there is a different ID value or something that is actually saved in the database and not the actuals ScreenID.Does anyone have any insight they can share?

Hi all - I'm only new here and to the product.  Just hoping I could get some assistance with this.We have several filters for different things in our Invoice/Memo and Bills/Adjustment areas.  Just wondering is there a way we can get a total to that filter - screenshot below.  Thanks heaps.  

I modified our Historical Inventory report to get average consumption data for a group of periods.I’m having trouble with getting the correct averages. Here are the formulas I’m concerned with:=Sum(IsNull([ItemHistCurr.FinBegQty], [ItemHistLast.FinYtdQty])) Not getting the correct ending quantity. (See “4148.000”) =Sum(([ItemHistCurr.FinPtdQtyIssued] + [ItemHistCurr.FinPtdQtySales] + [ItemHistCurr.FinPtdQtyAssemblyOut] + [ItemHistCurr.FinPtdQtyTransferOut]) / Count([INItemSiteHistByPeriod.FinPeriodID] )) Not getting the correct average (See “1,019.7143”) =Count([INItemSiteHistByPeriod.FinPeriodID] ) Not correctly counting the periods (See “20.00”)  In the header: number of periods, Average Consumption, and Ending Quantity is incorrect.  

I’m trying to group in a GI by Lot/Serial Number for Stock Items, however, there are a few items without a serial number, and these are all being grouped together, despite being different lines (this is not a issue on Inventory Valuation for some reason.) Is there some way to do a conditional grouping? I tried =iif([InCostStatus.LotSerialNbr] <> ' ', [InCostStatus.LotSerialNbr], null) but the grouping happens even if the field is blank. Is there some way to do this?

Hi people,we are looking for a condition that works for both sites, main site and portal. This condition would restrict the access on portal by the user linked to the PMProject when it is a guest account.Something like this: I couldn’t find why it does not work for both.I can only make it work for one at each time. Thanks

       Hello,  we previously were using ItemCustSalesHist table to run some reports. This table is very useful. It has the sum up data with Item and Customers by each period. So we don’t have to count from the ARTran to reduce perfermance issue.     I don’t understand why this table is obsolete in 2024R2 or even earlier version .Is there a replacement for it?   I Know there is a ItemSalesHist table, but we need to group or exclude some customers.  So I need some data form like customer ,item ,sales qty (already counted) , period, something like this.    Can anyone help?

Hello!I am trying to calculate Total Revenue and COGS in a Generic Inquiry. The goal is to match the values by financial period to the values on the P&L in financial reports. I looked at the source data for the P&L and saw that it’s summing the balance between 5000 and 5070 for COGS. My formula in the GI is: =IIf([Account.AccountCD] >= '5000' AND [Account.AccountCD] <= '5070', [GLHistory.CuryFinYtdBalance], 0). I am summing this field and grouping by financial period. I wasn’t getting the same Ending Balance Total (COGS) on my GI and P&L and found that it’s because my GI is missing two accounts: 5037 and 5060. Can anyone help me understand why the generic inquiry is not pulling all of the accounts between 5000 and 5070? I don’t have any conditions set that is preventing them from showing. Is it something in my formula? This issue happens to other financial periods too. The GI does not have 5037 and 5060P&L has 5037 and 5060I was able to use the below post to get s

Hello all,I am not able to figure out the expression to insert in report desginer to display the company’s logo in report.  

Need help building a GI which shows all items sold in a period of time to include the total amount of sales and need to be able to filter by Tax Category so I can items that are in our NOTTAXABLE Category. This wouldn’t just include Sales Orders as many of our NOTTAXABLE Items are labor. Would need to include Service Orders as well.

The below formula is currently working for me to display the [ARTran.Qty] for the last 365 days. Now I need to add a seperate column to my GI that displays [ARTran.Qty] for Year To Date in the Results Grid > Data Field. Any advise on how to achieve this? =Sum(IIf(DateDiff( 'd', [ARTran.TranDate], Today() )<=365,[ARTran.Qty] , 0)) Thanks in advance! 

Client has a business event triggered by schedule to run everyday (workdays Mon-Fri) to send email notification but doesn’t want to send it when it is a Holiday.  Is there a connection between Holiday list define under 'WORK CALENDAR' to 'Automation Schedule' function?

In the form of reverse Tax import from Bill. when select bill that usd currency but in current field of form it displays khr currency. please advise me how to make the currency from bill

Hello Acumatica Community,I am customizing the delivery note report (SO642000) in Report Designer, and I need to display the customer contact information from the related Sales Order (SO301000).To do this, I believe I need to join the SOOrder table to the SOShipment table, but I’m not sure how to properly set up this join in the report.Could someone please guide me on: How to join SOOrder to SOShipment in Report Designer? Which fields should be used to link them correctly? Any best practices for adding this kind of join? Thank you very much for your support!Best regards,Pantea  

Is there a way to adjust the metadata of a generic inquiry exposed via OData?  I have a simple customer balance inquiry that an external CRM system will use to get an account’s balance.  The friendly names of the parameters are “Company” and “Customer”, but the OData field names are “BranchID_2” and “Account”, respectively.  Also, the response includes fields that aren’t in the Results grid of the inquiry.  Why? Presumably because they are fields used in the joins and aggregation, but there’s no need for them to be in the response as it just adds clutter.  Thanks. 

Acumatica Generic Inquiries (GIs) allow for conditional formatting of rows, enabling users to highlight rows based on specific criteria. This feature enhances data visualization by visually distinguishing rows based on their data values. To implement conditional formatting in a Generic Inquiry:Navigate to the Generic Inquiry: Open the Generic Inquiry screen (SM208000) in Acumatica.  Select the Results Grid Tab: Go to the "Results Grid" tab, where you'll find the "Row Style" box.  Click the Pencil Icon: Click the pencil icon within the "Row Style" field to open the formula editor.  Enter the Formula: Write an IIF statement to define the condition for highlighting. The formula should evaluate a specific field and apply a style based on the outcome.  Specify Styles: Choose the desired style (e.g., color, font) for rows that meet the condition and optionally, a different style for rows that don't meet the condition.  Validate and Save: Click "Validate" to check the syntax of your formula. 

Hi Community!I have been receiving the below error message on a Generic Inquiry anytime I try moving fields, using column configuration, and using any filters.I tried troubleshooting by checking each relationship and making sure I am linking correctly. I do have a sub GI used in this Main one. Anytime I remove the relationship with the sub GI, there is no issue. But when I link it, the issue persists.Any ideas on how I should be joining these two tables?Here is how I joined my Sub GIKitComponentItem is my Sub GI​​​​​​These are my joins on the Sub GI:  Please let me know if you have any suggestions!! Thanks! 

Hi community,I’ve customized the Invoice and Memo, standard invoice report (ar641000.rpx) by adding a custom report that includes a subreport to display tax details like VAT name and amount. The subreport works correctly when I run it from the Parameters screen — VAT values and names display as expected.However, when printing the invoice through the Print action on the Invoice and Memo screen, the subreport shows 0.00 for tax amounts and 0 for VAT names.Could this be related to parameter passing or visibility of data when run from the main report?Any suggestions or best practices to ensure the subreport receives the correct tax data when printing through the screen.Thank you

We have a customized Sales order Invoice report that contains links to custom tables and subreports, etc.  The report has been used for a few years with no problems and previous to 24R2 upgrade (previously 23R2) a few months back, ran fine from the Process Invoices and Memos → Print Invoice action as well.  However, after the 24R2 upgrade, from the Process Invoices and memos screen, if user selects some number of multiple invoices, it does not print all of them.  In production the user has found that if they select <=5 invoices all will print.  If more than that they often get less invoices.  If I try to print the missing invoices manually - the report runs fine so not a report problem.  I don’t know that 5 is a magic number as in my local test system I got different results but still less were printing than selected.  If I reverted back to simpler/standard report with no subreports it seems to be OK.  But as I said, previous to 24R2 it all worked fine. Anyone encounter anything lik

Hello, I am trying to export account details for the whole year 2022 by a specific branch for all accounts. on the Account details inquiry (GL404000) we have to include an account, so I was trying to recreate the screen as a GI where we do not have to include an account. I can get all the information in the GI besides the Beg. Balance and the End. Balance, any suggestions on how to get that information?Data class: GLTranRData field: SignBegBalance Screenshot of Account details screen:Thank you,KT

Hi guys. I am working on a report design in acumatica report designer.If a field is empty, how do i ensure that the white space left open is eliminated so that whatever should have come after that field, appears in the place of that specific field?

Hi, can anyone help me ? $SubDPP=Format('{0:N2}',Round( Round([ARTran.CuryUnitPrice], 2)/1.11, 2 ))$SubTotalDPP = CDec( $SubDPP ) * [ARTran.Qty]I created a $SubTotalDPP variable in detailSection1, and I want to sum the variables in groupFooterSection1 =Sum( $SubTotalDPP ). and then when I run the report it always gives an invalid error Invalid field name $SubTotalDPP has been specified.