web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Purchase Order & Sales Order number Financial Dimension not taking if we restrict the user in specific legal entity

(0) ShareShare
ReportReport
Posted on by 130

Hi All,

We are using Purchase Order number financial dimension to track the PO transactions in GL level and enabled advance rule to avoid black PO dimension while posting. But if we  restrict users in specific legal entity via System Admin module-Users-Assign organization , then system will not considering PO number dimensions and will throw an error PO dimension value missing. If we remove legal entity restriction,  and create new PO, it will work properly.

As of now we have only one legal entity, but we are going to implement D365 for one more legal entity. So we have to restrict users from other legal entity to restrict the view. I have test few scenarios and find below.  

  • If we create new purchase order from legal entry restricted user id, system will not allow to post PO receipt due to PO dimension validation error from advance rule
  • But if we check PO dimensions( header & line) from legal entry restricted user id, PO dimensions not updated in PO form.
  • Same purchase order , if we check from system admin role , we can see PO dimensions in both header & line level. But if we try to post PO receipt will get same error even from system admin role
  • After that , if we run the job “Rebuild dimension data from source records” from DataMaintenancePortal , system will update PO dimensions in Header & line view and will allow to post already created PO from both legal entity restricted user and system admin role
  • Again, if we create new PO and try to post product receipt, system will show the same PO dimension validation error

Looking for your valuable advise to resolve the issue. We need PO dimension to track PO transaction in GL level since we are booking all third party invoices like freight, insurance , customs duty etc to Control A/C by referring respective PO dimension and applying those charges in PO while booking vendor invoice through charge allocation from respective charge code. 

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,109 Super User 2025 Season 2 on at

    Hi Sunil,

    You provided a lot of information, but I wonder if you have customizations to use the PO number as dimension. On what role, what exact legal entity restriction did you implement? Can you probably share screenshots which could clarify your question?

    PS. Have you also looked at the Landed cost module instead of using the PO number as financial dimension?

  • CU07101257-0 Profile Picture
    130 on at

    Hi Andre,

    Thank you for your reply. We didn't customize the dimension , it was there in Dimensions form and we were using its from 2018 onwards. I don't know in 2018, over layering concept was available that time we enabled backing table/customization. But its look like standard dimension similar like fixed asset, items since new button disabled. But I have checked in new one box environment to reproduce the issue, but i didn't get purchase order and sales order dimensions in Financial dimension - User value from lookup.

    Please see below screen shot. 

    pastedimage1649923238220v1.png

    If we restrict users in specific legal entity, Purchase order dimension not auto displayed, but it was created in dimension value along with PO creation. If we select manuallly also, system will not consider while posting. 

    pastedimage1649923660103v2.png

    PO was created with all legal entity permission. 

    pastedimage1649923820241v3.png

    PO Invoice voucher transaction after posting. PO dimension properly updated in GL level if users have all legal entity permission

    pastedimage1649923888556v4.png

    User role permission for specific organization-Legal entity restriction 

    pastedimage1649923996358v5.png

  • André Arnaud de Calavon Profile Picture
    301,109 Super User 2025 Season 2 on at

    Hi Sunil,

    This is helpful. There is a customization to use the PO and SO as backing dimensions. Can you tell what exact roles are assigned to the user and if you restrict access to the current LE having the POs? Are you restricting only one role or also the System user role?

  • CU07101257-0 Profile Picture
    130 on at

    Hi Andre,

    Sorry for the late reply.

    I have applied legal entity restriction to all user role including system user role. Is there any issue if we restrict " System user role". My intention to restrict the view/post data to other legal entity.

    If we remove the legal entity restriction, Sales Order and Purchase Order dimension will work properly. but once we invoke restriction, these dimesnion not taking. But if we rum " Rebuild dimension data " from mainteance portal, system will consider Sales order/Purchase order dimension for the created records.

  • André Arnaud de Calavon Profile Picture
    301,109 Super User 2025 Season 2 on at

    Hi Sunil,

    There might be indeed side effects if you restrict the system user role. You can restrict this role, but try to add the 'DAT' company in addition and see if that would solve the issue.

  • CU07101257-0 Profile Picture
    130 on at

    Hi Andre,

    As advised, I have given all legal entity access to system user and DAT company permission too. But no difference system is not considering Sales Order dimension.

    Is it required to give any access level permisson on the backing dimension we added as mentioned on below document.

    docs.microsoft.com/.../dimensionable-entities

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    301,109 Super User 2025 Season 2 on at

    Hi Sunil,

    There is one option, I'm thinking of, which might be worth a try. Do restrict the roles as you intended to restrict per legal entity. Then create a new Security role. On the role, go to the Tables node and add read permissions for both the sales order header (SalesTable) as well as the purchase order header (PurchTable) tables. I do assume these two tables were used for the entity backed dimensions. When you assign this role, then don't restrict it per legal entity.

    In this scenario, the user will not have menu item permissions in some legal entities, but the table values can be read for the dimension value purposes.

  • Kristi Slininger Profile Picture
    66 on at

    Sunil - Please read the following documentation, specifically the Important warning at the beginning of the document.

    docs.microsoft.com/.../dimensionable-entities

    It is NOT recommended to use financial dimensions for tracking data that is not reusable, such as the PO number. This is what we call a 'degenerate dimension'.  This will cause performance issues across the system, and issues around processes such as the Year-end close, GL foreign currency revaluation, and so on.

    We do have a new feature on our roadmap called Financial tags, which will help fill these requirements.  Yes, this isn't available yet but using a financial dimension is not the correction solution.  

  • CU07101257-0 Profile Picture
    130 on at

    Hi Andre,

    As advised, I have crearted new role and added SalesTable & PurchTable Read ,create,Update permission . But still facing same issue. I will ask our technical consultant to check permission on entity backed dimension view.

    Just to clarify my doubt regarding PO & Sales Order dimension, how normally companies are tracking & updating cost to PO based on the third Party expenses like Insurance, frieght, customs duty,Port Charges, Bank charges etc. Most of the cases we are receiveing partial shipment, but some expenses paid for entire PO. so we have to allocate those expenses proportionaly (based on shipment value) to vendor invoices at the time of booking. So we are checking Ledger transaction report to identify how much expenses we incured till based on that we are allocating expenses to PO.

    Also, if we are not using PO dimension, how can we check/track the voucher transction based on PO to track posted GL transactions. Please let me know Is there any standard procedure or customization widely using to track PO transactions

  • CU07101257-0 Profile Picture
    130 on at

    Yes, I have noticed the same document but here if we are not using PO dimensions it is quiet difficult to track PO voucher transactions and PO expenses we already booked before posting vendor invoices. Nornally we will book all PO expenses to control  A/c and reversing the same by using charge code at the time of vendor invoice booking.So any time we can track the PO related GL transactions. Please let me know do we have any alternative method to achive the same

    Third Party Expense booking

    pastedimage1651349060203v1.png

    Vendor Invoice Booking

    pastedimage1651349265294v3.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans