Skip to main content

Posts

Showing posts from June, 2013

Error while refreshing the Temp Table in Visual Studio and RDP Class design

If you are getting the error while refreshing the Temp Table in Visual Studio, and also getting the same error to add RDP class in Designing the SSRS report  Error is:  "An error occurred when retrieving the meta data for the query.  Exception occurred on the meta data service on client or server.  See Exception details below:  >data or calculated fields with type"Record" are not supported". Solution: 1.redeploy meta data, BI service from services node, also try refresh BC proxy setting from AX configuration 2.There is problem in RDP Class can you please Check any field is missing or else you can do one thing just in Visual studio Take the name for the DS and Remove and try to add once again ten you will find out the Error clearly then you can fix that from AX

select best choice before Resigning from job in MSDAX

If you are working  in ERP(AX) field then you are thinking to resign from job then select best choice before Resigning from job. Following point you should keep in mind. 1. Do not resign from job if you do not have any offer letter if you do that then if will very difficult for you to get new job but at the time of current job you could get other job easily. 2. Read carefully  about company profile where are you going like work environment,behaviour with employees,job shift,outsourcing work and salary structure. 3. In AX ERP TCS,Godrej,Tectura ,L & T,Sonata, Accenture,NDS could be your choice. 4. Select Mar to May month period for joining new job because that time your children will enter in new standard. 5. Always love to your job do not love to company.

Code to copy file from one location to other in MSD axapta

This is a sample of Code to copy file from one location to other in axapta.

How to set debug for Enterprise portal in MSD axapta

X++ code can be used in various parts of a page, such as Web forms, reports, and Weblets. You can debug X++ code for elements that display on pages by using the debugger for Microsoft Dynamics AX. You can debug Enterprise Portal code only on the system that is running Internet Information Services (IIS). Setting Up Debugging for Pages -------------------------------------------------------------------------------- To set up debugging for pages 1.Log into the server that is running the AOS. 2.Open the Microsoft Dynamics AX Server Configuration utility (Start > Control Panel > Administrative Tools > Microsoft Dynamics AX 2009 Server Configuration). 3.Create a new configuration that allows debugging. a.Click Manage and then click Create configuration. In the Create Configuration window, name the new configuration, such as "DAX Debugging". Click OK. b.On the Application Object Server tab, select Enable breakpoints to debug code X++ code running on this ser

Terminate all online users by code in MSD axapta

To Terminate all online users by code in axapta you can try following code.

Accept and Reject new client session request in MSD axapta

If you want to use accept and reject new client session request manually then in online user form this option is available and same thing you can do with job also.

How to Change user group of user from sql query editor for Axapta

If you are not able to change user group of particular user and any problem occurred then you can modify user group of user from SQL back end through update query using query editor. Select * from USERGROUPINFO   Select * from USERGROUPLIST To modify user group you can use following update statement to add user testuser to admin group   of Axapta. Update USERGROUPLIST set GROUPID='Admin' where USERID='testuser'

Add report to batch process to send daily in MSD axapta

If you want to Add report to batch process to send daily in axapta by mail using outlook or any other email provider. you can try followin steps. Set Email Parameters at Menu Path->Administrator->setup->Email Parameters for example Customer details report (a) open Report. (b) In selection dialog box select option then select email recipient-set email in to field and select message format as pdf then select printer then select Adobe PDF in name filed of printer click ok.  (c) go to batch tab of dialog box make tick selection for batch processing. (d) Select batch group blank. (e) click on recurrence then set starting time of process rest field leave as default.

Update Invoice date in salesTable in MSD axapta

If you want to show invoice date in sales order form then you need to add field invoicedate in salestable and update date using following code. CustInvoiceJour custinvoiceJour1; SalesTable SalesTable1; ; while select forupdate * from SalesTable1 where SalesTable1.InvoiceId=="" && SalesTable1.SalesStatus==SalesStatus::Invoiced { select custInvoiceJour1 order by invoicedate desc where custInvoiceJour1.SalesId == SalesTable1.SalesId && custInvoiceJour1.SalesId != ""; ttsbegin; SalesTable1.InvoiceDate=custInvoiceJour1.InvoiceDate; SalesTable1.update(); ttscommit; }

