FTFREZGLEXTN

The FTFREZGLEXTN algorithm type is used to create FT GL extension for the following financial transaction (FT) types when the account's invoice currency is different from the division's base currency:

  • Adjustment

  • Adjustment Cancellation

  • Bill Segment

  • Bill Cancellation

  • Pay Segment

  • Pay Cancellation

You need to attach an algorithm of the FTFREZGLEXTN algorithm type on the FT Freeze system event of the customer class. The FT GL extension is created for bill segments when you have an algorithm of the C1_​CURALGBS algorithm type attached on the Currency Conversion For Bill Segments algorithm spot of the respective division. The FT GL extension is created for payments when you have an algorithm of the C1_​CURALGPY algorithm type attached on the Currency Conversion For Payments algorithm spot of the respective division. The FT GL extension is created for adjustments when you have an algorithm of the C1_​CURALGAD algorithm type attached on the Currency Conversion For Adjustments algorithm spot of the respective division.

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 on which the exchange rate should be picked up when FT GL extension is created for adjustments with the Freeze At Will option. The valid values are:

  • A (Accounting Date) - Used to search for an exchange rate which is effective on the accounting date.

  • R (Arrears Date) - Used to search for an exchange rate which is effective on the arrears date.

  • F (FT Freeze Date) - Used to search for an exchange rate which is effective on the FT freeze date.

  • C (FT Create Date) - Used to search for an exchange rate which is effective on the FT creation date.

 Yes
Exchange Rate Date Type for Adjustments with Freeze At Bill Completion Used to indicate the date on which the exchange rate should be picked up when FT GL extension is created for adjustments with the Freeze At Bill Completion option. The valid values are:

  • A (Accounting Date) - Used to search for an exchange rate which is effective on the accounting date.

  • R (Arrears Date) - Used to search for an exchange rate which is effective on the arrears date.

  • F (FT Freeze Date) - Used to search for an exchange rate which is effective on the FT freeze date.

  • C (FT Create Date) - Used to search for an exchange rate which is effective on the FT creation date.

 Yes
Exchange Rate Date Type for Payments (Valid Values: A, R, F, C) Used to indicate the date on which the exchange rate should be picked up when FT GL extension is created for payments. The valid values are:

  • A (Accounting Date) - Used to search for an exchange rate which is effective on the accounting date.

  • R (Arrears Date) - Used to search for an exchange rate which is effective on the arrears date.

  • F (FT Freeze Date) - Used to search for an exchange rate which is effective on the FT freeze date.

  • C (FT Create Date) - Used to search for an exchange rate which is effective on the FT creation date.

 Yes
Exchange Rate Date Type for Bill Segments (Valid Values: A, R, F, C, E) Used to indicate the date on which the exchange rate should be picked up when FT GL extension is created for bill segments. The valid values are:

  • A (Accounting Date) - Used to search for an exchange rate which is effective on the accounting date.

  • R (Arrears Date) - Used to search for an exchange rate which is effective on the arrears date.

  • F (FT Freeze Date) - Used to search for an exchange rate which is effective on the FT freeze date.

  • C (FT Create Date) - Used to search for an exchange rate which is effective on the FT creation date.

  • E (Bill Segment End Date) - Used 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 to Freeze At Bill Completion in the Billing tab of the Installation Options screen. Otherwise, erroneous results might occur.
 Yes

Related Topics

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