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.