Reports and Generic Inquires

Hi EveryoneI recently uploaded a few stock items with incorrect default prices. Now, I would like to review the last audit history before the new prices were updated. Can we obtain the details of the audit history prior to the price update? In the attached screenshot, the old price is $289 and I have updated it to $319. Similarly, using a GI, I would like to extract data on the old price.Please suggest.

Hello, Novice Report Designer here. We are trying to design a text box on our Purchase Order to add a various web links, based on filter logic. I have the IIf side working, but what is the proper method to make that text box a web link?

Hello we just went live with Acumatica Monday. I am trying to learn to use the Generic Inquiry interface.Basically I have 2 questions. First question - I am working with multiple tables and trying to create joins using the interface. Having some trouble getting my head around setting up proper joins. I am use to just creating a SQL view (Oracle) and then access that view through our ERP via a report interface. Is there a specific method for me to see the code behind a Generic Inquiry that I create.  I think that would really help me figure things out. If I understand correctly that would be the BQL code or some sort of combination of that and something else.Second question  - As I mentioned I  am used to creating SQL views in our previous ERP (IFS). Reading through some post on line it appears we have that capability in Acumatica  where we can create a SQL view and then create a DAC (Data Access Class) to look at that SQL view and then access that DAC via a Generic Inquiry or a Report.

Getting really aesthetically granular with a client’s printed reports and running into some formatting issues I can’t seem to figure out. Is it possible to center align report sections to the report page layout? (1) Does this get rid of the right side gap? (2)Also can a border for the entire report be made so it is visible when printed or exported to PDF. (3)When I do print or export the outside border disappears? I have moved items around on reports by adjusting their position manually, but would like to utilize built in functionality if it exists for center aligning entire report sections, not just on report section objects.  I have reviewed the Report Designer documentation, and nothing I can find speaks to either of these issues. Any ideas?  

I have a generic inquiry for displaying a side panel on an ‘Export Shipments’ page. This side panel lists all the Files on the page (this page has the option to create a document and attach it to the page, populating the default ‘Files’ popup). I would like to update this side panel so when a user clicks the file name it will download the file instead of navigating to the ‘File Maintenance’ page. I noticed the File Maintenance page has the ‘External Link’ field that is a part of the ‘UploadFileWithIDSelector’ -I was originally using the ‘UploadFile’ data class for displaying the Name, CreatedDate, and a few other properties belonging to ‘UploadFile’ on the side panel but this data class doesn’t have access to the ‘External Link’ field so I updated the generic inquiry to use the ‘UploadFileWithIDSelector’ data class and attempted to add the ‘External Link’ field in the Results Grid -  With this setup the page only displays the Name and CreatedDate with the External Link value being empt

Hi All,I have a GI that has QTY total and it works. I need to be able to add the location and lot/serial number, but when I use the table I “believe” it should be, I return no results. Does anyone have a solution? 

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

Hi team, I’m looking to start promoting the use of dashboards in my organization. The challenge I’m finding is that the preloaded dashboards take an eternity to load.As a start, I wanted to change the refresh time of widgets to a longer interval, however, I cannot enter design mode until the dashboard refreshes in full.Is there a way to ‘stop/pause’ the refresh to access design mode? Or is there another way to enter design?

I have GIs that are designed to dynamically include a sales order total to either a MTD column or YTD column depending on the value of the date in the GI’s parameter. We are using grouping and aggregates to summarize these totals by Branch and Month or Branch and Year.  I’d like to display the results of these queries in a table format on a GI, meaning that the GI should have the data in the desired layout prior to exposing it to the Dashboard, but the user should be able to enter a date on the dashboard, that would then feed the GI so that the summarized totals are reflected in the results as though they were entering the date parameter in the GI as shown below where Ext Price = MTD Salesand no - I don’t want to use a Pivot table… 😉If anyone has cracked this puzzle, I’m interested in understanding how you did it.  

We have dashboards that use Power BI widgets. The tokens being used (Power BI Embedded) are still active and haven’t expired. We are not sure what is causing this issue.  

When printing the invoice for the Customer, I would like the POD image file attached to the ARInvoice document to display on the report. The way it currently works in ReportDesigner is using a PictureBox, with the Source set as Database. The value is [ARInvoice.NoteFiles]. This works fine some of the time, but if there are multiple attachments on the Invoice document it will pull the one first added. Is there any way to change this so it gets the image from the latest added attachment?  I would like to avoid a subreport as this is generated extremely frequently and I’m worried that generating twice the reports to achieve this will take an unnecessary toll on performance. 

