Reports and Generic Inquires

Hello,      In previous version (2020R2), user can print Released SOinvoice in batch on screen SO303000.In current version 2021R2, user can no longer print released invoice anymore, even if he select “show printed” button.        Why change the logic? We have the need to print all invoices of a single customer at end of month, no matter it released or not.         How can we do this in a simple way. Please advise.

Hello,      I am sorry. I don’t know whether it is too much to ask.We are using a GI as the datasource of Business Event to monitor the PO receiving.     The GI is with predefined monitor conditions by me.And I help change the conditions if user ask.         I know, I know, it should be not difficult to teach the user change the conditions himself.But the user I served is not so good at computer. And I am also afraid he might get something wrong if he works directly on Generic inquiry setting screen (SM208000).         Is there a way he can adjust the datasource without coming to Generic inquiry setting screen (SM208000).?

We have set up a notification for emails, however when we follow this process below, the notification is coming from elsewhere.  Where can I change this notification?Step 1 - select a customer from the below list and choose “process”:  Step 2:  Select “send” A notification now opens up and I want to modify this, but I can’t find where to do it (it isn’t in Notifications).Acumatica 2021 R2Build 21.210.0030

Can someone help me with what I’m doing wrong here please?I created a report joining 2 files to retrieve Customer #, Customer Name, Email address, and Date the Customer # was created.  Joining the 2 files to include the Email address returns the same line multiple times for some customers, while other customers only return a single record.What can I do to prevent the duplicate records?  

Hi,Is it ok to use SQL view in report designer. Whether Acumatica is planning to remove that option is near future ? Is there any other option other than SQL view, if I want to aggregate transaction quantity in released status for YTD and last year.Thanks,Shyam.

Hi everyone,Hope everyone is doing well.I have come across a Fonts issue where printing of invoices looks fab however the email copy is quite shaky fonts not showing as required.Not sure how do I resolve this. Below are 2 screenshots of how it looks Left shows when printed from MYOB Advanced => Right looks when its emailed out.Even the Logo has a some shadow on right.I installed the fonts on all the local PCs. Please help, any help comment really appreciated :) 

I have a function in a report that is not working as expected.  It should only show an inventory code if the type is “Finished Good”:=IIf(([InventoryItem.ItemType]='Finished Good'),[InventoryItem.InventoryID],'') This is only returning blanks for all Item types, but if I show the value in the ItemType field, it is displaying “Finished Good”. I’m wondering if the underlying data in this field is actually something other than what displays on the screen, like maybe FG or something.  But I have no access to the DB to find out.

Hello, I am creating GI for Pro Forma invoices, the main goal of the GI is to mass send out Pro Forma Invoices to customers. I am having trouble connecting the Activities information for the Pro Forma invoices (PM307000), see attached picture for reference.  I would like the GI’ to populate in a column if the Pro Forma has been emailed before or not. Below is a screenshot of the current results grid (last line):  When I run the GI, I receive the below error:  any suggestions on how to resolve this error? Thank you,KT

Hello,  I have an Opportunities report set up to send daily - the report is to show when opportunities have been created with no Owner ID. Does anyone know how I can set up the report to send only when there is data on this report? We only want one report per day, not each time an Opportunity is set up with no owner ID. Thank you!

I have currently been using the historical inventory valuation for reporting month inventory values. This report needs to tie to the the balance in my inventory account. To accomplish this, I am having to the use a start period that is the beginning of time to the current period. The report size gets larger and larger every month due to an additional months data being added. Are there any reports that can be run that do not include each months transaction details? Ideally, I would only need 4 columns:Inventory ID, Description, Quantity on Hand & Value for any given historical period. Any input would be appreciated!

Hi guys, Is there a GI behind the Approval screen? Trying to create a dashboard widget to show “My Workgroup Approval” but can’t find a way to assign users. 

Hello,     I accidently find pdf attachment size are 10 times different in size. like below, both are 1 page data. 1 is 128KB, the other is 4 kb.  I checked, both with the same setting “compress PDF file”, “embed fonts” So, I am just wondering, can anybody tell me what causes such differences.

Hi,Was wondering if anyone can help me with the table joins that are required for me to include SO header fields on my invoice reports AR641000 and SO643000Any help is appreciated TY!

For some reason when I expose the FS-ManufacturerModel GI to OData I cannot connect to it in excel.  This is the error I get: I was able to connect to the FS-Manufacturer GI without any issues.  We haven’t modified that GI so I’m not sure what could be causing the problem.  

hi, I’m not able to get the opportunities owner’s email. If I join the CROpportunities with Owner tables, i will get the error - Operand type clash: uniqueidentifier is incompatible with int.Attached it the XML of the GI. Hope someone could advise how I can obtain the owner’s email from the opportunities. Thanks

Business Event History shows that the business events has no issues and the email notification subscribers also has no issues, but when I want to process the email, I could not find the email notification under Email Pending Processing. Hope someone can advise why and how can I fix it. thanks 

Hi Guys,Hope you are doing well..!I’m also facing same issue, I’ve added a annexure (Terms & Condition) page on AR Invoice “AR641000” format. but when I view report in PDF viewer or export to PDF then some content will cut off and content is fully printing on normal view.here is the condition and setting I've set on the group footer section part. Since Terms & Condition content is very long. so it should go to 2nd page. how we can solve this ? Groupfooter section setting

Hi All,We have a custom made report to show the balances of inventory stock items including their images.The report runs ok without images but it crashes when we execute it with the image option.Also it runs fine for a small set of data with the image. So the problem is when you have over 1000 records to be loaded with the images.This is what that is used to load the images at the moment:Could someone please let us know if there is a way to optimize showing images?.Thank You

Have custom report created in Report designer. Long comment field on the report ic cut when exported to PDF. Tried to add some spacing between sections - no change. WratText=True, CanGrow=True for the field. 

I’m creating a notification template using opportunity details screen (GI). In the “To:”, I would like to send to the owner that creates the opportunity, but I can’t seem to find it in the entity here. Is there any way I can do it?  

Hi. Is anyone encountered this? I created a discount and it duplicates in the generic inquiry I am creating. Also, how can I get the value of its discount percent?  Thank you.

Hello,      I have a need to find the modified lines.It is simple in GI by using below way: However, the same method does not work in Report Designer, even I change “Greater” to “NotEqual”  How can I achieve my need in Report designer. Please advise.

An inquiry that was working fine started giving this error.  When I create a GI with just SOShipmentAddress or SOAddress in tables and put SOAddress.AddressID in the result grid and try to view the results I get error: Object Reference Not Set to an instance of an objectIf I view the trace log it has: An unhandled exception has occurred in the function 'IsValidateRequired'. Please see the trace log for more details.immediately before it. Does anyone know how I should go about troubleshooting this? Phil

Hello and good Saturday everyone!I am wondering if it is possible to hang a “print report” action inside a generic inquiry?I noticed that you can export a GI to the Report Designer and build a report there, that you could upload back to acumatica and create a sitemap entry. But is there a way, like it is in normal screens, that i can hang a action to print the report inside of the inquiry?Greetings 

Hello,I am wondering has anyone came across this odd anomaly during SO Quote creation?Everything was entered line by line and when I printed the report it duplicated each line.The crazy thing is everything add up correctly.  I checked the SOLine table for this quote and it is fine there was no duplicate data.  I checked the report and it looks fine too.  This duplication did not happen to other quotes just this one.  I copy the quote to another quote and the same issue happened.