Skip to main content

Posts

Showing posts from December, 2012

differences between Enterprise User and Functional User or Task User

Differences between Enterprise User and Functional User/Task User.... Lets say,  1 Functional User; irrelative of the Role Assigned to it, what basic or advanced global functionality/Option/Screen of AX2012 he will not be able to see or access when compared with Enterprise User. Lets say for a client, I have a user "Machine Supervisor" whose role is not listed in 82 predefined roles in AX2012. My machine supervisor will be needing access to Production Cycle as well as access to Service Management Setups forms to perform his job.Now upon what criteria I will be deciding whether I need to purchase Enterprise/Functional/Task User?? there must be some boundaries (related to accessibility of forms/setup) associated with each CAL which gonna restrict me or bound me to choose between these CAL!! you need to access CALMappingtool to find what two or three roles gets consolidated in your custom role "Machine Supervisor". If default roles get covered through task or any

Error while installing Reporting extension for MS dynamics axapta

If you are facing following Error while installing Reporting extension for dynamics axapta. 1. Locate the AX Reporting services dll from the extracted AX 2009 SP1 folder [\\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52] 2. Copy the microsoft.dynamics.setup.reportingservices.dll i nto the folder: \\DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\50\Setup [since my system is 32-bit so Components32] 3. It will ask to replace the existing dll having File Version - 5.0.593.0. Say Yes and replace. Now, carry on with the installation process. The issue coming from SQL server reporting component; not from AX if you are using sql 2005 then install service pack 2 for reporting extension or else if you wish to go for sql 2008 r2 then install full component of sql 2008 r2 after removing sql 2005 completely. in that case you need to reinstall your AX base components AOS, DB from scratch again. also you should

Password encrypt decrypt in MSD axapta 2012

To Store password or other secure information which cannot be read by any user in AX 2012. You can get code for password encryption and decryption.

Error Voucher do not balance as per date in MSD axapta 2009

Error AX-2009  The transactions on voucher 00_00004 do not balance as per 7/31/2012. (Company currency: 74,771.80 - secondary currency: 0.00) Suggestion : Make sure that you have entered Debit, and Credit side amounts. You need to mentioned the exchange rate in every entry where ever required, is there any need to mention the exchange rate in the exchange rate form. You have to enter the Exchange Rate in the Exchange rate form you do not have to enter it on the Voucher line since it is automatically populated, if you need to specify a certain rate you have option to update it on the voucher line. You need to check decimal rounding for Base and Secondary currency

Workflow error for users on second installation of MSD axapta instance

If you have installed second instance of AX 2012. Following are the problems. 1- The specified client configuration does not contain valid WCF settings. 2- As an administrator, Workflow is working fine for editing or else. But for the other users it show error. ": The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state." Suggestions looks like WCF setting issue... Create a new client config and create a new wcf connection from client configuration. also make sure full CIL is generated successfully since service classes are used in 2012 workflow. 1) make sure the server name is used not the ip and server name is reachable (pingable) from client for 2) Make sure u installed .Net Framework and all its updates / hot fixes are installed.. sometimes .net Fx 4 and client profile 4 has issue

TTSBEGIN TTSCOMMIT Error in MSD axapta

You may found an error while posting inventory journal (Inventory Counting, Inventory Transfer etc.) if you enable ModifiedDateTime property on InventJournalTrans or Inventory journal related tables. It throws following error. The operation cannot be completed, since the record was not selected for update. Remember TTSBEGIN/TTSCOMMIT as well as the FORUPDATE clause.  It should not throw error if it's only standard code and no customization is there. But the reason of this type of error is that somewhere update on record has been performed without selecting for forupdate clause or without locking the table. best way to know put a break point in info class and debug. There no single change in codes.you set the InventjournalTrans table ( I am not sure it was InventJournalTrans or inventTransPosting ) property ModifiedDateTime as YES and from one blog you can got the clue that It may happening because of this property. After removing this property it may work fine. apparently i

Closing stock of items datewise in MSD axapta

Sometimes we need to to find the Stock of Item by Date. You can set following code in for or while loop to get closing stock for all items in tables. You can get posted,recieved and deducted qty. screeshot of code is as above.

Tables which included in purchase order posting in MSD axapta

These are Tables which included in purchase order posting in axapta. These are main table of purchase order posting. InventTrans is common table for all type of inventory related transactions. PurchTable PurchLine PurchParmTable PurchParmLine InventTrans VendInvoiceJour VendInvoiceTrans VendInvoicePurchLink VendTrans VendTransOpen LedgerTrans TaxTrans TaxTrans_In

Clear User AUC cache file for all users in MSD axapta by code

Some times user face problem with axapta client instance startup then you need to clear cache file of user profile. .Auc file is right things to clear. You can delete it manually or by code for all users following way. #AiF SysSQMSettings _sysSQMSettings; ; ttsbegin; update_recordset _sysSQMSettings setting GlobalGUID = str2Guid(#EmptyGuidString); ttscommit; You need to restart AOS after running above code through job.

Create copy of movement journal entry by code in MSD axapta

To Create copy of movement journal entry by code in axapta you can try following code hint and can apply in loop also to create large number of entries. InventJournalCopy _InventJournalCopy = InventJournalCopy::construct(); _InventJournalCopy.getLast(); _InventJournalCopy.parmJournalIdFrom('JournaNum'); _InventJournalCopy.run();

Unable to logon MSDAX while client opening SSRS Report

