Adding external processing to the database. Adding an external report to the database Add processing to the trade management configuration

25.10.2023

This article describes how to connect an external printed form to a 1C database using the example of the “Trade Management 11.2” configuration

The “Trade Management 11.2” configuration is a configuration on “MANAGED” forms!

Our instructions “show” how to connect an external printed form in the 1C information base with configuration on “MANAGED” forms, namely:

"Accounting 3.0"
"Trade Management 11.2"
"Salary and personnel management 3.1"
"Comprehensive automation 2.0"
"Small Firm Management 1.6"
"Retail 2.2"
and other similar configurations.

In order to connect an external printing form in 1C we will need to go through 11 steps.

1 — Menu “Master data and administration” (In other configurations, such as in Enterprise Accounting 3.0, it may be called simply “Administration”). 2 — Select “Printed forms, reports and processing” (see figure below ↓)

3 — Expand the “Reports and Processing” submenu (In other configurations, such as Enterprise Accounting 3.0, there may not be such a submenu, so we immediately move on to the next step). 4 — Check the “Use of additional reports and processing” box. 5 — Go to the section: Additional reports and processing. (see figure below ↓) ()

6 — Click the “Create” button. (see figure below ↓)

In new versions of 1C (starting from August 2016), the program has a built-in warning mechanism about the danger of using unknown external processing that may contain “viruses”; in earlier versions of the program the warning will not appear! If this occurs, then to connect an external printing form it will be necessary - 7 — click the “Continue” button. (see figure below ↓)

8 — Select the directory in which the processing is located. 9 — Select it (the processing we need). 10 — Click the “Open” button. Or, instead of steps 9 and 10, you can simply double-click on the external printed form we need in the selection window. (see figure below ↓)

If we need to add placement for the added processing (For example, this is a Universal Contract Form from our website and we need the command to print this form to be displayed in some object in which it is not initially displayed) - 11 — click on the placement line (“Place in:”, maybe “Placement:”) and select the necessary directories and documents. 12 — We complete the steps to connect an external printing form by clicking the “Record and close” button. (see figure below ↓)

That's all! Congratulations! External printing plate is connected! Did we do everything right? Let's check...

Before Recording and closing, we noticed that this external printed form is located in the document Sales of goods and services, which means that we can open printing options for any document of the type: “Sales of goods and services.” press the “Print” button and see that a window for selecting printed forms has appeared, among them there is - 13 — external printing form connected by us (see figure below ↓)

Now that’s it for sure. We hope that this article was useful to you.

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 “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.

Connecting external processing in 1C 8.3

Go to the top menu Service->->.

The external processing directory list form appears. In the top menu press the button Add.

The Add New Object form will appear. Click the open button and select the file with the desired processing. After you have selected the desired file, if necessary, specify a processing name (Name field). After this, you need to click OK to save the changes made.

After this, the window for creating a directory item closes, and you are taken back to the list form, which already contains the new processing.

That's all! The process of adding processing to the configuration is complete. To open this processing later, go along the old path: Service->Additional reports and processing->Additional external treatments.

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

External processing for 1C:Enterprise 8 comes in several types. In this instruction, I will show you how to attach processing for group modification and processing for filling specific objects.

For the first case, we will add processing for filling out the nomenclature directory from Excel.

Let's go to the appropriate section of the program:

It is necessary that the flag for using additional reports and processing is set; follow the hyperlink to the list of external objects:

In the list click Create:

In the dialog box that opens, select the desired file for processing:

The card for a new external object in the program has been filled out, all that remains is to configure it accommodation(sections of the program from which processing will be available):

Select an arbitrary section (or several) for placement:

Write and close the external object card:

Now let's open processing from the interface:

The list is empty, click Customize the list:

Choose our processing:

It is now available for selection. To open processing, you need to click Execute:

Now let's see how processing for filling (modifying) specific objects is added. For example, let's take external processing, which attaches scans to selected elements of directories or system documents. The beginning of adding such processing is no different from the previous option. The difference is that in this case the placement is filled in automatically (and not by the program section, but by the types of database objects):

If desired, the placement list can be adjusted ( do not add additional placement, but remove unnecessary):

To accept the change, the external object card must also be written down.

In order to use processing, you need to go to a specific database object (from the placement list), click Fill in the command panel and select the command:

In this article we will look at how to connect external processing or reporting to your 1C. As an example, we use the configuration “Enterprise Accounting ed. 3.0", but the article is also suitable for any other modern 1C.

Processing connection

If the processing came to you by mail, first save it to your computer;
Go to the menu “Administration” - “Print forms, reports and processing”:

“Administration” - “Printed forms, reports and processing”

3. Check the “Additional reports and processing” checkbox if it is not already selected:

"Additional reports and processing" checkbox

If you do not have this checkbox, it means you do not have enough rights in 1C. If 1C is installed on your server, then contact your 1C administrator so that he can enable processing for you. If he has never done this before, give him a link to this article.

Also, this checkbox may not be present if your 1c is in a cloud service. In this case, simply send the processing file to your manager. If they refuse to connect processing to your cloud, we can

4. Go to “Additional reports and processing”:

5. In the list that opens, click “Create”:

Adding External Processing

6. 1C will display a security warning, click “Continue”:

7. A window for selecting a processing file will open. Select the desired file and click "Open":

Selecting a processing file

If the message “It is not possible to connect additional processing from the file. Perhaps it is not suitable for this version of the program,” which means either you downloaded the processing not for your version of 1C, or the developer formatted the processing code incorrectly, or there is an error in the program code itself:

Contact the processing developer, or contact us, we

8. If the file matches your version of the program, a form for creating a new external processing will open. It will immediately contain the name of the processing specified by the developer and the name of the command that opens the processing: