Reports and Generic Inquires

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!

***so on the worksheet pick list, some of the shipment nbr do not produce any data after Run Report****the status are completed already ***some of the shipment works in the worksheet pick list 

Hi,I’m trying to build a new Generic Inquiry to view my approvals instead of using the existing Approval screen.I’ve tried adding multiple screens as navigation links because I would like to open the relevant documents directly from the GI. However, it is not working as expected. Currently, all documents are opening through the Bills and Adjustments screen, resulting in a blank screen when the document belongs to a different screen.Is there a way to configure multiple screens as navigation links and have Acumatica open the appropriate screen based on the document type?  

Hi Everyone,I am trying to create a GI that tracks all Tasks and Activities created by the users, I was able to create one that displays both the tasks and activities, but it has a limitation, I am only able to open up the records for as long as it’s a Task, but I can’t open up the activities, I was forced to add the Navigate to as the Task screen in order to open the tasks, but I don’t how to deal with the activities,I have attached screenshots and the XML on how I set up the GI, anyone with an idea to how to achieve this requirement, I could appreciate your assistance, 

Hi, is there a setting for reports to default on the company / organisation rather than the branch?  I know this can be done by modifying each report to default on company, but if there is a setting / preference that can do this please let me know   

I have a generic inquiry containing filters and pivot tables When I tried to switch to the modern UI no results were given and an errror message “Object reference not set to instance of object” was displayedI then made a copy of this generic inquiry, published it and tried again to switch to the modern UI (without the additional filters and pivot tables) I still got the same error. The pivot tables on the original generic inquiry are also used on dashboards

Hi,I am creating a new Inventory Item Label with a QR code. This report is intended to generate inventory by warehouse and will be used with the Scan and Count feature in the Acumatica Mobile app.At present, the report is displaying as blank, and I am unsure of the root cause. I would greatly appreciate professional assistance in resolving this issue. Thank you.

Hello, My boss is asking for an automated email of our inventory report every week. Currently we use a pivot table set up by our VAR to show our inventory at a quick glance.  however, i cannot automate this as an excel file email so i have to build a report. I’ve got all the data to show, however, each warehouse creates it’s own line. I’ve tried grouping, but that will only pull results for the BBPA location. I looked at possible solutions but adding =Sum to each line didnt work, grouping didn’t work, trying to hide the 0s in the conditions didnt work.  Any ideas on how to combine all of those lines into one single inventory line like the pivot table does?

I just created this KPI, and I’m trying to pull the OrigOrdeNbr to know the Original Owner. NOT the new ownerAll the records are pulling the OrderNbr Owner.Like the records below its showing 2 different OwnersI need help in finding out how to get to the OrigOrderNbr Owners.

Hi, I have a field to display PO#, and I’m trying to make its size dynamic, but despite trying all possible properties, it still only displays as much as fits in the original field size.I tried CanGrow first, then also ticked WordWrap, CanSplit, and Multiline, and as a last attempt, I also ticked CanShrink—none of them worked.The Report Designer version matches the Acumatica version, and the text field is not inside any other panel.I know I can manually increase the field size, but I’m trying to understand if these properties are actually functional. Any insights?Thanks! 

I’m getting this error when attempting to export a GI to an excel file using the Excel export button.  Any idea how to avoid getting this error AND get my Excel file?

Hi, in AR Clerk default dashboard, there is a DSO (Days Sales Outstanding). Its purpose is to understand how long it takes in average for customers pay their outstanding.On the other side, there is a default AP Clerk dashboard but I can’t find its equivalent which should be the DPO (Days Payables Outstanding). I understand AR Clerk displays something actionable, but it would be good to maintain good vendor relationship as well by understanding how long in average does it take to pay the suppliers. Has anyone built a GI for this? I am unable to find the equivalent/appropriate tables for this. Thank you in advance!

Hi, I created a GI to show approval maps (XML attached). How do I set the sorting of Steps and Rules in ascending? Note that sorting of Rule description to ‘ascending’ won’t work. Also, how do I show the Entity and Field name from schema instead of DAC name?Approval Maps Steps and RulesShowing DAC name instead of SchemaSchema name 

Hello everyone, so one of my clients they have transactions using other currency. We already set up module currency management, rate transaction, etc, but why there is no menu for Financials Statement or budget report using other currency. Do we need to add customization report in Acumatica to display the menu?Our base currency is IDR and the other currency we want to added for the report is USD.Please help me to solve this, I really appreciate, thank you. 

Hi everyone,I'm working on a printing workflow in Acumatica and I'm trying to make it a little more reliable.Before sending an invoice or report to a printer, I'd like to have a quick way to confirm that the printer is actually producing good output. Checking whether the printer is online isn't always enough, since a printer can accept a job while still having issues such as faded text, missing colors, streaks, or alignment problems.For example, if a printer has recently had an ink or toner change, paper jam, or maintenance, I'd prefer to run a simple test print first rather than discovering the problem after several Acumatica documents have already been printed.Does anyone here use a printer test or verification step before running important Acumatica print jobs?I'm particularly interested in whether people rely on DeviceHub/printer status alone, or whether you also use a physical test page to check the actual output.What has worked well for you without adding too much extra work to t

