пользователям программных продуктов Scala 5.1, iScala 2.1, iScala 2.2, iScala 2.3, iScala 3.0, iScala 3.1 (и так далее)

Записи в категории For English speaking people

SQL Server: OLE Automation Procedures

SQL Server: OLE Automation Procedures

To make SQL Server possible to write information into files you must switch on “Ole Automation Procedures
Чтобы разрешить SQL Server’у записывать информацию напрямую в файл вы должны включить опцию “Ole Automation Procedures”

Multi Level Approvals for Requisitions: How it works?

Multi Level Approvals for Requisitions: How it works? Alexey Vasiliyev, principal consultant, Epicor’s partner

English version of the presentation at the Epicor client conference in Moscow 12.09.2017

MSRS channel — what to use instead in case of very old version of Scala/iScala?

Настройка принтера для печати через внешнюю программу в Scala 5.1

You can use MSRS channel to design documents with rich formatting in case of modern versions of iScala (starting from iScala 2.3 SR2 and SQL server 2008). And what if you have Scala 5.1, for example? Can anything be done for this version more or less gracefully? 🙂

How to add a document template for MSRS Output Channel

What we have: files of document templates for printing internal delivery note of iScala Stock Control module via MSRS Output Channel. Also we have Reporting Service Connector installed. How to configure Output Channel and to put files of document description in necessary place? If you don’t have Reporting Services Connector installed, you can install right […]

Заявление / Memorandum

Заявление / Memorandum

Каждую неделю я получаю одно или несколько писем с предложением списка адресов предполагаемых пользователей Epicor ERP или Epicor iScala. В связи с этим я хочу заявить…
Every week I get one or more emails where I’m offered to get a list of addresses of prospective users of Epicor ERP or Epicor iScala. In this regard, I want to say…

Deploy existing AFR reports on another server

There is a file with exported AFR reports.
It is required to deploy them on another server
Step-by-step description of what you need to do

How to delimit user access on the Reporting Server?

There are different approaches to organizing folders on the MS SQL Server Reporting Services. One of them is to group reports on topics or modules and grant access to all users of iScala. The advantage of this approach is in simplicity, but the disadvantage is that anyone can view any report. In this article I will share a more […]

Standard steps when working with the «Purchase Order» module

Of course, in different companies, iScala users work differently, but nevertheless, there is a standard system logic that needs to be taken into account. The mandatory and optional steps are described in detail, as well as some comments on what will happen if you make changes of purchase price in the order line at different steps

The most common mistake when working with AFR reports

Very often people who are using MS SQL Server Reporting Services and AFR, begin to «walk» through folders and find mistakes of 2 types: First mistake: Call of AFR report NOT through AFR server (URL contain port number at the end of Server Name, for example, «:8000»), but directly from MS SQL Server Reporting Services (URL does not contain port number at the end of Server […]

Usage of external tables with primary data. How to design Daily Budget Report.

 «The artillery was not shooting for twenty reasons; First of all, it had no shells…»   However powerful our report design tools might be, we can encounter the lack of “shells” (primary data in the source ERP system) issue which at first sight may seem unsolvable. As far as you know, in iScala 3.0 it […]

How can I create an AFR report in 2 currencies using fixed rate?

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 […]

How to create AFR report with daily budgets from iScala?

As you know, budgets are entered in iScala monthly. Probably it will be changed in the new version, and now, when this material is written, you can not enter them on a daily basis. However, this does not prevent us to consider the various ways in which this limitation can be overcome. «If you can […]