Reports and Generic Inquires

Has anyone created a Summary Invoice for Projects. In contracts there is a drop down for Summary or Detailed Invoice. Anything similar in Projects

Hello - Is it possible to display notes from the Customer screen on a Generic Inquiry? I see it’s been added to one of our reports via =[Note.NoteText] but I cannot figure out how to recreate in a GI. I cannot find this CustomerMaster table in the GI screen:  

On our Shipment Confirmation form we provide our lot numbers on stock items but on a service or non-stock item I want to hide the Lot # field to not show that doesn’t have a lot code. See below. I tried using =IIF(StkItem = FALSE, FALSE,TRUE) in the text box visual expression behavior but it does not work. Can someone let me know if I need to add something to the schema to make this work? 

My Mass Update is greyed out in my GI regardless of the Entry Screen I set. I am using APTran and trying to mass update the 1099 Box form on all of them. When I go to select an entry screen, I only get Bills and Adjustments as the “PL” screen, not the actual entry screen. Using the PL screen still renders all my options as greyed out.  I assume I’m missing something obvious, so any help is greatly appreciated.

Hello Community,I have created a new GI and have a question on it.  It is pulling information how I wanted, but then noticed that it is missing information.  This is a copy of the Account Details report, but I added the Reason Code column.This is the report results:For the Reason Code column, the SCRAP result should continue down the report as it is all the same record.I have tried different relationship set ups, but the SCRAP is not coming through for the rest of the items.These are the relationships that I currently have set up:GLTranR left join to INTranGLTranR left join to GLTranGLTran left join to BatchAny ideas/feedback is welcome!Thank you,Trisha

Hi There,I’m looking for AP retainage report shows open retainage invoices as of historical cut off day. Ie.  Open retainage invoice as of Oct 31 2023. Thank you. 

Hello All,I have been trying to add the report logo in a sample report. i took the reference of the already created reports in Sales Demo, but my report doesn’t print the logo.    

How can I display the latest bill number for a particular vendor record in vendor GI?How can I display the total number of payments for the vendors for a particular year in vendor GI?And how can I display the sum of the spend made to the vendors in a particular year in vendor GI? Thanks in advance.

Hello, We’ve recently activated an additional processing node in our instance, but every generic inquiry I try to run shows this error if the results have more than 1000 records. I tried running the same GI’s in the original node, and they work just fine.The biggest reason we wanted to have this additional node was for running larger reports/GI’s and being able to export them without taking processing power away from the rest of the work. Any ideas why this is happening?   

hello all,I would like to know if there’s any report or GI in acumatica that would display the failed login attempts by users. I tried but didn’t find any. If its not there how can build up a GI for the same? Thanks in advance.

Community,I am writing a GI to show number of days between Production Date and Shipping Date.I am currently using this formula, and it is pulling in the information correctly.=CInt(DateDiff('d' ,[AMProdItem.ProdDate] , [SOOrder.RequestDate])) It is pulling in correctly with the results, but when I try the filter, it does not allow me to sort by greater/less than.This is the report results. I do not have any parameters set up, I do have a few conditions set, those are round what type of status to bring in.  What can I do to set it up so that the end user can sort that Date Difference column using the greater/less than function?Thank you,Trisha

Hello all,I have been looking how can I calculate the number of payments done by the customer in a GI?

We have a report that we want to highlight the last billed date if it is six months or older, but I’m having trouble getting the correct coding to make it happen. I know that I’ll have to have two overlapping fields, one visible for the highlighted dates, and one visible for the non-highlighted dates. For the highlighted dates, everything I’ve read has lead me to believe that =[ContractBillingSchedule.LastDate]>=Today(),'m',-6 should work, but it doesn’t. I’ve tried adding additional parenthesis, apostrophes, etc., but always get the same error: Syntax error in the expression. Context: TextBox 'textBox53' property 'VisibleExpr'  Any ideas? I’m sure it’s probably something simple that I’m missing. 

After the upgrade to Acumatica ERP 2023 R1, I cannot open or print a custom Check Form with Remittance (AP641000) form due to the “The report cannot be opened because it includes a table (ROUTINGNBR) or a field (AccountID) that does not exist” error message as shown in the following screenshot. 

I have added the header Notes to the body of our Project Invoices and that works fine.  However when the doc type is Credit Memo, the Notes get duplicated in the body of the printed form.  How do I fix this?  

All,I’m seeing the following error on our transaction labor report. The Opr Nbr field is throwing an Invalid field error:I checked in the Report Designer schema and everything appears to be linked/associated ok. Is there something obvious I’m missing? 

Hello all,I have been trying to add a parameter of the line level Note Text in a report. i would like to filter and display the results in the report based on the term entered in the Note Text field. So till now I have tried to add as follows:  So as an example: if any of the records has a note text entered as “record is accepted”So if I type “accepted” in the report parameter then the system should only display the records that have the text “accepted” entered.So as a result the report should display my record as “record is accepted” since it contains “accepted” in the string.Also to mention the parameter that I am trying to add is not getting displayed on the screen.How can I get this done? Thanks.

How can I display all the Line details in a report? I tried to following syntax, but it only displays the first line : Thanks in advance.Also I am looking to apply the PXFiltered Condition, so it is like if the line detail → Account column contains the word/number “200” then only it should display the line detail.

Hello! I’ve created a business event to send out an email with an attached form (AP payment remittance) whenever it is triggered (or payment is issued). I’ve created this same exact event and form in another tenant and it works perfectly! However for some reason in this one, it will send the email and form, but the fields appears blank. I’ve tried recreating the event and form several times and nothing seems to be working. Does anyone have any idea how to fix this?  

Is there a way for Report Designer do a proper validation for sub report variables?The Expression Editor always returns this error when validating a Sub report variable, even when the syntax is correct:The variable returns the expected value without any issues when you run the report.Knowing that this is a false check, we are just very careful with the variable syntax in both the main report and the sub-report.Thanks   

Hello team,I would like to know if it's possible to set a default value for a Generic Inquiry Parameter. Specifically, I want the parameter to pull financial periods from the prior period.For instance, if I am logged in with a System Login Date of 1/9/2024, the Period parameter currently defaults to 01-2024 when I open the inquiry. However, I would like it to default to 12-2023 (December 2023)Regards,Sagar

Hello, I have a report created to track changes made to vendor profiles. Then I’ve also setup an automation schedule, business event trigger, and email template that will send out an email once a day with all changes to vendor profiles from the previous day. The email gets sent out only when changes were actually made the previous day, which is fine. However, the issue I’m still facing is that when using the HTML embedded format for the email, it only shows the top 3 lines from the report. I’ll share the schedule and business event here. The report also is created from the following generic inquiry.  Does anyone know why it won’t show all the record changes?  Thanks!

HI, I added a parameter to a GI. I want to use that parameter in the filters that create a tab via the funnel. I do not see how to do that. The case is that we have a GI to show SO type transfers. The parameter is for warehouse. The condition uses the parameter to display the order if either the Destination Site ID or the Default Site ID. I want to create tabs for the To warehouse & the From warehouse. Thanks in Advance.

Hey Community!I would like to make a GI available to our portal users, as the standard screens offer hardly any possibilities for dashboards and these queries should serve as a basis for KPIs.For example, I would like to build a GI for the cases. However, all tickets of all users are always provided there. However, the users should of course see the data records that affect ther Business Account.In the conditions, I have tried different variants, for example with Contact.BAccountID and CRCase.CustomerID. However, without success. Do you have any tips?Thank you very much!

Sales Order Quote Report  Print-Quote-Form: Screen ID SO641000