Sales Order Report Parameters and Drop Down - Acumatica Report Designer

RE: Sales Order Report Parameters and Drop Down

Tim Rodman — Tue, 15 Jun 2021 23:13:19 +0000

I'm glad that they considered this to be a "bug" and fixed it. It's the little things like only showing meaningful parameters that make a report pleasant to use 😀

RE: Sales Order Report Parameters and Drop Down

KimM — Tue, 15 Jun 2021 15:19:04 +0000

We fixed this issue with custom DACs and hard coded the Order Type in. Then I got notification from support yesterday that this issue has been fixed in 2020R119. I have not tested the new version yet.

Sales Order Report Parameters and Drop Down

KimM — Fri, 07 May 2021 16:48:01 +0000

I am working in the Sales Order report of which we have several different custom versions. We don't want our end users to be able to change the order type and I have set default parameters in each report and made them not visible. The problem is that when the parameter is not visible the search functionality is affected and the drop down list for Order Number is no longer active and the full order number must be entered. The full search accessed through the magnifying glass is fine.

Is there a way to hide to Order Type parameter and still have access to the drop down list and partial Order Number searches. The attached png

shows what I am trying to say in case it's not clear.

2331

For the OrderNbr parameter the View Name is =Report.GetFieldSchema('SOOrder.OrderNbr,OrderType')