Reports and Generic Inquires

Hi all,Is there a way for us to edit or remove additional sort and filter values in the report screen via a customization?my goal is to add a filter to the list of values shown under the value selector based on Organization ID. im unable to find where this is originated from any help would be greatly appreciated.Thank You.r.manathungage@e-analytics.com

Good day CommunityI have modified the Journal Transactions GL report in Report Writer to display the VAT code for AR, AT or CA batches. This formula needed to be changed after the upgrade to 2026 R1 t dislay correctly. Old firmula is commented out in the below.=Switch( [GLTran.Module] = 'AP', [APTax.TaxID], [GLTran.Module] = 'AR', [ARTax.TaxID],[GLTran.Module] = 'CA', [CATax.TaxID],([GLTran.Module] <> 'AP' or [GLTran.Module] <> 'AR' or [GLTran.Module] <> 'CA'),'CheckModule')/*IIf([GLTran.Module] = 'AP', [APTran.TaxID], IIf([GLTran.Module] = 'AR', [ARTran.TaxID], ''))*/This appeared to work perfectly but we have discovered that it is dropping the VAT Code from some lines in the report.  Please can you check to see if the formula is correct (is asses validation) and why some of these transactions are missing the VAT code on the report.Many thanks on advance.

Hi, I have a problem when using the Acumatica 2024 R2 version, in the old version of the Acumatica report when I search inventory by typing, all inventory lists come out, but in the 2024 R2 version it doesn't come out, so I have to click the search icon first so that all typed lists appear. in the view name parameter report I use Report.GetFieldSchema('INTran.InventoryID')  

Is there a way to refresh the cache for a particular GI?  I’m noticing that the IN-StockItem GI used in the Stock Item view (IN2025PL screen ID)  is showing an invalid Brand name (doesn’t match the Brand Name attribute on the actual item page): 

How can I get value from EPEmployee for POOrder? I tried to join them by EmployeeID for POOrder and AcctCD for EPEmployee but got error that EmployeeID does not exist in POOrder. How should I join them?

Hi, I was wondering if there is any report or GI (custom) that can display for all transactions:The net amount of the payment (excluding GST) The GST amount in the payment The details of the payment (ie supplier/client name, transaction description etc) What GL account the transaction was coded to Some way to be able to drill into the transaction if needed, whether that be a link in the report or at the very least a transaction number or similar that I can then go and look up in the relevant area to get more detailThe idea here is to be able to review whether GST has been claimed correctly.  For example, I can look at all transactions in the “Donations” expense account and confirm straight away that no GST has been claimed on any of those, and then I can look at all transactions in the “Software Charges” expense account and confirm straight away that they all have GST claimed on them.  Example of what the report should display (see the yellow highlighted section). You can see straight

Hi there everyone,We recently upgraded to 26R1. When using the Inventory summary screen, we noticed that double clicking one of the lines does not always apply the correct filters when sending us to the Inventory Allocation Details screen. Typically when doubly clicking a line in Inventory Summary it will send us to Inventory Allocation Details with the filter for the Warehouse and Location already matching that of the line we clicked on.  Now however, majority of the time it will instead only send the filter results for whatever row was at the top of the Inventory Summary results.  Once in a blue moon it will apply the right filter settings, but typically it does not. Has anybody else experienced this?

Not sure if I am allow to ask this here, but does anybody have an original/slightly modified customer statement report that they would be willing to share?We had a firm do some work for us because we wanted an accompanying copy of all invoices included in the statement report, but now we have lost the ability to show a summary. The automation process for generating and emailing these statements yields a mess of a “statement” and then the invoices. Rather than pay money to have them fix it, I think I would rather have something at least similar to Acumatica’s out of the box report and try to embed the invoices myself. Any other advice would be appreciated!

