Reports and Generic Inquires

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?

Hello everyone,I am working on report Purchase Receipt that will display all items in the gridand also show the sum of Landed costs with code <> “IMP” I tried to join table POReceiptLandedCostDetails to POReceipt  But the report return duplicate row:Could you please advise me how to get LandCost related Purchase Receipt without causing duplicate data of POReceiptLine? Please find the report in attachment. Regards,Khoi

Good day,We just upgraded to 2022 R1.  Most every time I save changes to a GI I get the below message.Anyone know what the issue is and why I getting this message.  My changes are saved.  Not sure if anyone else has the issue Error message.Thank you  Error: Another process has added the 'MUIFavoriteScreen' record. Your changes will be lost.

Hello - I have a weird issue. We have a custom field on our PO form called “Requested By”. If I go to the PO screen and preview/print, the value appears perfectly. However whenever the PO form is sent via a business event that I created, the “Requested By” field shows but not the value for some strange reason. I confirmed the business event is pulling the same form ID than the one I see when I preview it from the PO screen, so I have no idea what could be causing this. Wondering if there is something I need to change on the form itself or perhaps the business event?

Good dayMy company updated to 2022 R1.  I have a number GIs that use the @Today function.  Does it still work in the upgrade version.  I was previously on 2020 R1.  Do I need to replace it with Today().  (Date/Time fields). Does anyone have a list of the 2022 R1 GI functions?Thank you@Evan G 

Has anyone ever added the overall average to the footer of this report? I’ve tinkered with it but haven’t gotten it to work and was hoping someone else has already accomplished this and could share their report version. Thanks!

Hi everyone,In report of dunning letter (AR661000). I wonder how to show only the detail of the first invoice  which dunning level is 1 instead of showing all including level 0Thanks in advanced

Hi All, We are preparing for a client upgrade and need to find all modified reports. Is there a way in Acumatica that tells you all the modified forms and reports ? Thanks,Shyam.  

Hello!I have this visible expression here. What if I need to specify many values in this conditional statement, where or how should I place them? Thanks so much in advance! 

Hi,I have spent a fair amount of time testing how  a DAC referencing a view in the database works, specifically around a second independent BQL statement on the view not behaving as you might expect.  To demonstrate the issue as clearly as possible I have created a simple, abstract test case running on a local instance.I have a view: And, the test case attempts to run 2 BQL statements returning one or more of the following records: There is a DAC that references the view: And, here is the Test method that runs the 2 BQL statements: So here is the issue.  When I set a breakpoint at the end of the Test Method and interrogate the contents of q1 and q2, the contents of q2 are wrong.  I was expecting 2 records being InventoryID 3236 and 3249, but we have 2 records both being InventoryID 3235 (ie. the record the first BQL statement returned)What is going on here?  Some kind of caching around the contents of the View?I have used SQL Profiler to check what query is being running to populate q2