Reports and Generic Inquires

I am having trouble moving GI Condition rows using the “Move Row Up” and “Move Row Down” buttons. When I select a row and click the “Move Row Up” button nothing happens. In my screenshot below, the only way I can “move” the row at the bottom up to the second row is to delete all 17 intervening rows and then manually add them all back below the new row. I don't have an option to import criteria either, which would be useful here.Is this really the only way to “insert” a GI condition somewhere other than the bottom row?Can’t Edit GI Criteria Row Order Thank you!

We redesigned the PO641000 form and are able to print from Printed forms, but not from the actual Purchase Order on Screen PO301000.  We are using 2025 R1 which has still the classic UI.  Just went down an AI wormhole and still could not get a solution. All tips greatly appreciated.  

Hi All,I am trying to get OpenOrderQty to show on a GI that is based on Purchase Receipts screen. I have linked POReceipt to POReceiptLine as per DAC Table, however the value for OpenOrder QTY does not show up.If someone can let me know what is missing in order to make this work, it would be wonderful.Kind regards,Calvin Law

Hey Guys,I need a little help, i have a back order report im pretty sure i found on here. ive made some changes, but i’d really like to show the expected dates for the items. Im having trouble relating tables todo so. Is it as simple as adding PO.POrder to the table then adding a relation? the relations confuse me.  

Hi all, I am looking for a way to merge all the attachments for the transactions (for e.g., and AP Bill) showing up on AP Edit Detailed report into a PDF and link it on the same report against respective transactions. Please let me know if you have any suggestions/ alternatives for this. Appreciate your time!

Hello all, I wanted to share a tip that threw me of course today. If you use an attribute field in a formula in a Generic Inquiry which is aggregated at all, this will throw an error similar to this: To overcome this, you should add an Inner Join to the table which holds the attribute with the following data field links (in this case I will use Inventory Item as the example): The NoteID link ensures that the right record is selected, and the AttributeID link ensures that the right attribute value is selected. In your results grid, instead of this: You should use this:  Once you had switched out those values you will be able to load your GI:   Happy GI Building!

I have a Generic Inquiry that was created from scratch. It is published to the UI & it is exposed over Odata.  It is a combination of 3 source tables.  PX.Objects.CT.Contract; PX.Objects.PM.PMForecast and PX.Objects.PM.PMForecast details.Within Acumatica itself this rendering as I want. The results grid shows each column with the desired custom captions.  This all appears to be working as desired.If I try to connect to this OData feed via Excel\PowerQuery via OData there are issues when I try to navigate to the actual result of the GI.Specifically the Custom Column that I created as a concatenation of two columns doesn’t appear to be in the dataset and there is at least one column not currently in the definition of the GI that IS showing up.  I *think* that this was the previous iteration of the GI as I was working on it.  My question is that after “saving” the GI with the desired updates, do I need to re-publish to the UI to have my changes visible on the OData feed?  

Hello, I currently have a GI set up to display an amount with a decimal that is two digits in so we can display it as 1111.00. Does anyone have any tricks for getting the value to add commas in after the hundredths place? Below is my current config.=iif([ComplianceDocument.LienWaiverAmount]=null,'-',left(cstr([ComplianceDocument.LienWaiverAmount]),instr(cstr([ComplianceDocument.LienWaiverAmount]),'.')+2)) Thank you,Justin Long 

Hi Everyone,How to customize the Report Definitions screen to add the fields under the Default Data Source Settings for the PM Type.  

Can we create a GI directly from a report. I want to make changes in the report and it is very hard with the report designer to do that. 

Hi all,I want my customer statement does not include transaction with prepayment type. I have created a parameter doctype and filter conditions type does not equal ‘PPM’ but it does not work. Thanks in advanced.

Recently we have discovered a couple of automation schedules that use the new Email Notifications functionality on the report screen have stopped sending the emails in the last week.  they were working previously.  The automation schedule history shows that the schedule fired and was successful.  The attached report in question does not have any parameters, and runs without errors when run separately.  The email addresses are hard coded into the Email Template.  There is no record of the email on the All Emails screen.Has anyone else seen this issue?Thanks,Laura

Hello, is there a way to prevent duplicated quantities and amounts for items that are shipped and invoiced multiple times? This is for a single sales order that is invoiced multiple times due to split deliveries. 

I created two subqueries.  One totals the sales booked by order date and the other totals the invoices billed by doc date.  When I add the two subqueries to the main query and try to filter on a date range I get the object reference error.Booked QueryInvoiced QueryBoth are grouping by date, the formula is makes the amount negative if a CM.ConditionsMain left joins invoiced query to booked query by date.Without the conditions the data is returned 

I am trying to create a dashboard widget for unassigned opportunities from the Opportunities generic inquiry.The filter would be:    Opportunities having a status of open or new    Owner ID is empty.However when creating this filter, there is no option under the Ownder ID for ‘Is Empty’. Nether is there one for assignment date. Whe creating a chart using the AI Assistant on the above criteria, I see on the filter for the widget, the filter shows as follows:How does one replicate this on a widget such as the one I have tried to create form a dsshboard?