Error and Troubleshooting Report Definition Issues in SSRS RDP Class

If you are  getting the error when refresh the Temp Table in Visual Studio, and also getting the same error to add RDP class in Designing the SSRS report  Error is:  "An error occurred when retrieving the metadata for the query.  Exception occurred on the metadata service on client or server.  See Exception details below:  >data or calculated fields with type"Record" are not supported".  Please help me how to rectify this issue.

Posting Problem in purchase order in MSD axapta

Posting Problem in purchase order in Microsoft dynamics axapta Sometimes we face problem in posting purchase order Problem is number sequence hang and tax not required then we need to check tax on particular purchase order and number sequence for voucher generation. If there is no tax requirement then you can deselect Tax component for particular Purchase order if its coming default. You can check item group tax component whether its missing any ledger setup or value and date mentioned in from date to date. You also need to check formula designer setup. To check taxes you can check following step. General ledger > Setup > Sales tax > Sales tax codes. To check posting account for item group you can select below step. Inventory management > Setup > Inventory > Item groups. Click Posting.

Data Back up using Definition Group in MSD axapta

  Go to Administration > Data Export / Import > Definition Group > Create new Definition group “ Table Back up” Identify the name of a definition group. Click on “Include Table Groups” tab. Select all the check boxes including the transactions also. Click OK. A definition group will get created in the form  Now click on Export to button. Select the file location where data will be saved. Now click on OK.

SQL database Data backup files with Bak Extension

SQL Table Data backup Enter in the Data server. Go to Start > Programs > SQL server 2005 > Click on SQL Server management Studio > Click on Connect > Database > select the database ( i.e. AXTESTDATABASE) . Right click on the Database. Click on “Task”. > Click on Backup. Click on SQL server management Studio. A window of “Connect to server” will appear.Click on “Connect”. SQL Server Management Studio will open.Click on “Databases” & select the appropriate database whose back-up to be taken.Right click on the data base. Click on Task & then click on “Backup”. After clicking on Backup option, Backup database form will open. System by default will give one backup destination. The same destination can be changed with the help of “Remove” & “Add” button. Click on OK to start the back-up.

Error Item has no inventory parameter of Item transaction in MSD axapta

If you are facing  problem in Item transaction appear this message "item has no inventory parameter" while there is transaction on it Then you can try following to resolve this problem. Create one item by your hand and set the default settings as you want, then go to the table "inventiteminventsetup", and search for that item.you will find two lines then.see how the invent dim ids are placed then follow the same pattern for old item. You can check other tables like inventiteminvetsetup.inventitempurchasesetup,inventitemsalessetup etc.

Objectives of PROJECT Monitoring and development phases ERP

Objectives of PROJECT Monitoring and development phases • Examine how to plan early for the Deployment phase by creating a deployment plan. • Learn how to use solution design documents. • Examine Performance Reporting. • Examine Status Reporting. • Plan and perform testing activities across different phases. • Conduct a Tollgate Review. • Prepare and conduct the cutover from the non-production to the production environment.

overview of project management activities

The following summary provides an overview of project management activities from the different project management disciplines that are performed during the execution phase of a project.   • Plan and perform quality assurance • Plan and perform quality control • Monitor and close purchase and acquisition • Ongoing risk management • Ongoing issue management • Manage project scope • Ongoing time and cost management • Project communication • Develop and manage a project team

Different Task on Deployment Plan of Project ERP

The Deployment Plan outlines the activities that need to occur to perform a successful roll out of the application to the user base. The Deployment Plan is created by the Project Manager and needs to outline the process and activities that need to occur during the Deployment phase of the project. The Deployment Plan is initiated during the Design phase to provide sufficient time for the project team to consider the deployment activities. It is a living document that needs to be constantly updated with feedback from the team.The plan lists out all the key tasks that need to occur for a successful roll out of the application. These tasks include • Environment Setup • Data Migration • User Setup   •End User Training