• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer
  • Home
  • Archive
  • About
  • Technical youtube Channel
  • Recommended Readings
  • Free Courses
    • Fixed Asset management Course
    • Financial Modules
    • Supply Chain Management Guide

Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Data manipulation tip 1 In Dynamics ax 2012 and D365 Of Operations Data copy method.

April 9, 2017 by alirazazaidi

 

Currently I am doing Report development project, I got some tips for Data manipulation , these tips I recently learned.

 

Copy data from one table buffer to other of same type.

 

 

During report development, We usually populate  temp table with result of Query execution. Usually we need copy of same data for aggregate functions.

 

Instead map each field of buffer with each other. We can copy the whole data by using .data method.

 

 

Suppose we have custom temp table CustSaleQtyTmp which we need to copy from one buffer to other.

class DataManipulationJob
{
/// <summary>
/// Runs the class with the specified arguments.
/// </summary>
/// <param name = "_args">The specified arguments.</param>
public static void main(Args _args)
{

CustSaleQtytmp _temp1,_temp2;
_temp1.IntQty=100;
_temp1.CustAccount =”Cust00001″;
_temp1.insert();
_temp1.IntQty=200;
_temp1.CustAccount =”Cust00002″;
_temp1.insert();

_temp1.IntQty=300;
_temp1.CustAccount =”Cust00003″;
_temp1.insert();
while select * from _temp1
{
// Instead copy like this we can use Data method
// _temp1.CustAccount = _temp2.CustAccount;
// _temp1.IntQty = _temp2.IntQty;

_temp2.data(_temp1);
_temp2.insert();

}

while select * from _temp2
{
info( ” _temp2 with ” + _temp2.CustAccount + ” ” + int2Str(_temp2.IntQty));

}
}

}

output like

Related

Filed Under: Dynamics 365, Dynamics 365 for Operations, Dynamics AX 2012, Dynamics Ax 7, MS Dynamics Ax 7, New Dynamics Ax, Tips and tricks Tagged With: Customization in Dynamics 365, Dynamic AX 2012, Dynamics Ax 7

Primary Sidebar

About

I am Dynamics AX/365 Finance and Operations consultant with years of implementation experience. I has helped several businesses implement and succeed with Dynamics AX/365 Finance and Operations. The goal of this website is to share insights, tips, and tricks to help end users and IT professionals.

Legal

Content published on this website are opinions, insights, tips, and tricks we have gained from years of Dynamics consulting and may not represent the opinions or views of any current or past employer. Any changes to an ERP system should be thoroughly tested before implementation.

Categories

  • Accounts Payable (2)
  • Advance Warehouse (2)
  • Asset Management (3)
  • Books (6)
  • Certification Guide (3)
  • Customization Tips for D365 for Finance and Operations (57)
  • D365OF (55)
  • Dynamics 365 (53)
  • Dynamics 365 for finance and operations (125)
  • Dynamics 365 for Operations (144)
  • Dynamics AX (AX 7) (133)
  • Dynamics AX 2012 (274)
  • Dynamics Ax 2012 Forms (13)
  • Dynamics Ax 2012 functional side (16)
  • Dynamics Ax 2012 Reporting SSRS Reports. (31)
  • Dynamics Ax 2012 Technical Side (51)
  • Dynamics Ax 7 (64)
  • Exam MB-330: Microsoft Dynamics 365 Supply Chain Management (6)
  • Favorites (12)
  • Financial Modules (6)
  • Functional (6)
  • Implementations (1)
  • Lifecycle Services (1)
  • Management Reporter (1)
  • MS Dynamics Ax 7 (64)
  • MVP summit (1)
  • MVP summit 2016 (1)
  • New Dynamics Ax (19)
  • Non Defined (9)
  • Power Platform (6)
  • Procurement (3)
  • procurement and sourcing (4)
  • Product Information Management (1)
  • Product Management (2)
  • Production Control D365 for Finance and Operations (9)
  • Sale Order Process (9)
  • Sale Order Processing (9)
  • Sales and Distribution (5)
  • Tips and tricks (275)
  • Uncategorized (165)
  • Upgrade (1)
  • Web Cast (7)
  • White papers (4)

Secondary Sidebar

Footer

Tags

Account receivable AIF Aif Services Apps for Dynamics 365 for Operations asp.net AX 7 BizTalk 2010 c# Customization in Dynamics 365 d d365 for finance and operations D365 for Operations Dynamic AX 2012 Dynamics 365 for finance and operations Dynamics 365 for Operations Dynamics Ax Dynamics Ax 7 Dynamics Ax 2012 Dynamics Ax 2012 development 2 Dynamics Ax 2012 functional side Dynamics Ax 2012 R3 Dynamics Ax 2012 Reporting SSRS Reports. Dynamics Ax 2102 Dynamics Ax tips and tricks ER Diagrams of Dynamics Ax 2012 tables Exam MB-330: Microsoft Dynamics 365 Supply Chain Management Excel Add ins financial Dimension Microsoft Dynamics 365 for Operations MSDYN365FO New Dynamics Ax Power BI Power BI tutorial procurement in dynamics ax 2012 Product Management Sales and distribution SQL Server 2008 SSRS Tips and tricks TSQL url regular expression Workflow WorkFlow in AX X++ X++ tips

Copyright © 2023 · Magazine Pro On Genesis Framework · WordPress · Log in