Adding external sound to the base. Adding external sound to the base 1c creating external sound from scratch
Go to the site as a student
Data composition system 1C 8.3 for Pochatkivtsi: first light on SKD
If you haven’t read the introduction to this module, please read it: .
For Wikonian lessons you will need 1C 8.3 (not lower 8.3.13.1644 ) .
If you have 1C version 8.3 installed - check it out. In any case, download and install the initial version that 1C releases specifically for educational purposes: .
The following label may appear on your desktop:
For all the lessons in this cycle, we will use the Gastronom database that I have prepared. Vaughn is completely avoiding the base that we vikoristed from the school modules when teaching questions. Therefore, I will provide insurance that you know about their witnesses and documents.
If you have deleted it, re-enter it as soon as possible, unpack it to the list of databases.
Finally, the work place has been cleared up and we will immediately create our first link for an additional system for compiling data. We will forgive you in order to demonstrate the hidden capabilities of the data composition system (for short SKD).
Let's put a meta
Let's talk about this lesson- create a function that allows the customer mode to display a list of clients from the following fields:
- I'm
- Pidloga
- The client's favorite color.
The sound may be external. This means that it will be created and configured in the configurator, and then saved as a separate (external) file on the computer.
To form such a message in 1C Koristuvache, you will need to launch the database in Koristuvache mode, open the file and click the “Form” button.
Let's go!
We create a sound
Let's launch the configurator for the "Gastronom" database:
From the main menu, select the item "File" -> "New...":
Select "External Sound":
Creating a scheme for arranging data in the middle of the world
The creation of the external world has finally opened. How I enter: " Lesson 1", and then emboss the button " Open the data composition diagram":
The circuit designer has started. Let's wait with them for washing " Basic Data Layout Scheme"I emboss the button" Ready":
The main working window has opened, with no tabs and fields, in which we have adjusted our data composition scheme.
There’s no need to rant – there are truly a lot of possibilities here, but we don’t need all of them. Especially during the first lesson.
We are now in stock Set of tributes We'll stop with it.
The writing is entered through the constructor
The data composition system (abbreviated as DCS) is important to us tribute, as you deduce koristuvachevi.
The simplest way is write a question to the base. At school, we learned to write and understand how to drink - so I’ll pay you for your basic skills.
Pressing on greenery plus sign in the list that opens, select the item " Add data dialing - ask":
Our task is to write the text in this field. You haven’t forgotten yet, how can you stop worrying?
I'll show you:
From whose request we have selected three fields (" Name", "Pidloga"і" Lovely colors") from table " Dovidnik.".
Please do not rush to write this text in the "Written" field manually.
At the same time, we will immediately ask the same person visually, just for help with the bear. This method is called " The constructor will be asked".
To click on this designer, click the " button The designer will ask... at the top right part of the "Write" field:
In the window, drag the table " Clients From the first paragraph to the next, to indicate that we will be asking the data from this table:
The axis came out like this:
Next, let's open the table " Clients"Another has a hundred for a sign" Plus"to add all the fields and drag the field" Name"From the other column to the third, to indicate that from this table we need to query the "Name" field:
The axis came out like this:
We can do it the same way with the fields" Pidloga"і" Lovely colors". The result will be like this:
Click the "OK" button to exit the query constructor, and most importantly, the text will be automatically added to the "Quote" field.
Moreover, on the subtext of the query, 1C itself included the names of the fields (the area in which the query is most important), which will be based on the data composition scheme:
Now, if we have put in a request, the SKD knows how to extract the data for the call.
We are preparing to present the data
Got lost visualize this data for koristuvach yak drukovany form. And here SKD can work wonders!
To create such a miracle, let's go to the "tab" Setting up and press the customize designer button ( Charming stick):
The window shows the type of sound " Perelik" and pressed " Dali":
At the next window, select (drag and drag) the fields that will need to be displayed in the list (we will drag and drop all available to us: " Lovely colors", "Name"і" Pidloga"):
Let's select this result and press the button " OK":
The designer adjusts the closing and appearing item Detailed entries":
He's ready, let's check him out. For this purpose, the first one is considered as an external file.
We save the sound in a file
Open the main menu item File"->"Save":
I'll save it on my desk under my desk Lesson 1":
Let's check the sound of the customer service
Let’s close the configurator and go to our database in customer mode:
Account name "Administrator", no password:
Via the menu, select the item " File"->"Vidkriti...":
And let’s add the file (I saved it to my desktop under the name “Lesson1.erf”:
The call form will open, press the button " Formulate":
Ready! Our axis is designed with a form with a list of clients, their favorite color and layout:
The Drukovan shape can be easily separated. For this, it is enough to vibrate in the menu item " File"->"Druk...":
It’s so simple, without programming, we were able to create a full-fledged sound that companies can create from their bases, shape and deconstruct.
uchniv - I confirm by mail, first look at.
Go to the site as a student
Log out as a student to deny access to school materials
The need to adjust external sounds may arise due to rapid changes in different sound forms. Even the government authorities that approve the relevant forms must not always ensure that the subjects of government need time to prepare the relevant form. Author - S.A. Kharitoniv.
In typical configurations for "1C:Enterprise 8", which are produced by the company "1C", the forms of regulated significance are included in the configuration warehouse and are released simultaneously with configuration releases. However, when the need arises - for example, a new edition of the news form is gaining ground - the 1C company releases such news forms in the form of external news "1C:Enterprises 8 " (files with *.erf extensions).
The choice of external opinions and timely decisions must be made only before the release of the configuration, in which the necessary changes will be implemented. Therefore, based on external sounds, the following songs are superimposed:
- At the hour of the release of the new report, it is necessary to decide which release the changes can be taken into account;
- External sound support of the latest configuration releases is not guaranteed;
- At the moment, it is not possible to work with the configuration of the koristuvach more than the version of the external world;
- According to the form of the sound, more than a difficult hour ends, against the sound implemented as an object of configuration;
- The use of data in electronic form results in greater and greater benefits.
A list of external news released for a specific configuration release can be found on the configuration page of the support site for customer programs "1C:Enterprises 8" at the address www.users.v8.1c.ru (at the or Information provided It is necessary to click on the number to click on the version number to click) or on the form Information about the update(click the button Information about the update top team uniform ), if the information base includes service notification of regulated information.
In this form you can click on the name of an external star to add it to your computer.
As a rule, the names appear everywhere in the RAR archive. To use the archives externally, you must unzip them.
In the archive, along with the external call file, there is a text file describing the purpose of the call and the order of its connection.
Yakshcho calls for deputy regulations of the regulated navit, Yasky in the configuration, yogo is able to piddlychiti to іnormatniynaya base, simply navigation of the navit at the regimen "1c: PIDPRIMENT" (menu "(menu" (menu "(menu" (menu File - Open).
When energized, power will be supplied Register current regulations in the information database? After the video So The new sound will be registered in the information database and will be opened for the creation of a new sound.
How to report No, there will be no registrations, but will also be open to creating a new link. With this information, it will be possible to delete all actions - creations, completions, etc. - but the creations will not be able to be saved in the information database.
Since external calls are a new type of regulated call, it is not possible to automatically register in the information database: this mode must be activated manually. Indications for connection are also in a text file, which is located in the archive extracted from the 1C website.
In order to vikoristan external sound, it is necessary to note that from this regulated sound there is not an internal configuration object, but an external sound.
For registration of external sound as a new type of regulated sound with the agent Regulated calls necessary (div. Fig. 1):
1) go to the group of the adviser, which has a new view;
2) create a new document element by pressing the button Add at the top command panel of the browser form;
3) in the form of the Adviser element, fill in the name that the Adviser has Regulated calls and in the list of types of sounds of the form Financial matters are regulated. Bazhano also fill in the description of the sight;
4) peremikach Vikoristati Insert the file into the position and indicate which file will be selected as the external sound. After pressing the button OK When opening a file in the file form field, the document element will be indicated outside the name of the external link.
Small 1. Registration of external sound
After pressing the button Write down The external sound is saved in the information base, after which the external file name is replaced with text Sound is in vogue in IB.
The same is displayed when the button is pressed OK, whereby the shape of the element is Regulated calls closes up.
For advisor elements for which external calls are selected, a row (external) is added to the advisor list form after naming the call.
Once the external voice has been imported into the information base, the external voice file is no longer needed and can be deleted.
The work with a regulated sound, which is what the world knows, has nothing to do with the work with an object configuration, except for the “increased reaction” when detected and when disturbed. data in electronic form.
As a sign of the current situation, a blue information text is displayed on the right side of the top command panel External sound.
If only you can turn to the “internal” object of configuration. For which form of the indicator element for the necessary regulated signal it is necessary to install a jumper Vikoristati at the camp object and save the witness element.
The external call itself is not deleted from the information base, so this may be counterproductive. To delete a call from the information base, you need to sign in like this:
1) at the witness Regulated calls find out the regulations of the sound for which an external call is connected - for such a call, after naming the call, a row (external) will be added;
2) open the browser element to edit it manually using the button Change flow element;
3) in the field for selecting external sound, press the button X (Clear). After typing text Sound is in vogue in IB cleared, which means that the entry will be deleted from the information base;
4) close the form of the indicator element by clicking the button OK.
The notice expires at the hour of saving the guard element.
Whenever you need to enter the information database, you can save the file on disk. For what form is the element of the indicator? Regulated calls it is necessary to press on the message with the text Vivantize external sound from the file. The standard file saving dialog opens. When you type the name of the file, the name of the specific configuration object is indicated.
It is important that in one session of the computer program with an information base it is not possible to access more than one version of the current message: for example, since the computer system already works with a regulated version, which is external With this name, and having attracted the attention of the interviewer Regulated calls Another version of this current call (for example, with added auto-refills) for this new version of the call, you will need to end your work session in the "1C:Enterprise" mode, after which you will immediately start a new session.
The creation of stars is one of the main functions of any system. We will look at what types of information there are in 1C Accounting 3.0, how to develop information in 1C Accounting 8.3, and how to find tools for creating new ideas. .
Types of standard calls
The accounting program of the 1C company has a wide range of options installed out of the box, which allows you to select all the necessary information. This is the latest influx of shows in the “Sounds/Standard Calls” section:
Also, each section of the program presents other types of standard inputs, for example, inputs from salary in 1C 8.3 are saved in the section “Salary and personnel/Inputs from salary”.
Each person has the opportunity to “adjust” the sound, and you can add or add additional fields, add grouping, select, etc.
Let's take a look at the option of adjusting on the example of adding an additional field to the standard value “Turnover balance by rack” (10 racks can be selected). For which from the “Show customization” button go to “Additional fields”, add a new field, and in the selection form go to the required field, for example, to display the item of the nomenclature, select the “Article” field, which is located in the middle of the “Nomenclature” field ( To open the field you need to press “+”):
After pressing “Formulate”, the additional field that we have selected will appear.
For example, let’s look at the situation if before the call it is necessary to include the entire range of nomenclature in order to remove the word “chobit” from the named one. What needs to be earned for? After pressing “Show settings”, go to the “Vidbir” tab, add a new field, and in the window, opening the “+” field “Nomenclature”, select “Name”.
After forming the name, the nomenclature is removed so that the named value does not have a specified value.
Formation of responses across documents
The “Standard Sounds” section has a universal sound that allows you to display information from such configuration objects as:
- document;
- Dovidnik;
- Registry of accumulation;
- Register of statements;
- Register of rozrakhunks.
Let's take a look at the situation, if it helps the teacher not to go into the disarray of external influences, but to use the typical adjustment mechanism.
For example, we need to formulate a report that will represent all the goods that were received from a specific counterparty during the current period. For this item, select from the drop-down list the type of object – “Document”, the type of object – “Receipt (acts, invoices)”, and the specified type – “Goods”.
*The Counterparty field is completely absent there.
In the “Type of payment” field, set “River”; in the “Value” field, select the required counterparty from the contractor.
At the top part of the sound, the required period is indicated and the sound is formed.
To complete the settings we have added, you can make savings: to do this, press the “More/Save” button.
Let's take a look at the situation when, in order to correctly formulate the regulated information, it is necessary to check all the details of the “Separate area of the MDV” register at the document level.
For which in the header, select from the list that drops out, the type of object is “Accumulation Register”, in the next field we select the type of object – “Separate volume of PDV”, in the remaining field we select the type – “Surplus and turnover”.
In order for the information to be displayed in the context of documents, using the “Show settings” button we go to the sound settings, then to the “Indicators” tab, adding a new field and selecting the “Registrar” field in the window (“recorder”). "estrator" is a document that was formed according to the accumulation register). A newly added field will be displayed at the bottom of the list of fields: the Registrar field will be moved to the top of the list using blue arrows.
In this article, we looked at what options there are to work with this information in 1C Accounting 8, how to navigate the settings and how information can be removed, vikoryst and universal sound.
For reference, I (hereinafter referred to as the Person), give my permission to IP Zabolotnov Oleksiy Volodimirovich INN212702621854, OGRNIP 313213018300022 (hereinafter referred to as the Company) to process my personal data specified when filling out an application on the Company’s website ї (https:// applications or any other way communication to the Company (hereinafter referred to as the Agreement), and communications with me within the framework of the preparation of this Agreement, as well as other related purposes within the framework of the official legislation of the Russian Federation and the technical capabilities of the Company.
Processing of personal data Individuals may be subject to additional automation features and/or without additional automation features, subject to the applicable legislation of the Russian Federation and the Company's regulations. This year, Individuals are required to process their personal data, which was entered during the registration of the Agreement on the Company’s website, which is sent (renewed) from the following website, from the moment of registration of the Agreement on the Company’s website until the moment of its clicking. The request for the processing of personal data included in the registration of the Agreement on the Company’s website, which is sent (repeated) from the website of this website, can be specifically requested at the time of submitting a written application (click) to the Company. Processing of personal data of an individual is carried out within 2 months from the moment the Company receives a written application (clicking) Individuals and/or at any time the processing is available in the lines and on the minds established by law, which is not transmitted otherwise. Non-separated personal data Individuals may be used by the Company for statistical (and other pre-investigative) purposes after the application has been withdrawn, as well as after the achievement of goals for which the purpose has been withdrawn .
This site allows IP Zabolotnov Oleksiya Volodymyrovich to collect information that contains the personal data of the Person, as well as his father’s nickname, contact phone number, email address, as well as other personal data that may be to identify the Individual (“Your personal data”), times when a person voluntarily gives to their company.
The person gives permission to IP Zabolotnov Oleksiya Volodimirovich (IPN INN212702621854, OGRNIP 313213018300022), to process his personal data, and himself: nickname after father’s name, contact phone number, email address ї mail, as well as all personal data for the provision of information services.
By means of a contract, the person gives individual entrepreneur Oleksiya Volodimirovich Zabolotnov (IPN IPN212702621854, OGRNIP 313213018300022) the right to carry out any activities (operations) with your personal data without deduction: collection, recording, appearance, collection system, accumulation, non-isolation, blocking, vidalnya, impoverishment; research for statistical purposes, through analysis, through informing Individuals (by sending SMS or email) about the products and services of the Company, as well as carrying out any other activities in accordance with the regulations of the law favors.
Privacy Policy
Any other information that is transmitted to the Special Site (“Other Information” that is not personal data of the Individual and cannot be used to identify the Individual) can be included in the databases , which belongs to IP Zabolotnov Oleksiya Volodimirovich (INN ІНН212702621854, OGRNІ03 and its representatives. IP Zabolotnov Oleksiy Volodimirovich reserves all rights to this database and the information that is stored in them. We choose to include your IP address and other information that is collected by additional cookies. (div. below).
This site may use technology, such as a cookie. A cookie is a notification that the web server sends to an Individual’s computer when the Individual accesses the site. When you visit our site again, check if you have one of our cookies on your computer. Our cookies improve the functionality of the site and help us more accurately analyze how the site is used by the site.
This site is a vikoryst Internet Protocol (IP) address. IP addresses are a number assigned to a computer by an Internet provider for access to the Internet. The IP addresses change as soon as you access the Internet (not “dynamic” addresses). Tim is not less, since the vikoryst is a high-quality connection, it is important to note that the IP addresses or send a cookie that we vikorist can contain information that is identified. This means that with any type of high-speed connection, your IP address does not change (“static”) and can be associated with the Person’s computer. We are using the IP address of the individual to provide illegal information to the site, as well as for further processing.
This site uses technology for the special purpose of the individual.
You are specifically required to close this site if you do not want other data (cookies, data about IP addresses and location) to be collected.
This site is not suitable for special occasions until the 18th. We do not collect personal data from individuals who, based on the information we provide, have not reached the 18th century. The site where information is collected uses standard Secure Sockets Layer (SSL) encryption. However, in order to use this option quickly, the browser must support cryptographic security (starting with Internet Explorer 3.0 and beyond). Individual Entrepreneur Oleksiy Volodimirovich Zabolotnov reserves the right to provide information to government authorities for specific requests or in cases provided by law.
For further information about the Person from our contact lists, you must contact the following address: IP Zabolotnov Oleksiy Volodimirovich, tel.: +7 8352 441133. Or e-mail: manager@site
Individuals can continue to retrieve materials while our lists are being updated. The Website Privacy Policy may be updated from time to time. After updating, these rules will be available on this page.
It seems that under the name 1C from the very beginning there is a small phrase “one second”, then. The programs are responsible for calling Shvidko, “in one second.” The fluidity of the work of sounds is very important, but it is even more important that the calls provide the correct information - let’s look at this with the example of creating a simple call in 1C 8.3 with the organization of the configuration of Trade Management 10.3. To create correct sounds, it is important (or recommended) to configure 1C and program a little with the internal and external inputs of 1C, although, on the other hand, the creation of sounds - the miracle of power has begun and master these skills.
This is described as a starting point for understanding the basic principles of the creation of 1C
How to create a sound in 1C 8.3
To create a sound, you need to open 1C in configurator mode, for which, at the 1C launch window, select the required database from the list and press the Configurator button:
In the configurator itself, go to the File menu and select New:
From the menu, select the External Sound item and press the OK button:
After this, a new world appears. In the Name field, enter the name of the name, there may be no spaces or special characters:
How to earn money for an additional layout
For which method requires the most basic programming skills in 1C, if we do not understand the mechanisms for extracting and processing data, we will create a simple call to understand the mechanism for launching the call and displaying the call form on the screen:
In the sound window (which opens when the sound is closed) in the lower list, place the cursor on the Layouts item and, while pressing the right mouse button, click Add in the menu:
In the layout designer that opens, you can specify the name of the layout, depending on the layout type, the selection is Spreadsheet document, after which you click the Finish button in the designer:
After this, the layout window will open, which resembles an Excel sheet:
In this layout it is necessary to create areas - groups of rows of people, such as programs, like templates, present data contained in the database, and display these templates on the screen, thus selecting them all at once From these parts.
It is obvious that this is the difference in nomenclature. For this purpose, we create two areas of the layout: the header and the row of nomenclature.
To open the header area, use the left button to click on the row header (where the row number is indicated) to see the row axis like this (you can see the entire row with one click on the header):
After going to the Table menu of the main menu, go to the Names submenu and click on the Assign Names item:
The program prompts you to enter the name of the area, and you also don’t have to add spaces or special characters, after which you click OK and can exit like this:
Now in the creation area you need to enter the text that appears in the name and format. For this purpose, enter the text into the first box, for example, “Perelik nomenklatura.” The work with middles is similar to Excel.
To format the text from a business, click on the business with the right button and click on Power. The right hand is revealed to the authorities of the business. Scroll down instead of the window, find the Font field and click the “...” button:
In the window that has opened, in the Chair section, check the Bold checkbox and press the OK button:
The layout may have an axis like this:
Use the same procedure to create the area of the nomenclature row, but it is not visible in bold:
In the row area, it is necessary to indicate that the name is not a parameter, then. that the actual naming of the nomenclature is presented there when the call is displayed. For which the power of the business from the name and the power of the Replacement field is selected, select the value Parameter, at which configuration of the layout is completed:
Turn around at the head of the icon and in the lower list, right-click on the Form item and click Add:
In the form designer, when it opens, click the Finish button, the form appears, and click on the Form button:
As a result, the power button window will open on the right side of the screen, in the Action field, click on the magnifying glass:
After this, the form module will open, where you need to program the forming of the name:
Now let’s insert the following text into the program code instead of the seen text:
//create a spreadsheet document that consists of parts and displays on the screen
TabDocument = New TabularDocument;
//Next, we can remove the layout that was created when the light was created
Layout = OtrimatiLayout("Layout");
//now you need to add a header to the image, for which you select the header area from the layout and display it in the spreadsheet document
AreaHeader = Layout.OtrimatiArea("Header");
TabDocument.Vesti(AreaHeader);
//for this additional question, select the name of the nomenclature that you require from your partner
Zapit = New Zapit;
Cap.Text = "
| VIBRATE
| Name
|З
| Dovidnik.Nomenclature
|";
//remove the area of the nomenclature row from the layout - move to it in a cycle to display the skin name
AreaRow = Layout.OtrimatiArea("Row");
//produced in the cycle of skin lesions from the removed sample
Vib_rka = Request.Vikonati().Vibrati();
Poki Vibirka.Offensive() Loop
//to display the drawing row, you need to specify the drawing name of the area parameter (we adjusted the parameter itself during the creation of the layout)
AreaRow.Parameters.Name = Vibirka.Name;
//the parameter has been filled in, now you can enter a row
TabDocument.Vesti(RowArea);
KіnetsCycle;
//tabular document of formations, now displayed on the screen
TabDocument.Show("Perelik nomenclature");
If the text is copied into the form module, then the rows that begin with the trailing slash “//” will be visible in green - here are the comments that describe how each row ends with the code:
To summarize, what lines of program code are needed to form a sound:
- It is necessary to create a tabular document that will resemble parts of the name and be displayed on the screen, working in a row “TabDocument = New TabularDocument;”
- It is necessary to select the layout of the image, from this we can select the structure of the image in parts (areas), work in a row "Layout = OtrimatiMaket("Layout")"
- To display the skin areas, you need to select them from the layout and enter them into a spreadsheet document, using the rows "Header Area = Layout. Select Area ("Header")" and "TabDocument.
- If you need to fill in the parameters that become visible only when programs are launched, before displaying the area, you need to fill in such parameters, follow the sequence “Area.Parameters.Name = Selection.Name”
- Moreover, if the tabular document is filled with all the necessary parts, it is displayed on the screen, run in sequence "TabDocument.Show("List of items")"
And now you can check the work signal - open 1C in the business mode (button 1C: Business in the 1C launch window). At the main menu, go to the file menu, press Open:
We know that the savings file is open. On the form that has opened, press the Form button:
and we can remove the shift in nomenclature:
This is just one of the ways to create sounds in 1C. We will look at other articles in the following articles.