Reports and Generic Inquires

Hello. I have a problem with Report designer. Today it works fine. I was working on the report and suddenly got electricity cut-of. And after i got it back report designer always shows me this error It said that “Unhandled exception in application. When you click on the "Continue" button, the application will ignore the error and try to continue working. When you click the "Exit" button, the application will exit immediately. Root element is missing”

I am printing  AP Payment data in a sub report. The first line prints an empty line for the shipment number ‘20231414’. But when i pass a different shipment number it doesn’t print the empty line. Is there any way to fix it ? This is when passed shipment number 20231414 as a parameter. This is when passed a different shipment number  Also some of the rows in my report are not in line 

Hi all,I have a problem when I create a GI for showing scan details. I get data from the audit history. The problem is the data combined with NULL. How can I replace them in the GI? Even I export it to the excel, it’s not editable. I prefer to use GI, report or in the excel. I know it can be done on database level with using sql. But I don’t have access rights.   Doesn’t work 

I have one problem. I need to group into one item items that have same inventoryId(they are duplicated i don’t know why  i need to make it like That what i tried already but didn’t help  

I am using INItemSiteHistDay to write a GI for inventory aging.  The field INItemSiteHistDay.QtyIn is available for the results grid.  However, INItemSiteHistDay.QtyIn and INItemSiteHistDay.QtyOut are not available for formulas or selection criteria.  I need the QTY for every transaction in and out of inventory and these seem like the 2 fields I need.  I’m unsure why they are only available to the results grid.Thanks for any guidance!

Good morning all, We’re on 22.110.0018.In vendor shipments, our printing menu options are disabled. Please see screenshot below:The links for vendor packing list and pick list reports still work properly: ***/(W(148))/Main?ScreenId=AM642000***/(W(148))/Main?ScreenId=AM644000 Is there a way to relink these manually in the menu without creating a customization package? I see a possible similar issue mentioned for 2020:   

I am looking to add hyperlinks to the below highlighted field in a GI similar to the Approvals screen: How can I achieve this?

Hello Community,I have a code line that I am trying to apply in report designer too but haven’t been able to. The Code is:[SOLine.LineNbr]-1) Mod 8 + 1How can I apply the same code in my report designer for a field?

Hey Acumatica Community,Just wanted to share a write up on something that I have been utilizing frequently to get results that Clients have been wanting in their Generic Inquiries. This is not of my own invention but something that I learned how to do on the Acumatica Community forums and have had the need for on many occasions for varying scenarios. Get ready for a slight read but if you're interested in learning/understanding how to isolate the most recent record entered into any data table in Acumatica then you're in the right place.I was unable to copy paste the document directly into this post, so you will need to review the attached .PDF file. The .XML file for the Generic Inquiry from the document is also attached here to this post.Credit for this method belongs to a user in the Acumatica Community who goes by Gabriel Michaud. Here is a link to the original Community post where I found this method that was presented by Gabriel as an answer to someone else’s post. How to get the

Hi all, I am having an issue where the Korean characters are not exporting to pdf when I export the Invoice.The stock item description shows in Korean on screen but not on PDF. I tried to change the PdfDontEmbedded to true, also installed the font Arial Unicode MS to the C:\Windows\Fonts, but still not working. Any ideas?  Thanks, Patricia 

Hello,I edit a lot of reports and always log in as ADMIN.  Now, when I open report designer and type admin@ I get a huge list of past tenants I have logged into. Is there a way to edit this list of cached past admin@ logins I have used?Same question for URLs, but the admin@ login is the list I would really like to reduce.Thanks for any thoughts!

Hello ACU Community,  I’m running into an issue with printing 3 column labels on a report. Followed the link in the article here to initially set it up; https://www.mibar.net/blog/printing-3-column-labels-in-acumatica-report-designer/?unapproved=27946&moderation-hash=2d1f4c0db9d378a80cc80535408f5b6c#comment-27946.  Also, adjusted a few section of this report with the help of ACU but the report still does not print correctly. The report is printing all records in one column instead of 3 columns. See attached.  Thanks! Eric   

We have a modified sales order form with a text box in the header. The content to the customer is the main part of the text. Depending on whether the sales order is international or not, depends on the email address embedd in the text. For example, if the order is international, then the customer will be directed to email international@ourcompany.com, if not international, then sales@ourcompany.com. I’ve tried googling it, looking at Augforums and have come up short. Any  help will be appreciated. My other thought is to have two different forms, one for international, one for other, but I’d rather use one if possible.