I was hoping to add the ability to filter by SOLine.InventoryID_description in the Sales Order Details by Customer report, but for the life of me i can’t get this field as an option. Following what online tips i could find I added this field to the Viewer Fields in the schema browser. Then I also placed it in the groupDetails section on the report itself at another recommendation. Every other writeup i can find is either putting it in as a parameter or a sorting option, neither of which is what im looking for.End result, our staff wants to be able to sort this report by keywords in the item description. Sales Order Details by Inventory Item doesnt work for us in this case because its layout is item-first instead of customer-first.I have my fingers crossed this is something simple im just not seeing as i don’t spend alot of time in report designer.

I am effectively trying to match strings with an IIF statement to create an ‘substitution list’ with a GI. =IIF(InStr([ATTR_USES.Value], 'Hiking')>=0, 'Outdoor', IIF(InStr([ATTR_USES.Value], 'Athletic')>=0, 'Athletic', 'Casual'))Issue is that it italways provides incorrect resultsAs you can see above, when I join on CSAnswers I don’t get the raw values back?  Looking for answers on both. thanks! 

Hello Community, I created a new custom report to display payment details. The report runs correctly from the Report screen when I provide the parameters DocType and RefNbr of the payment.To automate this after releasing a payment, I created a Business Event and added an Email Template subscriber. In the Email Templates screen, I attached my custom report with the parameters defined.However, when the Business Event triggers and sends the email, the attached report is always blank. I have tried both enabling and disabling the “Use Event as Data Source” option, but the result is the same.Steps to Reproduce: Create a custom report that takes DocType and RefNbr as parameters (works fine when run directly). Create a Business Event triggered after releasing a payment. Add an Email Template as a subscriber. Attach the custom report in the Email Template with required parameters. Trigger the event → The email is sent but the attached report is blank. Is there anything I need to change

 We have a requirement to provide users access to financial reports only for the subaccounts they are authorized to view. How can this be achieved? I have already tried using restriction groups. But seems it doesn’t restric users by viewing the other subaccounts.

We have a regular business need for barcode images (JPGs) of arbitrary lists of items for use on promotional and other sales materials. It could be up to a thousand items so the ability to mass-process is a must. It seemed silly to me to license additional software just for this when we already are printing barcodes internally on reports like the pick list. So I devised a report which gets as close as can be - it still relies on external software like Adobe Acrobat Pro or PDF24 to convert the PDF into images. It uses some clever page setup and join tricks, so I thought I’d share. Piece 1: Page SetupExported PDFs don’t have individual images embedded and the images don’t export to Excel. The PDF → Image converters can split the document by page, so the goal is to have one barcode per page. A page break after the detail section easily accomplishes this. To save on further processing, I also wanted the page to be exactly what was needed for our materials, that being just a thin strip of b

 I am currently building a Generic Inquiry to identify valid Purchase Receipts that require an AP Bill. The logic is that if a receipt has no corresponding AP Bill, it should then check whether there is a related Purchase Return; otherwise, it is considered valid and requires an AP Bill but I seem to be getting a duplicate. Any insight as to how to make it efficient? Sharing my GI. Thank you for your time in looking.  

Hello all,I’ve created a GI on a tenant with the Modern UI, and I’ve created a pivot.How can I transfer the GI and pivot to another tenant?I’ve tried: Customization Package - just packs the GI without the pivot. Export the GI to XML - again, doesn’t pack the pivot. Looked at the GI code - can’t see anything about a pivot view.I don’t understand, you can pack a filter into a customization but you cannot pack a pivot view. Thanks,Ewan.  

If you are in the prepare replenishment screen a line item will not show up as Qty on Supply if an SO is linked to a PO for that item.In my case I link SO transfers to PO’s for all or some of items I know will have to be shipped to our satellite offices once it comes in. The problem comes in if you were to check the Prepare Replenishment after that, it does not show any of that item as Qty on Supply or at least until the SO is posted.To me it seems logical that the Prepare Replenishment should still show an item as having a Qty on Supply even if there is an SO for that item.If this topic has already been discussed let me know and I will check it out.

