AMDPREPT Update LTD/YTD Incorrectly On PS_DEPR_RPT After Transfer (Doc ID 1937117.1)

Last updated on JUNE 13, 2017

Applies to:

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

Symptoms

Issue with YTD_DEPR in DEPT_RPT after Financial 9.1 bundle 27

It seems the issue caused by Bug 16226578 - EAM: AMDPREPT CREATES INCORRECT YTD DEPRECIATION AMOUNT IN PS_DEPR_RPT AFTER TRF that got posted in Financial 9.1 bundle 26,

They ran the DEPR_RPT report with include transfer checked.  If not checked the calculation is correct but that is not what they want in their report.

Analysis from depr rpt aft trf tab in the spreadsheet:

2 Scenarios:
Partial 50% transfer and full transfer

Partial transfer
Book Name Unit Asset ID Year Period Depr Amt YTD Depr LTD Depr CF Sequence Num
INTERNAL 40002 400020002582 2,013 8 35.00 35.00 35.00 0
INTERNAL 40002 400020002582 2,013 9 35.00 70.00 70.00 0
INTERNAL 40002 400020002582 2,013 10 35.00 105.00 105.00 0
In November the asset is 50% partially transferred. Look at the YTD Depr for CF Seq Num below.. the amount total depreciation should be 140. However the system split into 2 without considering the previous depreciation for cf seq 0.

YTD for cf seqno 0 should be 105 +17.50 (partial in Nov) LTD is ok
YTD for cf seqno 1 should be 17.5 LTD is OK

INTERNAL 40002 400020002582 2,013 11 17.50 70.00 70.00 0
INTERNAL 40002 400020002582 2,013 11 17.50 70.00 70.00 1

Full transfer
Book Name Unit Asset ID Year Period Depr Amt YTD Depr LTD Depr CF Sequence Num
INTERNAL 40002 400020002583 2,013 8 244.08 244.08 244.08 0
INTERNAL 40002 400020002583 2,013 9 244.08 488.16 488.16 0
INTERNAL 40002 400020002583 2,013 10 244.08 732.24 732.24 0

In November the asset is 100% transferred.

YTD for cf seqno 0 is correct as it retains the previous depreciation amount 732.24 LTD is ok
However, YTD for cf seqno 1 is not correct. It should be 244.09 LTD is OK

INTERNAL 40002 400020002583 2,013 11 0.00 732.24 0.00 0
INTERNAL 40002 400020002583 2,013 11 244.09 976.33 976.33 1

Note:
YTD amount is used in income sheet representation
LTD amount is used in balance sheet representation

 



Cause

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