How to connect an external report. Adding an external report to the database

This article describes how to connect an external printed form to the 1C database on the configuration example "Trade Management 11.2" configuration

Configuration "Trade Management 11.2" - this is a configuration on "managed" forms!

Our instruction "shows" how to connect an external printed form in information base 1c with configuration on "managed" forms namely:

"Accounting 3.0"
"Trade Management 11.2"
"Salary and personnel management 3.1"
"Comprehensive automation 2.0"
"Management of a small company 1.6"
"Retail 2.2"
and other similar configurations.

In order to connect an external printed form in 1C We will need to pass 11 steps.

1 - The "NSI and Administration" menu (in other configurations, such as enterprise accounting, 3.0 can be called simply - "Administration"). 2 - Select "Printed Forms, Reports and Processing" (see Fig. Below ↓)

3 - Reveal the "Reports and Processing" submenu (in other configurations, such as in the company's accounting of 3.0, this submenu may not be, so we immediately go to the next action). 4 - We put the "tick" using additional reports and treatments. 5 - Go to the section: Additional reports and processing. (See Fig. below ↓) ()

6 - Press the "Create" button. (See Fig. below ↓)

In the new versions of 1C (starting from August 2016), the program has built a mechanism for warning about the danger of using unknown external treatments, which may contain "viruses", in earlier versions of the program warning will not occur! If it occurred, then to connect external printed form It will be necessary - 7 - Press the "Continue" button. (See Fig. below ↓)

8 - Select the directory in which processing is. 9 - Select it (processing you need). 10 - Press the "Open" button. Either instead of actions 9 and 10, you can simply click on the external printed form you need in the selection window. (See Fig. below ↓)

If we need to add placement for the processing added (for example, it is Universal form Treaty from our site and we need that the print command of this form will be displayed in some object in which it is originally not displayed) - 11 - Press the placement line ("place in:", maybe "placement:") and choose the necessary reference books and documents. 12 - Complete steps to connect an external printed form by pressing the "Record and Close" button. (See Fig. below ↓)

That's all! Congratulations! The external printed form is connected! And did we do wrong? Check ...

Before recording and closing, we noticed that this external printed form was placed in the document implementation of goods and services, which means that printing opportunities are opening any document of the species: "Implementation of goods and services". Click the "Print" button and see - a window selection window appears, among them are present - 13 - the external printed form connected by us (see Fig. Below ↓)

Now exactly - all. We hope that this article was useful to you.

How to add (register) External printed form (or processing) in 1C Accounting 8.3 (edition 3.0)

2019-05-15T13: 40: 54 + 00: 00

Often the accountant has a need for additional printed form to some of the standard documents 1C: Accounting 8.3 (edition 3.0). Or needed additional processing, for example, to automatically fill out a document or enter a new one on the base. Usually such an opportunity has already been designed for someone else and it can be found or order from a programmer. And here the refinement is obtained, it remains only to add it to the accounting department. How to do it? About this below steps.

1. Open 1C Accounting 3.0 and select the "Administration" section in the left pane -\u003e "Print forms, Reports and Processing" ():

2. Here are finding and select "Advanced Reports and Processing", after setting the "Advanced Reports and Processing" daws on the left:

3. Click the "Add File ..." button.

4. And select a file with an external printed form or processing (EPF extension).

5. In a new window, click the "Record and Close" button.

6. Open necessary document And make sure that another printed form option or item appears in the Print button or the "Create based on" menu or a new button on the shape toolbar. Ready!

Yours faithfully, Vladimir Milkin (teacher and developer).

Very often, 1C users need additional functionality that is not contained in a typical applied solution. This can be a special printed form of a document, a report containing the necessary data, filling out reference books and documents on a specific algorithm, entering some objects on the basis of others, etc. To fulfill these and many other actions, it is not required to remove the configuration with support and lose automatic updatesTypical applied solutions allow you to solve such tasks using external reports and treatments. In addition, external processing can be launched in basic versionsthat do not provide changes to the configuration of the applied solution.

Any application solution (even an empty, not containing objects), built on the basis of 1C: Enterprise, allows you to use external reports and processing. This is done through the main menu: "File" - "Open". After selecting an external report or processing file, it opens its form and the user can use the required functionality.

The feature of typical applied solutions is that they are built into special subsystems that expand the possibilities of using external reports and treatments.

By type of launch, applied solutions are divided into two groups: built on the basis of a regular or managed application. The first group includes "Accounting 2.x", "Managing Trade 10.x", "Retail 1.x", etc. The second group includes "Accounting 3.x", "Managing Trade 11.x", "Retail 2.x", "Management of our company", etc. Applied solutions built on the basis regular appare outdated, but still widely used by users.

In this article, consider the use of external reports and treatments in the usual interface using the example of a model applied solution "1C: Trade Management 10.3".

In the usual interface, external reports and processing are connected through the main menu "Service" - "External printed form and processing".

The system allows you to use external reports and processing of four types:

External reports

External printed forms - forms printed forms of reference books and documents not provided for in a typical applied solution.

When adding or editing an additional printed form, an external processing card opens.

In the card, you must specify the name of the printed form, comment and select the external processing file. If the external processing has the autoregenial parameters, the printing form table will be filled automatically. But if necessary, it can be filled or edited manually.

The object representation is an object to which the external printed form is attached (directory or document). Pressing the selection button opens the form of selection of printing form.

Selection - allows you to connect an external printed form not for all documents, but for determined by selection. Moreover, the selection is configured for each object of affiliation separately. Selection is configured in similarly typical selections in reports and processing.

Printed file file - allows you to choose for each object affiliation separate file external printed form, i.e. It can be absolutely different on the implementation of processing, but the same in meaning.
Replaced Printed Form - Allows you to select a typical printed form of an object, which will replace a new external printed form. It is necessary that users do not get confused in cases when a new external is developed instead of typical form.
Processing parameters - extra optionstransmitted to the print function. Practically not relevant for external printed forms. Parameters can only be values \u200b\u200bof simple types (number, line, date, boolean).

After connecting an additional printed form, it will be available in the specified document or directory in the "Print" menu.

In our example, the external printed form is replaced by a type of counterparty type for the document "Account.

For the document "Realization of goods and services":

External processing of table parts

External processing of filling in tabular parts - allow you to fill out the table parts of reference books and documents on specified algorithms.

When you add or edit the processing to fill the table parts, the external processing card opens. It differs from the card of the external printed form.

In the card, you must specify the name of the processing of the table parts, comment and select the external processing file. If the external processing has the autoregenial parameters, the printing form table will be filled automatically. But if necessary, it can be filled or edited manually.

The table contains the following columns:

The object presentation is an object to which the external processing of filling out the table parts (directory or document) is attached. When you press the selection button, the form of selection of the Table Parts Filling Processing Supplies.
Table parts - Table parts, which is assigned processing.
The button representation is the name of the button that will run the processing of filling out the table parts.
Processing parameters are additional parameters transmitted to the print function. Parameters can only be values \u200b\u200bof simple types (number, line, date, boolean).

After connecting the external processing of filling out the table parts, it will be available in the specified document or the directory in the "Fill" menu of the selected tabular part.

In our example, the "Fill over the remnants" button is added to the table part "Products" of the document "Came Order for Goods".

External treatments - carry out data processing on an arbitrary algorithm.

When adding or editing external processing, its card opens.

In the card, you must specify the name of the processing, comment and select the external processing file. The tabular part "belonging" for external processing is not active.

After connecting external processing, it will be available in the external processing list and it will be possible to open it with a double click.

External reports

External reports - withdraw data, the receipt of which is not provided in the type applied decision.

In the card, you must specify the report name, comment and select an external report file. The tabular part "belonging" for an external report is not active.

After connecting an external report, it will be available in the list of external reports and it can be opened with a double click.

As we see, using external treatments in the usual interface expands the capabilities of a typical application solution and simplifies users.

In the following article, consider a managed interface that gives even more opportunities to use external reports and treatments.

Consider in this article. step-by-step instructions By creating external processing in 1C 8.3 in the controlled application mode, respectively, we will use managed forms. And most importantly - we will learn to connect it to the "External Processing" mechanism of configurations 1C, built on the Library of the Standard Subsystems version 2.0 and the newer.

The task will be as follows: Create the simplest external processingwhich will perform a group action on the "Nomenclature" directory, namely, to establish the selected percentage of VAT rates for the specified group of the nomenclature.

To do this, immediately make the necessary setting in the program (the configuration of 1C 8.3 is considered: "Business Accounting 3.0" managed formas).

Installing this check box gives us the ability to use external processing.

Creating a new external processing in 1C 8.3 on the example

Now go to the configurator. In the "File" menu, choose "new ...". The window selection window opens created file. Choose "External Processing":

A new external processing window opens. Immediately ask her the name. It will be proposed while maintaining processing on the disk:

Add a new handling form. We indicate that this is a form of processing and it is the main:

On the form we will have two details:

Panconducture - reference to Handbook "Nomenclature";
Cholations - reference to the listing of VAT rates.

Create details in the "props" column in the upper right window. Drag and drag them to the left top window. New details should immediately appear on the form below.

The order of details can be changed by the "Up" arrows - "down":

Get 267 video tutorials for 1C for free:

It remains to add the "Install" button. In managed forms, it is impossible to add the button to the form. Even if you add it to the structure of the elements of the form, it will not be visible on the form itself. The button must be associated with the command it will perform. Go to the "Commands" tab and add the "InstalsewordCundens" command. In the properties of the team, create an action. Team handler Select "on the client". The command can be added to the form also by simply "dragging" to the section with form elements.

In the module, the procedure is created in the module. In it, call the procedure on the server:

& Svalette

Setting procedure (command)

InstallingCunderver ();

Extrudresses

In the Procedure on the server, write a small request and actions related to the installation of the VAT rate:

&On server

Procedure settingCanserver ()

Request. Installation parameter ("PageNeture", Panconducture);
Speed \u200b\u200b\u003d query. Fill ();
Selecting \u003d Speed. Embry ();

While tapping. Next () cycle

Attempt
Sprocket. To recruit ();
An exception
Report ("Error writing an object" "+ springs +" ""!
| " + Description ());
Celebrations;

EndCycle;

Extrudresses

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

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

However, the work in this mode is convenient for debugging processing, and for work, the user does not quite fit. Users are accustomed to them all the "arm at hand", that is, in the database itself.

For this, and serves the "Additional reports and processing" section.

But to add our processing there, you must first give her a description and inform the program of its properties.

Description of the function "Information about external processing"

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

Function Information Summer Processing () Export

This data \u003d new structure ();
Data ("Name", "Installing VAT Rate");
Data ("Safety", truth);
Data ("version", "Ver.: 1.001");
Data ("Information", "Processing to install VAT rates in the Nomenclature directory);
Dannoundedoleg. Land ("View", "Additional Pressure");

Tabzncomans \u003d new tables;
Tabzncommands. Cuttings. Addly ("identifier");
Tabznomands. Tablocks. Addly ("use");
Tabzncomans. Cuttings. Addly ("performance");

Novstok \u003d Tabznomands. Addly ();
Novstok.Identifier \u003d "Openwork";
Novstoka. Using \u003d "Openingform";
Novstok.Representation \u003d "Open processing";
Data ("teams", tabsnomands);

Return of this data;

Endfunction

To better understand what fields of registration data structure must be used, we will see the details of the reference book "Additional reports and processing":

As you can see, everything is quite simple. Only one props are not coincided: "Option" is "use". If you see the code of one of common modules, we will see how the bunch of these fields arises:

To determine which fields are mandatory, you can first not describe it, just create an empty, and then use the debugger. If you trace modules when registering processing, it becomes clear which fields are required, and which are not.

Connecting external processing in 1C 8.3

In this article, consider how to connect external processing or report to your 1C. As an example, we use the configuration "Accounting of the enterprise Ed. 3.0, but the article is suitable for any other modern 1C.

Connecting processing

If the processing came to you by mail, first save it to the computer;
Go to the "Administration" menu - "Printed Forms, Reports and Processing":

"Administration" - "Print forms, Reports and Processing"

3. Check the Advanced Reports and Processing check box if it is not yet set:

Checkbox "Additional reports and processing"

If you do not have this flag, it means that you are not right in 1C. If 1c is installed on your server, contact your 1C administrator so that it connects processing instead of you. If he never did it before, let him link to this article.

Also this tick may not be if your 1C is in cloud service. In this case, simply send the processing file to your manager. If processing refuse to connect 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 security warning, click "Continue":

7. The processing file selection window opens. Choose the desired file. and click "Open":

Selecting a processing file

If the message appears "Unable to connect additional processing from the file. Perhaps it is not suitable for this version of the program, "it means that either you downloaded not for your version 1C, or the developer incorrectly issued the processing code, or in the program code itself there is an error:

Contact treatment developer or to us, we

8. If the file comes to your version of the program, the form of creating a new external processing will open. It will immediately be filled with the name of the processing specified by the developer, and the name of the processing team:

You need to fill out the processing and determine the list of users to which it will be immediately available.

9. Click on the inscription "not defined":

10. In the form that opens, select one or more partitions, where do you want to open processing:

11. Now specify those users who need access to processing:

12. Button "\u003e" select necessary users. If access is needed to all, then click "\u003e\u003e":

13. On this settings are completed, it remains to be preserved. Click "Record and Close":

Checking the connected processing

14. Now go to the section in which we placed new processing. It should appear link " Additional processing»:

15. Click on it, there will be just connected processing. Highlighting it with the mouse and clicking "Run" you start processing:

Connect report

The external report connects exactly as external processing.

The only difference: the report will appear in the "Advanced Reports" section:

Starting an external report is the same as the external processing:

That's all, now you know how to connect external processing or report to 1C