PeopleSoft Finance General Ledger Allocations
What is Allocation and Allocation Types
Allocation is the process of allocating the assets or expenses held by one entity to other entities inorder for them to recognize their own share of amounts. This way you can allocate both monetary and statistical quantities across the entities within the organization.
Working of Allocation Process:
Allocation builds a dynamic SQL statement to select the pool rows from the Pool table. Pool
Record type of Fixed Amount is exception to this.
The dynamically generated SQL Statement contains SELECT, FROM, WHERE clause and
GROUP BY fields based on the Allocation step definition.
Query for Pool:
SELECT Clause includes the following:
1. All Target and Offset fields whose source is from pool or group by pool and basis.
2. Sums the Pool Amount field and Pool base currency amount field.
3. Ledger field
4. Currency control fields CURRENCY_CD and BASE_CURRENCY
FROM Clause includes either one of the following:
1. LEDGER table name defined in the Ledger Template for Ledger Group type.
2. Any Table
WHERE Clause includes the following:
1. All pool fields specified in the pool page
2. Business Unit specified on the Allocation Request page.
3. Fiscal Year and Accounting period derived from Timespan and Request As of Date.
4. All ledgers in the group if the pool record is a ledger group that contains multiple ledgers.
5. Non blank Currency code.
GROUP BY Fields:
All Select fields except the Amount fields.
SQL:
SELECT DEPT_ID, LEDGER, CURRENCY_CD, BASE_CURRENCY,
SUM(POSTED_TOTAL_AMT), SUM(POSTED_BASE_AMT)
FROM PS_LEDGER
WHERE BUSINESS_UNIT = ‘US001’
AND LEDGER = ‘ACTUALS’
AND FISCAL_YEAR = 2006
AND ACCOUNTING_PERIOD = 6
AND ACCOUNT = ‘500500’
AND CURRENCY_CD = ‘USD’
GROUP BY DEPT_ID, LEDGER, CURRENCY_CD, BASE_CURRENCY
What is Allocation and Allocation Types
Allocation is the process of allocating the assets or expenses held by one entity to other entities inorder for them to recognize their own share of amounts. This way you can allocate both monetary and statistical quantities across the entities within the organization.
Working of Allocation Process:
Allocation builds a dynamic SQL statement to select the pool rows from the Pool table. Pool
Record type of Fixed Amount is exception to this.
The dynamically generated SQL Statement contains SELECT, FROM, WHERE clause and
GROUP BY fields based on the Allocation step definition.
Query for Pool:
SELECT Clause includes the following:
1. All Target and Offset fields whose source is from pool or group by pool and basis.
2. Sums the Pool Amount field and Pool base currency amount field.
3. Ledger field
4. Currency control fields CURRENCY_CD and BASE_CURRENCY
FROM Clause includes either one of the following:
1. LEDGER table name defined in the Ledger Template for Ledger Group type.
2. Any Table
WHERE Clause includes the following:
1. All pool fields specified in the pool page
2. Business Unit specified on the Allocation Request page.
3. Fiscal Year and Accounting period derived from Timespan and Request As of Date.
4. All ledgers in the group if the pool record is a ledger group that contains multiple ledgers.
5. Non blank Currency code.
GROUP BY Fields:
All Select fields except the Amount fields.
SQL:
SELECT DEPT_ID, LEDGER, CURRENCY_CD, BASE_CURRENCY,
SUM(POSTED_TOTAL_AMT), SUM(POSTED_BASE_AMT)
FROM PS_LEDGER
WHERE BUSINESS_UNIT = ‘US001’
AND LEDGER = ‘ACTUALS’
AND FISCAL_YEAR = 2006
AND ACCOUNTING_PERIOD = 6
AND ACCOUNT = ‘500500’
AND CURRENCY_CD = ‘USD’
GROUP BY DEPT_ID, LEDGER, CURRENCY_CD, BASE_CURRENCY
