Skip to Content
0
Former Member
Jul 08, 2009 at 05:50 PM

Details of parameters passed in the SPRUNCONVERSION procedure

61 Views

Hi,

I am trying to perform currency conversions using Business Rules. Below is a sample code I have written which I am calling in the Default logic.

*SysLib Stored_procedure_wrapper.lgl
*SELECT(%REPORTING_CURRENCIES%, "ID", "RPTCURRENCY", "REPORTING = 'Y'")
*XDIM_MEMBERSET RPTCURRENCY = %REPORTING_CURRENCIES%

*RUN_STORED_PROCEDURE=SPRUNCONVERSION('%APP%','%CATEGORY%','%REPORTING_CURRENCIES%','GLOBAL','%SCOPETABLE%','%LOGTABLE%')
*COMMIT

I would like to know what the third parameter is in the SPRUNCONVERSION procedure. As you can see I have passed the Reporting currencies. This however is giving out an error during data send which states *ERROR FX-140 No Currency available*. When I remove the currency and keep it blank I dont get an error but the currency conversion does not happen.

Is the logic above incorrect?

Can someone please help out.

Thanks,

Prasanth.