Reports and Generic Inquires

I am building this GI to get GP$. it seems like the formulas I am using is not giving me the accurate answer. Can someone please check formula to see if I have the right one. =IIf(    [ARTran.TranDate] >= '2025-01-01'    And [ARTran.TranDate] < '2026-01-01',    [ARTran.CuryTranAmt] - [ARTran.Cost],    0)

I have found the following Report Designer resources:Basic Help: https://help.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=e15a22db-126f-40f7-a362-e02a4ea7e4ad Acumatica Open University S150: https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/I can’t find documentation for things like:Behavior: CommonSettings: AlternativeEngine PrintAllPages ViewPdf MailSettings: ActivitySource ParentSource ProcessOrder ProcessUnbound RequestContext RequestParams

Hi everyone, Happy new year! I was hoping for an insight regarding setting up a default recipient in Mailnig & Printing tab specifically in Purchase Order preference.  This is how I set it up but email doesn’t seem to be sent. I was hoping to set this up as CC so I don’t have to update each vendor.Thanks so much in advance.  

So, I just build this GI. I want to show year to date for this year and last year.The formula for this year is working. The formula I have for this year is not working. Can I please get help if anyone has done this.This is my result now. 

When change date on datetime picker in report back to 2025 but calendar still display in 2026. In Acumatica 2025R2

Good Day how can one get the current detailed TB report to display budget columns next to each TB line? 

We are trying to clean up old vendors from our list vendor but do not have a way to identify the VENDOR status without having to drill down and open each one which is rather inefficient and not as useful as “VENDOR” status.  This may be to do a user before my time messing with the generic inquiry schema or is that how everyone’s vendor report appears. We do have MASS EDIT option SELECTED and can INACITIVE the VENDOR(s) accounts all at the same time once we have the VENDOR STATUS column available in the GENERIC INQUIRY.Does anyone know our VENDOR GENERIC INQUIRY would have a column for CUSTOMER STATUS rather than VENDOR STATUS?  The Vendor status also does not appear in the list of fields that can be selected to be visible in the report edit options.  . 

I’m trying to create a report that produces a excel sheet with cell borders. However, I can’t figure out how to get the borders to display in Excel. Is there a way to format the excel cells in Report Designer?

Hi All,Is it possible to add a line number as a field item and use it to format the output of the GI? For e.g., I have a GI that lists 10 rows but I had like to use the line number to change the background color of each alternate row, which is not based on any conditiion. Since, the Row Number is available only for display, how to get a row number for any GI (not a report)?Manish

Hello everybody,I have the following scenario:A set consists of two components: a certificate, a 20-item box, which can contain one or more lot/serial numbers. In the delivery note, the information should be displayed as follows: Line for the certificate Line for the item (20-item box) Below the item line, a list of all associated lot/serial numbers should appear – regardless of whether there is one or multiple lots. The lot/serial numbers come from the field:[SOShipLineSplit.LotSerialNbr]Problem:When I use a separate detail section for the lot/serial numbers in the report, Acumatica repeats the item line for each lot/serial number. This causes duplicate or multiple item lines, which

Hi All,    Is there anyone with you able to create a generic inquiry with the Relationship for SOOrder, CROpportunity, and AMEstimate. I am trying to create a generic inquiry where i can see what is the estimate cost, and the created SO Unit Price for per specific project.  Thanks 

Hello!I have a GI that I need to filter by date range. When running the GI it is not filtering down to the date range window. GI and Screenshots below. I feel like I’m missing something obvious.Thank you for the help!  

I wanted to share a setup I created to be able to use a list of IDs as a filter for GIs. It’s very flexible and can be used for Inventory IDs, Customer IDs, heck, anything, really. The general idea is to create a dedicated Import Scenario that does nothing except provide a place to load a list of records, and then join that list of records with the inquiry to act as a filter. The Data Provider and Import ScenarioCreate a simple data provider that has only one column. I find it convenient to name the tab ‘Data’ so that you can use exports from Acumatica fairly directly.Also helpful if you name the column ‘Inventory ID’ or the like if you intend to only use this for inventory items, again for export compatibility.Then create an empty Import Scenario which uses this provider. Publish it as

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,