I’ve created a variable to sum the total amount shipped of an item during a specific time period.  However, if zero of this item are shipped, the variable is blank, instead of outputting 0.  Can someone review my code and hopefully point out what I have been overlooking? Many thanks in advance. =IIF($DateDiff > 2,CInt(SUM(IIF([SOShipment.ShipDate] >= CDate(CStr(Month(DateAdd(@EndDate,'m',-2))) + '/1/' + CStr(Year(DateAdd(@EndDate,'m',-2)))) AND [SOShipment.ShipDate] <= @EndDate,[SOShipLineSplit.Qty],0))),0)

Hey all, I looked through the search but I could find a definitive answer. I would like to know if there is a stardard GI or report were I can find a PO that was deleted, more pointedly who deleted the PO. I have already enable the “show deleted records” in the Purchase Order GI but that does not produce any results. We have had this crop up a few times and I would like to find out why it is happening.  Let me know if there is a way to do this. Thank you

Hi, working with a base report for Germany ARXXX.rpx, we have now new a Swiss localization and added the base report with the localization tag in the name ARXXX.CH.rpx.We wanted to make some changes in the CH report and noted that if we make some changes in the data schema (for example different parameters or filters) , the report CH does not work anymore if the localization CH is activated.It looks like the Schema has to remain the same for base and localization version and only the content of the report can be adapted in the localization version.Can someone confirm these findings?

When a customer orders from our online store the sales order comes into our system sometimes before the payment. When the payment does come thru, because that payment can be for multiple sales orders it comes into Acumatica hitting our Unearned Revenue account under the HeadOffice Branch.I have created an import scenario that takes that amount and based on the applied to order of the sales order and allocates the money to the respective branch of the Unearned Revenue accounts. My original plan was to have this import scenario run once a night since most of our sales orders aren’t touched same day, but I’m wondering if a business event can trigger that import scenario for when payments do come into the system?

Hello,We’re just over a month into our implementation and the business is looking for reports that list sales of certain models by units and not by $. Are there standard reports available or does this require a new GI?

We want to email a report using the Email Template and Automation Schedule but we receive the error “A field with the name FSAppointment.UsrPartsReviewed cannot be found”.  The report runs fine from the screen and I’ve built a GI that uses the custom field as a filter and it also works as it should.   We received these trouble shooting steps from Acumatica Support:1. The updated report version containing the refreshed FSAppointment.UsrFinishedDate field is assigned as the active/default version.2. The report attached to the email template is pointing to the correct report ID/version.3. The customization package that adds FSAppointment.UsrFinishedDate is published in the tenant where the automation schedule is running.4. The automation schedule is running under a user that has access to the customization field/report.We verified all these as well as clearing the cache and restarting the instance but the issue still persists.  Just wondering if anyone else has had this issue and have bee

Hey there! Since “IsDefault” is non-existant in the POVendorInventory DAC how else can I bring in the default vendor for a specific inventory item?

Hey, team - I am attempting to automate an email when an AP Batch is released to only those vendors associated with payments in that specific batch.  However, what I’ve built is resulting in an email to many vendors that are not associated with payments in that batch. I've reviewed the following video in preparation for this. https://www.youtube.com/watch?v=JEwTAB47opg The Business Event triggers and sends an email when it's expected.  However, the issue is in the sending of unnecessary emails to vendors who aren't included in the released batch.  My guess is there is an issue with the GI. GI and BE attached

I am getting the following error in report designer. An error occurred while executing the Substring(Identifier(ARTran.TranDesc), Const(0), BinaryOp - (InStr(Identifier(ARTran.TranDesc), Const(|)), Const(1))) function. Length cannot be less than zero.Below is the formula. It works in a GI, but not here.=iif(InStr([ARTran.TranDesc],'|')<0,[ARTran.TranDesc],Substring([ARTran.TranDesc], 0, InStr([ARTran.TranDesc], '|') - 1)) I am trying to print all characters to the left of “|”, but this fails when there is no “|” in the string.