Reports and Generic Inquires

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!

Trying to find a way to capture the date a Sales Order changes from the state of On Hold to Open.  Looking to build some KPIs off of this time difference.  I am struggling on how to find and show this data.  Is it available somewhere?

Hi All, Is there a way to exclude weekends for Automation Schedules?We want to avoid that Sales people receive their Daily Sales Report and some other Data on the Weekend. Thanks,

Two of the subreports, (attached below) are appearing blank within the main report. They work fine and load data by themselves, but don’t populate within the main report. Any specific reason why?

Is there a report that shows released inventory receipts that do not have an AP bill created from that receipt? 

Hello,    Irina previously shared a trick to get the current finperiod as default in GI.  This worked fine in 2020R2, but it does not work in 2021R2.  Normally, we just only want the current period data.The below trick is working. If someone has better solution, please also share. Thanks. Although it shows 06-2022 in screen, it actually stores as 202206 in DB, so I am using the below formula to calculate current fin period.=IIf( Month( Today())>9, Concat( CStr( Year( Today())),CStr( Month( Today()))),  Concat( CStr( Year( Today())),'0',CStr( Month( Today()))))And then put it in GI conditions. 

I have a strange issue today. In my report, I am trying to create a parameter to select a specific salesman. I have joined the salesperson table to my service order table and have the following filter set SalesPerson.SalesPersonCD  Equal @Salesman  Or@Salesman IsNull My parameter is setup as follows When I set a default value to the salesman parameter and then click preview, it works as it should and there are no errors. However, when I save to server and run the report, it gives me the following error:I don’t understand, the parameter selector is the exact same syntax as what it is filtering the report by. I have never had this error before. I understand how to fix it when there are issues translating from string to datetime or string to int for example, but I have never had an issue going string to uniqueidentifier. I didn’t even realize those were separate syntaxes to be honest.