Microsoft Dynamics Axapta Technical,Functional Coverage

I want to share one interesting clip from Youtube which will show you Control panel features and settings for  Windows operating system. If you like this clip then waiting for your subscription to get daily updates on new topics.

I am sharing here one Important thing to learn in Project Management Module in Axapta. Please watch this clip to learn free and subscribe to learn more. AX 2012 Project types and Time & Material cycle. We are discussing here all the  Project types available AX 2012. This is  Microsoft Dynamics AX 2012 Demo for Project Management and Accounting concepts for Project types.

Sharing Information for Ax 2012 Item master fields and Item Model Group understanding  I am sharing information of  clip which will show you Ax 2012 Item Master product Product Master, CW Catch weight Business Examples.Difference between item type service and Item, Product and product master, Element of items like name, search name etc ar properties of product in Axapta. Item master fields Item Model Group understanding  I want to share clip which will show you Ax 2012 Item Model Group properties and its  fields detail Path of Model group  in Ax 2012 is  as below Inventory management  Setup -Inventory - Item model groups. Other Important Inventory model things are as follows: FIFO LIFO LIFO date Weighted avg. Weighted avg. date Standard cost Moving average And other field related to Item Model Group. InclPhysicalValueInCost InventModel InventModelSecCur_RU MandatoryDeduct Man...

Top Tips for Ax 2012 Performance improvement. I am sharing This clip will show you Top 10 tips for SQL performances on Ax Quickly. 1. How to Check Client and Server configuration of ax 2012. 2. Check memory setting options for SQL server databases. 3. Regular checking of Disk size is required. 4. Regular Cleanup of log data from ERP. 5. Client Usage data cleanup at ax side. 6. Index optimization(use include column option in index) and new index creation at Ax. 7. Reindexing and Rebuilding Indexes. 8. Use set based operations is required to improve the performance of execution of logic. insert_recordset , update_recordset and delete_from 9. Check batch jobs running sequences on Ax side. 10.Don’t create indexes directly on SQL for Axapta. Visit below clip to get practical knowledge for the above points. If you like this video do not forget to subscribe that channel. 

To create view  from other database from SQL for Ax database you can get hint by below  script. SET QUOTED_IDENTIFIER ON GO Create VIEW [dbo].[TestCustomer] AS SELECT [CUSTGROUP] ,[ACCOUNTNUM] FROM MicrosoftDynamicsAX.dbo.CUSTTABLE group by [CUSTGROUP] ,[ACCOUNTNUM] ; GO Source database is MicrosoftDynamicsAX and destination is testDb in this clip. Just see clip to create view from custtable to other database new view .. Just need to execute script in query editor of SQL. Same way you can include more columns by alter alter THANKS FOR YOUR PATIENT ON WATCHING CLIP.YOU CAN SUBSCRIBE ON MY YOUTUBE CHANNEL TO GET FUTURE UPDATE TO IMPROVE YOUR KNOWLEDGE. GROUP BY IS REQUIRED TO MAKE VIEW  READ ONLY. SO ITS IMPORTANT.

Code to get total time consumed between two times means if time one is 14:10 and time two is 15:40 then you want to get difference time in hours only like in this example it will be 1.5 hours. Getting time in hours in very difficult but you can get it easily by writing one simple method. # int seconds, minutes, hours, totalTime; # str timeStr = "",minstr=""; # # if (_startTime > _endTime) # { # totalTime = _endTime + (str2time('23:59:59') - _startTime); # } # else # { # totalTime = _endTime - _startTime; # } # # seconds = totalTime mod 60; # minutes = totalTime mod 3600 div 60; # hours = totalTime div 3600; # # if (hours > 0) # if (hours == 1) # timestr = timeStr + strFmt("%1", hours); # else # timestr = timeStr + strFmt("%1", hours); # #...

To Display time difference in hours in Axapta  you can use below code where timeConsumed is a method to get difference between from time and to time. You need to convert string to time first to get the right value. TimeofDay fromTime,toTime; // Time variables ; fromTime = str2time("8:50 am"); toTime = str2time("10:50 am"); info(strFmt("%1",timeConsumed(fromTime,toTime)));