EGL: How to Set Up Allocation Step Using Arithmetic to Multiply Pool and Basis Data only on Matching Chartfield Values? (Doc ID 1941930.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Goal

How to set up allocation to meet below requirement?

Pool = Account 999902 ( Statistic Account)
          >> Department 10000 --> $26
          >> Department 20000 --> $11

Basis = Account 999905 ( Statistic Account) 
            >> Department 10000 -->$868.25
            >> Department 20000 --> $827.13

Desired result
            >> Department 10000 -> 26 x 868.25 = $22574.50
            >> Department 20000 -->11 x 827.13 = $9098.43

Currently, Allocation type Prorata yield below result
  >> Department 10000 --> 22574.50 (26x868.25) + (26 x 827.13) = $44079.88
  >> Department 20000 -->  9098.43 (11x827.13) + (11 x 868.25) = $18649.18
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms