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

Journal Entry Reserve Ledger

edited Sep 25, 2019 1:41PM in Reporting and Analytics for ERP 1 comment

Summary

Customization of the Journal Entry Reserve Ledger

Content

I'm customising the Journal Entry Reserve Ledger report - I am trying to add new data columns and change the report, the questions i have are as followed:

1. What do you need to enter in the 'Lexicon Flexfields' to allow customisation of the Data Model? (I have attached screenshot and code for reference)

2. Has anyone successfully customised this report before? 

Thanks,

Elliot 

Version

19

Code Snippet

SELECT 
	&ACCT_FLEX_BAL_SEG	COMP_CODE,
	decode(TRANSACTION_TYPE,'B',&RSV_FLEX_ACCT_SEG, &ACCT_FLEX_ACCT_SEG )	GL_ACCOUNT,
	&RSV_FLEX_ACCT_SEG      RSV_ACCOUNT,
	&ACCT_FLEX_COST_SEG	COST_CENTER,
---	AD.ASSET_NUMBER || '-' || ADTL.DESCRIPTION	ASSET_NUMBER,
       ADTL.DESCRIPTION || ' [' || AD.ASSET_NUMBER || ']'       ASSET_NUMBER,
   &D_CATEGORY D_CATEGORY1,
   to_char(DATE_PLACED_IN_SERVICE, 'YYYY-MM-DD') START_DATE,
	METHOD_CODE			METHOD,
	RSV.LIFE				LIFE,
	RSV.RATE			ADJ_RATE,
        FCAT.SEGMENT1, -- CUSTOMISATION
        FCAT.SEGMENT2, -- CUSTOMISATION
        FCAT.SEGMENT3, -- CUSTOMISATION
	DS.BONUS_RATE			BONUS_RATE,
	SUM(decode(transaction_type,'B',NULL,COST))			COST,
	SUM(RSV.DEPRN_AMOUNT)	    DEPRN_AMOUNT,
	SUM(RSV.YTD_DEPRN)		YTD_DEPRN,
	SUM(RSV.DEPRN_RESERVE)          DEPRN_RESERVE,
	sum(decode(transaction_type,'B',NULL,nvl(PERCENT,0)))		PERCENT,
	TRANSACTION_TYPE		T_TYPE, 
	FA_FAS400_XMLP_PKG.d_lifeformula(RSV.LIFE, RSV.RATE,
	          

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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