Table of Contents

J38662 Calculate historical Reporting currency amounts

Code J38662
Entity Finance.Accounting.AccountingVoucherLines
Job type name Calculate historical reporting currency amounts
Parameters EnterpriseCompany
Used for retrieving the exchange rate and the start date.

ReportingCurrency

Retrieved from EnterpriseCompany.ReportingCurrency.

FromDate (Optional, default is NULL)
The starting date for processing. It is set within the task. If left empty, the processing begins from the oldest available documents.

ToDate
Retrieved from EnterpriseCompany.ReportingCurrencyStartDate. If empty, no calculations are performed.

ReportingCurrencyRate
Retrieved from EnterpriseCompany.ReportingCurrencyRate.

LastProcessedDate
The last date up to which calculations have been completed. The value is retrieved and stored from EnterpriseCompany.ReportingCurrencyProcessedDate.
Description Calculations Performed:
ReportingCurrencyDebit = DebitBC * ReportingCurrencyRate
ReportingCurrencyCredit = CreditBC * ReportingCurrencyRate

Execution Logic:
Processes only documents whose date is:
Earlier than the ToDate

If LastProcessedDate has a value → processes documents with a date greater than LastProcessedDate
If LastProcessedDate is empty:
If FromDate has a value → processing starts from the FromDate
If FromDate is also empty → processing starts from the oldest document in the database

The calculated values are stored in the fields:

ReportingCurrencyDebit
ReportingCurrencyCredit

Upon successful execution, the job updates the LastProcessedDate with the last processed document date.

If ToDate is empty, the job does not make any changes.
First to process N/A
Automatically created YES
Version Introduced: v.25

To learn more about the documentation template and get a short explanation for each table column,
see Jobs documentation template.