Reports and Generic Inquires

Hello. I need a resulting statistic that shows me Inventory Turnover Ratio: (This measures how efficiently you sell through your inventory.)Has anybody done this yet on an acumatica dashboard, and if so, can you share the method here? Please and thank you

I am experiencing an issue with Report Designer. When I make changes in Report Designer, they appear in the preview tab but do not reflect in the URL.Please note that I have saved the changes to the server with a new version and activated the version in Acumatica. My user permissions allow access to Report Designer, yet the changes still do not appear. I specifically tried modifying the dunning letter printing format in Acumatica.

I have formula that can grab all the differences in expected vs real dates, but how do I tell my AVG() aggregate to ignore any zero values in the formula (i.e. the false branch of the statement below)? =AVG( iif(DateDiff('d',[POOrder.ExpectedDate],[POOrder.UsrOrigPromDate])>6 OR DateDiff('d',[POOrder.ExpectedDate],[POOrder.UsrOrigPromDate])<-6,DateDiff('d',[POOrder.ExpectedDate],[POOrder.UsrOrigPromDate]),0))I tried using the empty set instead of zero, but it gets angry about it not being a number. There has to be a way to just say “Skip this row” based on a condition. Can someone save me?

I was looking through other forum posts trying to find a solution to a long standing request regariding Inventory Valuation report where my supervisor would like to run it by date, he linked me to this post  which I have already gone through before but hit a dead end as they state you can use an If statement to allow the date range to be input but I cannot seem to properly format this nor wrap my head around how the parameter would correctly engage the data sets the way they have shown it built. any help with this would be greatly appreciated.

HiMy asset already fully depreciation with 100 salvage value. After that, i want to change the salvage value to 1. Is there any option to trigger depreciation for amount 99. Asset with fully depreciation status, we cannot trigger Calculate Depreciation process.  Thank you,Nas 

How can I retrieve the date when the status of a sales order changes from 'Open' to 'Completed' using a Generic Inquiry.

Hi! Is there a way to identify $ amount of what is shipped on a SO and the $ amount of what is not shipped on the SO and put them both in one GI? I am guessing you can’t do this but would like to be confirmed. Any ideas on if this is possible?Right now I have a GI where I’m using the formula qtyhardavil >= openqty to determine where an item on the SO is Shippable or not. Not what has shipped and not shipped from the SO.Thanks!

Hi, is there a way where I can show all stock items their QTY on hand, available, location, and lot/serial number all on 1 GI? similar to inventory summary screen (whether it has a lot/serial or not) but in GI form? It seems like they are two separate tables being I would like to show lot/serial number as well. any thoughts are appreciated.

Hi ,I have a requirement to create a generic inquiry to see the projects revised budget (Original + Change Orders) for a given date. It needs to be able to select the date as a parameter and system show the total revised budget for the parameter date. I tried creating a GI but it was not successful. Do you anyone know a table to fetch this data or way of creating a GI to get this results?Thank You,Dulanjana

Good day, we have a client that has suddenly received an error on one of their Generic Inquiries.On the Main GI there is an exclamation mark that states System was not able to get record count and there’s an exclamation mark in the top right corner indicating that the number of records is capped at 50,000On one of the exisitng filters it states: The exact number of records cannot be retrieved. During export to Excel top 1000 transaction records will be exported.See screenshot below.Version 2024R1 PCS on an Azure server  

We have a newly created report that we would like to add to certain customer’s Mailing and Printing setting. When we attempt to add the report it is not found under either Mailing ID or Report ID. What is the process for adding a new report to these setting. 

Hello! I received the following error when trying to open a GI that I have created. I’m assuming this has to do with customization projects? The system recently got upgraded to 2024 R1, and the customization projects are published. Any ideas on where to go for this? Thanks!! 

We have a custom GI which is showing this message in the status bar:Same query exists in two tenants but only one of them (the one with more data) shows the message.

