Microsoft Dynamics Axapta Technical,Functional Coverage

Following Role Centers Available in Ax 2012 R3. You can add users to view particulars roles on Home page or EP website for the same. 1 Accountant 2 Accounting Manager 3 Account Manager 4 Accounts Payable Coordinator 5 Accounts Receivable Administrator 6 Budget Manager 7 Chief Executive Officer 8 Chief Financial Officer 9 Controller 10 Cost controller 11 Credit and Collections Manager 12 Customer self-service 13 Customer Service Representative 14 Dedicated Sales Representative 15 Dispatcher 16 Home page for users who fill employee role 17 Environmental Manager 18 FinanceDirector 19 Human Resources Assistant 20 Human resources manager 21 Marketing Manager 22 Marketing Staffer 23 Operation Manager 24 Order Processor 25 Practice Manager 26 Product Designer 27 Production Manager 28 Production Planner 29 Description 30 Project Manager 31 Purchasing Agent 32 Purchasing Manager 33 Retail IT Manager 34 Retail Merchandising Ma

1. Click Area Page node: System administration -> Inquiries -> Batch jobs -> Batch job history. Form name: Batch job history 2. Click the Log button. 3. Make sure the selections are changed in table Batch jobs history to: 4. Delete the record(s) in the Batch job history form. 4. Change Batch job ID from '52665554646' to '0'. 6. Click the Close toolbar button. 7. Close the Batch job history form. 8. Click Area Page node: System administration -> Inquiries -> Database -> Database log. Form name: Database log 9. Click the Clean up log button. Form name: Microsoft Dynamics AX 10. Click the OK button. 11. Close the Database log form. 12. Click Area Page node: System administration -> Inquiries -> Database -> SQL statement trace log. Form name: SQL statement trace log 13. Click the Functions -> Clear log menu button. 14. Click Yes in the Microsoft Dynamics form. Th

If you want to get Purchase order Invoice Total in Accounting Currency before posting in Ax 2012 then you can apply below code sample. Purchase Total form is as below. PurchTotals purchTotals; PurchTable purchTable = PurchTable::find('000035'); Amountmst InvAmount; ; purchTotals = PurchTotals::newPurchTable(purchTable); purchTotals.calc(); InvAmount = purchTotals.purchTotalAmount() * (purchTotals.exchRate()/100) ; as per above code variable InvAmount will show in total amount for Accounting currency and method purchTotals.purchTotalAmount() will return Total Amount in Transaction currency. which is 165 in our screenshot.

Sometimes we need to refresh parent form from child form in Axapta but its become tedious on thinking but here is an easy 4 line code you can write on child form on close event to get page refreshed. FormDataSource datsource; ; datsource= element.args().record().dataSource(); datsource.research(); datsource.refresh() I hope its solve your problem

Some times you need to filter some records in MSD Axapta grid but its take time to get vertical column values with comma separated values This is simple example to understand How to take vertical column values to horizontal with Comma separated values. for example values in vertical column is like this way 1 2 3 4 5 6 7 8 9 10 You need To convert it on this way for record filter purpose 1,2,3,4,5,6,7,8,9,10, This clip will show you above scenario solution. Hope you got this tricks.  Thanks for watching.. if you like it please subscribe.

To get Ledger Account balance in Axapta 2012 You can try below code. This code can be try out at any new job in AOT. This code output will be for single ledger but if you want to get all ledger balance then you can use while select loop instead of select. MainAccount mainAccount; select mainAccount where mainAccount.MainAccountId == '1454542' && mainAccount.LedgerChartOfAccounts == LedgerChartOfAccounts::current(); info(strFmt("%1",mainAccount.getBalance(dateNull(), systemDateGet(), FiscalPeriodType::Opening, OperationsTax::Current)));

 To get Employee Name For all employee in Ax 2012 You can get idea from below code. DirPerson dirPerson; HcmWorker hcmWorker; HRMDailyAttendance hrmDailyAttendence; ; while select Name ,gender from dirPerson join hcmWorker group by dirPerson.Name,dirPerson.Gender where hcmWorker.Person == dirPerson.RecId { info(strFmt("%1",dirPerson.Name)); }

Following step need to set for administration point of view for workflow steps and setting. 1. Click Area Page node: System administration -> Setup -> Batch group . Form name: Batch group 2. Switch to the Batch servers tab on the Batch group form and check whether server is added to batch group or not. 3. Click the Close toolbar button. 4. Close the Batch group form. 5. Click Area Page node: System administration -> Setup -> System -> Server configuration . Form name: Server configuration 6. Click the Close toolbar button. 7. check server name and Close the Server configuration form. 8. Click Area Page node: System administration -> Setup -> System -> System service accounts . Check the service accounts. 13. Click Area Page node: System administration -> Setup -> Workflow -> Workflow infrastructure configuration . Form name: Workflow infrastructure configuration wizard 14. Click the Next

Step 1: (‎05-‎Mar-‎17 12:42:41 PM) User left click on "Microsoft Dynamics AX 2012 (menu item)" Step 2: (‎05-‎Mar-‎17 12:42:43 PM) User left click on MSD‬ [‎‪xyz‬‪: ‎‪Session ID‬ - ‎‪3‬‬]‎ - ‎ [‎‪1‬ - ‎‪usmf‬ - ‎‪initial‬]‎ (list item)" Step 3: (‎05-‎Mar-‎17 12:42:45 PM) User left click on "BatchJob (link)" in test‬ [‎‪xyz‬‪: ‎‪Session ID‬ - ‎‪3‬‬]‎ - ‎ [‎‪1‬ - ‎‪usmf‬ - ‎‪initial‬]‎" Step 4: (‎05-‎Mar-‎17 12:42:47 PM) User mouse drag start on "‪Batch job‬ (‎‪1‬)‎‪ - ‎‪‪‪Job description‬: ‎‪Change based alerts‬‬, ‎‪‪Withhold‬‬‬, ‎‪Partition Key: initial‬‬ (window)" in "‪Batch job‬ (‎‪1‬)‎‪ - ‎‪‪‪Job description‬: ‎‪Change based alerts‬‬, ‎‪‪Withhold‬‬‬, ‎‪Partition Key: initial‬‬" Previous Next Step 5: (‎05-‎Mar-‎17 12:42:48 PM) User mouse drag end on "‪Batch job‬ (‎‪1‬)‎‪ - ‎‪‪‪Job description‬: ‎‪Change based alerts‬‬, ‎‪‪Withhold‬‬‬, ‎‪Partition Key: ini