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

1:1 relationship between target and offset GL accounts in allocation manager

edited Oct 27, 2023 8:36PM in General Ledger & Intercompany 2 comments

Summary: have odd requirement where allocations should not be generated in standard M:1 relationship between debits and credit. standard M:1 approach takes source account balance and distributes over range of debits.

in my case i need to specify in offset account the value that is concatenation of prefix "SUB" with value of cost center (which is used as range for allocation), for example

Content (please ensure you mask any confidential information):

sample case can be described as following:

  1. take PTD balance for expense account at "000" cost center
  2. distribute per head count over all non-zero cost centers
  3. in target account for each allocation reflect in separate GL segment what cost center was used in debit

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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