Roll up cost centers in BPM approval workflow for AP invoices

Summary:

How to "roll up" cost centers to a higher value in hierarchy in BPM approval workflow?

Content (required):

We have a requirement to have different approval limits per set of cost centers. In the requisition approval workflow we use User Defined Attributes which roll up the cost centers to a higher cost center in the hierarchy.

For example

B2B cost centers

• 1234
• 2345
• 3456
• hundreds more

  B2C cost centers

  • 4567
  • 5678
  • 6789
  • hundreds more

  For B2B the approval limits per job level as as following:

  Job level 50 - approval limit 100.000

  Job level 60 - approval limit 250.000

  Job level 70 - approval limit 500.000

  For B2C the approval limits per job level are as following: