FTFREZGLEXTN

The FTFREZGLEXTN algorithm type is used to create an additional FT GL entry (i.e., FT GL extension record) for the following financial transaction (FT) types when the financial transaction’s currency is different from the division’s base currency and/or division’s local currency:

Adjustment
Adjustment Cancellation
Bill Segment
Bill Cancellation
Pay Segment
Pay Cancellation

It creates an FT GL extension record in the CI_FT_GL_EXT table to store the equivalent financial amount in the division’s base currency and/or division’s local currency. The currency conversion is done using the respective algorithm attached to the division to which the financial transaction belongs.

You need to attach an algorithm of the FTFREZGLEXTN algorithm type to the FT Freeze system event of the required customer classes. For more information, see Additional FT GL Entry Creation (FT GL Extension).

The FTFREZGLEXTN algorithm type contains the following parameters:

Parameter	Description	Mandatory (Yes or No)
Exchange Rate Date Type for Adjustments with Freeze At Will	Used to indicate the date whose exchange rate should be considered for currency conversion when additional FT GL entries are created for an adjustment whose freeze option is set to Freeze At Will in the respective adjustment type. The valid values are: A - It stands for the accounting date. It is used when you want to search for an exchange rate that is effective on the FT’s accounting date. R - It stands for the arrears date. It is used when you want to search for an exchange rate that is effective on the FT’s arrears date. F - It stands for the freeze date. It is used when you want to search for an exchange rate that is effective on the FT’s freeze date. C - It stands for the creation date. It is used when you want to search for an exchange rate that is effective on the FT’s creation date.	Yes
Exchange Rate Date Type for Adjustments with Freeze At Bill Completion	Used to indicate the date whose exchange rate should be considered for currency conversion when additional FT GL entries are created for an adjustment whose freeze option is set to Freeze At Bill Completion in the respective adjustment type. The valid values are: A - It stands for the accounting date. It is used when you want to search for an exchange rate that is effective on the FT’s accounting date. R - It stands for the arrears date. It is used when you want to search for an exchange rate that is effective on the FT’s arrears date. F - It stands for the freeze date. It is used when you want to search for an exchange rate that is effective on the FT’s freeze date. C - It stands for the creation date. It is used when you want to search for an exchange rate that is effective on the FT’s creation date.	Yes
Exchange Rate Date Type for Payments (Valid Values: A, R, F, C)	Used to indicate the date whose exchange rate should be considered for currency conversion when additional FT GL entries are created for a payment. The valid values are: A - It stands for the accounting date. It is used when you want to search for an exchange rate that is effective on the FT’s accounting date. R - It stands for the arrears date. It is used when you want to search for an exchange rate that is effective on the FT’s arrears date. F - It stands for the freeze date. It is used when you want to search for an exchange rate that is effective on the FT’s freeze date. C - It stands for the creation date. It is used when you want to search for an exchange rate that is effective on the FT’s creation date.	Yes
Exchange Rate Date Type for Bill Segments (Valid Values: A, R, F, C, E)	Used to indicate the date whose exchange rate should be considered for currency conversion when additional FT GL entries are created for a bill segment. The valid values are: A - It stands for the accounting date. It is used when you want to search for an exchange rate that is effective on the FT’s accounting date. R - It stands for the arrears date. It is used when you want to search for an exchange rate that is effective on the FT’s arrears date. F - It stands for the freeze date. It is used when you want to search for an exchange rate that is effective on the FT’s freeze date. C - It stands for the creation date. It is used when you want to search for an exchange rate that is effective on the FT’s creation date. E - It stands for the bill segment end date. It is used when you want to search for an exchange rate which is effective on the bill segment end date. Note: If you set the Exchange Rate Date Type for Bill Segments parameter to R, ensure that you set the Bill Segment Freeze Option field to Freeze At Bill Completion in the Billing tab of the Installation Options screen. Otherwise, erroneous results might occur.	Yes
Exchange Rate Algorithm	Used to attach a date or date and time based currency conversion algorithm which must be triggered when the financial transaction’s currency is different from the division’s local currency.	No
FT Types to be processed (Valid Values: BS, BX, AD, AX, PS, PX)	Used to indicate whether you want to create additional FT GL entries for a particular type of financial transaction. The valid values are: AD AX BS BX PS PX Note: You can specify comma-separated values for this parameter. If you do not specify any value, by default, this algorithm will create additional FT GL entries for all the financial transactions irrespective of their type.	No

Related Topics

For more information on...	See...
FT GL Creation	FT GL Creation
Additional FT GL Entry Creation on FT Freeze	Additional FT GL Entry Creation on FT Freeze
How to setup the currency conversion feature	Prerequisites