Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Move or Allocate by department and vendor

edited May 23, 2024 3:02PM in Planning 13 comments

Summary:


Content (please ensure you mask any confidential information):

I am trying to allocate or move some expenses based on two components: departments and vendors. I need to move them within the same department, but to a different vendor. I need this to be done for all base level departments/vendors.

Example: For "Mark" vendor and department D1055 below (3rd line) , I need to allocate from entity 09 (column c) 22% to entity 10 (column d) and 68% to entity 01 (column e). It needs to go into vendor "corporate allocations" and D1055 department.

I used the business rule below, but it isn't working. (I ran an agg after running the rule)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!