Reports and Generic Inquires

Hello,I have created a GI for daily orders and I am trying to set a condition so it only pulls orders created Today(). I have brought in the SOORder.CreatedDateTime and set the value1 to Today(). However that does not return any results. I am not sure it is due to the fact that the Created on has time included. But got stuck on something that fells like it should be a very easy Condition. I have included the GI below.  Thoughts?

Anyone know how to create a GI that displays the average customer order count over a rolling 12 month period? I’d also need to be able to exclude specific order type (mainly returns).I’m just not sure how to get an order count using formulas. And I would need to include any open (non-completed) orders in the count as well.

Hi I’m trying to print my report with some sub-reports attached , the issue is that it is printing an extra EMPTY page at the end when I click print for the second time. Steps:Run reports → Print Report → cancel print → print report.  

Hi all,I usually use an existing report to make another, but when I have edited the columns with my own without changing anything from schema or anything, just adding columns and fields, which do not reflect in the excel when I export. Is there sth I need to do for the new columns to display? I appreciate your answers!Like in this pic, only 3 columns were shown.

Hi Community,I’m working on GI POLines 2.0, where I can see a bunch of relevant data all in one spot.  I’m trying to create a field and formula that will give me a run rate for specific products over a specified date range.  The data I would need is InventoryID - SUM of QTY on SO’s created during a date range, ideally <@Today-180.  I’m struggling to figure out the best place to pull the data and/or write a formula where it will SUM the total quantity sold and allow me add date parameters.Attached is the GI I’ve been using. Thanks for the help.  PS - I am running 2022 R1 Commerce Edition.  I do not have the manufacturing module.   

Hi,I trying to create a GI to just show customer ID and the tax zone. I know I have to include the location table so I can pull the tax zone however I only want to see customer ID and tax zone not all the locations as well. Is there a way to do this? 

Hi there,I am trying to make a relationship of Freight details so that I can put the line total on the invoice but I think my relationship is wrong, could someone help please  

Has anyone successfully recreated the Inventory Valuation report as a GI? We currently have 181614 stock items and each one has more than likely touch multiple location. This leads to multiple entries on the inventory valuation report which then leads to a large document which can be a little annoying to parse through and analyze. I’ve been trying to recreate the report as a GI, but so far have remained unsuccessful. I’m open to any ideas!

Hello,This is what displays as my Linenbr, which seems to follow the line nbr of the list inside the system, I want it to count the line in this print though. Where should I edit this? Thanks a lot!

How do i show the original purchase order amount and all of the change order transactions for the entire purchase order?How to add Change Orders to Purchase Order report AcumaticaReport Content: To Add a Subreport I have went through the tutorial to create a subreport and tried adding this in to my custom report. how can i add change orders into my purchase order report This is how it generates in my original purchase orderHow do i show the original purchase order amount and all of the change order transactions for the entire purchase order?

Hello,I’m not using any filter because I’m not using any parameter, how can I format this in RD visible expression so that I can only display the same name once? Thanks!

Hello everyone,I want to compare what I’m charging for shipping versus what I’m paying for shipping.  SOSHIPMENT - CuryFreightAmt, is not equaling SOOrder - CuryFreightAmt, I’m not sure why, so I’m trying to add SOrder - CuryFreightAmt to the Shipments GI.  I’d like to connect them by the original order number, which as far as I can tell, does not exist in SOShipments.  So I’m trying to use either SOShipLine - OrigOrderNbr or SOOrderShipment - OrderNbr to build the relationship.  I can get it all set up, except the GI is showing duplicates and I’m not sure why.  Please help.  

Hi, I want to create market level Unit Set using our subaccounts, but I’m getting an error. Here’s what I did: Created a new Market code and a code for our Florida market.I selected all the sub accounts by defining the Start Sub as the first record and the End Sub as the last record in the Data Source fieldI added up all of the FL-related sub accountsCan someone advise me on what I’m doing wrong?

Hi All, Our company is looking for a custom daily report which runs automatically in the evening and distributes to a email list. The report would consist of all the SO’s entered in that day. So first, what would you recommend for a GI build? A simple copy and customization of the Sales Order screen and then just setting up a automated schedule?

Hi there,How can I show the total net sales per Sales Agent? I also wanna list down the names of agents but only appearing once. Can anyone please help me? Thanks a lot in advance!

I want to format SOOrder.CuryLineTotal to read like 1,000.00 across the entire document. This is due to a formatting issue when having the report do math to the SOOrder.CuryLineTotal value. After the math, it comes out with no comma and more than two decimal places despite the ‘format’ column having of the text box having the right information. Any solutions?

Hi,I want to add a “Duplicate” tag to all the printouts of a report except the first one.If this is the first printout.all the other printouts of the same report should be like,does anyone know how to do this in report designer? Thank you,Regards.

Hello, can someone please kindly help me with this?I want to display the value of ‘not null’ VAT Sales (or) ‘not null’ VAT Exempt (or) ‘not null’ ZERO Rated in “Total Sales”. I need a formula, I’ve been trying to use ISNULL and IFF but I’m wrong. Can anyone please give one. Thanks so much! 

I’m trying to show an extra empty row at the end of the report in the report designer, but I don’t know how to go about it. Can someone please tell me what I can do? For example, in the attached picture, there's only two entries. I want to show a third empty row. For every report, one extra empty row at the end. How do I go about doing it?Thanks in advance))  This is the report Report Designer 

This is a question related to reporting for date-based activities.In an ideal situation I’d be able to create the below Pivot Table showing a column for each day in the upcoming work week. If there is an activity scheduled against that day, I’d be able to display it in my pivot table. If there is no activity on that day, the day column would just act as a “placeholder.”This would be to help users interact with the data and having a Calendar feel.I see a possibly related question here that looks unresolved.Just curious if, within the Generic Inquiry used to generate the pivot table, if I cross join to:CS Calendar? Field service calendar? Payroll calendar?I’d only want to do this in order to generate the upcoming calendar dates. Or maybe there’s an add-in or another way to solve this.Would be great to hear any ideas.ArlineIdeal layout concept is sketched out here: 

Hi Guys, I am building a report that prompts for a vendor:When I run the report it shows the Vendor ID:I would like it to show the vendor name: Currently my schema on report designer looks like this:And no filters for that particular field:Here is the report:Does anyone know what I should do to display the Vendor name

Hi,  We are in process of the customizing Additional Remittance Form. We need to add vendor ID as a parameter to this custom report version. Which data field do we need to use to accomplish this requirement? RegardsNethupul  

Why would the = [Page Of] not calculate all the pages in report designer? Does the location matter?

Good day. When i preview the invoice printout, it looks fine. However when I download it to pfd, the "-” symbol is disappeared. Is anyone having this issue before?As highlighted the field name, it's showing the "-” symbol in print preview. When we download the printout to pdf format, it's not showing the dash symbol.The field properties 

Does anyone know if it is possible to show the “Quantity on Hand” as a column in the Generic inquiry for Stock Items?