Posts

How to import data in Ax2009 from a CSV file

In Microsoft Dynamics AX 2009, importing data from a CSV file can be done through the Data Import Export Framework (DIXF) , AIF (Application Integration Framework) , or by using X++ code to handle custom imports. Here's a step-by-step guide to importing data from a CSV file: Method 1: Using AIF (Application Integration Framework) AIF is commonly used for integrating external data in AX 2009. Here's how you can use it to import data from a CSV file. Step 1: Create an AIF Service Define an inbound port for the data import: Navigate to Basic > Application Integration Framework > Channels . Create a new channel for importing the CSV file, specifying the necessary details. Create a Data Service : Go to Basic > Application Integration Framework > Services . Add a new service or choose an existing one that handles the type of data you want to import (e.g., purchase orders, vendors). Setup File Adapter : Go to Basic > Application Integration Framework > Adapters . U...

how to recover voided Purchase in ax 2009

In Microsoft Dynamics AX 2009, once a purchase order is voided, it cannot be directly "recovered" or reversed because voiding is meant to be a final action. However, you can manage the situation by using a workaround to recreate the transaction. Here’s how you can handle the situation: Option 1: Re-create the Purchase Order Re-enter the Purchase Order : Manually create a new purchase order with the same details (vendor, items, quantities, prices, etc.) as the voided one. Navigate to Accounts payable > Purchase orders > All purchase orders . Create a new purchase order and enter the necessary details. Update the Status : Once the order is re-entered, you can follow the normal approval and posting process. Reference the Original Order : In the notes or description fields, you can reference the voided purchase order to maintain clarity for audit purposes. Option 2: Reverse Journal Entries (If Applicable) If the voided purchase order has already created financial impacts, y...

How to create Movement Journal with Code X++ Sale Order

Sometime we need to make leftover quantity of Inventory at the time of Sale Order. I created a code to use to make a movement journal in Ax 2009. void clicked() {    InventJournalTable journalTable;    InventJournalTable InventJournalTable_;    SalesTable SalesTable_; InventJournalTrans journalTrans; InventJournalTableData journalTableData; InventJournalTransData journalTransData; Salesline _Salesline; //alesline Salesline; InventDim _inventDim; numberSeq numberSeq; NumberSequenceReference NumberSequenceReference; Counter cnt; InventJournalCheckPost journalCheckPost = new InventJournalCheckPost(); ; if((SalesTable::find(Salesline.SalesId).RefJournalID) != '') { info(SalesTable::find(Salesline.SalesId).RefJournalID); info('Journal is already Created'); } else { select sum(RemainSalesPhysical) from _SalesLine where _SalesLine.SalesId == Salesline.SalesId; if (_SalesLine.RemainSalesPhysical != 0) { select * from _SalesLine wher...

X++ to C# Comparisons

Differences The following table lists X++ features that are different in C#. Feature X++ C# Comments Declarations All declarations must be at the start of the method, before any X++ statements. Declarations can occur anywhere in the method. Both languages permit multiple variables of the same type to be listed together in one declaration. Both languages allow you to assign an initial value in the declaration statement. if  and  else conditional statements The  if  statement accepts any type of expression that it can automatically convert to a Boolean. Common examples include an  int  for which 0 means false, or an object for which null means false. The  if  statement requires a Boolean expression. The syntax structure regarding curly braces and parentheses is exactly the same between X++ and C#. Literal string A literal string can be delimited by either of the following: A pair of double quotation mark (") characters. A pair of singl...

Karodeal Means Business

Karodeal Means Business : Free classifieds ads for Individual and Businesses in Pakistan, classified advertisement in Pakistan (Local Sale in Pakistan, Toyota for Sale in Pakistan, Real Estate in Pakistan, Community in Pakistan, online local classified Ads Online shopping from the biggest selection of books, magazines, music, DVDs, videos, electronics, computers, software, apparel & accessories, shoes

Internal Store Requisition Module in Dynamics AX 2009

void clicked() {     InventJournalTable _InventJournalTable;     InventJournalTrans InventJournalTrans;     EmplName _EmplName ;    super();     if(InventJournalTable.EmplId != '')     {     error("Requisition Already Submitted");     }     else     {     if (InventJournalTable.NumOfLines != 0)     {     ttsbegin;     _EmplName = DirPartyTable::find(EmplTable::find(syscompanyuserinfo::current().EmplId).PartyId).Name;     info(_EmplName);     update_recordset _InventJournalTable setting IRStatus = 1,EmplId = syscompanyuserinfo::current().EmplId,CreatedDate = Today(),     CreatedName = _EmplName where _InventJournalTable.JournalId == InventJournalTable.JournalId     && _InventJournalTable.IRStatus == 0 && InventJournalTable.ReqId != '' ;     _InventJournalTable.rer...

Custom Number Sequence

void clicked() {     NumberSeq   numberSeq;     InventTable inventTable;       ; //--Code Add by Arif because Custom Sequence Number is needed for Internal Requisition......     super();     if(InventJournalTable.ReqId != '')     {     error("Requisition Number Already Generated");     }     else         {     //******************* if(InventJournalTable.JournalNameId == 'RQM')     {     ttsbegin;           numberSeq = numberSeq::newGetNumFromCode("REQ_02");           InventJournalTable.ReqId   = numberSeq.num();           InventJournalTable.CreatedDate = TODAY();           element.dataSource().research();    ttscommit;    }       } }