Problem In AX 2012 , Error : "Unable to logon Microsoft dynamics ax" while clients opening SSRS reports. Solution Hints: your reporting server config needs to be checked properly. choose the default report server DB from configuration and check the logon criteria there. also you need to check correct report server config from AX admin module. Validate the settings on reporting services configuration manager. check the domain user has proper user groups in active directory also in AX system user roles should be assigned

suggestions to maintain two database on same application in MSD axapta

If there is  an interesting requirement where our client have offices that are located in different locations. The Internet connection is not that stable between the head office and all this offices and they want 100% availability of the system.  At the same time they want to work the whole system together so that one person on location1 will do something and head office guy will get the data instantly and work on it. Now to solve the high availability problem, one solution could be having separate AX system running in different offices. But the question comes how then the synchronization will happen with the head office? Is this possible to use multiple Ax systems in hub and spoke manner. Actually it depends on full scenario In one case where there is HQ and multiple site business all site businesses itself qualified as separate ERPs so individual ERPs are running on Site and consolidation data and all the bulk transactions get uploaded in the system. If you want details in th

Data Migration Framework Beta in MSD Axapta

Problem If Problem occured during setup of  the Data Migration Framework (BETA). If you have installed as per the description of Data Migration Framework Service , AOS, Client Component in documents. You have restarted the AOS and experiencing following problems. 1- when You open my AX client environment, it shows nothing and on click of new workspace. Then it will show you the whole AX control panel. 2- How to perform export/import MS Dynamics AX Power shell Execute the DMF package one after another in following sequence as per the description. 1- AOS 2- CLIENT 3- SERVICE Perform the import of server and client ax model through MS Dynamics SHELL. You have Increase the buffer size to 48. Re-started the AOS Service. but if you Open AX environment then no work until and unless you have to click new work space even as per the documentation regrading DMF, system will ask for the configuration and synchronization, but it didn't do that. Solution: Afer you import DM

Handling different printing behavior of different printers in MSD axapta

If you report is printing perfectly on one printer but not printing same format in another printer then you can follow follwoing steps to tackle that issues. Lets laserjet printer is working perfectly for report but EPSON printer is not working properly then read comments below to resolve that issues. 1) define a custom paper size using Printer Server Properties for that follow step a and b as under a) measure your paper size, and try to find approximate matching sized paper from http://en.wikipedia.org/wiki/Paper_size b) if you can find a paper size from above site which is near to your measured paper size, create a custom paper size in printer server properties on your printer If you are unable to find a approximately matching paper size among available sizes, just measure your paper in cm or inches and create the custom paper size in printer server properties 2) go start from one corner left upper of report and adjust each object on the paper. here object mean any text bo

Format Excel Worksheet of workbook in MSD axapta

This is code hints to Format Excel Worksheet of workbook in axapta. You excel workbook will be in xls or in higher version. You can open excel sheet by using visible true property then you can use other properties like font,style etc     #Excel SysExcelApplication excelApp; SysExcelWorkbooks XLSWorkbooks; SysExcelWorkbook XLSWorkbook; SysExcelWorksheet sheet; SysExcelRange range; SysExcelStyles styles; SysExcelStyle style; SysExcelInterior interior; SysExcelFont font; COM _char, RangeComObj; ; excelApp = SysExcelApplication::construct(); excelApp.visible(true); XLSWorkbooks = excelApp.workbooks(); XLSWorkbook = XLSWorkbooks.add(); sheet = excelApp.activeSheet(); range = sheet.range('A1'); styles = XLSWorkbook.styles(); style = styles.add('MyStyle'); interior = style

Post Journal in MSD axapta using x++ code

To post Journal in Microsoft dynamics axapta you can try following code. InventJournalTable _inventJournalTable; InventJournalCheckPost Class_journalCheckPost; ; ttsbegin; _inventJournalTable = InventJournalTable::find("JV0000124",true); _inventJournalTable.SystemBlocked = true; _inventJournalTable.update(); Class_journalCheckPost = InventJournalCheckPost::newJournalCheckPost (JournalCheckPostType::Post,_inventJournalTable); Class_journalCheckPost.run(); _inventJournalTable.SystemBlocked = false; _inventJournalTable.update(); ttscommit; In above code JournalCheckpost is standard axapta class which used to post journal. Your journal should be unblocked to post successfully.

Code to Post Sales Order in MSDAX

If you are trying to post Sales order in Microsoft Dynamics axapta by code then you can use this code in job. SalesFormLetter SalesformLetterObject; SalesformLetterObject = SalesFormLetter::construct(DocumentStatus::Invoice); SalesformLetterObject.update(SalesTable::find("SONO10003")); Here SalesformLetterObject is object of SalesFormLetter class and its initialized by using construct method and Document status as Invoice passed. Same way you can use for packing slip and picking of Sales order. After post you need to call update  to post Sales order transaction.

How to get first day date of month in MSD axapta

If you want to get first date of month then this is first simple or forceful method to get it. You can try following code in job. TransDate AnyDate=systemDateget(); TransDate FirstdateOfMth; ; FirstdateOfMth=mkdate(1,mthofyr(AnyDate),year(AnyDate)); info(date2str(FirstdateOfMth,123,2,2,2,2,4)); //This is second method to get first day of month. DateStartMth is standard global method to get first //date of month. TransDate AnyDate=today(); TransDate FirstdateOfMth; ; FirstdateOfMth=DateStartMth(AnyDate); info(date2str(FirstdateOfMth,123,2,2,2,2,4)); Systemdateget and today method will give you current system date.