Reports and Generic Inquires

I’m trying to get this check report to work with the checks our company uses, however, there seems to be some white space at the top of the report I can’t get rid of it. Is there some way to get the text, specifically the date, higher up on the printout? 

Newbie here, how can you pull the data from prepare replenishment into a generic inquiry.Given that our INReplenishmentFilter has Incoming References - There are no incoming references.Outgoing References - There are no outgoing references.To INReplenishmentLine

Hi, I have added a condition under row style to highlight records based on the profit margin. However, I have noticed that this condition is not working for those lines where revenue budget exists, but it is working fine if revenue budget doesn't exist under the project's Revenue Budget. For instance, in the below attached screenshot, you can see that the revenue to date is 0 for project P10221, and the cost to date is 487.50 which is highter than revenue to date. However, it is not highlighting this record based on the row style condition set under the GI. attached GI for your reference. 

Is it possible to use a GI as part of the data source / table in another GI.Background:We sell our products in an online store, we also have a customer that sells our products on their online store and we fulfill and ship these orders. This customer is also a distributer for us. At the end of each month we report the total sales (wholesale and online store) for this customer. The issue is the Online store orders come into our system as retail orders. We currently manually combine the sales numbers at the end of each month. I have a GI that pulls the Wholesale sales and a separate GI that pulls the online (retail) sales numbers.Is there a way that I can use the online (retail) GI as one of the data sources (tables) in the wholesale GI, similar to a nested query in SQL, so we just have one GI to run that give us the combined sales numbers?Thank you!

Any ideas on this one?  I’m trying to login to Report Designer and getting this error: Client found response content type of 'text/html', but expected 'text/xml'  

I appears that the Report Designers for 2024R2 is not backward compatible. This means a VAR that supports multiple version needs to reinstall Report Designed based on the customer version since you can not have multiple versions of Report Designer installed.

Currently, when we process payments in the Process Payments/Print Check, it defaults to Check Form. We want to print the Remittance as well. Is there a way to change the process to default to Check Form with Remittance?

