AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Report De...
Report Parameter de...
 
Notifications
Clear all

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

 
Acumatica Report Designer
Last Post by Royce Lithgo 3 years ago
4 Posts
3 Users
4 Reactions
3,051 Views
RSS
JLange
Posts: 45
 JLange
Topic starter
July 27, 2021 11:33 pm
(@jlange)
Trusted Member
Joined: 6 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 12:44 am
(@jlange)
Trusted Member
Joined: 6 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: 40
 matthewjames
June 1, 2022 8:04 am
(@matthewjames)
Trusted Member
Joined: 5 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: 557
 Royce Lithgo
June 1, 2022 6:59 pm
(@roycelithgo)
Honorable Member
Joined: 6 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
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 39 Online
  • 2,410 Members
Our newest member: thollings
Latest Post: Attribute Input Mask
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

  • Steven Fuller
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×