Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Help with creating a function to write data between tables/fields

(0) ShareShare
ReportReport
Posted on by 68

Dear Community,

I have a question regarding the creation of a function, in which I want to write data from one table/field to another. I'm not sure how to best solve this problem and would like to hear your opinions.

What methods or techniques would you recommend to tackle this issue? Have you perhaps already created similar functions and can help me with this?

I'm looking forward to your answers and thank you in advance for your support!

Best regards.

pastedimage1678453964004v1.png

  • EavenCS Profile Picture
    EavenCS 68 on at
    RE: Help with creating a function to write data between tables/fields

    Good morning,

    Exactly as they mean it.

    greetings

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,274 Super User 2024 Season 1 on at
    RE: Help with creating a function to write data between tables/fields

    hi

    There are several ways to create a function that can write data from one table/field to another in Dynamics 365 Finance. Here are some possible methods you could consider:

    Use the Data Management framework: You can use the Data Management framework to move data between different environments, entities, and fields. This framework provides a set of tools and APIs that allow you to import, export, and manipulate data in bulk.

    Use X++ code: You can use X++ code to read and write data from/to tables/fields. You can create a custom class or a job in the AOT to perform this task. You can use the select statement to read data from one table/field, and the insert statement to write data to another table/field.

    Use a workflow or a business process flow: You can create a workflow or a business process flow that includes steps to copy data from one table/field to another. This method is useful if you want to automate the process of copying data and apply some business logic to it.

    Use Power Automate: You can use Power Automate to create a flow that connects to Dynamics 365 Finance and copies data from one table/field to another. This method is useful if you want to create a more complex flow that involves multiple applications and services.

    The best method to use will depend on your specific requirements and the complexity of the task. I suggest starting with the method that you are most familiar with and then exploring other options as needed.

    DAniele

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Help with creating a function to write data between tables/fields

    Hi Eaven, if you want to copy data from one table to another, there is standard function buf2buf.

    Check this out

    markedcode.com/.../

    rahulmsdax.blogspot.com/.../copy-data-from-one-table-to-another.html

  • Phil Matthews Profile Picture
    Phil Matthews 52 on at
    RE: Help with creating a function to write data between tables/fields

    How will this method be used? Is it a generic method to accept any two table fields and attempt to copy between them, or do you have a degree of control over the tables, fields and data types involved?

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

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans