Skip to main content

Posts

Question and answers on Reports in MSD axapta

Q)what are the important methods on report? Ans: fetch, send, dialog, getfromdialog, pack, unpack programmable section - control number - we can execute the ps with e element.execute(controlNumber) in the fetch method Q)What is the difference between auto-design and generated design? Ans: Generate design will not give the printing options of print totals, print grand totals Q) How to create a Report template ? Ans: You can refer to existing templates and can replicate the logic pageno - element.page(),companyname

Some important question and answers on forms in MSD axapta

Q)when you open the form - what methods/calling sequences ? Ans:init(), run(), executequery() Q)When you close the form? Ans:canclose()- boolean, close() Ok command buton - closeok(), canclose(), close() Q)when you create a new record? Ans:Ctrl + n, create of ds, initvalue() of ds, initvalue() of table Q)how do you do filteraions on the forms? Ans: Executequery and use queryBuildRange Q)Enabling and  disabling controls ?   Ans:active method of data source Q)How  do you link the datasources on the form?? Ans: join source and link type property Q )How many link types are available on the datasource?? Ans:delayed, active, passive, inner join, exists join, non exists join, outer join Splitters [sysformsplitter_x, y, z] Q )How  to you pass values from one form to another form - Ans: menuitemButton - Args[formrun] Q )what is args class?? Ans:Args is arguments class which will help to pass values from one form to another, object to obj

Interview question and answer for Data dictionary in MSD Axapta

Table - collection of rows and columns EDT(Extended datatype) - Inheritance, code easy readability, lookups,- 2 RELAtions [Normal and RFF [where clause] example : select * from custtable - is normal select * from custtable where gender == female is RFF How to add columns to the Lookups [Index, Titlefield1, 2 or autolookups] Q) How to get lookups?? In 3 ways - EDT, AutoLookup,Relations Q) what is base enum??? Set of literals or constants which will never change - example [week - s,s,m,t,....] enums are stored as integers and max - 250 can be accessed by using :: [scope resolution] Indexes why do we use index ?- faster performance in select queries Not to allow duplicates FieldName Followed by Idx = AccountNoIdx Field groups: Autoreport - ctrl + p Autolookup almost all the fields should fall under a fieldgroup - on the forms - field groups will form as Group control Relations on table : How one table is related or linked to another Normal -

Some interview question and answer for classes in MSD axapta

1) ACCESS Modifiers [Public, private, protected, static, display] 2) Is multiple inheritance possible in AX?? No It can be achived through interfaces. Interfaces : It does not have method definition] void calculate() {} class classz implements interface void calculate() { a +b; } 3) Is method overloading possible, or function overloading possible in AX ??? No - it does not allow to create another method with same name 4)Abstract and final key words abstract - no need to create object, y?? when we know that we have to create object of child classes only, I will make the class as abstract and i use the concept of constructor controlled inheritance construct(str _bankName) { swtich() {} }

Why You selected Ax for your career MSDAX

AX is a very good ERP which I heard and it supports Tier1 to Tier3 companies It can easily integrate with all other Technologies[sql server, biztalk, ssis, ssrs, MS office] Programming seems to be very similar to .net and I feel very comfortable Also, AX is easy on customization. AX is pretty reasonable when compared with other ERP's. Its good user friendly. It support re-usability means you can develop scenario to implement same things in different clients. 

SSRS Report deployment Error in MSD Axapta EP

I am getting following error on report (SSRS) in EP for axapta. Deployment failed un xpectedly with the message: Invalid URI: The format of the URI could not be determined. See the log file for further details. The deployment log file can be found at My Observation. In AOS there is both sql 2005 reporting service and 2008(Database in sql 2008) exists As per my views if We remove installation of sql 2005 reporting service then problem can be resolve. Please give your comment on this latest error. The deployment log file details are as below Could not load file or assembly 'Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)  

Enterprise Resource Planning Timeline MSDAX

Physical updating quantity in the unit nos must me other than zero for purchase order in axapta

I am getting this error while posting purchase order on entering receive now qty " Physical updating quantity in the unit  nos must me other than zero" for purchase order posting in axapta I search lot of things from inter net and got following observation. 1.Go to the main table of the Unit Id form, and then on the setup tab, there are the decimals. Default there is 0 (means no decimals), change it for this unit decimal to 2 to enter unit quantity with decimal like 1.23 etc. 2. Debug the following class and try out following code in method . Classes\InventUpd_Financial method initUpdate, insert at line where its required: if(abs(physical) < 0.00001) physical = 0.00; method updateFinancialReceipt, insert at line where you got some value for add qty less than zero on point: if(abs(addQty) < 0.00001) addQty = 0.00; 3. For Ax 4.0 To apply this , change the code in the decreaseQty method and in the increaseQtyOverdelivery method in the WMSOrderTransType

Show Random number in MSD axapta

To Show Random number in axapta you can try below code through job. Random is class name which has nextInt method to get next random number. Random Random = new Random(); int RandomNo,RandomwithMod; ; RandomNo=Random.nextInt(); RandomwithMod=Random.nextInt() MOD 1000; info(Strfmt('%1%2',RandomNo,RandomwithMod));

display current system time in MSD axapta

To display time in axapta,timenow,display current system time in axapta you can try below code in job. Only timenow() will not display in time in time format it will display like number but to show time in time format you can try below code. time2str(timenow(),1,1) To show in message box info(time2str(timenow(),1,1));

How to get purchase invoice amount total at the time of invoicing in MSD axapta PO

To  get purchase invoice amount total at the time of invoicing in axapta Purchase order you can try below  code in a method and just need to call that method on any event to get show total amount which will be invoice amount. vendPackingSlipJour _vendPackingSlipJour_1; real TotalInvoiceAmt; purchParmTable parmtable; purchParmUpdate parmupdate; PurchId _PurchId; PurchTotals purchtotal; ; While Select parmtable where parmtable.ParmId == PurchParmTable.ParmId && parmtable.Ordering == DocumentStatus::Invoice { Select parmupdate where parmupdate.ParmId == parmtable.ParmId; _PurchId = parmtable.PurchId; if(parmupdate) { purchtotal = PurchTotals::newPurchParmTable(parmtable, PurchUpdate::All, AccountOrder::Auto, parmtable.ParmId, _PurchId, PurchParmTable.Ordering); purchtotal.calc(); TotalInvoiceAmt+= purchtotal.purchTotalAmount(); } } You can get total after select single packing slip or multiple packing slip.

Start Ax client in Single user mode MSDAX

To run Ax in single user mode you need to reject new user from online user form as following steps 1. Click Area Page node: Administration -> Online users. Form name: Online users Fig 1 2. Switch to the Server Instances tab on the Online users form. Fig 2 3. Click the Reject new clients button. Form name: Dialog Fig 3 4. Click the OK button. 5. Close the Online users form. Same as Fig 2 Accept New Client To Accept new user you can follow step 6 to 9 6. Click Area Page node: Administration -> Online users. Form name: Online users Same as Fig 2 7. Switch to the Server Instances tab on the Online users form. 8. Click the Accept new clients button. 9. Close the Online users form.

Create Duplicate company account in MSD axapta

To Create Duplicate company account in axapta you can follow below steps. 1. Click Area Page node: Administration -> Company accounts. Form name: Company: , Fig 1 2. Click the Duplicate button. Form name: Duplicate company accounts 3. Change Duplicate to company accounts from '' to ' tst'. 4. Change Company accounts from '' to ' tst'. 5. Click the OK button. Fig 3 7. Make sure the selection is changed in table Company data to: Company accounts Name of company accounts tst tst