Reports and Generic Inquires
Reports, GIs, Dashboards, Pivots
- 1,417 Topics
- 5,529 Replies
Good afternoon!I wanted to pass along a “How To” for a great/simple (and underutilized) feature in Acumatica Generic Inquiries that allows users to add the functionality to run reports directly from the Generic Inquiry Results grid.In the process below, a report has been added to print PO Receipt Line Labels, on demand, directly from a Generic Inquiry. Please see the following steps. Create the Report (ex. Receipt Labels) Create the Generic Inquiry. Under the “Navigation” tab, add the report and assign the needed “Navigation Parameters” from the GI Results to run the report. Under the Results Grid tab of the Generic Inquiry, create a new line, and assign the “Navigate To” for the screen added in the step above. (you can also add the “Navigate To” report to an existing field in the report if you prefer) When you run the Generic Inquiry, you will see the hyperlinked option, at the line level, to immediately run the report on demand. Hope you find this helpful!
Hi, I want to create a report in Payments and Application form.when I create a record in invoices form, A record will automatically create in Applications history tab in the Payments and Applications form. how can I make the relationship in the Report Designer to connect Invoices form and this record to the Payments and Applications form to fetch the data in the invoice form? I want to create a Report in the Payments and Applications form to get inventoryID, Desc from ARTan.Thanks.
Hello, On a Sales order screen, we recently experienced this error message: The trace log doesn’t seem to show which column is causing the error. I’ve looked into the fields of the generic inquiry and not sure what to do next. This GI was working fine last week. Any help is much appreciated! I’ve attached the XML of the generic inquiry here, as well.
Hello Community,I have been trying to create a report where I would like to display the vendor name (of the subcontracts) in the details section on the basis of the project ID selected. I have implemented the following on GI level and it works fine. But not able to replicate the same in report:GI: Report: Have used the same as that of GI What is it that I am missing here?Thank you in advance.
Hello Community,I wonder if anyone had experience translating check amount, that’s represented on Check form AP641000 by field [APPayment.AmountToWords] in to Spanish?Localization was completed for the system, and everything is being translated fine, including the rest of the fields on this form. Thank you
Dear Acumatica Community, I was wondering if anyone knows how to force the system to print the additional remittance every time a check is being printed?The best I could do was set the line per stub in the payment method screen to one which will trigger the additional remittance when there are 2 lines or more in my check stub. However, I would like the additional remittance to print even if there is only 1 line in my check stub:Is this possible or is there any code changes I will need to do? Thank you, Choenho
Hi, I've created a GI to display the serial number details of sales order lines. I intend to retrieve this information from the "SOLineSplit.LotSerialNbr" field. However, even after joining the "SOLine" table with the "SOLineSplit" table, I'm encountering an issue where the GI result grid does not display any output. I've attached the GI for your reference. Can someone assist me with this problem?
Hi all,Working my way through S130 and realized I had never worked with aggregates, so I copied Invoices and Memos to create an aggregate of counts, totals and average by customer:Everything is grouped correctly by customer and displays totals and counts perfectly; average however doesn’t show up (even though I have visibility checked in results grid).Also, I turned on Total Aggregate and everything is summed correctly for the totals, but not the counts.Any ideas what I’m doing wrong?Average also isn’t displaying in the column configurator:
Hello all,I have been trying to create a new report from scratch which would list out the Project & the subcontract details on the basis of the selected project ID.I have copied the Project Balance (PM621000) report.Have only kept one parameter: But when I run the report, the values of the detail section isn’t getting displayed: What is it that I am missing here? Is the View Name for the Project ID parameter correct?
In a Sales Order, add the linked Purchase Order in the Sales Order line for each SO line item. (SOline.PurchaseOrderNbr). If the PO Nbr was added in the SOLine DAC, you could have a Sales Order Generic Inquiry that listed Sales Orders with the associated PO for each line item in the Sales Order, thus enableing you to quickly check on Purchase Order when a customer calls to inquiry about a Sales Orders. Often, a Sales Order is assoicated with more than one Purchase Order and you would have the ability to display the associated PO with each line item on the SO.
Hi, We have a client that we installed the PDF Annotator for 2022 R2 in A/P under Bills & Adjustmenys. I published the customization and setup the security. However, the side panel shows but then quickly disappears and does not stay. What am I doing wrong? Here are my security settings. Am I missing something? Let me know. Thanks, Frances
I’ve looked at the articles about this process, but still not getting the results I am looking for. I have a Bar Chart that looks like this:The values are based on a Attribute filed on the Stock Items. Values are Medium, Low and High.In the Color option of the Series, I have the following formula based on the documentation.=Switch(Value = 'High', '#AB400C', Value = 'Medium', '#e9e00', Value = 'Low', '#a9d360')But the results are this:Any ideas?
We would like to display an attribute stored as text to date time. Below is the attributeAttributeWe would like to create something similar for End Time and calculate the difference between the two fields. Start Time End Time Difference 2:30 pm 5:30 pm 3 hours or 180 mins We tried using CDate() function and it errors out (=cdate([INKitRegister.AttributeSTARTTIME]))How can I fix this issue? @lauraj46 -Hi Laura, do you have any ideas, thank you as always! Any help would be appreciated!!
I’m building a GI and need the ToLocationID data field from the POReceiptLineSplit data class.However, when I click on the POReceiptLineSplit link, that field does not exist in that data class. Am I missing something? How can I access it for my GI?
Hi all, I need a VisibleExpr that flips visibility based on a string inside of our InventoryID -- if an InventoryID contains “-STRING-”, then flip this text on. =iif(([AMProdItem.InventoryID]='-STRING-'),false,true) Unfortunately, I don’t know how to write the query so I’m asking if it CONTAINS, not EQUALS.How do I craft the query to see if the InventoryID contains ‘-STRING-’?
Our invoice form contains a gif with our address that has a typo in it. I would like to replace the image. However, when I go into report designer, click on the image (which is a picture box) the properties, Data shows “Database” and I cannot determine where that image would be located. (see screenshot attached) Does anyone know how to find and change a database image in a form in report designer? At the moment I am working with form SO643000 but would have to make the same change in a few other forms. Any feedback would be helpful.
Hi Team,We have a requirement where we have to create a GI and have to show Qty on Hand across all warehouses and Sold Qty (Qty across all released Invoices) for stock items. We created a GI and for all new products it is working fine but for existing products the values are incorrect. I am attaching the created GI, can you please review and suggest the best way possible to achieve it.Thank you!
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.