Reports and Generic Inquires

Is it possible to display the discounts created by line level discounts from the sales order on either of the invoice printed documents?

Hello all,Trying to build something based on a concept from a great session at Summit 2024 - open to any ideas on this.Goal: Capture the value(s) from fields presented in a workflow dialog box and present them in a generic inquiry.I created the dialog box within a custom Case workflow in Acumatica CRM. The dialog box has 3 different prompts, all of which I would like to capture.The mission is to join that dialog box info with the PX.Objects.CR.CRCase DAC. I believe this is possible based on @Doug Johnson ‘s session :) but I can’t seem to find details on how to configure this when I check the documentation, but I might be looking in the wrong spots. Investigation so far:If I try to inspect the element (1) upon launching the dialog box I see that the business logic is part of CRCaseMaint. But if I attempt to (2) View Data Access Class Source ….   I get crickets:  So, if they’re not here, where can I find them, and then join them to the Case in a Generic Inquiry?Thank you for any input.Ar

Hello - Does anyone know how I can get this field to show up on a GI? It is on the Customer screen under the Billing tab. It seems when the “Override” box is checked, that it will not appear. However if there is a value there and the box is not checked, it will. I am not sure why some are checked and some aren’t either? Maybe an update changed this? Note - this information does typically come from an API connection to a separate system.. not sure if that plays a part.. any help would be appreciated!  

Hi,We are attempting to expose customer specific files on an Acumatica portal via a Generic Inquiry. We already have one that exposes common files associated with the customer using the @me condition which works file.  These files are associated with a property and have the “Is Public” option checked in the file Maintenance screen. We are linking the usual suspects: Contact → Customer → NoteDoc → UploadFile → UploadFileRevision We are adding the files on the customer screen.  When the GI runs in Acumatica, and the @me disabled, we can see the files. In the portal, with and without the @me enabled, we cannot see any files.  We also checked and unchecked the “Is Public” checkbox, without success.  We also attempted to add the files to the customers associated business account, replacing in the GI the customer table with the Business Account table, also with no successes. What are we missing?   

I have a customer that has multiple tenants, and I wrote a SQL view to view all of the users across all of those tenants for administrative purposes.I would like to add a Navigation to pull up the full screen User (SM201010), as a Side Panel link.  However, two things are stopping me. I can setup a relation to pull these data and display it by linking in the PX.SM.Users to a Key in the SQL View. However, I can only pull the users data from the “active browser tenant”. In the SQL view I do store the CompanyID for all the users over all of the tenants, but I do not know of any way to pass that value to the Navigation link so that I can pull any user information from across all of the tenants, unless I have changed the browser into that tenant as a session.Is there any way to pass the CompanyID over to that navigation link?(and I can accept the answer of “NO”. LOL)

Like the title says, I am trying to create a GI that shows all late shipments, whos orders didnt contain any shipments prior. This may be too much to ask for. I am new to GI’s and am trying to figure this all out. Any direction towards if statements within GI’s would be helpful and any help on this particular question would also be appreciated. Thank you! Attached is the GI I have been working with.

Hi Good Friday! I am trying to pull the UNIT of measure conversion details into GI. I am able to generate the GI as needed however I identified every stock item showing false even SKU does not have unit of conversion.For example Below SKU has no Unit of conversion  Another SKU has conversionsit shows two time in GI  During my Observation every SKU has one record saving in DB, How can get the exact records with out showing dummy information

Hello all,I have the below Po order details & the result in PO Order report:The Inventory IDs are same for all, but have modifications made in the Line description column PO Order report PO641000When we compare the above screenshots we see that the Line description are not on the same line number as in the PO screen (PO301000). So I am looking to print the descriptions & details in the same way as they are entered in Line level in PO Order.How can I achieve this?I tried the below in report designer, but still no changes, Thanks. 

I would like the “Service Orders” tab to be shown in the “Payments and Applications screen in “Receivables” as it does from the “Prepayment” tab in appointments. As you can see in both images, it says “Payments and Applications” but one screen does not have the “Service Order” tab.I would like this option when coming from the “Receivables” module so the Accounts department does not have to open an actual service order to apply a prepayment so prepayments are properly recognized from a Job and Accounting view point. Any thoughts? Screen from “Receivables”Screen from “Prepayments” tab form an Appointment in a Service Order 

We had a Project Inventory Location GI we had created in 2022R2 we use heavily.  Now that we are upgrading to 2023R2, the GI has to be re-written because of the PMLocationStatus and PMLotSerialStatus tables having been removed in 2023R1.  I’ve been trying to get the GI modified using the table references in the Release Notes for 2023R1.  I am apparently missing something.  I would appreciate help reviewing our original GI (titled Project_Inventory_Location.xml attached here) against the version I am working to modify in our SANDBOX for our upgrade to 2023R2 titled MR_050724_Project Inventory Location.xml attached here.  The modified GI is creating duplicate rows.  I’ve reviewed the GI and am not seeing the reason for the duplicate rows being returned.  Thanks for looking and any help you might offer in advance.

The refresh in Power BI on all reports running form Acumatica GI’s are being blocked after upgradeing to 2023R2 (build 23.211.0017 ).For each refresh the following error occurs:‘The field ‘BegPeriod’ already exisits in the record’This message shows up for all reports where different GI’s are used with different tables. 

