Reports and Generic Inquires

Hi, I have a problem when opening a report and creating a new report, Maybe someone knows why?I am using report designer version 17and acumatica version 2024 R2 

Hi, A client is looking to have a side panel on the inventory screen that shows the customers who purchased the item They do not want to see every invoice but a total quantity.  That is very doable with a grouping by Item & Customer.They also want to see last purchase information, the Quantity & the Unit Price & Date of Sale.  When I do the grouping the Quantity & Unit Price total. The Date Of the last sale is correct but I can’t get the quantity & unit price to show for the associated last purchase.Any help is appreciated.Bill 

Hello,I had a salesperson come to me and ask if I can make sure that the lines in her Project Quote match the lines that are printed in the report. I see for sales orders , SOLine.SortOrder can be used. However PMQuote.SortOrder doesn’t look to exist. Has anyone sorted the lines on a Project Quote?Thank You,Brent

We just realized that our SOOrder CreatedOn is giving us issues when we make the date today and OrderType SO.The number of records shows in the soorder field is not the number of records that it pulls in to excel sheet. When the OrderType is SO and CreatedOn is today. The records say 27 but ones I pull it to excel it gives me 24 rows. In excel 4 of my rows are missing.Also, the OrderTotal in sum up to $128,992.65, but in excel it sums up to be $51,072.68What could be the problem? This is GI 

Does anyone have a report suggestion for getting invoiced and entered orders within the same report (attached) without having to rebuild all the structure.

Hi Everyone, I am trying to create a GI that will breakdown the “Actual Amount” of the material account group on the Balance Tab of the projects’ profile, since I noticed the actual amount includes the cost consumed after LC adjustments or any form of adjustment after the PO receipt/INreceipt, Anyone with any idea on how I can achieve this?

Our financial officer requested a GI/report that allows him to see the amount of money we spent on goods for each month for each branch. I have gone around and around with APPayment, APTran, and APInvoice tables and I haven’t been able to find a way that allows me to getPayment Date (when the check was printed), Payment amount, which inventory items this payment was associated with (I was using the APTran table for this), and Branch (based on the APTran table)It seems like the inventory ID dissapears as soon as a payment has a closed status. I need the inventory ID in order to filter out which items are not goods or cost of good inventory items. Unless there is another approach that I am not utilizing. 

I checked the data for the date I filtered, and it has records. However, when I try to filter by parameter, nothing shows up.

We have several companies in one tenant, and we want to send batch payment remittances to different suppliers across these companies. Each company should have its own email template and sender. I tried overriding the Mailing settings for one supplier, but it didn’t work. Is it possible to send remittance email to multiple supplier with different email templates all-in-one go, and how can we set this up?

Hello!I currently have a report to show all orders entered for the prior date, and this is how it currently looks.This works fine but on Monday’s this will try and pull orders on Sunday (our company is closed on Saturday and Sunday). What would I need to add in this section to have this report skip the weekend and show me Friday orders on Monday? Thank you!

Hey guys, I found a place to assign a vendor specific PO report. however the dropdown list is not showing my custom report that i uploaded via Report designer. Also overrride box is greyed out. how do I solve this?  

We built this GI in 2024. it was just last week found out that some of the data is repeating itself. Either in a negative or different date  

Hi Community,I’m working with the Inventory Valuation report (IN615500) in Acumatica and I need to filter the report by a date range.In my report schema, the main table used is INCostStatus, and it only contains fields like: InventoryID CostSiteID QtyOnHand TotalCost ReceiptDate There is no transaction date or financial period field available in this dataset.My requirement is to:Filter the Inventory Valuation report based on a selected date (for example, valuation as of a specific date or between a date range).I’m considering adding a parameter and filtering using:INCostStatus.ReceiptDateBut I’m not sure if this is the correct approach for inventory valuation in Acumatica, or if there is a standard/recommended way (such as using financial periods or another table).Could anyone advise: What is the correct way to set a date range for Inventory Valuation (IN615500)? Is filtering by INCostStatus.ReceiptDate valid? How does standard Acumatica handle valuation as-of date? Any gui

