Posts

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;    }       } }

Fwd: [SSWUG.ORG] Daily Tips and News (for Jun. 7, 2018) (752493)

Image
  http://www.sswug.org    Your Database/BI/IT Tech News   for Thursday, June 7, 2018   Stop by SSWUG.ORG for the latest... We keep all of the latest news, tips and ...

Fwd: NonClustered Index Structure (SQLServerCentral 6/1/2018)

Image
A community of more than 1,600,000 database professionals and growing Featured Contents NonClustered Index Structure The 2018 State of DevOps Survey. Don't just wait for it. Be a part of it. Quick Tips For Debugging Large Stored Procedures You know everything about GROUP BY. Do you? (From the SQLServerCentral Blogs) Hands off dbatools upda...