We are designing a new form where by we need to have a FROM: and a TO: using the first of the current year and the last of current year for the period. We would like to use @YearStart, and @YearEnd but are not quite sure where and how to code it in the Report Designer, or if parameters need to be stated first in the Schema. Most, if not all, of our reports have a date already associated with the type of report needed, but in this case, none of that is present. The initial form will be a “blanket” form just to get started. My code in the groupHeaderSection1: I have one text box: [=’FROM:’ + [@DateFrom]], another text box: [=’TO:’ + [@DateTo]]. but these are not showing up on the report in preview at all. My Parameter Schema has DateFrom as Name, Data Type Date Time, Prompt: Start Date, Default Value @YearStart, Visible, Required, and the DateTo has its’ appropriate parameters set up also basically the same way.

Hello,I have a custom report to print a lable.  The physical label is being printed on a label printer.  The label is 4” wide by 6” tall.  I want to print the label landscape as the items on the label are wider than they are tall.I was hoping setting it to 4” wide and Landscape would accomplish this.  However, it does not. If I select portrait when printing, it prints the label information at the top of the label and does not turn the items 90 degrees to be properly aligned on the label.  Items are squished and use about half the physical label.If I select Landscape when printing, it does turn the items 90 degrees as desired, but does not expand out to use the entire label, it squishes it use about half of the physical label.  

I would like the value to display as a currency with 0 decimal places and comma separators.However, when I used a formula like CInt(x), it still showed 1,111.00, so I would like it displayed as 1,111. I also created a new field decimal type (19,0) and selected it in the schema field, it still showed the same like1,111.00. Is there any suggestion? Thanks!

How can i convert a report into GI. “Inventory Analysis”1. That Report Contains Subreport2. These Fields were displayed in the reportSubreport Contains parameter - InventoryItem.InventoryCD Please help, Thanks in Advance

Is there a report that totals prepayments by purchase order?  I am only looking for amounts that have actually been paid, not in process.

Hi Community!I have created a pivot table that counts Orders and Lines per day. How can I then add a column that averages the two totals in the pivot table or is this something that can only be done using Velixo?  

Hey All…. I’ve used MYOB V18 desktop version for 20 years, well last week I started a new job and they are using MYOB Acumatica! HELP! 🤣So…How do I do a monthly revenue report? So i can see all the months!Also a monthly profit and loss report, showing each month.Thank you 😖🤣 

Hello,         I have a requirement to display all invoice lines and its related shiplines(the key is the shipped 0 line, which has not converted into invoice) by invoice#         I can get the data using the sql below: select* from ARTran a full join SOShipLine c on a.SOShipmentLineNbr=c.LineNbr and a.SOShipmentNbr=c.ShipmentNbrleft join SOOrderShipment b on c.ShipmentNbr=b.ShipmentNbrwhere a.RefNbr='xxxxx' or b.InvoiceNbr='xxxxx' The key here is the “or” where condition. However , when it comes to report designerI can only either group by artran.ref / arinvoice.reforgroup by soordershipment.invoicenbr either way, I would get data lost.       

Hello, me again 😅 In the file I'm working on, I have a situation where the warehouse for some part numbers is not displayed.I added a formula to replace the blank spaces with the selected warehouse, but it gives it to me in the form of a number.Is there a way to change it to text?Can this formula be defined from the table relationship? 

Hello to everyoneIm doing a GI to show me the run out date, i already made to show me the date but it show me with the time.. how can i get to forces to show me only the date mm/dd/yyyy thank you 

Currently all Restriction Group access screens are limited by the Header the Function example Vendor/Customer For Maintenance how do I create a GI that will show the Restriction group including all the included Vendors I cannot find a link?    

Hello,I’m trying to make a form in report designer that has text in boxes.  The problem is that there are tiny gaps and the lines of adjacent boxes don’t touch leaving a gap of white space.  This method worked fine in the header section, but in the detail section I cannot get this gap closed.It looks good in report designer showed below.I have tried increasing the size by the smallest amount, but then report designer shows it in error.The form is covered in boxes and this looks sloppy.Any thoughts on how to overcome this?  I’ve tried panels with broders and have the same problem.Again, this worked fine in the header section which makes no sense to me.I am just putting borders on these text boxes to create my printed boxes. Thanks!