I added the following formula to a GI: =[CSAnswers.Value]*[POReceiptLine.ExtCost]The value of CSAnswers.Value for one of the records is 0.204714, and the POReceiptLine.ExtCost for that record is 11,117.76. The value I get in the cell with the formula is 2,275.805472.The product of 0.204714*11,117.76 is 2275.96112064.After closer examination I realized that the formula is only using the first four decimals of CSAnswers.Value. So the value in the cell with the formula is the product of 0.2047*11,117.76 which is indeed 2275.805472.How do I get the formula to calculate the value using the additional decimals? 

hello all,After a bunch of research and import scenarios, yadda yadda, i found out how to shrink the amount of decimals the weight of our products is showing. However, when i edit the project, nothing reflect this change. I’ve edited it via the project editor, i’ve done the hard coding, i’m just not sure what i’m doing wrong. the internet tells me i need to enable and publish it, but the pages are already published. Do i need to take any further steps? 

Hi,Can anyone explain how to use LLike and RLike in Acumatica Report Designer?Do you need to put percentage symbol after the text or not?Thanks in advance!

We are using version 2025 R2. Whenever a GI or Pivot table is named (not shared), the same name appears on multiple and non-related screens. Refer attached screenshot. This happens with just about any GI or Pivot table filter. None of these are shared and yet these filters appear on non-related screens also. Clicking on them obviously displays an error message.How to fix this in such a way that these filters are available on related GI and Pivot table screens only? We don’t have direct access to the on-premise hosted application.

Hi, we have a GI that shows Won opportunities per period. Beside the $ value, there is a value that counts how many documents consists of it. However, it adds 1 count to in pivot tables. I’ve used all aggregate functions in Pivot table and Count Distinct is the best option which is still not correct as the value is still one off. If this is not a limitation, how do I correct this?There is no won in opportunities $50-100k (AUD), but it is showing 1 in the count column beside itUsed Count Distinct as the best option to show the ‘closest’ correct option 

I’m wanting to show the qty available in two different warehouses as two columns.  The records should all still come through, regardless of whether there is qty available or not.  For this reason I used a left join: But this left join should only be for records from a specific warehouse, so I added the following condition:  I would expect to see all inventory records, but only some are being returned.Do I have to use a subquery?  What is wrong with my condition that can be improved?

I build this GI like last year. So it was this year I found out that when I multiply AvgCost * QtyOnHand some of the results are off by cents. this is my results 

I’m trying to build a GI report based on INItemSiteHistDay, the end balance of in inventory after a transaction is considered as on hand quantity in the location. A date filter has been added to know a ending balance on the specified date, I have added a condition where INItemSiteHistDay.SDate is less than or equal to a specified date in the filter. The problem is that the report is showing all transactions before the date as shown below.Is there a way to show only the last transaction as on or before the date specified in the filter?

Hi everyone, I am working on a GI and I need it to display the number of days between the Last trans date of an item and current date (Today()), =DateDiff('d', Today(), [INTran.ReleasedDateTime]) gives me the right difference but in negatives as shown in the first screenshot and I need them show as positives.The following formulas are the other attempts I tried but they all gave me totally wrong values as shown in the second screenshot; =Abs(DateDiff('d', Today(), [INTran.ReleasedDateTime])), =DateDiff('d', Today(), [INTran.ReleasedDateTime]) * -1, =CDec(DateDiff('d',[INTran.ReleasedDateTime] ,Today())), =CDec(DateDiff('d', Today(),[INTran.ReleasedDateTime])), =CInt(DateDiff('d', Today(), [INTran.ReleasedDateTime])).Anyone with a solution for this or a workaround, I could appreciate.Thank you!

Is there a way to print multiple pro forma invoices at once? I tried adding “Print” to the Mass Action tab in the Pro Forma GI and it resulted in only displaying one report/print screen at a time. 

I want to click a button and print a report without the preview page, without the Windows print page. I don’t want to use Device Hub. Are there any other ways?

Within a import scenario, I’ve found this formula field that is causing problems. I want to locate it to fix the issues, but I’m not sure where it’s coming from. It’s considered a external field, so I assume a customization, but I can’t locate it anywhere. Is there a way to find it?