=IIf((Sum([PMCostBudget.CuryAmount]-[PMCostBudget.CuryActualAmount])<0),'green0')Above expression is not working. This field is a calculated field to find the variance.  

Has anyone one been able to create a GI that is one line per GL Account and a column for each periods ending balance?  That is for account 1234 I want to see a column for period 01, period 02, etc.I struggled with this foreverI would love to see if someone has accomplished this  

I have a SubReport that lists the LotSerialNbr’s of items in a SubReport. The goal is to just list the beginning and ending LotSerialNbr’s (MIN, MAX) as listing all of the number would be too cumbersome. The main manufactured item would be the same but with different qtys of 1 to higher numbers (such as 400, or 500). The first number may be 210324001381, 210324001382, 210324001383, 210324001384 and maybe higher, so all we would need is the 210324001381 - 210324001384.

Hi, I close a month in the system. But my colleague can still post a journal entry in that month. Have I not close the month correctly?Thank you.Regards,Raymond

I am in the process of desiging a new invoice and my question is what and where are the SOLine.DiscPrice and SOLine.CuryLineAmt. I have SOOrder and SOLine in the relationship and have tried a Left Joiin, Right Join, Inner Join and the report doubled up the line items, as there should have been two line items, there is now four. I do have ARTran and ARInvoice and have been experimenting with those, but I’m still a noob in Acumatica.

Hello all,I have been working on a report - AR Aging (AR631000) and I am looking to put up a condition where the report should not display the rows that have 0 figures as highlighted below: How can I apply the condition? Thanks in advance.

Hello, I’ve created what I thought was a rather simple GI, yet it keeps timing out saying the request entity is too large. It should be pulling customers, which is only about 9,000 records, and it can’t load it. Can someone take a look at this GI and see if something could be improved? Thank you!

Someone else made the report and I cannot seem to to get rid of the border. There should be an easy fix for this, and I’m not lazy, I googled it but couldn’t find a solution. Can someone guide me in the right direction on how to get rid of the border from the report?   

Dear All,I want to create different output report designer value based on Subaccount that stated on PO Line, how can I make this? for example :Sub : 00-000000-STV-00, I want to show Stevedoring as return value from Subaccount on third segmentSub : 00-000000-VES-00, I want to show Vessel as return value from Subaccount on third segmenthow can I make this work on report designer?Thanks

On a generic enquiry, how do i get the number/$ sum of invoices etc between to dates? I have seen the threads as to date differnce calculations, but they all seem to be related to getting the amount of days bewteen two dates.  DateAdd( date, interval, number ) etc I want to get for example how much a customer spent in 2021 in a column. 

I have a business event that I created to send email notifications to customers when their order has shipped. I want the email to be triggered when the shipment is marked as confirmed. I have set up a GI to pull in the correct data, but the business event is not triggering. See screen shots below. Has anyone else gotten their shipment notifications automated? Is this the correct approach or is there a better way?  

Hello! We have an AP Aging report that has been customized and somehow the Vendor Class stopped working. I was able to get the lookup back but for some reason the report continues to ignore the selection and produces all records instead. I have compared the Parameters and Filters tab to a previous version that works and the settings are the same. Is there somewhere else I need to be looking in order to correct this?  

We have a number of GIs that have multiple side panels / color schemes; it would be really great to have smaller text under the GI title at the top of the page where you could provide simple instructions or a color legend (even if it’s just text--preferably multi-line) to give users some context / action items.  We have the below GI used by our PMs to keep our project financials updated without having to leave the screen using side panels.  I’d love to put a sub-heading under ‘Live Cost Report’ that says “use the ‘PO Lines’ icon to the right to see PO lines written to selected line item” and “update your % complete using the ‘Claim % Complete’”.    

Once a Production Work Order is Released and we can see the LotSerialNbr in the Production Order Maintenance, where does that number actually reside, or is it a phantom number until the Production Work Order is completed? I have looked in AMMTran.LotSerialNbr, AMMTranSplit.LotSerialNbr, and AMProdItemSplit.LotSerialNbr and cannot find the same number in any of the DAC’s. Once the Production Work Order is Completed, all the numbers appear to be there, but we need to see them on the Released level, not Completed, which leads me to think that the number doesn’t really exists until Completion. Even useing a GI with the three DAC’s I mentioned above yields no records found.