Adding an external report to the database. Adding external processing to the 1C Accounting database, how to connect an external form

External treatments are very handy tool for companies using standard configurations on 1C:Enterprise 8.3. They allow you not to waste effort and money on 1C updates, making it possible to update databases with one button in simple user mode. Using the standard subsystem library mechanism, you can add various buttons to documents and reference books without changing the standard configuration. Let's consider an example of creating and connecting external processing in one of the 1C configurations.

We create external processing in 1C 8.3

To create a new external processing, we use the configurator. Through the “File” menu, select the creation command “New...” and determine that we will create external processing. In the window that opens, set the name, and when you press “Enter,” it is filled in automatically. The system will also offer you this name as the file name when saving.

Let's add a processing form by clicking on the button with a magnifying glass in the corresponding window. As an example, let's create a processing showing which customer orders use a certain item. To do this, we need to place on the form:

• Attributes – field for setting the nomenclature;
• A button that will call the code.

Add the “Nomenclature” attribute with the data type “DirectoryLink.Nomenclature” in the corresponding section and the “Show” button in the “Commands” -> “Form Commands” menu.

In order for the added data to be reflected on the form, you must drag it into the form elements located in the upper left part. It is possible to swap elements using the blue arrows. In order for the button we created to do what it intended, it needs to be assigned a procedure. Through context menu Let’s select “Command Action”, and when asked where the handler is needed, we will answer: “Create on the client and a procedure on the server.”

Fragment 1

&OnClient Procedure Show(Command) ShowOnServer(); End of Procedure &OnServer Procedure ShowOnServer() //Insert the contents of the handler. End of Procedure

We chose to create a procedure on the server because we want to receive a sample from the database as a result. We do not have this option on the client, so we will need to connect to the server, which exchanges data with the database. Now we need to write code that implements what we have planned. The request and output of all documents through the “Report()” function will be used.

Fragment 2

&OnClient Procedure Show(Command) ShowOnServer(Nomenclature); EndProcedure &OnServer Procedure ShowOnServer(Nomenclature) Request = New Request; Query.Text = "SELECT VARIOUS | Customer OrderComposition.Link AS Link | FROM | Document.Customer Order.Composition AS Customer OrderComposition | WHERE | Customer OrderComposition.Nomenclature = &Nomenclature"; Request.SetParameter("Nomenclature", Nomenclature); RequestResult = Request.Execute(); SelectionDetailRecords = QueryResult.Select(); While SelectionDetailedRecords.Next() Loop Report(SelectionDetailedRecords.Link); EndCycle; End of Procedure

At the current stage, we can open external processing in a running 1C database as an ordinary file, and it will already be operational. But if we have many users, we will have to send this file to all of them, providing them with instructions on how to actually open it in 1C, which is extremely inconvenient. To avoid this, our processing should be located inside one of the 1C sections. To do this, we need to modify it a little more through the configurator, specifying certain settings.

To place external processing in section 1C, it is necessary to register the procedure “Information ABOUT External Processing” in the object module. From the main processing menu, click Actions and select Object Module. Here you need to register all the settings necessary for 1C so that the system understands what is required of it and what kind of file is in front of it. The screenshot shows the code for the “Information ABOUT External Processing” function.

Function InformationOnExternalProcessing() Export DataForReg = New Structure(); DataForReg.Insert("Name","New external processing"); DataForReg.Insert("SafeMode", True); DataForReg.Insert("Version", "ver.: 1.001"); DataForReg.Insert("View", "AdditionalProcessing"); CommandTable = NewValueTable; TabZnCommands.Columns.Add("Identifier"); TabZnCommands.Columns.Add("Usage"); TabZnCommands.Columns.Add("View"); NewRow = TabZnCommands.Add(); NewString.Identifier = "NewExternalProcessing"; NewRow.Use = "OpenForm"; NewRow.View = "New external processing"; DataForReg.Insert("Commands", TabZnCommands); Return DataForReg; EndFunction

Fragment 3

Connecting external processing in 1C