Does anyone know how I can get the calculation in a generic inquiry for a fixed asset? Currently, the calculation is only shown in the asset depreciation history, which you must look at each individual asset. 

I have a GI titled New Accounts. Sales reps get either a $500.00 bonus if their first initial order with a new customer is >= $5,000.00 - $9999.99, and $1,000.00 if the initial order is > $10,000.00. My IIF statement is as follows:=IIF([ARTran.TranAmt] >= 5000.00, (IIF([ARTran.TranAmt] < 10000.00, 500.00,IIF([ARTran.TranAmt] >= 10000.00), 1000.00))). The Inquiry errors out when being run. I’ve tried using SWITCH also to no avail. Maybe my syntax is not correct? It does Validate with no errors. 

Hi All, Is there a way to format the quantity to exclude the decimal point in the email template?for example instead of 1.00 should be presented as 1.  Appreciate any help on this. Thank you. 

Hello all,Is it possible to display the data separated into different weeks. So if I select a financial period, the report should segregate & display the data based on weekly format.

We have 9 fields in a tab under contacts in Acumatica and in order to get credit for it our sales representatives must have at least 3 of these fields filled out with some form of information, my manager has asked me to figure out a method of filtering down the list of Contacts to just those that have a minimum of 3 of these fields that are not Null in value. how might I go about doing this?Attached are 2 images, one of the fields as they look under the Contact Profile and the other is how they are in the results tab of the Generic Inquiry (GI) editor.

Hello,I'm seeking a method to determine the remaining balance of an invoice as of a specific date in a generic inquiry. Consider the following scenario:Initial Invoice Amount (01/01/2024): $1,000.00 Payment Made (02/01/2024): $400.00 Payment Made (04/01/2024): $200.00 Payment Made (05/01/2024): $300.00 Current Balance: $100.00My goal is to find the balance of the invoice on a past date, such as $400.00 on (04/25/2024).While I can join the ARInvoice with the ARAdjust table and filter by the ARAdjust entries made before my specified date (04/25/2024) to calculate the total amount paid, this does not provide me with the balance. Unfortunately, the ARAdjust table lacks a field that reflects the document balance after each transaction. Thank you for your help!

I am attaching the basic GI I am trying to create which all it is doing is displaying the PMActivity information and then simply converting the PMActivity.TimeSpent from Minutes to Hours by dividing the minutes by 60.  HOWEVER, Acumatica is NOT calculating this correctly, as you can see from the screen shot below.  One of the returned rows calculates 28800 / 60 correctly to 480 hours. But the OTHER two returned rows are NOT calculating correctly at all.  Not even close.  29070 / 60 should = 485.5 hours.  And 31920 / 60 should = 532.  NEITHER of those are even close to Acumatica calculating them to be 421 and 439 hours respectively. Is this a major Acumatica bug?  Or is this simply something that Acumatica cannot do, and is there some way to simply have it perform this automatically?Here is the equation from the attached GI  

I’ve run into an issue where particular inventory records are being ommited from the GI results when I turn on group by ARTran.InventoryID:   Ungrouped: Grouped on ARTran.InventoryID I’ve attached a copy of the GI.

I’m wondering how to create a GI that will list all warehouse locations that are empty so we know where to put away newly received goods. 

I have a bit of a complex task given to me that I suspect is reliant on Parameters but I have no idea on how to go about having multiple date parameters existing at the same time without causing conflicts or maybe I am going about this wrong.So in the report as it currently exist there is only a start date and end date Parameter, what I need to do is get another field within the report that pulls the net sales for a month prior to the selected start date/end date and then the net sales from the previous fiscal year.the Net sales is pulled from ARTran.NetSale like this =sum([ARTran.NetSalesAmount]) 

On the system monitor screen,In the “Running Processes” tab we see reports, but not GIs that are launched.In “Requests in progress” tab we see GI queries, but there is no button/action to abort the query, That is taking longer time to execute .  

I’ve created a report that groups Inventory Items so that I can sum Qty Produced for each item over a given time frame. The goal is to have a column for Inventory ID/Description, a Qty Produced Goal Column, and an Over and Under Column for the sum/difference where an item was over or underproduced where even if the item has not been produced, it would still show on the report. For instance, no CHOC400 had been produced, it would still appear on the report, where:Goal = 700Qty Produced = 0 Under: -2060Instead the report is only showing if the item has been produced. So, for example, an inventory ID, CHOC400 which has not been produced this month, isn’t showing at all. How can I fix this? I’ve attached a copy of the .rpx version of the report that’s saved as .doc so I could upload it.  

We are having a problem trying to use Create Transfer Orders, in that when we try to process we get an error that CS cannot generate the next number.   This causes two problems.  We have to create the transfer manually,  and the prepare replenshment report wont reccomend a quantity because there is a value “in replanned” Does anyone have ideas on the cause of the errorAlso, does anyone have ideas on how to clear those items “in replanned” Much appreciate any feedback  

Hello everyone,I have a question regarding report designer.I would like to display in the report a file name that exists in a SharePoint directory and not the entire link.Is it possible to do this? Thank you in advance.