Microsoft Dynamics Axapta Technical,Functional Coverage

This is a code to get details of table data which is added to report data source. You can add following code in fetch method of report to check how to get value of data you can add range in data source and get the filtered records from report. Query q; QueryRun qr; QueryBuildDatasource qbds; QueryBuildRange qbr; ; q = this.Query(); qr = new QueryRun(q); QBDS = QR.query().dataSourceNo(1); while(qr.next()) { inventtable = qr.get(tableNum(InventTable)); info(inventtable.ItemGroupId); }

To update records forcefully in table you can use doupdate method with tablename. Following example is helpful to understand this thing . InventTrans _inventTrans; ; ttsbegin; while select forupdate _inventTrans where _inventTrans.RecId == 5637152999 { _inventTrans.inventDimId = '123213'; _inventTrans.doUpdate(); } ttscommit;

You can write following Code to check BOM Hierarchy in axapta. BOMHierarchyCheckJob _BOMHierarchyCheckJob; BOM BOM; ; while select BOM { _BOMHierarchyCheckJob = BOMHierarchyCheckJob::newBOM(BOM); _BOMHierarchyCheckJob.run(); }

You can Execute AIF Batch Job in axapta just you need to paste following code to check for the same. AifInboundProcessingService _AifInboundProcessingService = new AifInboundProcessingService(); AifOutboundProcessingService _AifOutboundProcessingService = new AifOutboundProcessingService(); AIFGatewaySendService _AIFGatewaySendService = new AIFGatewaySendService(); AIFGatewayReceiveService _AIFGatewayReceiveService = new AIFGatewayReceiveService(); ; _AIFGatewayReceiveService.run(); _AifInboundProcessingService.run(); _AifOutboundProcessingService.run(); _AIFGatewaySendService.run();

If you are facing error like this in ax client. Data base log Issue -sql issued an error on sysdatabaselog table,disk spacing issue Then you need to check your disk drive in sql database it may be full you need to release some space on drive where your database is stored.

The most common approach to import xpo file from command prompt is just start AX client (ax32.exe) with -AotImportFile parameter (e.g. ax32.exe -AotImportFile=c:\temp\x.xpo). We could make the executable batch job to do the task.

Please comment on this error . I am running tutorial_workflowprocessor form. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.ComponentModel.Win32Exception: The handle is invalid at System.Drawing.Graphics.CopyFromScreen(Int32 sourceX, Int32 sourceY, Int32 destinationX, Int32 destinationY, Size blockRegionSize, CopyPixelOperation copyPixelOperation) at System.Drawing.Graphics.CopyFromScreen(Int32 sourceX, Int32 sourceY, Int32 destinationX, Int32 destinationY, Size blockRegionSize) at System.Drawing.Graphics.CopyFromScreen(Point upperLeftSource, Point upperLeftDestination, Size blockRegionSize) at Microsoft.Dynamics.Framework.UI.WinForms.Controls.Toast.get_BackgroundTransparentImage() at Microsoft.Dynamics.Framework.UI.WinForms.Controls.Toast.OnPaint(PaintEventArgs e) at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer, Boolean di...

If you are facing error on any item transaction like posting of sales invoice or purchase invoice and error is like this.  Item is locked for update in warehouse in axapta. Then you need to check in item master page on qty table if its stopped then you need to untick that option to allow for inventory transaction.

 To resolve inventory recalculation cancellation error for Weighted Average date setting error may be like this Item xxxx could not delete weighted average inventory closing transaction on item xxxx on date dd/mm/yyy Then solution is you should apply following hotfix. KB973239