Before connecting external processing to a standard configuration, you must enable the use of this tool. In “Administration” in the sub-item “Printed forms, reports and processing” we set the flag opposite the mechanism we need. A button for going to the directory of additional processing and reports becomes available to us.

When we go to the list, we will create a new line in it, and the system will prompt you to select a file. We select the processing we made and saved, and the 1C configuration independently fills in most of the fields. Using the “Run” button, we can already check the functionality of our processing, but this is not very convenient for other users. In order for users to have our command and be able to make a call, we need to:

• Specify the location of the object. By clicking on “Undefined” we open the sections window and indicate in which sections the operation will be available;
• Select users who have this command will appear in the “Additional processing” menu of the selected sections without unnecessary settings. To do this, in the table section you need to select the item “ Quick access"and add responsible users to the right half;
• On the " Additional information» you can specify the folder in which the downloaded processing will be located;
• After pressing the “Write” button in the selected section in the “Additional Processing” menu, users will find our command and will be able to use it.

If we want to make changes to our processing, we must first unload it from the database. To do this, find the required line in the “Additional processing and reports” directory and use the “Upload to file...” command. Make changes, save the processing and use the “Load from file...” button to find the modified epf file without changing the parameters. After recording, all users will see the changes made.

If you are using a non-standard or discontinued 1C database, then take advantage of the opportunity to download processing through the configurator. In the object tree, in the “Processings” section, create a new processing and, through the context menu, select “Replace with external processing, report...”. All that remains is to configure the launch of external processing from the desired section, including the added processing in the desired subsystem.

Working with external processing is very convenient and allows you to avoid many conflicts. Their only significant drawback is that they are not updated automatically along with the configuration. That is, if the developers changed the name of the document or reference book in the main configuration, we will have to manually configure the processing.

How to add (register) an external printed form (or processing) in 1C Accounting 8.3 (revision 3.0)

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

Often an accountant needs an additional printed form for one of the standard documents 1C: Accounting 8.3 (revision 3.0). Or do you need additional processing, for example, to automatically fill out a document or enter a new one based on. Usually someone has already developed such a feature and it can be found or ordered from a programmer. And now the revision has been received, all that remains is to add it to the accounting department. How to do this? More on this below, step by step.

1. Open 1C Accounting 3.0 and select the “Administration” -> “Print forms, reports and processing” section in the left panel:

2. Here, find and select “Additional reports and processing”, after checking the “Additional reports and processing” checkbox on the left:

3. Click the "Add from file..." button.

4. And select the file with external printing form or processing (epf extension).

5. In the new window, click the "Save and close" button.

6. Open the desired document and make sure that another option appears in the print button printed form or the menu item "Create based on" or new button on the form toolbar. Ready!