I have build this GI. Everything is good. I just want to get the result in % between 1 and 100. Can someone help me please.this the formula im using=(  Sum(    IIf(      [ARInvoice.DocDate] >= '2025-01-01'      And [ARInvoice.DocDate] <  '2026-01-01',      [ARInvoice.CuryOrigDocAmt],      0    )  )  -  Sum(    IIf(      [ARInvoice.DocDate] >= '2024-01-01'      And [ARInvoice.DocDate] <  '2025-01-01',      [ARInvoice.CuryOrigDocAmt],      0    )  ))/NullIf(  Sum(    IIf(      [ARInvoice.DocDate] >= '2024-01-01'      And [ARInvoice.DocDate] <  '2025-01-01',      [ARInvoice.CuryOrigDocAmt],      0    )  ),0) * 100this is the result i am getting now 

Is there a way to have a “generic” attachment that goes out with every sales order or invoice?More specifically, we would like to include ACH and Wire information every time we send our customers a sales order or invoice. I would rather this be an attached document than in the body of the email. Is it possible to have a document that is always attached every time a sales order or invoice is sent?

I have created this report in GI. Everything looks good until I found out the grouping is not work well.   After I view the inquiry, I released that some of my price class did not group 

Hi everyone,I’m working on an Acumatica label report that uses a custom Numbers table (UsrNumbers) and a parameter (QtyOfLabels) to control how many labels print.I’m seeing very different behavior depending on where the report is executed, and I’m trying to understand what the correct pattern should be. Setup Parameter: QtyOfLabels (Integer) Custom Numbers table: UsrNumbers Relation (simplified): <RelationRow>   <ChildField>Number</ChildField>   <Condition>GreaterOrEqual</Condition>   <ParentField>=CInt([@QtyOfLabels])</ParentField> </RelationRow>   Behavior I’m seeing1. Acumatica UI (Report Preview / Print) If QtyOfL

I have grouped the report by Type. Now I need to calculate a value in a new column that depends on data from both Type records (e.g., Type = I and Type = E). The calculation should use values from both Types within the same group and display the result. Is this achievable in an Acumatica report?

for most of the dashboards I can not click create user copy. Where do I found that and active it for select users? 

Hi, I need some help with a report.We have a weekly report that is scheduled to be sent every week. We received it correctly throughout the month, but this week the report was generated with a Non-Production watermark.When I send the report manually, there is no watermark.Could you please advise what might cause the watermark to appear only in some cases? 

Hi there,I need to convert the total SO Line value into words (letter format). I have reviewed the links below and noticed that this does not appear to be a straightforward process and may require customization. I would like to double-check with you whether there is any standard or built-in way to achieve this in the latest releases, without requiring customization.Thank you in advance for your guidance.https://community.acumatica.com/develop-customizations-288/how-to-convert-amount-into-word-when-the-amount-is-more-than-ten-thousand-15933?tid=15933&fid=288https://blog.acumatica.com.sg/2017/09/amount-to-words-conversion-at-acumatica.htmlhttps://stackoverflow.com/questions/38320680/how-to-do-word-representation-of-amount-field-in-acumatica-invoice-report-ar-64https://community.acumatica.

I need to perform some additional calculations on the results of a pivot table. How might this be possible? The goal is to come up with a value that is this formula:SUM(Invoice Total) / COUNT (Number of Invoice RefNbr values) for a given customer & time period.I am struggling to produce this number because of the limitations I am finding within Generic Inquiries.Similar/Reference posts:  Does anyone know if this is possible? I also see that other people are attempting to to aggregate fun

We’re experiencing an intermittent printing issue when printing documents (invoices / reports) from Acumatica.After a paper jam or printer reconnect, Acumatica sends the job to the printer, but nothing actually prints.Windows shows the job briefly and then clears it without errors.What we’ve checked so far: Printer works fine outside Acumatica (Word, PDF, browser) Driver reinstalled and printer restarted Windows test print confirms the printer itself is responding correctly (a simple printer self-test helps confirm this) This seems more like a driver or Windows spooler state issue that Acumatica doesn’t recover from automatically after a hardware interruption.Has anyone seen Acumatica require a printer rebind, report refresh, or service restart after a printer error like this?Any best practi

Does anyone know what the limitations are when creating a pivot table from a generic inquiry in 2025R2? I’ve reviewed the help file on https://help.acumatica.com/ but it does not mention limitations.  It appears that I can make a pivot view from one of the Generic Inquiries that ships with Acumatica (eg BI-ARInvoices).But once I create my OWN Generic Inquiry, I can’t seem to get to the configuration screen after attempting to do the below steps. I wondered if the pivot wouldn’t work with a generic inquiry that had aggregate functions, so I removed the grouping and the COUNT and SUM functions from my query to get a more flat result set.Even doing that, after clicking Create (step 4 in the image) , the screen does not respon