Reports and Generic Inquires

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. 

I have an AP employee who is trying to use the Additional Remittance Form and it seems regardless of Cash account, Payment method of other fields entered it always prints out a blank page when the report is run. I have not been able to get it to print anything but the AP employee says that it prints out what they want at least 50% of the time. does anyone have experience with this issue or know what might be causing the problem?

We have a report where we concatenate the InventoryID and the Description fields.Is there a way to bold the InventoryID while leaving the Description portion of the string normal/Thank you!

Hello,Can someone please help me with a null formula in my GI. If my customer reference number field is NOT blank, I would like it to have Blue or Blue Font. Here is what I came up with: =IIf( [SOOrder.CustomerRefNbr] <>' ' , 'blue40', default) The result is everything is blue.  

We have few attributes with multi-select control type.AttributeHowever, when multiple values are selected, the values are concatenated in the database. Below is a database snapshot: Db snapshotWe have a GI that is using this attribute as a parameter. We would like to filter based on individual attribute and not look for a specific combination. It doesn’t work right now as it keeps looking for a specific combination of attributes  Is there a way to store this differently in the database or a way to separate them?

In the Invoices Form, Tax Details tab there can be instances where 2 taxes are applied as below.We need to get both these tax values to the report. I have used this join for that purpose.But this join takes only one tax ID to the report and the detail lines end up getting duplicated. How can I avoid this issue?

I need to limit Requests view so employees can see their own Requests or those of employees in their department (field on Request). I can easily limit users to their own requests using RQRequests.CreatedByID = @Me in the GI condition. But I need the equivalent of “Or RQRequests.DepartmentID = @Me” . Problem is, @Me doesn’t work for DepartmentID field. Does anyone know how I can accomplish this?

Hi~I am tiring to customized Account Summary GL4010000 to excluded Branch information.My final purpose is grouping Account in that screen to see totals include every branch.Is it possible to realize it by my customization? or how can I change the hierarchy for Company/Branch into Company and Branch in the filter?Thanks!!!!

can we generate a GI that includes all transactions with reason codes? We need to see all inventory adjustments and their associated reason codes, as well as write-offs and the reason codes used for them. Thank you!

Customer is on 2023R1Created a new Business Event Based on status chnage on a new Sales order GI Business Event did not trigger as expectedCopied the GI and BE to Sales Demo instance and trigger worked as expectedwhat could the issue be on the customer instance to cause the BE not to trigger ?

We are creating a report in Report Designer where one description field needs to be set to Can Grow. The user would like the detail section to be maintained at a minimum height, but would like the Detail Section to grow when the description field grows in height. Currently, the Detail Section height remains constant and when the Description field grows in height, it is cut off at the bottom. Is there an easy way to cause the Description section height to grow when the field grows?

I have a Generic Inquiry for tracking Blanket sales orders but I need to add a function to it that allows me to track schedule compliance for the contracts in the GI. we have the start and expiration dates that I need to draw from as well as the order quantity plus unshipped order quantity. what I need is the Unshipped order quantity to be tracked in relation to the remaining months in the order.so for example in an order of 11,200 units over the course of 12 months needs to show that a minimum of 933.33 units are being shipped per month, if you get to 2 months and the total shipped is not equal to or greater than the order quantity total divided by the number of months between start and expiration date it should show it as being out of compliance.now I know this is very complicated and I am unsure if it is even possible to track this data using a GI and/or dashboard.I attached the XML of the report as well.