AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Report Parameter de...
 
Notifications
Clear all

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).
Sincerely,
Tim Rodman

#AcumaticaTnT Report Parameter dependent on another Parameter/Filter Customer Parameter to Parent Account

Acumatica Report Designer
Last Post by Royce Lithgo 8 months ago
4 Posts
3 Users
4 Likes
1,139 Views
RSS
JLange
Posts: 45
 JLange
Topic starter
July 28, 2021 12:33 am
(@jlange)
Member
Joined: 3 years ago

Hi all

 

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?

 

image
ncantral reacted
3 Replies
JLange
Posts: 45
 JLange
Topic starter
July 28, 2021 1:44 am
(@jlange)
Member
Joined: 3 years ago

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        

    

image
image

 

Reply
Tim Rodman reacted
matthewjames
Posts: 24
 matthewjames
June 1, 2022 9:04 am
(@matthewjames)
Member
Joined: 2 years ago

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.

1
2
3

 

Reply
Royce Lithgo
Posts: 544
 Royce Lithgo
June 1, 2022 7:59 pm
(@roycelithgo)
Member
Joined: 3 years ago

Checkout SO643000.rpx (Sales Orders -> Invoices & Memos). It does what you are attempting but the syntax is different:

image
Reply
Tim Rodman and matthewjames reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 5 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×