Reports and Generic Inquires

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

I am new to Acumatica (about 2 months on the3 system) and am having issues try to fund the corrent date fields to use in my Generic Inquiries.Is there a document that explains what each date field in each table is used for. As an example in the SOShipment has two date first one is call CreatedDateTime and the other is called ShipDate. I am struggling to determine when these two field are updated and what each date represents.Thank you for any assistance with these date fields.    

Hi all, I have data fields i want to export on Export by Scenarios and have imported mapping as shown image, but i can't export them. Do you have any ideas?Thanks in advance

Hi all,I was in the middle of creating a Generic Inquiry. To know what is the source of the field I will add, I need to have a Customizer role for my account, so I did.But after adding Customizer role, andd going back to the Customer Screen, this error make me stucked: The Trace Error Message says:  I tried removing the Customizer role as it was before, even adding new User, but still not able to access the Customer entity. Can you please help me.. 

Dear partners and customers,Currently, we have two OData endpoints:~/odata, which is GI-based, uses the OData v3 protocol, and has been with us since the 5.1 release; it is widely adopted in various ISV solutions ~/odatav4, which is DAC-based, uses the OData v4 protocol, and was released in 2020R2.The OData v3 protocol slowly becomes obsolete in favor of OData v4. For example, some .NET client libraries stop supporting OData v3 at all, and .NET Core/.NET 5.0+ supports OData v3 only in the compatibility mode with some restrictions.Because of that, we’d like to collect feedback on the OData v3 endpoint usage (GI-based, located at ~/odata route) and ask some question on what protocol-related features you actually use. As you may know, the default payload format for OData v3 is Atom XML (Accept: application/atom+xml or $format=atom). OData v3 also supports JSON in two forms: a regular one (Accept: application/json or $format=json) and a verbose one (Accept: application/json;odata=verbose o

Hi all,Anyone please, is it doable that these highlighted parts disappear. I want it to appear once and the next be blank for the other items when multiple items are under the same transaction. I appreciate any help. Thanks!

Hi everyone,I want to show field currency rate in report designer but I dont know how to do that? If you have any idea, pls advice me.Thanks in advanced.

Hello， I wrote a GI for our company to hightlight the lines using the below formula： =IIF([ARTran.Qty]>[INSiteStatus.QtyOnHand],'orange40','default') It works OK. However, you see, we are having 36 pages,And if the management team would like to view the on hand qty below period usage qty lines,he have to click 35 times to view all pages.Is there a way to filter out the lines by the highlight colors? I am thinking out add a new column with value : [ARTran.Qty]-[INSiteStatus.QtyOnHand]However [ARTran.Qty] should by SUMwhile [INSiteStatus.QtyOnHand] is by AVGThis column won’t get the expected result.Any suggestions?

When printing multiple Production Orders (using Print Production Orders process), I want to be able to sort all the orders by the Workcenter in which they start. The reason is so production orders can be distributed to each work center without manually sorting. The default is to sort by Production Order ID.  I am playing with the sort properties but not having much luck: I have tried to change the property from [AMProdItem.ProdOrdID] to AMProdOper.WcID:I’m not having any luck the sort order remains the same sorting by ProdOrderID. Any help is much appreciated. thank you

Hi, To the Shipment PL, SO3020PL, I added the table SOOrderShipment, Joined from SOShipment via the Shipmemt.NoteID to the SOOrderShipment.ShipmentNoteIDI am trying to get the Sales Order Number. This is working great for all but 1 user. That user cannot see the column. The user can access Sales Orders & Shipments. They have the Administrator Role. I tried doing a reset to default Configuration I log in as that user & can customize the GI & can see the table/ join & field on the Results Grid. But when I view the GI , as them, the field does not display. It is also not listed in the Column Configurator.There are no errors in the trace. TIA, Bill

How do I add a hyphen in Report Designer between 2 fields. Trying to end up with this;  Address - Number. +IIf([ShippingAddress.AddressLine1]<>null,[ShippingAddress.AddressLine1]+ - +[POOrder.OrderNbr]+'{br}','')

Hi,I wanted to get sum of all values in CASplit.CuryAmt field to display the Total Amount.these are the two tables that I wanted to get the line detail values.CASplit CAAdjAnd this is the new join I put to get the line detail values.  And this is the condition to get the Total Amount=Sum ( [CASplit.CuryTranAmt] )  But when I run the report, it duplicates all the value details in CASplit.CuryTranAmt field and added to the Total Amount.Does anyone know what causes this issue and how to fix it? Thank you.

Hi everyone,I have a question with Purchase Order that the order of the rows is reversed, I want the lines to be printed in the order they were entered. I use the print version of the system and have not edited anything.Pls advice me if you have any idea.Thanks in advanced.

Is there a way for us to create a generic inquiry, for this two table. Currently my project on the company is to set an approval map on the Sales Quotes based on the total amounts, and when printing the quote, the Approver name and their E Signature will be shown on the report. I want to use the subreport to get the approver name on the main report on the sales quotes. But my problem is how can i get the E Signature to be shown on the report.   

A debit adjustment that was created from an invoice was applied to the wrong invoice, how can I unapply it or move it from one invoice to the correct one after it has been released?

Hi! I’m new to using Acumatica Report Designer and I still don’t get where I should put table headers for example. In this picture, the highlighted part is what I want to be my first set of columns (and I need three sets of columns). Then I encircled this columns’ respective contents. Where do I put them? I tried to put it in the detail section, then tried putting my next set of columns in another page header section and tried changing places too but I can’t get what I want. I want my first set of columns to list down all contents before showing me next page (2nd set of columns) then next page again (3rd set of columns). I don’t even know if I’m making sense to anyone right now. Thanks for your help! 

I have a client that needs the Credit memo background color to be the same as the AR invoice, blue not red on the 641000 reports. Please advise. I appreciate any assistance. Thank you,Barbie