Extract data of PO from the System in Ax 2012

 static void Job(Args _args)

{

    PurchTable      purchTable;

    PurchLine       purchLine;

    Dialog          dialog  = new Dialog();

    DialogField     dialogFieldFileSave;

    Commaio         file;

    container       line;

    FilePath        TempPath;


    dialogFieldFileSave     = dialog.addField(extendedTypeStr(FilenameSave),"File path","Caption here");

    dialog.caption("Extract PO data");

    dialog.filenameLookupFilter(['*.csv']);


    if(!dialog.run())

    {

        return;

    }


    if (dialogFieldFileSave.value() == '')

    {

        error("Please set up the location for export file.");

        return;

    }


    TempPath = dialogFieldFileSave.value() + '.csv';


    #define.filename(TempPath)

    #File


    file = new Commaio(#filename , #io_write);

    if( !file || file.status() != IO_Status::Ok)

    {

        throw error("File Cannot be opened");

    }


    //Put headers

    line = ["PO number","Vendor name","Vendor Id","line Id","Net price","Qty ordered","Product unit price","Unit value","SKU","Item description","PO date"];

    file.writeExp(line);

    //Put a sample line

    while select firstOnly100 PurchId, PurchName, OrderAccount from purchTable

        order by purchTable.PurchId

        join LineNumber, LineAmount, PurchQty, PurchPrice, PurchUnit, ItemId, createdDateTime from purchLine

        where purchTable.PurchId == purchLine.PurchId

    {

        line = [purchTable.PurchId, purchTable.PurchName, purchTable.OrderAccount, purchLine.LineNumber, purchLine.LineAmount, purchLine.PurchQty, purchLine.PurchPrice, purchLine.PurchUnit, purchLine.ItemId, purchLine.itemName() ,purchLine.createdDateTime];

        file.writeExp(line);

    }


    info(strFmt("File exported successfully. Please find it at %1",TempPath));


}

Comments

Post a Comment

Popular posts from this blog

Assembly reference containing type is not referenced, Object 'CLRObject' could not be created

Image
Problem Statement I have RDP and an AX shortcut icon, I have a parameter form with a "Test Connection" button. Upon clicking this button, a DLL is invoked to authenticate the connection status. This DLL is placed in both the client and server directories: specifically, it is located in the Client Directory at C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin and in the Server Directory at C:\Program Files\Microsoft Dynamics AX\60\Server\<MachineName>\bin . Additionally, a reference to this DLL has been added to the Application Object Tree (AOT) to facilitate its functionality When running the process from RDP, the "Test Connection" passes successfully. However, when using the AX shortcut icon, an error is encountered. Solution Add C# project into AOT, by right click on project and ADD <ProjectName> to AOT. Open project and set the project property. Deploy to client YES and Deploy to server YES and Deploy the project. After deployment of projec...
Read more

Send email using .Net framework

Image
This code will send email using .Net Framework. Create email template:      Goto : Organization adminstration > Setup > E-mail templates. Create E-mail template give E-mail ID, E-mail description, Default language, Sender name, Sender e-mail. set the email body of above-created record. Goto: E-mail message and set e-mail body as below. static void SendEmployeesDataInEmail(Args _args) {     System.Net.Mail.MailMessage    mailMessage;     System.Net.Mail.SmtpClient     smtpClient;     SystemParameters               systemParameters;     Email                          emailFrom, emailTo;     SysEmailMessageTable           message;     SysEmailId                     sysEmailId;     Employee...
Read more

Make Partial and Fully Product Receipt of PO also make Partial and Fully Invoicing of PO in ax 2012 using X++

Image
  In this blog we will discuss how to make partial and fully product receipt and also partial and fully invoice of PO using x++. Importing data from .CSV Microsoft file which contain PO data and converting the purchase order status to invoiced status by a two-way matching process.   Functional Process  In AP Module > Accounts payable parameter we create an  AP automation  Tab. which contain file path and archieve folder path. In periodic tab, there is an custom form AP automation.   Process of  PO Data Here is the .CSV file which contain PO data. Upload file, and give Invoice number and product receipt number if PO status is opened order. Process the file. Now, Product receipt number and invoice number is created of that lines which are uploaded from the file. Repeating same process to Invoice all lines of PO partially, to make the status of PO Invoiced. Process of Non-PO Data Upload Non PO data and process it. It will create reference journal ...
Read more