Reports and Generic Inquires

I’m trying to filter results on a GI to @today but it returns 0 results.  I attached the GI.

Hi All,I am trying to create a report footer which contains multiple item details. Multiple items are show in the main PO but when I transfer the same fields to report footer section, only the first item is displayed in the report footer section.can someone please help?Thanks  

Hello Acumatica Support i want to know that is it possible to get column count in groupheadersection of acumatica report designer please check the below requirements for batter understanding…want to get sum of column in groupheadersection for exp..here have 3 rows inTotal Work (Incoming calls + Assigned Cases)244i want sum of Total Work (Incoming calls + Assigned Cases) column here have 10 want to store that result in one variable inside the groupheadersection  so is that possible or not ?  

Is it possible to add global variable in Acumatica Design reportRequired to add global variable to use in other section of report Requirements Using one Main report and from that use sub report and access sub report value in main report in header part but facing one issue that sub report value access only where subreport control is define so in my report set subreport in Header and then i want to use that value which is return from subreport in group header so somehow currently i am not able to access value out of the section even used assign functionality also but that is also not working  Thank you for help in advance…. 

Yes the modified check is selected as active.  what I DID: under payment methods I have selected checkThen under settings for use in AP I selected the AP641000 Check Form with Remittance.  Under the AP menu I select Check Form with Remittance and click on the Edit Report and did some minor changes. Just moving fields on the check itself.  I saved the report as new version check box and made sure it is actived. Then I go to Process Payments / Print Checksselect Checks, enter the account and next check number click on process and the check generated looks like the check unmodified. Are my assumptions correct, that selecting AP641000 under payment methods for Check will make the system use the latest modification under Check form with remittance (the one I selected) or am I missing something here???? Any help would be appreciated

In the Projects form in Acumatica, if we attach more than one file in the record, how can we select one specific image file to be selected and printed in the report, this image file will have a specific naming convention so that it will be selected to be printed in the report. How can I approach this development?

Business Requirement- Send a product review after the Invoice is closed.We have created a below GINow in the Template, we need a display the Items with Image when we have multiple Lines.We are displaying the Line Items in a same row because of our business scenarioIn the GI the inventory Info is listed row-wise which we need to show as columns in the notification template.Expectations in the template as shown belowI am expecting those 3 Lines as below in the notification template. Acumatica responded this required customization- Need your thoughtsFor each loops can loop through multiple rows on a GI based on same reference number, but will not loop through multiple data fields listed on the same row on a GI.  SKU Image 10343886230   85126691547   85126691555    

We enter order transfers between warehouses. When we create the order, we override the Ship To Contact Account Name with a Customer Name. I have setup the Pick List to show that name on at the top. The report customization works well until multiple Pick Lists get printed at the same time. If that happens, all the pages show the same name at the top. I have tried to mimic the Shipment Confirmation setup to keep this from happening but can’t get it to work. What am I missing?Printed with 000494Printed with 000493Printed individually 

Hi,I want to get the information on the applied documents to the Payments and Applications form (AR302000) to a copy of the standard report that we are customizing. The standard report is AR Register Detailed (AR622000). We have used the following relationships to get the relevant data to the report.But the data does not display in the report as expected.can anyone please assist me on getting the relevant data to the report..

Hello,I’m trying to add the Available for Shipping calculation to a couple different GI’s but can’t figure out where it’s stored.  Everywhere I look either doesn’t give me an Inspect Element option, or it does as an Enquiry that I can’t get to work on the GI’s.  Any help would be greatly appreciated.  Thanks!Nathan 

Hi All,I am trying to figure out what the formula would be in order for me to track invoice balance for the last 30 /60/90/over 90 days. I have modify a report base on AR.63.30.00 AR Balance by Customer MC.Currently the formula $StCycCurrTot / =$StCycAgeTot00 / =$StCycAgeTot01 / $StCycAgeTot02 / $StCycAgeTot03 are pulling a sum base on the month and not by how many days the invoice is open.  If you look at the above example, you can calculate that Over 30 Days don’t add up properly as Today is April 18, and the transactions that should have been added is between Mar 7 to Mar 15. However if you add all the March transaction together, the value $6863.91 is correct. The goal is for this report to show balance based on the number of days and not based on the month. Thank you.Calvin Law 

I have made a new inquiry about payment screen and I want to add an option to show all status as well as each status filter in this inquiry. Is it possible to add “all status” in the dropdown filter of generic inquiry? 