Dear All,            Here I used Sorting But Not working, With Group can sorting or not please help me to solve this issue, I Want to sorting Red Color Highlighted, Grouping yellow color text, I want sorting as following ID Ex:-4465,4466,4467, 4468,4469,4470 and 4471,4472,4473….etc 1.Quality of Product/Service 2.Quotation/Piece 3.Delivery Lead Time 4.Payment Term like this I want to SortSorting I used above Red Color Highlighted ID 

Community,I am attempting to add the table POOrder to the Journal Transactions for Account report in Report Writer.  The field that I have been asked to pull in is the POOrder.OrderDesc field. My struggle is finding the right way to tie the table in with relationships.This is the current relationship set up: I have looked through the DACs and have not been able to find a way to link the POOrder table to any of these other tables.  Does anyone have any ideas on how to make this work?Thank you in advance for any help!  

Hi,For some subreports in my main report : In acumatica preview i have 25 rows , it’s fine If I export it in excel, i have 25 rows, so it’s fine too If I export it in PDF , its seem to be cropted , i have 21 row. What can be my problem?Thanks!

Hi! I’m using the formula editor on generic inquiry for this formula: =IIf( ([POReceipt.Status] = 'R' And [INRegister.Status] = 'R') And  ([POReceipt.OrderQty] = sum([INRegister.TotalQty])), 'True', 'False' )It validates correctly but when I run it, it returns this error: Column 'POReceipt.Status' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.Column 'INRegister.Status' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.Column 'POReceipt.OrderQty' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. Any ideas how to troubleshoot? Attached is GI and this field has the formula:  

I have a number of customers with a contact that has Override set on the contact’s address, and the address itself is blank.  I want to unset the Override value so they inherit the customer address.  I’m trying to create a generic inquiry that looks for contacts that match this, but Contact.OverrideAddress never returns a value, even on records that I know are set.  Looking at the DAC, it says “nonexistent in DB” so I don’t know how to find it.  Where do I search for that override setting?

Is there a way to navigate from a field on a printed report to another printed form? For example, we have the AR Aged Period Sensitive report and would like to be able to click on the reference number of a document which then would open up the printed invoice. Currently, the invoice screen is displayed when clicking on the reference number, and then one still needs to print the form from this screen. Is it possible to navigate directly to the printed AR641000 form, skipping the invoice screen?Many thanks. 

Dear Team,Let's say the report has multiple pages. How to display only the first page when pressing “RUN REPORT”?  Best Regards,NNT

Hello,I am creating my first subreport and have a very basic question.  My subreport works.  I have no selection criteria or parameters.  It just spits out all the data in the table.  Only a few records in it.However, I want the subreport to only show records relevent to the main report when I place it on there.Specifically, this is to print relevant discounts in ARInvoiceDiscountDetail when printing an invoice.So I assume I have to create a parameter on my subreport, and pass the invoice ID to it from the main report so I only get the discount records associated with the invoice being printed.Like I said, this is my first one using the reporting tool, so I’d appreciate it if someone could provide detailed instructions on this?  I have viewed videos etc and they seem to skip over this basic linkage.Thanks!

Is there a standard report that would allow me to see all Purchase Orders that have been linked to a particular project number? 

Hi everyone, I created a dashboard chart to show top 10 customers we billed this year vs. last year. The underlying GI is simply using the ARInvoice table to pull out all invoices with positive number and credit memos with negative numbers without grouping. I then added a new column using the Year () formula with DocDate to get the Year field. The widget settings are below.However, the result seems to sort by the sum of this year and last year total. So it looks not perfect for our client.Is there a way to setup the sorting by 2023? Please help! 

I am working on creating a dashboard chart to show top 10 customers we billed this year vs. last year. The underlying GI is simply using the ARInvoice table to pull out all invoices with positive number and credit memos with negative numbers without grouping. I then added a new column using the Year () formula with DocDate to get the Year field. However, when I put the “year” as series, I got error. Can someone help me with it?I also tried to link the ARInvoice table with MasterFinPeriod table to use FinYear field, but I got the same error for the dashboard chart.

Hi Everyone, Is it possible to create this scenario in Report Designer? Upon reading some articles creating a running balance in GI is not possible.   Where in the Depreciation stop if it identifies a certain value? What reports can I adjust or revise if ever.