Skip to main content

Posts

Showing posts from November, 2013

Some Important questions to prepare for MSD Axapta technical Interview

Tell me Differences between Ax 2009 and 2012 ? What is version control? How many modules in Ax 2012? What are join types in Axapta? How to pass multiple values in range of report? Syntax. How to create foreign key in Ax tables? What are basic setup required to post sales order? How many layers exist in Ax 2009 , 4.0 and 2012? What steps required to implement SSRS, Role center in EP Site? Prerequisite to install Role centers?

Alternate Access Mapping for Enterprise portal website in MSD axapta

If you have installed Enterprise portal and configured sharepoint services and you are able to run website on intranet but its not running on internet then you need to do one more step. Go to sharepoint central administration site and operation menu after that you need to specify static or public ip in  Alternate Ip mapping option. If still problem not resolved then you need to check your port whether its working or not.

Module Name Comparison in MSD Ax 2009 and 2012

Inventory Management ->(Ax 2012) Inventory Management ->(Ax 2012) Product Information Management Accounts Payable ->(Ax 2012) Procurement and Sourcing ->(Ax 2012) Accounts Payable Accounts Receivable ->(Ax 2012) Sales and Marketing ->(Ax 2012) Accounts Receivable General Ledger ->(Ax 2012) General Ledger ->(Ax 2012) Budgeting ->(Ax 2012) Fixed Assets ->(Ax 2012) Compliance and Internal controls Cost Accounting ->(Ax 2012) Cost Accounting Bank ->(Ax 2012) Cash and Bank Management CRM ->(Ax 2012) Moved to Sales and Marketing module Master Planning ->(Ax 2012) Master Planning Production ->(Ax 2012) Production control Product Builder ->(Ax 2012) Moved to Product Information Management Shop floor Control This Module is split into three and can be accessed from Home, Human resources and Production Control Modules. ->(Ax 2012) Time and Attendance – Human resources. -&g

Data Import Export tips through template in MSD axapta

If you are importing data for any single table through template then these tips can help you. 1. If you want to update only 4 columns data but table has more number of columns then you need to extract only 4 columns template with compulsory fields of tables. 2. If Master table already containing data and you want to retain other columns data then you need to select import new and update existing option from import dialog. 3. You should take backup of table data for safety purpose by exporting excel template with data. 4. Do not use clear table before import option its dangerous and it will delete previous data and will import template data.

Tax adjustment in Transfer order in MSD axapta

If you want to enter tax adjustment for transfer order then you should keep in mind that if you enter Amount 1000 for Tax Adjustment then Rs. 1000 will be applicable for each line it means in line one Tax Adjustment amount is 1000 line 2 amount is 1000 so if you want to enter  adjust Rs 1000 for all line then you need to enter rs 500 for 2 lines.

Salary Structure for MSD Axapta professional Grown up

In Indian market Axapta Professional salary structure is grown up. Now market is reaching up to 20 lac per anum package but all companies required experience person. I want to show probable salary package as per experience . Its for you friends to do best negotiation during your selection. For Fresher- 1.5 to 4 lacs per anum For 1 year Experience- 3 to 5 lacs per anum For 2 years Experience- 4 to 6 lacs per anum For 3 years Experience- 5 to 7 lacs per anum For 4 years Experience- 6 to 8 lacs per anum  For 5 years Experience- 8 to 10 lacs per anum For 6 years Experience- 9 to 12 lacs per anum   For 7 years Experience- 10 to 13 lacs per anum For 8 years Experience- 11 to 15 lacs per anum    For 9 years Experience- 12  to 17 lacs per anum For 10 or more years Experience- 13  to 20 lacs per anum   

Code to generate multiple progress bar in MSD axapta

#define.count1(10) #define.count2(5) #define.count3(20) #AviFiles // 3 bars. SysOperationProgress progress = new SysOperationProgress(3); int i, j, k; ; progress.setCaption("Your Process is in progress"); progress.setAnimation(#AviUpdate); // Bar 1. progress.setTotal(#count1, 1); // Bar 2. progress.setTotal(#count2, 2); // Bar 3. progress.setTotal(#count3, 3); for (i=0; i<#count1; i++) { // Bar 1. progress.setText(strfmt("Bar 1 - Step %1 of %2", i, #count1), 1); progress.setCount(i, 1); for (j=0; j<#count2; j++) { // Bar 2. progress.setText(strfmt("Bar 2 - Step %1 of %2", j, #count2), 2); progress.setCount(j, 2); for (k=0; k<#count3; k++) { // Bar 3. progress.setText( strfmt("Bar 3 - Step %1 of %2", k, #count3), 3); progress.set

Code for Inventory Transfer order posting in MSD axapta

If you want to post Transfer order for shipment or receive at runtime then this code can help you. You need to use InventTransferParmTable object and InventTransferUpdShip class object to do the same. InventTransferParmTable inventTransferParmTable; InventTransferTable inventTransferTable; inventTransferUpdShip inventTransferUpdShip; ; select inventTransferTable where inventTransferTable.TransferId =='00140_080'; inventTransferParmTable.clear(); inventTransferParmTable.initParmDefault(); inventTransferParmTable.ParmId = RunBaseMultiParm::getSysParmId(); inventTransferParmTable.TransferId =inventTransferTable.TransferId; inventTransferParmTable.UpdateType = InventTransferUpdateType::Shipment; inventTransferParmTable.ShipUpdateQty = InventTransferShipUpdateQty::ShipNow; inventTransferParmTable.ExecutedDate = systemdateget(); inventTransferUpdShip = InventTransferUpdShip::newParmBuffer (inventTransferParmTable); inventTransferUpdShip.ru

Get Value from table by using relation in query build datasource in MSD axapta

ReqTrans reqTrans; ReqPo reqPo; Query query; QueryBuildDataSource qbds; QueryBuildRange qbr; QueryRun qr; ; query = new Query(); qbds = query.addDataSource(tablenum(ReqPO)); qbds.addDataSource(tablenum(ReqTrans)).relations(true); qr = new QueryRun(query); while(qr.next()) { reqPo = qr.get(tablenum(ReqPO)); reqTrans = qr.get(tablenum(ReqTrans)); info(reqPo.RefId); }

Inventory Transactions table for Inventory modules in MSD Axapta

a) If Item is created using item master module (Inventory Management->Items) then Records get created in inventTable. b) If Sales Order created then Records get created in SalesTable and Sales Line table after confirmation, packing slip and invoicing orders records get created in other tables like custpackingSlipJour,CustPackingSlipTrans custInvoiceJour,CustInvoiceTrans,InventTrans etc. c) If Purchase Order is created then Records get created in PurchTable and PurchLine table after confirmation , packing slip and invoicing of order records get created in VendpackingslipJour,VendPackingSlipTrans,VendInvoiceJour,VendInvoiceTrans, InventTrans etc. d) If Inventory Movement Journal is created then Record get created in InventJournalTable and InventJournalTrans after posting of journal Records updated in invetTrans table. e) Financial Journal created in LedgerJournalTable and LedgerJournalTrans after posting Journals information Stored in LedgerTrans table.