Langsung ke konten utama

Postingan

Menampilkan postingan dari Agustus, 2016

AX 2012 - how to use 'NOT LIKE' in AX statements

static   void  Not_Like(Args _args) {     #define.createdBy( 'faisal' )     InventTable     inventTable;          while   select  inventTable          where  !(inventTable.ItemId  like   'I*' )     {          // do your logic       } }  Note: Using ! after 'where' keyword to reverses the effect of 'like'

How to get Next RecId through X++

static   void  getNextRecId(Args _args) {      //Table that stores record ids details for tables     SystemSequences systemSequences;      //Class that handles Record id generation     SystemSequence systemSequence =  new  SystemSequence();     ;     info( strFmt ( "%1" ,  tableNum (SalesTable)));           systemSequence.suspendRecIds( tableNum (SalesTable));     info( strFmt ( "Next record id: %1" , systemSequence.reserveValues( 1 , tableNum (SalesTable))));     systemSequence.removeRecIdSuspension( tableNum (SalesTable)); }

Fixing Trial Balance in Microsoft Dynamics AX 2012

In the legal entity in which you are experiencing trial balance issues with, go to the address  below  and  then click  Financial dimension sets . It will bring you to this form below.  Select the financial dimension set you were using when  viewing  the  trial balance and click  Rebuild   balances  at the top of the form. Next, click  OK  and wait patiently.  This might take some time depending on how many transactions  are  in your system. Once it is finished, go back into your trial balance and select the dimension set at the top of the screen.  Click Refresh  to ensure that the data has been updated. Finish..