Reports, GIs, Dashboards, Pivots
Recently active
I have been building a custom Kit Assembly report for my company to use and have it all set up the way I like it. However, it will repeat the “stock-items” sub report for as many items that are in the stock items.I feel like I’m missing something simple, I tried to set it up similarly to how fs641000.rpx works, with sub reports for stock items and non-stock items (stock items also has a sub report in it for lot/serials).I think the problem is with the sub report for stock items (KA207013.rpx). I have tried the grouping but keep getting the duplicatesAny help would be greatly appreciated!
I want to identify the report file for upgrade version.because if you have upgraded the version, the report that saves to report will not go to the upgrade
Hi all,I have a client with a specific requirement. They want each report to show the screen ID of that report. For example, when I view report Invoice/Memo AR641000, then AR641000 should appears on the report.I’ve tried using =Report.GetDefaultUI(‘AccessInfo.ScreenID’) and =Report.GetDefaultUI(‘RowAccessInfo.ScreenID’) and these don’t workDoes anyone know what how this can be achieved?
There is a requirement to print two different reports with the same parameters on a single document one after the other so as to export as a pdf. Can I know if there is a way to make fulfill this requirement with the report designer?
I’m looking to create an easy way for our sales people to filter sales order based on info in the order description. Since that is a free text field, is it possible to create a parameter on a GI for it?
Hi Acumatica Community,i am pretty new to the acumatica universe and struggling with a GI i need to build. I try to enhance the vendor GI and i need to show the payment details (red lined) of the vendors, but since its a grid column and i dont really get any helpful result i am requesting your help.for the GI i joined the table like thisThanks for helping.
We’ve been using Power BI to connect to Generic Inquiries via OData for the past year. All of the sudden in the past few days we’ve received the following error message in Power BI: Anyone know what might be causing this and how to resolve the issue?I found this article that references a similar issue, but none of our GIs have a period (.) in the name so the solve offered in the article isn’t helpful in this case.
Hello, I am trying to write a GI that allows me to see the Default payment method and cash account for all vendors, and I am struggling to get there.Would anyone know which table i need to relate in order to show that? I am using the default Vendor GI as a starting point.
Hi everyone,I am trying to add a description field for two separate fields, the PhantomBomID and the regular InventoryID. Is there any way to direct the description field towards the different descriptions for each item?Here’s a screenshot of my results grid. The underlined items are the ID’s that need to have a description, and the highlighted items are the descriptions themselves. Here are my relations. I tried relating a separate field to the PhantomBomID, but it caused me to have duplicate records.
Hello All, I would like to ask for your help guys. How can I show in the report designer and generic inquiry the RELEASED DATE and RELEASED By?In the > Purchase Receipts > Bills And Adjustment > Checks and Payments > Receipts > Transfers > Adjustment > and others, all with release function/action Thank you. I really need your help guys.
I'm creating a subreport in the PurchaseOrder report, I want the subreport to appear on the next page after the last page of the main report, is there a way?
Hi,I have a client who needs to report GST in Canada on the Sales and Purchases side. However, they have multiple AP or AR line items under one invoice that could include GST and Non-GST items. I am having issues how to reflect both GST and Non-GST amounts on the Tax Details or Tax Summary reports under % Taxes in Acumatica. Here is an example of the Reporting Group I have setup on the Purchases (AP) side. I have also created two separate tax zones for GST and GST Exempt here are print screen of those: What am I doing wrong? Any help would be great.Thanks,Frances
HI All,Currently the exported pdf version from Report Designer is shown commo “,” as the grouping symbol.Is there a way we can change from commo “,” (19,941,572) to dot “.” (19.941.572)?Thanks in advance,Yên Chi
Hi all,I want to format use a dot not comma as a thousand separator. But I don't know how to format it, I don't quite understand.I expect it show as 2.223.600
The Billings I manually grab the total sales from the P&L report.I want to add this in report designer which field i have to select ?
Hello, I am trying to concatenate string and integer fields from ARSalesPrice Table - InventoryID, CustPriceClassID, PriceType, CustomerID, BreakQty. The purpose of this GI is to count if we have duplicate prices at the same break qty. But currently, it does not let me concatenate string and integer fields together. Could you please advise how that is achievable?
Is there a way to filter Opportunities by week count and show as bar charts in dashboard widgets? The y-axis would be the count of how many opportunities there are, and x-axis would be the first date of each week. I’m not sure what to specify in the chart setting (shown below) and how to name the legend to date (mm/dd/yyyy).
Could someone point me in the right direction of where to start on a Generic Inquiry that can show Project Managers the ‘burn rate’ / spending's on their project based on certain dates?So two scenarios - Time Entry / Labor. We enter time and process payroll via Acumatica. There are a number of Inquiry Title pages that contain billable time fields and amounts, but I couldn’t seem to get that correlating / summing properly by Project. On top of that, would need a way to say ‘pull this data between these dates’ or from the previous weeks dates.The other one would be project transactions during those dates. However I’m not sure how I’d accurately show these dates because bills can be entered but not paid at the same time.Appreciate any insight!
Hi, I have a client that has a question for the Approvals grid under Time and expenses. In screenshot 1 they want to know why the note section is not highlighted like it is in Bills & Adjustments in screenshot 2. I tested in our demo and same thing. Is this by design? Client is on 2023R1.Sceenshot 1: Screenshot 2: Thank you,Frances
We are trying to figure if there is a way to setup an email template for the Inventory Register Details report (IN614000).Current Process: The user enters a new record using the Issues screen (IN302000) and then they run the Inventory Register Details report (IN614000). After reviewing the report they click the Send button which opens the Email Activity screen. The user then has to enter the To address, the Subject, and the Message. Is there a way you setup a template for this report so they user doesn’t need to fill in all the information each time they send the report?Thank you!
