Adding external processing to the database. Adding external processing to the 1C 8.3 database external report for a document

In the top menu go to Service->->.

After this, the directory list form will appear. In the top menu click Add.

The window for adding a new report appears. Press the button Open.

Select the file with the desired report and click Open. After adding the file, if necessary, change the name of the report (how it will be displayed in the list). Click OK.

As a result, the new report appears in the list.

After this, the report can be used, adding is completed. To open this report later, we also go to Service->Additional reports and processing->Additional external reports.

For BP 3.0, ZUP 3.0, UT 11, ERP 2.0.

To add an external report in 1C:Enterprise 8.3 configurations in a managed interface (using Accounting 3.0 as an example), let’s enter the corresponding section of the program:

It is necessary that the option to use additional reports is enabled, follow the hyperlink:

In the list that opens, click the button Create:

After this, a file selection dialog box with a report will immediately open, in which you need to select the desired file (in my case, it is a file with a plan-actual cost analysis).

Now you need to configure accommodation(the place in the program where the report will be available):

Randomly select the desired section of the program from the list:

Now you need to record the changes in the external report card:

Now open the report from the program interface:

The list is still empty, click Customize the list:

In the selection form, tick our report:

Now it appears in the list:

By button Execute The report form opens:

Download universal object processing 1C 8.3.

In a regular application version of the 1C platform 8.2 and 8.1 (on regular forms) there was such a wonderful processing as “Universal selection and processing of objects”. It greatly simplified life for programmers and program administrators.

The same 1C processing has appeared for a managed application (8.3 and 8.2). Before this, in 1C 8.3, it was necessary to make do with standard processing of group changes to details, but it does not solve all the tasks that are required in the daily work of a 1C user or programmer.

Search and selection of objects

After downloading the processing, we can run it as an external one. For those who don’t know, this is done through the “File” – “Open” menu. The processing window will appear:

On the first tab we must select the object we are going to work with. And so, in the “Search object” field the document “Sales (acts, invoices)” is already selected. This is because this object has already been selected before. Processing can remember.

By clicking the “Setting up selection” button, we can set selection for almost any field of the object:

If the selection data is not enough, you can select the necessary objects using a custom query. To do this, move the “Selection mode” switch to the appropriate position.

After all the settings, objects need to be selected. Click on the “Find objects” button and look at the selection result:

Processing elements

Let's go to the "Processing" tab:

Perhaps only the first three treatments are worthy of a separate brief review. The work of the rest is clear by name and they do not require settings.

Arbitrary algorithm

The “Custom Algorithm” processing allows you to write a program of actions on objects in the internal 1C language. Processing requires programming skills and its description is worthy of a separate article. With its help you can do practical actions on objects:

Setting up details

The “Setting details” processing allows you to change the details of selected documents or directories, as well as information registers. Quite useful, and sometimes simply necessary processing. For example, let’s replace the document currency in the selected documents:

It should be immediately noted that processing can be performed immediately, or you can save the setting. This setting will be displayed in the processing tree.

Renumbering objects

The “Renumbering of Objects” processing accordingly allows you to renumber documents or change directory codes. Processing provides a rich set of actions. For example, you decided to change the prefix of the documents that you selected:

Now let's see what we can do with the saved settings. It turns out that we can execute in one batch, transferring it to the “Selected Processings” window:

Now we can sequentially execute the selected settings by clicking the “Run” button.

Based on materials from: programmist1s.ru

In this article, we will consider step-by-step instructions for creating external processing in 1C 8.3 in managed application mode; accordingly, we will use managed forms. And most importantly, we will learn how to connect it to the mechanism of “external processing” of 1C configurations built on a library of standard subsystems version 2.0 and newer.

The task will be the following: to create the simplest external processing that will perform a group action on the “Item” directory, namely, set the selected VAT rate percentage for the specified group of items.

To do this, we will immediately make the necessary settings in the program (we are considering the 1C 8.3 configuration: “Enterprise Accounting 3.0” on managed forms).

Checking this box gives us the opportunity to use external processing.

Creating a new external processing in 1C 8.3 using an example

Now let's go to the configurator. In the "File" menu, select "New...". A window for selecting the type of file to be created will open. Select “External processing”:

A new external processing window will open. Let's give her a name right away. It will be offered when saving the processing to disk:

Let's add a new controlled processing form. We indicate that this is a form of processing and it is the main one:

We will have two details on the form:

Nomenclature group – link to the “Nomenclature” directory;
SelectVATRate – link to the transfer of the VAT Rate.

We create the details in the “Properties” column in the upper right window. Drag them with the mouse into the upper left window. The new details should immediately appear on the form below.

The order of details can be changed using the “Up” – “Down” arrows:

Get 267 video lessons on 1C for free:

All that remains is to add the “Install” button. In managed forms, you can't just add a button to the form. Even if you add it to the structure of form elements, it will not be visible on the form itself. The button must be associated with the command that it will execute. Go to the “Commands” tab and add the “Set VAT Rate” command. In the command properties, create an action. Select the command handler “On the client”. A command can also be added to the form by simply dragging it into the section with form elements.

A procedure of the same name will be created in the form module. In it we will call the procedure on the server:

&OnClient

Procedure Set VAT Rate (Command)

SetVATRateOnServer();

End of Procedure

In the procedure on the server, we will write a small request and actions related to setting the VAT rate:

&On server

Procedure SetVATRateOnServer()

Request.SetParameter("Item Group", Item Group);
ResRequest = Request.Execute();
SelectRecordDet = ResRequest.Select();

While SelectRecordDet.Next() Loop

Attempt
SprNomObject.Write();
Exception
Report("Error writing object """ + SprNomObject + """!
|» + DescriptionError());
EndAttempt;

EndCycle;

End of Procedure

We return to the “Form” tab, add a button to the form and associate it with the command:

As such, our processing is ready for use. To call it, in the “1C Enterprise” mode, you need to go to the “File” - “Open” menu and select the created file.

However, working in this mode is convenient for debugging processing, but is not entirely suitable for the user. Users are accustomed to having everything “at their fingertips,” that is, in the database itself.

This is what the “Additional reports and processing” section is for.

But in order to add our processing there, we must first give it a description and tell the program its properties.

Description of the function “Information about External Processing”

I will give an example of the contents of this function. It must be exportable and, accordingly, located in the processing module:

Function InformationOnExternalProcessing() Export

DataForReg = New Structure();
DataForReg.Insert("Name", "VAT rate setting");
DataForReg.Insert("SafeMode", True);
DataForReg.Insert("Version", "ver.: 1.001");
DataForReg.Insert("Information", "Processing for setting the VAT rate in the Nomenclature directory");
DataForReg.Insert("View", "AdditionalProcessing");

CommandTable = NewValueTable;
TabZnCommands.Columns.Add("Identifier");
TabZnCommands.Columns.Add("Usage");
TabZnCommands.Columns.Add("View");

NewRow = TabZnCommands.Add();
NewString.Identifier = "OpenProcessing";
NewRow.Use = "OpenForm";
NewRow.View = "Open processing";
DataForReg.Insert("Commands", TabZnCommands);

Return DataForReg;

EndFunction

To better understand which fields of the registration data structure need to be used, let’s look at the details of the “Additional reports and processing” directory:

As you can see, everything is quite simple. Only one attribute does not match: “Launch Option” – “Use”. If we look at the code of one of the common modules, we will see how a bunch of these fields arise:

To determine which fields of a structure are required, you can first not describe it, simply create an empty one, and then use the debugger. If you trace modules when registering processing, it becomes immediately clear which fields are required and which are not.