Sincerely, Vladimir Milkin(teacher and developer).

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 required file(in my case this 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:

Sometimes when working with software products 1C:Enterprise there is a need to use external printed forms, or external reports. These could be new reporting forms, non-standard reports made specifically for your company, and much more. They are very easy to use.

Let's consider connecting the report “Organizational Property Tax Declaration” using the example of “1C: Accounting 2.0”.

In the configurations “1C: Salary and HR Management 2.5”, “1C: Trade Management 10.3”, “1C: Integrated Automation 1.1” the scheme will be exactly the same. To do this, go to the “Service” tab, go to “Additional processing reports”, and then to “Additional external reports”

The following form will open:

Click the “Add” button, the registration form for a new external report opens, load our external report into it using the “Replace external processing file” button.

The program will write the “code” itself; the “Comment” is optional. Click "OK". The report will appear in the list. When you open it for the first time, 1C will offer to register the report, click “Yes”, the report will be automatically registered.

Very often, 1C users require additional functionality that is not contained in a standard application solution. This could be a special printed form of a document, a report containing the necessary data, filling out directories and documents according to a certain algorithm, entering some objects based on others, etc. To perform these and many other actions, you do not need to remove the configuration from support and lose automatic updates, standard application solutions allow you to solve such problems using external reports and processing. In addition, external processing can be run in basic versions, which do not involve changes to the configuration of the application solution.

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

The peculiarity of standard application solutions is that they have built-in special subsystems that expand the possibilities of using external reports and processing.

Based on the type of launch, application solutions are divided into two groups: those built on the basis of conventional or managed application. The first group includes “Accounting 2.x”, “Trade Management 10.x”, “Retail 1.x”, etc. The second group includes “Accounting 3.x”, “Trade Management 11.x”, “Retail 2.x”, “Management of our company”, etc. Application solutions built on top of a regular application are outdated, but are still widely used by users.

In this article we will consider the use of external reports and processing in a regular interface using the example of a typical application solution “1C: Trade Management 10.3”.

In the normal interface, external reports and processing are connected through the main menu “Service” - “External printed forms and processing”.

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

1. External reports

External printed forms - generates printed forms of reference books and documents that are not provided in the standard application solution.

When you add or edit an additional printing form, the external processing card opens.

In the card you must indicate the name of the printing form, a comment and select an external processing file. If external processing has auto-registration parameters, the “Print Form Ownership” table will be filled in automatically. But if necessary, it can be filled out or edited manually.

• Object representation - an object to which an external printed form (directory or document) is attached. When you press the selection button, a form for selecting a printing plate accessory opens.

• Selection - allows you to connect an external printing form not for all documents, but for certain ones by selection. Moreover, the selection is configured for each belonging object separately. Selection is configured similarly to standard selections in reports and processing.

• Printable form file - allows you to select accessories for each object separate file external printing form, i.e. these may be completely different in the implementation of processing, but identical in meaning.
• Replaceable printing form - allows you to select a standard printing form of the object, which will be replaced by a new external printing form. This is necessary so that users do not get confused in cases where a new external one is developed instead of a standard form.
• Processing options - additional options, passed to the print function. Practically not relevant for external printing forms. Parameters can only accept values ​​of simple types (number, string, date, boolean).

After connecting an additional printing form, it will be available in the specified document or reference book in the “Print” menu.

In our example, for the document “Invoice for payment to the buyer,” an external printed form replaces the standard one with selection by counterparty.

For the document “Sales of goods and services”:

External processing of filling tabular parts

External processing for filling out tabular parts - allows you to fill out tabular parts of reference books and documents using specified algorithms.

When adding or editing processing to fill out tabular parts, an external processing card opens. It is different from an external printed form card.

In the card, you must indicate the name of the processing for filling out the tabular parts, a comment, and select an external processing file. If external processing has auto-registration parameters, the Print Form Ownership table will be filled in automatically. But if necessary, it can be filled out or edited manually.

The table contains the following columns:

• Object representation - an object to which external processing of filling tabular parts (directory or document) is attached. When you click the selection button, a form for selecting accessories for processing filling out tabular parts opens.
• Tabular part - the tabular part to which processing is assigned.
• Button view - the name of the button that will start processing the filling of table parts.
• Processing parameters are additional parameters passed to the print function. Parameters can only accept values ​​of simple types (number, string, date, boolean).

After connecting external processing for filling tabular parts, it will be available in the specified document or reference book in the “Fill” menu of the selected tabular part.

In our example, the “Fill in balances” button is added to the “Goods” tabular section of the “Goods receipt order” document.

External processing - process data using an arbitrary algorithm.

When adding or editing an external processing, its card opens.

In the card you must indicate the name of the processing, a comment and select an external processing file. The “Affiliation” tabular part is not active for external processing.

After connecting an external processor, it will be available in the list of external processors and can be opened by double-clicking.

External reports

External reports - display data that is not provided for in a standard application solution.

In the card you must indicate the name of the report, a comment and select an external report file. The “Affiliation” tabular part for the external report is not active.

After connecting an external report, it will be available in the list of external reports and can be opened by double-clicking.

As we can see, the use of external processing in a regular interface expands the capabilities of a standard application solution and simplifies the user experience.

In the next article we will look at a managed interface, which gives even more opportunities for using external reports and processing.