Applies to Product - Dynamics 365 Finance
What’s happening?
The customer is experiencing issues with configuring the expense report policy feature in Dynamics 365 Finance and Operations, specifically encountering errors when attempting to add conditions.
Reason:
The error occurs when the customer tries to add more than 72 conditions in the cloud-hosted environment, while they were able to set up 185 conditions in the sandbox environment. This suggests a limitation or restriction in the cloud-hosted environment.
The error occurs when the customer tries to add more than 72 conditions in the cloud-hosted environment, while they were able to set up 185 conditions in the sandbox environment. This suggests a limitation or restriction in the cloud-hosted environment.
Resolution:
Ensure that Expense report policy table does not contain more than 72 conditions from Expense Management > Setup > Policy > Expense Report.
Additionally you can check ‘TrvPolicyRule’ table in SQL query to ensure that the conditions being added do not exceed the allowed limit. This can be done from SQL or by adding this in environment URL:
/?mi=SysTableBrowser&prt=initial&cmp=DEMF&tablename=TrvPolicyRule&limitednav=true
More information on expense policies at Define expense policies | Microsoft Learn
Ensure that Expense report policy table does not contain more than 72 conditions from Expense Management > Setup > Policy > Expense Report.
Additionally you can check ‘TrvPolicyRule’ table in SQL query to ensure that the conditions being added do not exceed the allowed limit. This can be done from SQL or by adding this in environment URL:
/?mi=SysTableBrowser&prt=initial&cmp=DEMF&tablename=TrvPolicyRule&limitednav=true
More information on expense policies at Define expense policies | Microsoft Learn