HI, I have created a business event that I want to archive every BOM but the latest one. Can any one give insight as to what the trigger conditions should be? My GI work fine and so does the import scenario, the Business Event is not firing. I also do not want it to archive the newest BOM such as A.  

In a Sales Order, add the linked Purchase Order in the Sales Order line for each SO line item.  (SOline.PurchaseOrderNbr). If the PO Nbr was added in the SOLine DAC, you could have a Sales Order Generic Inquiry that listed Sales Orders with the associated PO for each line item in the Sales Order, thus enableing you to quickly check on Purchase Order when a customer calls to inquiry about a Sales Orders. Often, a Sales Order is assoicated with more than one Purchase Order and you would have the ability to display the associated PO with each line item on the SO.  

Hello all,I have been looking for way as to how we can setup an automation on the Project Cost report (PM633020) where the requirement is that the report should be mailed out on 1st of every month, however the report should have the data for previous month.So for instance, if a report is auto mailed on 1st of March, it should have the records from 1st Feb - 28th of Feb. Is this possible in the above mentioned report?, As i could only see the parameter for Project ID. Regards,Harshita.

We just converted to Acumatica 25R2 and some of our Generic Inquiries are failing with error: Conversion failed when converting date and/or time from character stringAn example GI is set to use the following parameters and condition based on those : ParametersConditionsEV1STINVDT is defined as a DateTime in the Attributes:Attribute DefinitionIf I click From Schema I can choose dates as usual and it filters by them.  If I add the field itself to the Results when I click on the heading to filter there it gives me the expected Date range selections.It seems for some reason it is not being recognised as a date for only the conditions section when using parameters based on the attribute field. This worked fine before the upgrade.  Is there any way to get these working again? I have tried all I can think of but there seems no way for me to resolve this. Thanks for any advice/help, Phil

Hi all,I’d love to be able to see a widget or GI column that displays historical info about our customers. Specifically, I’d like to see the last time that a Customer’s status was “Credit Hold” and a count of how many times they’ve been on Credit Hold. I can’t seem to crack this. I know how to enable field level audit history, and I know the field is Customer.Status. However, I can’t figure out how to display the audit history of this field per customer without digging into the audit history page. Thanks in advance,Nathan

It seems that the attributes I’ve created are not listed in the Schema and Data field drop down list when selecting a field to do a Group by in the Grouping tab.  We’re able to pull in the attribute field to the Results Grid, but just not the Grouping tab. I also tried hardcoding that field name in there but got an error.   

Hello everyone,I’m trying to find the best and most performant way to get the average purchase price for an inventory item from a specific vendor, based on a user-defined time frame (last 3 months, last 12 months, or all time).For the last purchase price, it’s easy — the value is already stored on POVendorInventory.But I need the average price from actual purchases, not just the last one.Supporting a custom date range is my main requirement. An all-time average is not strictly necessary, but would be nice to have — and I want to make sure the query still performs well even if that option is included.Thanks a lot for your help!

Hello community,I recently came across two issues that I ended up spending some times on it and one of them resulted in a bug fix to be developed so I would like to share so others won’t pull their hair out. Special thanks to ​@Dmitrii Naumov for helping me out.When you create GI (GI X) from other GIs (GI A, ...), if you come to see random errors that some fields do not exist, check the the source GIs (A,B ...) and ensure no unused table exist in those GIs under the sources tab. Acumatica will develop a fix but no ETA. You might have come across this need requiering hierarchical parameters. i.e when you select a Project as first parameter you want to limit the tasks to the selected project as the first parameter not all tasks from all projects. To do so utilize the Schema Field of the parameter and instead of selecting schema from different tables (i.e selecting Project from PMProject and Task from PMTask) use a single table that has those dependent fields together. For instance in thi

Quick Search in GI looses results when you go into a record an then exit back out.  We are using 25 R2.  We have noticed this on miultiple screens.you have to renenter or change the search criteria to get the results back.  Has anyone else noticed this?

Hi Team,I’m facing an issue with the Customer Statement report while using an Automation Scheduler and would appreciate your help.I have created an Automation Schedule to send the Customer Statement report for a single customer via an Email Template. The overall flow is working fine — the email is triggered and the report is attached successfully.However, I’m facing an issue with the Statement Date parameter:When I manually pass the date in the format 10/04/2026, the report generates correctly with data. But when I use dynamic values like @Today or select Statement Date from schema, the report is generated as blank (no data).It seems like the parameter is not being resolved correctly when using dynamic values.Could anyone please help with:Why dynamic parameters (like @Today or schema fields) are not working in this case? Any specific format or configuration required for Statement Date in Automation Schedules or Email Templates? Steps to fix or best practices to handle this scenari0 Tha