Is there a way to select multiple rows in a Generic Inquiry? I have an inquiry that I am using a side panel on and I would like to select multiple records in the GI and send those to the side panel. This works great with the single selected item but it would be great to do for multiple.    

Hi All,As per customer requirement, we will send a dunning letter following Customer Order Nbr.So, on the Dunning Letter AR661000, we want to add a filter that allows us to select multiple documents belonging to 1 Dunning Letter and print it.Is it possible to add a parameter with the multiple-selected option? If yes, how can we do that?Thank you,Yên Chi

I have a Scorecard on a dashboard that show ordered that were invoiced yesterday. In the parameters for the scorecard I have Created On is equal to @Today-1.This has been working until today (November 1, 2022). This morning the score card shows 0 invoices created yesterday, when there was one created. If I change the parameter to Created On is equal to 10/31/2022 the score card shows 1 which is correct.Is there some issue with @Today-1 when at the beginning of a new month, or is there a better may to automatically pull yesterday from the score card parameter setting?

We have recently updated from 2020 R2 to 2022 R2 (don’t ask) and my dashboards have gone wonky.  I had many score cards with color coding - most are not visible now.  I can’t figure out why.  If I change them to meters they work fine, but as scorecards they show up - at best - like the KPI on the right of my screen shot (black text on white background), but the vast majority show as white on white unless they’re moused over.  I tried deleting one and adding it back in, but the results were the same.  Hopefully someone can help!  Thanks!left score card is being moused over 

I have an issue on my dashboard where creating a KPI scorecard gives me the following error: “Conversion failed when converting date and/or time from character string”. My GI’s work perfectly on the dashboard when in data table format, and even in the GI itself I am able to aggregate the column on the bottom of the screen without issue. For some reason when I create the scorecard, I receive this error. Anyone seen this before? (attached XML for the GI in question)

Hello Friends,How do I configure a custom-built report to send off Monthly/Weekly using business events or automation schedules? My report does not come up in the screen name selector in the Business Events.I tried using automation schedules, but I’ve been told those might be going away. Also, I couldn’t find any of my parameters in the Automation Schedules either. This report I want to send out will have 140 parameter iterations, so it’d be REALLY nice if there’s a way to run an import scenario for this in either the business event or the automaton schedule.Thank you for helping!

Hi all,I want to add tab Landed Costs to PO Receipt report but when I join, the inventory is doubled. If you have any idea, pls help me.  

Hi,I am not so clued up with report designer. A customer wants a report that will show time invoiced per project, broken down by week and day.We were able to create a report but when the ARInvoice as the invoice number is the parameter, is linked to the lines duplicate.Any ideas, please!

Hi, i encrypted the “TaxRegistrationID” field for vendor with a customization project using this Acumatica Article: https://www.acumatica.com/blog/technical-tuesday-encrypting-fields-acumatica-database/I replace the PXDBString attribute with PXRSACryptString . Now the field is encrypted in the database but in the UI we can see the real value. Thats what we wanted.If i make an api call to Vendor end point i do get the real value but if i export the vendor or add the field to a GI i get the encrypted value.How can i get the real value in the GI?

This is a duplicate post to : Curious if it’s possible to compress 2 Report Designer pages into a single final output page. The case we have is that we have a long item list that a customer prints and then hands out at their retail location. The issue is that the item list is multitudinous: 100 pages of items printed in 8 pixel font size. Goal: print multiple report pages per sheet, or create a Report that has multiple columns of item data under a single Report Header (this would be nicer for formatting IMO).I saw something similar being asked here.When I attempt this with a Print dialog, I’m not seeing the expected 2 pages per sheet, and I also see unexpected spacing in the print preview, despite having set the visible expression in the Group and Report footer to ‘False’.Any ideas would be interesting!Arline

Would like to see in the Generic Inquiry list columns with “Last Modified Date” and “Modified By” to ensure that we save all inquiries before a major update. It’s difficult to determine if someone has modified an inquiry that has not been backed up without this information. There should be some kind of audit trail for this.

Hi! I have a BA that trigger a notification for cases. The BA works fine if the case is created within the regular instance but when the case is created in the Self-Service Portal, the notification is not triggered. Attach is the BA xml. I tried to replicate the solution provided in the topic How to setup a notification when a client opens a case through the self-service portal but it didnt work. Actually, I dont undertsand why is needed the portal map for this to work.Thanks! 

Hello,I have a problem while I am export report to PDF that containing Chinese character inside. Inside the report page, the character is showing, but once I exported to PDF, the Chinese character becomes blank spaces Hopes you can give me the solution.