I have created a Business Event that fires when the Status of a Purchase Order goes from Pending Approval to Pending Printinng (when it is approved) or Rejected (if rejected by the approver.   i’ve created the GI and have the CreatedbyID and their user name in the GI.   and the BE is firing off every time but i can’t get the email to send to the User that Created the PO.  If i put in my log in in the “To” field it will send me the email every time but i want it to go to the person that created the PO.    Below is the email templete.Below is the Trigger which is working according to the History.Could it be this warning causing the issue?i am the Admin so no sure what the issue is.   Below are the other fields i’m pulling.  

I would like to add the below payment Instruction details to the Vendor Generic InquiryRequired table name and Relations and fields to add on result Grid 

hi, I am trying to create a report for bill of lading. I have added 2 parameters one i item 1 and second item 2.Its work fine the only weird thing is that the report is duplicating the table. I have attached the screen shot of table. Please guide me on this thanks 

  Hi everyone, this might be something really simple but I tried adding a new column (YTD Prev) and it’s only the lines in the headers that are getting cut off.  What I did is put the next column in the column range but that doesn’t seem to work. Any input would be much appreciated. Thank you.  Thanks so much in advance. 

Is It Possible to  make Bar Charts / any other Type of Charts Using a PIVOT Table Created from a GI 

I’m trying to create a GI that shows ACHUPLOADS via Checks and Payments to employees and combining that with a Business Event notification. The problem I’m having is correlating the ‘Vendor’ with an email address (Contact > Email) of the employee. Could anyone help point me in the right direction? Attached is what I have in place right now. It pulls the proper data that we’re after but not the email.

Hi Acumatica Team,I have a issue whit a GI, I detected that Data Sourse: PX.Objects.IN.INSiteCostStatus does not exist in the new version 24R1, please could you confirm me what is the similar object of PX.Objects.IN.INSiteCostStatus in 24R1 version of Acumatica?Best Regards,Karolina Ramírez

Anyone know if it is possible to filter by the most recent record at the relationship level? For example: In the above join between the Customer and the CRActivity tables, is it possible to add a condition in the active relations to limit to the most recent record? I’m trying to get the last activity date, and I know I can group the records by the Customer ID and set the Aggregate Function to MAX on the results grid to display the last activity date, but that is causing some other unwanted issues with other calculated fields.

Hello,      We’ve designed several inquiries and dashboards. Some of which are with multiple parameters.Currently, the changing or selection of every parameter would start the search immediately.Like below, if “Date from” is changed, the search would start.  However, in some cases(for some inquiries/dashboards) , user would like to start search only after several parameters be chosen at the same time, please noted, not all the fields are required , how many and what parameters depend on the user’s wish.    The reason behind this requirement is due to performance issue. For some inquiries/dashboards, it would take a longer time to retrieval data, and that would make the system “freeze” a while. And user think that freeze doesn’t need.    The desired steps would be looked like, user select all the parameters he wants, can then click a search button, and then the system start to do search work            This is not really an urgent question or something must have. But I am just wondering

When trying to add Data scripts getting an error - Stated -  Error Code - 406 while clicking on OK after adding Scripts 

i have a Generic Inquiry that i have been using for a few months now and all of a sudden the Value for the Default Receipt to is showing up as a number.  I also have a problem with my filters using this same field so i think i may be related.  how do i get it to show the actual field value.    thank you in advance.   Below is the Stock Item  and below is a screen shot for the Results Grid.     

HiHow can I pass Class Item description of the inventory id and the sum of  projectreveneue budget.Amount based on the project and customer id in a sub report that is needs to be passed in the group footer of the main report which contains the project revenue budget details based on project id and customer id.I struggle to apply the variable declared in the detailed section of subreport to use it in main report to display     Item Class description     Sum ($ Subreport_amount)Thanks

Hi! I have a GI created where it shows all items on landed cost transactions. I am grouping by inventoryID because I only want to see one line per item. With this, if the item shows on more than one landed cost, I want to sum up the allocation amt field, and I do not want to sum up the qty and ext cost field. Right now, when I group by inventory, qty and cost field automatically sums up too. Is there a way to prevent these two fields from summing when I group by the item?For example:this item is on three different landed cost with different LC allocated amtwhen I group by inventory, I only want LC Allocated Amt to sum, I do not want the qty and cost fields to sumIn my result grip, I only have SUM in aggregate function for Allocated Amt Any suggestions are appreciated! Thanks!!

I am try to get the customer portal site to not automatically check this box, so that anyone who comes into the cases page sees all the cases, and not just their own. I assume it is something I have to change in the Customization Project Editor, but I’m not sure where the specific change needs to be. How can I automatically uncheck this box?

I have a consolidated trial balance report in Acumatica that combines my consolidated US tenant in a ledger, another CA tenant in another ledger as well as an elimination ledger.Is there a way to link this report to an excel so I just need to click refresh in excel instead of redownloading the file. Also, in the case of having a new GL, how do I ensure the report captures the changes?     

Hi everyone, I was following the suggested solution in the Report Designer Parameter relation customer id and customer location id | Community to create the parameter. I was able to output the Location parameter which is dependent to the Customer. However, it seems that the filter is not working. Output in report is still printing everything.  I tried adding the filter to the table that’s created relationship with. (Note: I cannot output this in the paramater as location the field is SOOrder.CustomerLocationID,CustomerID ) Do I need to create relationship now for the ARPayment? I have attached the report in question. Thanks a lot in advance. 

The report only has one table, INLocation.  I want a parameter linked to LocationCD to be a lookup.  I cannot get that to work.  Here is my setup: What are the rules for adding a lookup parameter to a report?

Hi, I am trying to get the total of the sales order (together with all the charges/discounts) I tried using the field [SOOrder.CuryOrderTotal] but when I tried to get the sum, it seems that it is getting the sum of all the line items. Do I filter them and how?Thanks so much in advance!