Skip to main content

Posts

Showing posts with the label record level security

Question and answer on MSD Axapta 2009 development Tool

1. Which file contains the modification of the form CustTable when developing in the var-layer with an en-us user interface? ANSWER - axVAR.aod. There is no language dependence in the application objects as the user interface texts are stored in the label file. 2. What action must be taken after copying the modifications to the test environment? ANSWER - Start the AOS server and then an AX client in the test environment and make a compilation of the entire AOT followed by a synchronization of the database. 3. How can you determine every application element that is using the method VendTable.balanceMST()? ANSWER - Ensure that the cross-reference has been updated. Find the VendTable.balanceMST() method in the AOT. Right-click, select Addins> Cross-reference > Used By. 4. How can you ensure that a select statement considers record level security? ANSWER - Before the select statement set the recordLevelSecurity() property on the table variable to True.

Binding user to particular office in axapta application

This is simple filter code for Binding  user to particular office in axapta application. Like current user is adam and you want to show him only one employee date then you can use filter methodology this way. public void filter1() { UserId currentUserId; SysCompanyUserInfo sysCompanyUserInfo; _ServiceDetails2 _ServiceDetails2; EmplTable emplTable; InventLocationId inventLoc; Date LastDate; RecId RecId; currentUserId = curUserId(); select * from sysCompanyUserInfo where sysCompanyUserInfo.UserId == currentUserID; if(sysCompanyUserInfo) { if(sysCompanyUserInfo.EmplId != "") { select * from emplTable where emplTable.EmplId == sysCompanyUserInfo.EmplId; if(emplTable) { if(emplTable.EmplId != "") { while select * from _ServiceDetails2 where _ServiceDetails2.EmplId == emplTable.EmplId { if(LastDate == any2date(0)) { LastDate = _ServiceDetails2.DateTo; RecId = _ServiceDetails2.RecId; } else { if(LastDate < _ServiceDetails2.DateTo) { L