In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
#AcumaticaTnT Report Parameter dependent on another Parameter/Filter Customer Parameter to Parent Account
Hoping for a referesher on this. I'm sure I've done parameters depndent on other paramaters in the Report Designer before but can't remember the syntax 🙁
Also does anyone know if its possible to filter the Parameter selection by Parent Accounts only? For example in the AR Register Report, filtering the selection to only parent accounts?
Found an example of this in the Sales by Profitability by Customer Class and Customer where when you select the customer class it then filters the customers. Basically its in the View Name, you comma the Schema and add the Parameter name
hi All, appreciate was a while ago but has anyone else had success with this? i am trying to filter shipment numbers to only being those available from a predefined warehouse/site "DISPATCH", so i am trying to use the above. When i use the =Report.GetFieldSchema('FilterSOShipment.SiteID,SiteID') with a default SiteID parameter set as "DISPATCH" i lose the selection option in the parameter, any suggestions would be appreciated.
Checkout SO643000.rpx (Sales Orders -> Invoices & Memos). It does what you are attempting but the syntax is different: