Reports and Generic Inquires

Hi,Does anyone know how to get data from a hidden table in Acumatica report designer? We have a reference number to get from, but it is not visible in Acumatica report designer. How to get to this table in the report designer?     Thank you.

Hello,I am trying to bold a description field of a particular row without also bolding the GL value. Is this possible to do on only one row and not all rows in a singular column?My goal is to get “REVENUE” to display on row 110: 

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?

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 

Hi @everyone, Is anyone knows why some of the line items in the Kit assembly screen shows $0 under Unit Cost tab? I added it via GI. Each items has their unit cost and component qty.  Thanks in advance.

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!! 

hello community,How can i display the below highlighted fields in a report?As  “Income Totals: 9,997,604.39”  

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-’?

Hi All, I would like to ask on how to connect these two tables for report designer. What I want to achieve is to print the approver with their designation.  Thank you. 

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! 

Has anyone had success in building a report to identify the system users that were disabled over a period of time?  I’m looking to find a way to identify the date when a user goes from the “Active” status to “Disabled” status. 

Hi All, I have encountering an unexpected problem from report desginer.  The report is made by the exported G.I., and the G.I. actuallly have no problem at all. However, when I do the same setting in the report designer, finally there are 2-3 items cannot be grouped.  I have really no idea about it.  The grouping data is normally including Inventory CD, LotSeriesNbr, Site ID, and Location ID.  I have checked many times the data is not problem, referring to the screenshot I highlighted it in yellow, the data is matched and same, but it comes up not grouping. Is there anything I missed out or something I need to setup in the report designer (which is different with G.I.)?   I surely the original G.I. is working like a charm, but just report result is not the same. Appreicate if someone can help or advise to fix this problem.  Many thanks.    (Exported Excel, the data is not grouped.) 

As per subject, I have tried to use Max & Min Aggregate function in Report Designer.  Screenshot like below, no matter I use Max or Min, the resulted value is same, it does not capture Min or Max value, but just the first data value. Also, I tested with same formula in GI, it is no problem at all.  Seems this is the Report Designer bugs.

HiI am wanting to do a mass update for a large number of purchase order lines, for a specific branch, to set them to “closed” = yes.I have created a generic inquiry, and was hoping to use the mass update functionality in it:  But my problem is that the fields that are available in the mass update tab, are only for the purchase order itself, and not the purchase order lines.  That’s not surprising, since I am not sending a unique identifier to the screen, for it to know which line to update.Is my only option here an import scenario?  And does anyone have an example for me of an import scenario where only transaction lines are being updated? 

We are moving from an older ERP to Acumatica. One of the things we had in our old system that when we printed a Work Order the printout would print to our Dot Matrix DFX-9000 and also print the WO confirmation onto our Canon iR-ADV. This is also the case with our remote locations as they would print a WO that would print to the dot matrix and also the local Canon. It would also in certain instances trigger a third print that would print the confirmation at head office as well. We have device hub setup with all the printers and everything works as long as it’s going to one printer. How would we trigger when certain reports are printed it also prints copies to different printers at the same time. For example Florida location prints a Work order to the dot matrix, once that happens it knows to trigger another report to print the confirmation to the Florida Canon and also the Canon in NY.This is the same for invoices, needs to print locally and at head office accounting as well. 

 Hi all, I want to create Trial Balance by Period in ARM Report, but I have a problem with account Income and Liability, they show as plus sign then total beginning balance and ending balance not equal to 0.My purpose is to have a report exact data to Trial Balance Report (GL632000) and can filter from period to period. I have total debit and credit equal but my beginning balance and ending balance I expect it equal to 0.Can anyone help me solve this

I have a report I created that prints barcodes.  I need to print it to the Device Hub I have running, setup for RAW MODE.  How do I print this custom report to that device hub printer?

  I want to populate  [AMMTran.OperationID] as the report parameter. I have added the parameter in the schema but nothing is showing up on the report screen.This is how I see this empty selector. 

We have created a GI that displays item availability and how much is available on a kit assembly. Currently, the qty available column is not showing accurate information. I would like it to sum the total qty available, however it is currently displaying the maximum value. Same applies with kit assembly quantity. When we aggregate these quantities to SUM, we move the date parameter - it multiplies all the values by 2x or 3x. I have attached the xml file of the GI, any recommendations would be appreciated! ​​​Hi @lauraj46, could you please review the GI and advise what I am missing? It is currently not showing accurate numbers. thank you in advance for your help!  

I am looking to simply sum the poorder.curylinetotal for vendors for a rolling 365 day date range. (between a year ago, and ‘today’)  I have messed around with DateAdd and DateDiff but have not had success getting the syntax correct.  Any help is much appreciated!  Thanks!   

Hello Community,I have a requirement where I would like to display the Contract Total in the report from the Retainage Section --> Summary tab --> Projects form.I have added the PMProjectRevenueTotal.CuryRevisedAmount. But if the Include CO checkbox is selected, the field doesn't include the calculated amount. As below: When Include CO checkbox isn't selected :And the report shows the following amount:Now when I active the checkbox, the amount changes to,:But the report still displays:9,862,000How can I get this done?,