Limiting expenditure types while creating expenditures (Ap invoices, PO's and miscellaneous costs)
How to limit expenditure types based on the expenditure categories used in budgeting?
we have around 10 expenditure categories in total and each expenditure category is mapped to 3 expenditure types approximately. Our customer use expenditure categories to budget their projects. As a result of that, when they create cost transactions for a project, they want only the relevant expenditure types to show up in the drop down list.
For example, lets say a project is budgeted using two expenditure categories so when a cost is being entered on the projects, they want only those six expenditure types to show in the expenditure type drop down list. I understand we can use transaction control, however it will only prevent us from using irrelevant expenditure types, but not hide the irrelevant expenditure types in the drop down.