sql server - Microsoft Dynamics AX 2012 R3 XDS Security on Finacial Dimesion -


i'm trying create ax security framework 1 of client. key task here enable branch accounting in ax 2012 r3 environment. means i'm required filter different transactions / customers / vendors / transfer orders on basis of location & financial dimension bu respectively such each branch (location) should see records of there respective branch.

i created custom security roles enabled xds framework on them, easy in case of customer, vendor etc had location wise field.

but in case of transactions i.e 'ledgerjournaltrans' table not able filter on basis of financial dimension. field ledgerdimesion combination of different dimensions hard use in aot query.

if 1 give insight on how filter transactions or other records on basis of financial dimension combinations ?

note: i've studied white paper filter through dimensions on xds example mentioned there based on mydepartment table , methods cannot use in scenario

link white paper reference

you have create query or view values each ledger dimension. can info joining dimensionattributevaluegroupcombination (this has ledger dimension id), dimensionattributelevelvalue (field displayvalue dimension value), dimensionattributevalue (dimensionattribute recid). can use view or modify filter dimenison values.

mydepartments temp table has method named xds automatically called fill data. refresh of table can per session or per invocation. can use make own user based filter data.


Comments

Popular posts from this blog

yii2 - Yii 2 Running a Cron in the basic template -

asp.net - 'System.Web.HttpContext' does not contain a definition for 'GetOwinContext' Mystery -

mercurial graft feature, can it copy? -