Microsoft Dynamics Axapta Technical,Functional Coverage

At the Time of TDS Settlement if  date is wrongly specified during selection then you need to check in following tables. 1) TaxWithholdTrans 2) TaxWithholdSettleTrans_IN 3) TaxWithholdSettledPeriods_IN 4) TaxWithholdReportVoucher_IN

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; }

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 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.

  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 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.

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 • 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.

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

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

If You already installed and configure Axapta 2009 but after some times you want to display role center KPI in axapta home page the its headache to do it. You should install Enterprise portal to install EP you can refer EP Installation guide and pre-requisites. If you are getting error on EP installation then you should install sql client and SQL AMO as per your version of axapta. I am confident you will not get error after doing all these activities. But I am not sure about to configure role center which are standard but One hints I want to give you you should try to complete checklist. You can add user to role center using user profile module. role center KPI is good to display at home page to know about performance of business in single overview page.

InventTrans table base of inventory table its include all transaction related to inventory like following transaction 1. Movement Journal, 2.Transfer Journal 3. Production and BOM transaction. 4. Transfer Order 5. Sales Order 6. Purchase order 7. Counting Journal Each module has separate table after entry and posting for example Sales order entry level table is salesTable and SalesLine and table after posting is custInvoiceJour and CustInvoiceTrans. CustTrans stored line item transaciton of customers related transaction Same funda is for vendor transaction is vendTrans. If you want to search any transaction related to Inventory you first select inventTrans to get basic Idea of transaction.

If you want to Customer payment journal settlement with sales invoice by code in axapta. Mark invoice automatically by code before posting of customer payment journal You can refer this code

If you want to set up Planed Transfer Order, the system you recommended material to be prepared on the basis of the production plan and work orders in MS Dynamics AX 2009 you can read following help to do this. simply create a buffer warehouse for production and make it as your default warehouse in BOM lines , based on that the buffer warehouse should be refilled from the RM MWH , and you can define it in item coverage setting which mean (if the RM1 is required in production order so it should be picked from the buffer warehouse and if the buffer warehouse have no balance so it should be refilled from MWH) so once you explode or run Master Scheduling the planned transfer order have to be created from MW to Buffer Warehouse

From 1st Apri 2013 l LBT (Local Body Tax) started in Maharashtra due to this thing some changes need to implement in ERP application. There are limited tax type like VAT,Service tax,Excise,CST etc in current ERP so you need to setup for new tax type. You need to add new tax type in Enum but if you add then tax parameter will not support so you need to solve all that error also. If you are invole in LBT customizaiton then share your views and comments and how you tackle it easily. I will post in details after reviewing all comments and views. Thanks in Advance.

If you are blogger then this post may help to select your interesting topic from following list. This is collection of keywords and topic categorise related to Microsoft dynamics axapta. .cus .doc file .Net business connector .NET Business Connector Overview .net framework 2.0 3-Tier Setup components 6.0 and SQL Material 64 bit machine deployment A Brief History of Axapta abort transaction about Recycle Bin abstract access in axapta Access the Current Row and Field value in Enterprise portal Accessing Microsoft Outlook from Axapta using COM account name account number etc account payable account receivable accountnum Accounts payable Invoice Journal Creation accounts receivable action menuitem action properties active directory active directory Active directory configurations setting in axapta active directory group active directory users active join active method Add a form list control. in form at runtime using axapta add company range add control