I’ve been asked to provide a sidepanel on a few screens that will display the Remit To address of the vendor on the current screen.  That part is pretty easy and I’ve already provided that to the users.But the sidepanel is displaying the results of a GI (the Sidepanel technically points to a Dashboard that has a Data Table widget on it that displays the GI results).  The results are displayed horizontally, and since it’s displaying 5 fields, the results are kinda squished.  I’d love to display the results vertically, like:Addr 1: 123 Main StreetAddr 2: Box 17City:  AnytownState: PAPostal Code: 12345I’ve tried a pivot table but that’s not really what pivot tables are designed for.The only solution I can think of is developing a custom form screen and tying the sidepanel to that.  That kind of form screen is pretty simple...but I feel like I’m going down a rabbit hole for something that doesn’t justify that much work.

On the customer statement you see the invoices, and a total, and if a payment was applied the total is decreased, but the payment is not listed.  Is there a way to expose/show/display the payments that took place in the statement period? 

All, we have an email going out to a dead address -- the employee at the Vendor we’re sending a PO notification to has left the company months ago.“dead@address.com” isn’t listed in the vendor card anywhere.“dead@address.com” isn’t in Contacts.I can’t find “dead@address.com” anywhere in Acumatica.Firing up Report Designer is where I found the field =[RemitContact.EMail]Does anyone have an idea of where [RemitContact.EMail] is stored? 

I'm using a Master report to display two sub reports side by side.(see attached)I know I can use Excel-Manual mode to set the column width for each report, which works fine when applied to a single report. However, once I switch the master report's export mode from excel-auto to excel-manual, the two sub reports, which previously displayed correctly in Excel, become misaligned. Like belowrow 1 sub report1 c1, sub report1 c2row n............................................................... sub report2 c1, sub report2 c2It's as if sub report1 finishes printing completely before sub report2 starts printing on the next line.They display correctly, line by line, in PDF.If I switch back to excel auto, they display correctly in Excel on the same line, like this:row1 :sub report1 c1, sub report1 c2, sub report2 c1, sub report2 c2However, in auto mode, the columns are too wide, and the user doesn't want to manually adjust them every time. What should I do?

Hey, Gang - I’m trying to create a custom report for a client who wants to display all the lines associated with a selected task for any given Project Quote. Any assistance would be helpful here. In a perfect world, the task would be retrieved from whatever line is selected on the Estimation tab. For example, using the screenshot below, the report would display ONLY the two lines associated with task 040 since that’s the task of the selected line. This would be awesome, but right now I just need to get it to recognize the tasks used in a given Quote. However, I can’t seem to get the system to recognize the task list for the selected Quote. Here are the corresponding schema items  

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.  

Hi, I am getting duplicates when printing a credit memo. What’s weird is it not happening to all credit memos and invoices. Only happens to some of them. I’ve attached the report file. Thanks for your help!  

Hey, gang - I’ve reviewed a number of posts related to this issue, but wanted to get the team’s thoughts on my specific case.  I’ve got a client who wants to see total INTran Issue Quantities over the past 12 months, by month, as well as On Hand, Available, and a few other metrics related to the individual Stock Items, all in a single GI they can manipulate by date.  We usually get the System was not able to get record count warning, and I’m wondering if the community has some insight that’s tailored to this GI.  I’ve attached it for reference, too.  FWIW Somtimes, if I remove the grouping and re-add it, or if I change the date parameters, the warning goes away. This GI is really two parts - the first is the month-to-month data from INTran, conditioned by financial period.  Here, I aliased the MasterFinPeriod DAC 12 separate times using the DateAdd formula to reflect the month via the Joins.  The DateAdd formula is using a parameter, so all the months can change based on the selected [

 Hi Everyone,I'm facing an issue with barcode scanning in Acumatica 2026 R1 and would appreciate any guidance.I have created a report that prints a Code128 barcode using the standard PictureBox barcode control.Current barcode settings:Source: Barcode Barcode Type: Code128 Value: =Trim([INLocation.LocationCD]) (also tested with LocationID) BarHeight: 1000 BarWidth: 10 WidthRatio: 3The barcode prints correctly and the human-readable text is displayed below it.However, when I try to scan the printed barcode using the Acumatica Mobile App, nothing happens—the app does not detect the barcode at all.To isolate the issue, I generated the same barcode using the TEC-IT online barcode generator with the same value (e.g., PACKING-AR), and the Acumatica Mobile App scans it successfully. This suggests the mobile app is working correctly and the issue is related to the barcode generated by the report.Has anyone experienced a similar issue?

Hi, I’ve created a very simple GI to show account’s history out of GLTranR DAC. However, I am unable to pull the beginning and ending balance data. The goal is to show each GL Account ending balance per transaction line. Basically, like the below showing the Account ID, BegBal, Debit and Credit Amt and its ending balance on that day.Attached is the GI I created. I am open to suggestions or if you could modify the GI to achieve this, that’d be great as I think many of users/consultants would want this. Thanks heaps! 😊I’ve created a GI to show ending balance per period, but we do need the specific date rather than the period with no way to check at any other point in time. With a date filter we simply go back to the day we need to check.