AugForums.com

An Acumatica User Group

Acumatica Forums

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

Forums
AUG Forums
Everything Else
Change Location Des...
 
Notifications
Clear all

Questions Change Location DescriptionField attribute to pull from another DAC

 
Everything Else
Last Post by Bob Allande 2 years ago
1 Posts
1 Users
1 Reactions
935 Views
RSS
Bob Allande
Posts: 7
 Bob Allande
Topic starter
March 14, 2024 3:39 pm
(@ballande)
Eminent Member
Joined: 2 years ago

I need to change what displays on the SO screen when selected a Location.    By default, it is
LocationCD - Descr

699e41b5 801e 49b4 a8d5 9ab81fb236a4

We want to change it to LocationCD - AddressLine1

I can add the AddresLine1 easy enough in the Selector, but how can I add it to the DescriptionField ?  If I change it to

  • DescriptionField = typeof(Address.addressLine1),

It just shows the locationCD on screen with nothing following it (Description or Address). 

I realize it is from a different DAC (Address vs Location), so I guess the question is how do I get the info from the other DAC to display?

Thanks in advance!

[PXCustomizeSelectorColumns(
                typeof(PX.Objects.CR.Location.locationCD),
                typeof(PX.Objects.CR.Location.descr),
                typeof(PX.Objects.CR.Address.addressLine1))]

[LocationActive(typeof(Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>,
                And<MatchWithBranch<Location.cBranchID>>>),
                typeof(InnerJoin<Address, On<Location.defAddressID, Equal<Address.addressID>>>), 
                DescriptionField = typeof(Location.descr), Visibility = PXUIVisibility.SelectorVisible)]



[PXDefault(typeof(Coalesce<Search2<BAccountR.defLocationID,
InnerJoin<CRLocation, On<CRLocation.bAccountID, Equal<BAccountR.bAccountID>, And<CRLocation.locationID, Equal<BAccountR.defLocationID>>>>,
Where<BAccountR.bAccountID, Equal<Current<SOOrder.customerID>>,
And<CRLocation.isActive, Equal<True>,
And<MatchWithBranch<CRLocation.cBranchID>>>>>,
Search<CRLocation.locationID,
Where<CRLocation.bAccountID, Equal<Current<SOOrder.customerID>>,
And<CRLocation.isActive, Equal<True>, And<MatchWithBranch<CRLocation.cBranchID>>>>>>))]
[PXForeignReference(
typeof(CompositeKey<
Field<SOOrder.customerID>.IsRelatedTo<Location.bAccountID>,
Field<SOOrder.customerLocationID>.IsRelatedTo<Location.locationID>,
Field<Location.defAddressID>.IsRelatedTo<Address.addressID>
>))]

Tim Rodman reacted
Topic Tags
customization Attribute
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Feeling Stuck on Making a Sandbox of our Database
    3 months ago
  • Allow user to only see their own Journal Transactions
    1 year ago
  • Create new field in PO with default values
    1 year ago
  • Is it possible for acumatica to automatically pull up the customer information and show it as a pop up ?
    1 year ago
  • Adding a Customer Status w/Logic attached
    2 years ago
Topic Tags:  customization (15) , Attribute (4) ,
  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 27 Online
  • 2,412 Members
Our newest member: kadencewp
Latest Post: Generic inquiry with information from Audit history(CT301000)
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 © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×