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.
Good morning,
Exactly as they mean it.
greetings
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
Hi Eaven, if you want to copy data from one table to another, there is standard function buf2buf.
Check this out
rahulmsdax.blogspot.com/.../copy-data-from-one-table-to-another.html
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?
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156