Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Copy field from a view...
Finance forum
Unanswered

Copy field from a view into another field

Posted on by 71
Hi everyone,
I created the Field AZBProductivityUnit in the table CustPackingSlipJour and inserted it in the form CustPackingSlipJournal. This field of type String needs to be populated with the address of the warehouse associated to that line, so I have to copy this value inside my AZBProductivityUnit. The address of the warehouse is in the form InventLocation stored in the Data Source LogisticsEntityPostalAddressView under the field Address. In addition to that, the field AZBProductivityUnit should be editable, but this modification doesn't have to change the field Address of the warehouse. Anyone has any tip for me ? I tried several coding solutions but no one seems to fit my problem. Thank you very much to anyone who will help.
  • Raj Borad Profile Picture
    Raj Borad 399 on at
    Copy field from a view into another field
    Hi,
     
    You can copy the data from view using select statement OR by property of the EDT of the field same as view to your field.
    If this not solve your issue, Please share some more details about your query.
     
    Thank you,
    Raj
     
  • Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,572 Moderator on at
    Copy field from a view into another field
    Using the warehouse you can find the address of it from the related table using select statement. Are you looking about fetching the data?
  • Martin Dráb Profile Picture
    Martin Dráb 228,501 Most Valuable Professional on at
    Copy field from a view into another field
    Don't you have any more specific question? Discussing the parts of the solution that you already know would be a waste of time and it wouldn't help you; focusing on the problematic pieces would make a better sense.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans