Reports and Generic Inquires

How long should it take to make an open orders custom report ??

Hello, Can anyone tell me the DB values for the INPIDetail.Status field?  I need to check the status of a Physical Inventory Detail Line in a Generic Inquiry.Thank you,Dan Concannon

What table is the device information for a user stored?  I am trying to create a GI that will list each user that has a device attached to their account and the information about the device.

Hello ,I have created a GI but I want to convert the price base on customer currency (or by changing currency ID in Parameter ), How can I do it? My Default Currency is SGD but i want that when I will choose USD in my parameter it will change the Price in USD. Thank youJennifer

Hi,I am new user for Acumatica and have a question regarding adding email address in Report Designer. I am looking to add the email address of the user to invoice SO643000. My goal is when I click on Email Invoice under Invoice, it will send an email to the customer and also BCC to the user on the account. I have read some of the threads on the forum but it mostly just about setting up email but not on adding CC/BCC automatically.   I have try to use =Report.GetDefUI('RowAccessInfo.UserName') on the BCC field in Report Designer but it don’t seems to work. I try to use this logic in the Text Box and it does show the user email address.   Is there a formula or logic that allow the system to pull the user email address base on who is login to the site when emailing? Preferably in Report Designer and not Acumatica as I am not familiar with the coding and logic there.  Thank you.

I need to get some attribute values from the stock items form to a report (Modifying Sales Order Report SO641010.rpx). What are the tables to be joined in order to show the necessary value from the Attributes table to the report?

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.