Skip to Content
0
Former Member
Jul 27, 2010 at 06:31 PM

Help !! Error FX-070

32 Views

I'm doing a Currency Translation on the Finance Application, and right now this issue came up,

When Executing from Data Manager the Package FX Restatement , it failed and gave me this error:

Logic Executed:

AdminApp\FINANCE\FXTrans.lgx

Executing SPRUNCONVERSION 'FINANCE','ACTUAL','','GLOBAL','%SCOPETABLE','SPLOG_962476'

SPRunConversion Version 7.0.116

ERROR FX-070 No Entity available in your Application

The Script Logic File is FXTRANS.LGF

//=============================================

// Currency translation logic

//=============================================

*INCLUDE SYSTEM_CONSTANTS.LGL

*SYSLIB SYSTEM_LIBRARY.LGL

//*XDIM_MAXMEMBERS TIMEDIM=12 // if you experience memory problems try adjusting this setting to 6 or less (and remove the leading backslashes)

//*SYSLIB MULTICURRENCYTRANS.LGL

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','%CATEGORY_SET%','','GLOBAL','%SCOPETABLE','%LOGTABLE%')

//Culmulative Translation Adjustment (CTA)-(Edit for your accounts)

//TRANSLATE_LDI( CYNI, FXCYNI, AVG, END )

// Balance Sheet Historical Amts Overrides-(Edit for your accounts)

//FX_OVERRIDE( OD_CommonStock, CommonStock, FXDiff, USD )

//FX_OVERRIDE( OD_PreferredStock, PreferredStock, FXDiff, USD )

//FX_OVERRIDE( OD_APIC, APIC, FXDiff, USD )

//FX_OVERRIDE( OD_RetainedEarn, RetainedEarn, FXDiff, USD )

//FX_OVERRIDE( OE_CommonStock, CommonStock, FXDiff, EURO )

//FX_OVERRIDE( OE_PreferredStock, PreferredStock, FXDiff, EURO )

//FX_OVERRIDE( OE_APIC, APIC, FXDiff, EURO )

//FX_OVERRIDE( OE_RetainedEarn, RetainedEarn, FXDiff, EURO )

*COMMIT

And the Dimensions on the Application Finance are:

Account

Category

DataSrc

Entity

Flow

IntCo

RptCurrency

Time

Also, the System_Constants file on AdminApp\Finance are:

// application constants

//----


*FUNCTION CATEGORYDIM=CATEGORY

*FUNCTION TIMEDIM=TIME

*FUNCTION CURRENCYDIM=RPTCURRENCY

*FUNCTION ENTITYDIM=ENTITY

*FUNCTION ACCOUNTDIM=ACCOUNT

*FUNCTION INTCODIM=INTCO

*FUNCTION DATASRCDIM=DATASRC

*FUNCTION RPTCURRENCYDIM=RPTCURRENCY

*FUNCTION FLOWDIM=FLOW

// This part is needed when a RATE cube

// is associated to the application

// (FX = single or multi currency)

//----


*FUNCTION THISAPP=FINANCE

*FUNCTION RATEAPP=RATE

*FUNCTION RATEENTITYDIM=RATESRC

*FUNCTION RATEACCOUNTDIM=RATE

*FUNCTION INPUTCURRENCYDIM=INPUTCURRENCY

*FUNCTION RATEENTITYMBR=RATEINPUT

*FUNCTION RATESRCCALCMBR=RATECALC

*FUNCTION AVGRATEID=AVG

*FUNCTION ENDRATEID=END

Hope this detail help to diagnose this issue.

Regards,

Rodrigo