Reports and Generic Inquires

=IIf([Customer.AcctCD] = 'A123', 'John Smith', [ShippingContact.Salutation])All, we’ve had an issue bugging us for over a year. Long story short -- for customer ‘A123’, we have contact ‘Jane Doe’ appearing as the shipping contact on the invoices. Jane Doe left A123 years ago but still appears on the invoices. I’ve hunted her down in contacts, leads, business/customer accounts, shipping tabs etc and can not find a trace of her.So I’m trying to “hard code” our invoice -- if Customer = A123, then display value is John Smith (the correct contact); otherwise, just use the usual [ShippingContact.Salutation].This works for A123 invoices… John Smith now appears! Great!Now the issue is all non-A123 invoices leaves a <blank> Shipping Contact. :/Do I need to use a visible expression instead? 

I was hoping I could pick your brain about modifying a Generic Inquiry where the results can be grouped together based on a specific string or text pattern. For example, values such as “COMPANY1”, “COMPANY2”, and “COMPANYABC” would be grouped under “COMPANY,” while “SELLERA” and “SELLERB” would be grouped under “SELLER.” I was hoping to manipulate it in the Group By tab but was getting an error: Operand data type datetime is invalid for sum operator. 

Thank you for the follow-ups!  To help clarify the issues we are facing, We are running Acumatica 2025 R1 Build 25.101.0153.9.We are a construction company building a weekly cash position report by project. For Cash Received we want to include: 1. Payments applied to invoices (progress billing collections) 2. Unapplied payments such as owner deposits and advance payments 3. Retainage releases when collectedWe do NOT want credit memos or write-offs — only actual cash receipts.Based on this, should we use Inner or Left join between ARPayment and ARAdjust? And should ARPayment be the parent table as shown by Dipak?Also — we previously had a fan trap problem where amounts were multiplying incorrectly across joins. Is there anything in the join structure we should watch for to prevent duplicate amounts?

Hey, Gang - recently noticed for a customer that when the invoice report AR641000 goes out for Credit and Debit Memos, the report doesn’t display any values.  It displays just fine when I attempt to print it from the Invoices and Memos screen.  Issue is at the email.  Not sure what’s going on here.  I’ve attached the report and Email Template.  Any thoughts would be greatly appreciated.  

I am building a Generic Inquiry in Acumatica 25R1 to show actual cash received by project. I need to join ARPayment to PMProject. AR Payments do not have a Project ID field. I tried joining through ARInvoice and ARAdjust but fields AdjgRefNbr and AdjgDocType on ARAdjust return 'could not be bound' error in the GI even though they appear in the field dropdown. What is the correct way to get actual AR payment amounts by project in a 25R1 Generic Inquiry? We have retainage and partial payments so invoice amounts are not acceptable.This is for a construction company weekly cash position report by project. We need actual AR payments collected not invoice amounts due to retainage holdbacks and discounts. Cash paid out includes AP checks, ACH  and payroll.

We have built a dashboard whose data source is the InitemsalesHist table. It queries the sales data of the latest 24 periods and presents it with a line chart.I know we can manually adjust the start period every month. But is it possible to realize automatic monthly adjustment without any manual intervention? For instance, even half a year later, it can still show the data of the latest 24 periods at that time.

"In Acumatica 25R1 Generic Inquiry, what are the correct join fields between ARAdjust and ARPayment tables? Trying to link payments to invoices by project. AdjgRefNbr is not binding."

"In 25R1 how do I get Cash Received by Project in a GI? AR Payments have no Project ID field. Do I join through ARInvoice?"

"In Acumatica 25R1 Generic Inquiry, where do I set SUM aggregate for dollar fields? My Grouping tab only shows Active and Data Field columns."

Hi  I am looking for a suggestion to include backorder items in the shipment confirmation report, Any suggestions?

When I click a particular Payment on the Checks and Payments screen, then go to the AP Payment Register report, then click the Send button, I would like to have a simple email template which populates data from the AP Payment Register report. Specifically, I would like to use the Vendor Name and Email Address and the Amount. I would also like the User’s Name in the email signature.I have tried two things.I created an email template based on the Checks and Payments screen and specified that in the AP Payment Register Report Designer. But none of the Data Fields I select in the email template work. The AP Payment Register Report screen does not appear to be available for the basis of an email template. Next, I scrapped the email template idea and tried to enter the email in the Report Designer Mail Settings fields. The problems here include not finding the Vendor Email Address and not being able to create the email Body with the line breaks and formatting desired.The email template optio

Been struggling for a couple days to create a GI to extract Cash Receipts and Cash payments for projects.  Question is:"In Acumatica 25R1   I am building a Generic Inquiry joining PMProject, ARPayment, APPayment, PMTran and PRPayment. Getting error: Conversion failed when converting nvarchar value 'X' to data type int. Join is PMProject.ContractCD = ARPayment.ContractCD. What is the correct join field?"

