Dynamics Axapta blog

Hi, In SSRS Change the property/Expression of the column like below =Format((Fields!DoB.Value), "dd/MM/yyyy") I found the below link useful which describes more on Format function in SSRS - (A good read) http://thavash.wordpress.com/2007/04/10/working-with-dates-in-reporting-services/

Please restart the "Ax services" and "SSRS reporting" services it can be resolve your problem 

Hi, Use the below code to check whether a dimension is filled or not in the default dimension.       public Boolean checkDeptartmentDimension() {   DimensionAttributeValueSetItem dimAttrValueSetItem; DimensionAttribute dimAttr; DimensionAttributeValue dimAttrValue; Common dimensionValueEntity;   dimAttr = DimensionAttribute::findByLocalizedName( 'Department' ); select dimAttrValueSetItem where dimAttrValueSetItem.DimensionAttributeValueSet == this.DefaultDimension join dimAttrValue where dimAttrValue.RecId == dimAttrValueSetItem.DimensionAttributeValue && dimAttrValue.DimensionAttribute == dimAttr.RecId;   if (!dimAttrValueSetItem)      return checkFailed( strFmt ( "Department dimension must be filled in." )); return true ; }  

Hi, Please read the below link to change the date format (dd/MM/yyyy) for all users connected to the machine/computer. http://blogs.technet.com/b/askperf/archive/2012/08/16/how-to-change-regional-settings-for-all-users-on-a-computer.aspx Note: We have to setup the group policy.

Hi, The below job is used to import the purchase trade agreement journal lines. //To create the purchase trade agreement lines. //Forthis, just create the Journal header first and import the lines by using this job   static void CreatePurchTradeAgreementLines(Args _args) { CommaIO     csvFile; container    readCon; counter     icount,inserted; Dialog      dialog; DialogField dfFileName; FileName    fileName; itemId      itemId; AmountCur   amount; str          strFromdate,strTodate,type; TransDate   fromDate, toDate;     PurchUnit   purchUnitId; PriceDiscJournalNum journa...

Problem : Recently, I installed one of the model files from an ISV and everything went fine in DEV environment. I replicated the same process in UAT environment for installation and installed the model files. After which I ran the full application compile, database synchronization and then full CIL. The full CIL failed because of following error: CIL generation: Index was out of range. Must be non-negative and less than the size of the collection Solution : I could fix this problem by following steps: Since there were no compilation errors in full application compile, I was sure that there are no errors in the application. The system was not able to pick some assemblies so I compiled the Tables manually and then classes. After which, I put the application on full CIL again and it worked fine.     when you open the CIL log file the below error message shown, Note: CIL log file path is " C:\Program Files\Microsoft Dynamics AX\60\Server\YOUR_INSTANCE\bin\XppIL\Dyn...

Hi, Below code is used to refresh the parent form from child form / class. write this method in parent form //TO refersh the current form (from child form) and point the cursor for the selected record. public void refreshForm() {     <DataSourceName>_ds.reread();     <DataSourceName>_ds.refresh();     <DataSourceName>_ds.rereadReferenceDataSources(); } write this method in Child form / Class I wrote the method in close method of the child form to refresh the parent form public void close() {      super ();    if (element.args().caller() && element.args().caller().name() == formStr (Alle_SubcontractorPayRegister))    {       element.args().caller().refreshForm();    } } I wrote the method in main method of the child class to refresh the parent form static void main(Args args) {   ...