Microsoft Dynamics Axapta Technical,Functional Coverage

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.

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.