It is very easy to make the report, where the amount in one currency would be converted into one or more other currencies at a fixed rate. Below you can see an example of a report with the conversion of the sums of rubles into Euros:
To make such report using AFR just create a Row Set similar to the following:
Then create Column Set like this:
A feature of this Column Set is to specify the currency code for the columns that you want recalculate into Euros. In addition, in the report parameters you must specify the default Currency Conversion fixed rate:
It’s all! Very easy 🙂
If you have any questions, do not hesitate to ask:
Other procedures and articles in English:
- Структура таблиц / Table structure Epicor iScala 3.5 (x64) — 3.5.0.0429
- Что должно быть настроено в системе, чтобы при печати счетов-фактур в модуле «Заказы на Продажу» создавались XML файлы? / What should be configured in the system if we want XML files to be created when printing invoices in the Sales Orders module?
- Структура таблиц / Table structure Epicor iScala 3.4 (x64) — 3.4.0399
- Scala/iScala и электронная отчётность в России | Scala/iScala and e-reporting in Russia
- Добавлено описание структуры таблиц БД iScala 3.3 / A description of iScala 3.3 DB tables structure has been added
- Структура таблиц / Table structure Epicor iScala 3.3 (x64) — 3.3.0419
- Looking for the perfect ERP system. iScala’s strengths and weaknesses
- About different approaches to implementing iScala one more time
- Структура таблиц / Table structure Epicor iScala 3.2 (x64) — 3.2.0317
- AFR: Как сделать расчёт значения в столбце зависимым от номера строки? :: AFR: How can I calculate the value in a column dependent on the line number?
- Query execution failed for dataset ‘DataSet0’
- Структура таблиц / Table structure Epicor iScala 3.1 — 3.1.0511
- SQL Server: OLE Automation Procedures
- Знаете ли Вы, что? Новая фишка в последней версии AFR: перенумерация строк :: Do you know that? The new feature in the latest version of AFR: renumbering rows
- Multi Level Approvals for Requisitions: How it works?
- MSRS channel — what to use instead in case of very old version of Scala/iScala?
- How to add a document template for MSRS Output Channel
- Заявление / Memorandum
- Deploy existing AFR reports on another server
- How to delimit user access on the Reporting Server?
- Standard steps when working with the «Purchase Order» module
- Изменение структуры таблиц iScala 3.1 по сравнению с iScala 3.0 FSP4 / Table structure changes between iScala 3.0 FSP4 and iScala 3.1
- История изменения структуры таблиц разных версий iScala / Tables structure changes history from iScala 2.2 SR2 to iScala 3.0 FSP4
- Процесс создания отчёта фиксированной формы с помощью Epicor AFR :: The process of creating a fixed-form report using Epicor AFR
- The most common mistake when working with AFR reports
- Структура таблиц / Table structure Epicor iScala 3.0 FSP4 — 3.0.4267
- AFR: что это такое, из чего состоит, с чем взаимодействует? :: AFR: what is it, what does it consist of, what it interacts with?
- Usage of external tables with primary data. How to design Daily Budget Report.
- How can I create an AFR report in 2 currencies using fixed rate?
- How to create AFR report with daily budgets from iScala?
- Типы проводок Главной Книги :: General Ledger Transaction Types
- Reporting tools usage survey
- Sent PO electronically to Supplier’s FTP site
- Requisition Management module quick user guide
- What can you get from your iScala by using new technologies?