Skip to main content
Question

Report Designer conditional value


Dear All,

I want to create different output report designer value based on Subaccount that stated on PO Line, how can I make this? for example :
Sub : 00-000000-STV-00, I want to show Stevedoring as return value from Subaccount on third segment

Sub : 00-000000-VES-00, I want to show Vessel as return value from Subaccount on third segment

how can I make this work on report designer?

Thanks

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 28, 2024

Hello,

It seems like you want to connect to SegmentValue table and print the Description.

 

I could not find another post joining SegmentValue on Subaccounts.  I did find one post where a user connected to SegmentValue table to solve an Inventory SubItem report:

I hope this leads you to an answer, or inspires someone to add more details here on how to join the table.

Laura


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

@yosephadjie As a follow up to what Laura posted, you could make a long expression of chained IIF() statements switching the subaccount with the hardcoded description.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings