How to Map expenditure type based on category provided by user

Summary:

There is a requirement where business has provided list of categories mapped with specific respective expenditure type .
We want to assign the value based on category automatically to default expenditure type attribute under Inventory whenever any user put category while creating the item in system.
How to achieve this use case?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

25B

Code Snippet (add any code snippets that support your topic, if applicable):