Reports and Generic Inquires
Reports, GIs, Dashboards, Pivots
- 912 Topics
- 3,636 Replies
Possible to control pivot table hyperlink navigation?
It’s helpful within a generic inquiry to be able to influence the navigation using the Navigation tab.Is there a way to similarly control the pivot table hyperlink navigation?Example:I have a derived field (OrderAndLine) used as the “Value” that we count in order to show the results in the pivot table.But there are some problems with the hyperlink that is auto-created by the pivot table. When we click on the number shown within the pivot table, a new tab called “DRILLDOWN” opens to display the drilled-down data. However, there are never any records in the DRILLDOWN tab.I can manipulate the filter within the DRILLDOWN tab and eventually show the required data, but I can’t expect an end user to do that.(I think the root cause is actually a data type issue unrelated to OrderAndLine; it appears to me to be a data type issue related to a Date vs DateTime field, but IMO not relevant for this question)It would be ideal if we could configure the navigation within the pivot table such that we c
Bills & Adjustments -- incorrect excel export
Hi all, we’re having issues with our Bill & Adjustments excel export… it seems it’s only exporting fields based on one column (Vendor name) and not another (Description). Any ideas? You can see B&A shows 10 records, but only 6 were exported into Excel. Thanks!
Joinint to the AMMultiLevelBomData in Report Designer
Trying to enhance the AM613000 report to include our Legacy Part number on the report (this was implemented as a usr field on the InventoryItem table) It won’t let me join InventoryItem to AMMultiLevelBomData as I gather that AMMultiLevelBomData is a dynamic “table” based upon the answers to the questions on the AM413000 screen So how can I extend that to add a simple field? I assumed it should be as simple as adding the InventoryItem table to the report and joining on the InventoryID columns, but that errors.
Hi,Below is my formula in my Description column and next is the result.The thing here is, Linenbr 1-8 is actually one item with split 8 Serial Numbers (one is blank), that’s why at 8th line, it’s just a [TranDesc]. About the Linenbr 9, it is same inventory as the 1st but it’s another line and ext. cost. It is ok not to specify the description since its the same above and that’s what my formula dictates. My concerns are:(1) How do I display 1-8 as one Line only and (2) since the last SN is empty, I don’t need the desc to display (I know it contradicts the formula, but is there another way?)Thanks!
Pivot Table Format Property - Inherit color coding from GI Style
I’m curious if this is possible: Can the Pivot Table Format property use color coding?Using: Acumatica 2022 R2We have a generic inquiry whose field values are color-coded based on a string value, using the SWITCH formula. This piece is working fine.Example:=SWITCH([SOLine.InventoryID] = 'DELRETNSCCURM','yellow20', [SOLine.InventoryID] = 'DELINISCCU','orange',[SOLine.InventoryID] = 'DELREDLRRRM','green', [SOLine.InventoryID] = 'DELFNLSCRR','blue', [SOLine.InventoryID] = 'DELINISCCURM','orange20', 'default')This gives the customer some desired color-coding when they view the Inquiry on a screen.But when I create a pivot table from the inquiry, the color coding defined in the Style property of the GI disappears.It would be ideal if either:the pivot table would honor the Style property that I assigned against the field in the inquiry; orthe pivot table could respond to the Format property defined against the field in the pivot. It looks like the Pivot Table format property (according to th
Carrier Plugin - Customer - Carrier Account - Add to Report
I am trying to add [CarrierPluginCustomer.CarrierAccount] to the SO641010 report in report designer.Based on https://watertrucks.acumatica.com/dacBrowser/PX.Objects.CS/CarrierPluginCustomerI added the table CarrierPluginCustomer to get [CarrierPluginCustomer.CarrierAccount] Relationships:Parent Field Link Condition Child Field BAccountID Equal CustomerID I get no errors and added the value to the report, but when testing the report on a sales order that used a Customer’s Carrier Account, it displayed nothing.We are using the EasyPost Carrier PluginAny ideas what I am missing?I attached the test rpx file as a zip for reference.
Trying to filter on a Calculated data difference field
Hi, I created a GI trying to get the customers that are over the days past use. I am then trying to calculate the number of days past the Credit Due days of the oldest invoice. The data is displaying the way I expected it to. My issue is that I cannot apply a GI filter on the Day Past Credit Grace Period. If I enter 120, nothing appears even though in the All records tab, there are records that meet this requirement. These are the fields that I am using for the calculations. Thank you in advance. Bill
How to Add Email Signature To Report Designer
HI All,I am wondering is it possible to add email signature to the mail setting in Report Designer. Currently the email signature on the User Profile no longer automatically applied to the invoice when I am sending it via Invoice screen AR641000. It is only showing the text I have setup in Report Designer. Email signature only works If I use the Print Form screen and generate the invoice then send on that screen, which is strange as that screen would have been the same as the invoice card. I would want to avoid using email Template in Acumatica because I am not familiar with where to find the information. Kind regards,Calvin
GI and Dashboard ("@me") doesn't pull Owner
All, I’ve recently take on Acumatica support at my company and was told that some time back, an Acumatica update broke the @me filter in our dashboards. Then I found this:Here’s the drilldown… do I jut need to change OwnerID_description to OwnerID? from the GI results gridThanks!
Attempting to create copy of GI. It exists in Services module, but is not listed in Customization/GI when I search.
I want to create a copy of a generic inquiry that exists (OOTB) within our implementation. Acumatica 2022 R2, Build 22.205.0026. Construction Edition. The inquiry is within the Services module and is named “Appointment Summary.” It has the screen ID of FS400100. Within the Services module, the title shows under Inquiries, as you would expect. The inquiry opens when selected and presents the expected form and results (the OOTB inquiry). To attempt to create a copy that I can edit, I navigated to Customization, Generic Inquiry. When I select the magnifying glass to perform a lookup of the desired title “Appointment Summary,” no such inquiry exists. I’ve attempted using “appoint,” “app,” “FS,” “Summary,” “40.01.00,” and anything else I could think of. I cannot find this inquiry. I do get results in the lookup, just not containing the inquiry I’m looking for. I have made certain my view displays every available result by enlarging the search results form or walking through each
Changing multi-column report to single, only returning every other result
Hi all,I’m modifying the stock Location Labels report to a format that will better fit the labels we want to use. I wasn’t smart enough to keep a print out of the original report, but it basically outputs two columns of location labels. If you haven’t seen it, think of it like this:Location 1 Location 2 Location 3 Location 4 Location 5 Location 6 Honestly I kind of hacked and slashed the report, removing all of the objects on the right side as well as adding a barcode and some other stuff, to where it only outputs one location label per page. All of my additions and changes work, except the report still behaves as if it had the second column, and when I request a range of locations it gives me the equivalent of Location 1, Location 3, Location 5, etc. If I start the range on Location 2, it will then give me Location 4, Location 6, etc.I’m sure there’s probably a simple answer here, but I have a case of Friday burnout and this is kicking my butt. Any help that can be provided w
Generic Inquery - Get total count of records via OData
Hello,I’m using the Expose via OData with some generic inquires to get some data via the OData API. I need to know the total number of records. You can clearly see the total number at the bottom of the results grid but I don’t know how to get this information in the OData response.How can I get the total records for a Generic Inquiry in the OData api?
Lines not showing contuniously when content increases in report.
Hi I’m trying to create a table and trying to add lines betweens the line items by styling individual textboxes with borders, the issue here is the lines are not printing continuously when the description is getting longer than 2 lines. (ex: line 5 & 6)I tried to resolve it by styling pannel but same issue repeats.Is there any better way to add lines without wasting space.
EasyPost URL in Generic Inquiry
I have a Generic Inquiry that displays shipment information based on the tracking number that is input into a parameter. We have EasyPost integrated into our Acumatica, and we have the Tracking URL as one of the fields in the Generic Inquiry. Is there a way to make the Tracking URL link active in the Generic Inquiry so the user can simply click on the URL and view the tracking information on the EasyPost tracking page? Thank you
GI relating cases to emails in the cases
My team wants a report to show how many emails a customer service rep responds to a day from cases created from our website’s support page, not cases a rep would create on their own. My plan is to make a GI that has case id’s, and created by, then the emails within those cases which I can filter by rep later, but I’m having a hard time finding the relation between a case and the emails in the case. Does anyone have a good join for this?
Check From with Remittance - Add Joint Payee
Hello,Has anyone been able to get the Joint Payee name on the printed form “check form with Remittance” AP641000? We have everything set up in the system to allow a joint Payee name (Second column in the screenshot) we would not just like to add the joint Payee to the check form with Remittance. Thank you,KT
How to add an invoice report to a GI?
I am trying to make push notification which would deliver all my open invoices with amount,balance,customerID and copy of the invoice to an endpoint. I am wondering if there is a way to add the PDF Invoice as a column to the GI that would feed the push notification.
Dashboard caching issue: dashbord is always filter widgets based on logged user's employee id.
Hi,I created a new Generic Inquiry window using Px.Objects.EP.EPEmployee, Px.Objects.EP.EPTimeCard. And set the Employee ID as a parameter without default value and not from schema.Then created a Dashboard using this GI window. Owner role: DashboardDesigner set Employee ID as a parameter without default value and not from schema. Then designed the dashboard with widgets as below figure. After logged as a user who is an administrative employee and run the dashboard. Initial load the employee id is filtering based on logged user’s employee id. Removed the employee id from the filter parameter box and select a new employee. But the widgets are not loading correctly. Then activate the design mode and check the widget parameters, and found the logged user employee id has been set as the default employee id. After removing the value widgets are loading correctly, but every new session this logged user employee id is set as the widget’s parameter. Therefore, every time need to activate the
Already have an account? Login
Social LoginLogin with your Acumatica account
Login to the community
Social LoginLogin with your Acumatica account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.