We have recently upgraded from 2024 R2 to 2025 R2. Users reported that the same Dashboard loads much faster than before. Is this due to actual optimizations made to the underlying platform mechanism?

Hi All,I am currently setting up a QR code that can link directly to a Fixed Asset ID.At the moment, the QR code works when I use the fixed screen link only, and I can access the FA screen successfully. However, when I concatenate the FA ID field into the link, the QR code no longer works.Could you please advise if there is any specific configuration required for this? I would like to know if I am missing any setup or if the link format needs to be adjusted.It works with the screen link only, but it does not work after I add the FA ID field.Thank you.

Hello all,I have been trying to create a GI that will display the list of the customers whoes Customer class has an AttributeX added.How can I do so? I’m getting a bit confused in here as I tried to use AttributeX contains CustomerClass ID under Relations tab but no use.

Hello all,How can I define sorting conditions for cost codes with segments. I tried to define as:    Still no impact.

Hi All,I need some help with regards to bringing the amounts from a proforma Invoice to a main report.I have attached the zip file for the main report(PM652500.rpx) and the subreport. (PM652500CI.rpx)I have the below parameters on the main report.   Below is the external parameter for the sub report.   Parameters on the subreport   My problem is, I can’t figure out how to populate the amounts for [PMProformaLineWithPrevious.CuryLineTotal] on the main report which on the below column. 

Our management wants to display a metric on the Dashboard that identifies customers whose purchase frequency has dropped over the last month, compared to their regular historical buying pattern.For example:Customer A normally places 3 orders per week, but only placed 1 order weekly recently Customer B normally orders once every two weeks, but has made no purchase in the past two weeksWe need to flag these customers for sales team follow‑up to prevent customer churn. Could you advise how to build this logic via Acumatica Inquiry?

We need to flag inventory items that fail to hit our expected monthly sales growth targets, by comparing current‑month sales against the same month’s sales from the previous year.For example: Item A sold 100 units in May last year, with a predefined 2% sales growth target. If it sells fewer than 102 units in May this year, this item should be listed out for review.Is this logic achievable within Acumatica Generic Inquiry? If so, could you share the approach or required data sources to implement this YoY sales growth comparison?

Hi Team,I created the tables as shown in the screenshot for the Expenses Paid AP report and am currently trying to fetch the vendor details, specifically AcctCD and AcctName.I tried multiple possible approaches, including adding APTran, Vendor, and PMTran tables, but still no luck. I’m running into issues such as: Missing records Duplicate records Incorrect IDs being picked even after applying grouping It seems the joins/grouping logic is not returning consistent results for the vendor details. Could you please help review the approach or suggest the best way to retrieve the correct vendor information without duplication or mismatched IDs?Thanks! 

Im sure this has been asked, but I can not find it.  I need to know where to allocate material for production orders.  We are running into issues where not all materials are in for all orders, but enough is in for some.  and the production floor doesn’t know what they can and cant fill, then material gets pulled for orders that are not components complete.  example we have 1 product for 5 orders.1,2,3,4,5  we have everything for orders 2 and 5, and I want to allocate that material to those production orders. thanks!

Good morning,We are finding that when clicking on the  calendar / Year in our various Report Designer reports, the list of year values is now limited.  The first year in the list is after our go-live, so to see a wide open date range, we need to key in the value, instead of using the calendar view like below to switch to a year in the teens..Did something change recently that would limit the years in some way?  Can this be configured in our setup to extend the range?Thanks!  

How can I automatically print the invoice report so that it will be attached to the Activities section and automatically sent via email? Is it possible to make this work by simply clicking the Release button?

Is it possible to use HTML (or style sheets/CSS) to add a more robust e-mail signature at the end of an e-mail template in a report - either the code in the report itself or in an e-mail template in the system. Client is wishing to add their logo and formatting to an e-mail that is sent out with an invoice. Thank you in advance.

We are exploring a concept —  help us get it right!Acumatica Platform team is looking into ways to give non-admin users the ability to build their own GIs and Reports, while administrators control which data they can access. For example, a finance analyst building expense reports without ever seeing what employees are paid.We would love to hear your thoughts by commenting below to help us understand what level of control matters to your organization and why. Question 1: Review the two Mockups below and Provide your answers in commentsIf a user should not have access to Payroll data (for example), what should their GI and Report Designer experience look like?Option A: Payroll DACs are completely hidden. Users only see the DACs they have access to.Option AOption B: Payroll DACs are visible and can be used to build GIs and Reports, but no data is returned at preview or runtime. Option B  Question 2: Select a Poll answer below