Hello, our dear colleagues and partners. For the rest of the month, before us, it was necessary to supply a small amount of power to the programs 1C Accounting 8.3 from the prohannyam to help improve the list of nomenclature in the program, as it was in 8.2. So, in the old program, stinks could be added to the list of nomenclature of the article number code of the nomenclature position. It was all too easy. And the axis at 8.3 is not visible, but it was unreasonable. Really, everything is just nailed down. To that we wrote a small instruction to improve the results in the 1C Accounting 8.3 program, and then the algorithm will be fixed in any 1C configuration.
Otzhe, at the branch "Dovіdniki" there was a doc "Nomenklatura".
I’ll name the nomenclature in the list, in a way there are no information about the article of the product. To change the dues of the dovіdnik, quickly improve the yoga form. Open the list of commands by the "More" button, at the very bottom we know "Change the form".
At the form that was shown, we are presented with all the details of the report, which can be displayed on the screen.
Having installed a special ensign, for example “Code” and “Article”, we take away the list of nomenclature, in which the code and article are shown.
However, for such a deaky koristuvach, a dovіdnik is also not befitting. I want to stink bachiti number and article in front of the name of the product. It's also easy to screw up. I’m changing the shape of the list after the additional blue arrows on the toolbar, moving the props up and down, in addition, as we want to complete the list. You can also drag the details for the help of the left button of the mouse.
The axis is now the list of nomenclature such as you wanted yogo bachiti.
Experiment with the list options. Don't fight. Everything that I wrote can be twisted in whether it’s configurable on hardened forms and in some kind of agreement, for example, you can enter it on the checkpoint screen at the “Counterparty” agreement or the number of the contract in the “Contract” agreement. Don't be afraid that you are "breaking" the program.
In the extreme situation, you will always be able to “Install the standard settings”, as you know in the settings in the “Sche” section
I more. Some people telephone clients with such requests: “I have pressed on and in me now the name is not for an alphabet. Turn everything around, like I had it. The food chain is also easy to misunderstand. At the skin doctor, in the row of the heading of the tabular part, there is a “charitable arrow”, as if showing a stovpets, which sorting and directly sorting is inserted.
You can change the sorting directly by simply clicking on the arrow and then the list will be sorted, for example, from Z to A. If we want to sort the goods by the code, then for this you need to click the bear on the name of the entry code on the "CharCode" arrow" to move to the next page.
Well, from i everything. I'm sorry, I'll help you to practice with 1C programs. Work with 1C to your satisfaction. Join our groups in contact and classmates and be the first to know about our new statistics and changes in programs.
Nalashtuvannya vіdboru and keruvannya form list in 1C 8.x
In the eighth version of 1C, more "strings" of the ability to work with dynamic lists appeared, lower in version 7.7.
Under dynamic lists, follow the form of lists of addenda, documents, registers. All objects that appear on the screen in the world of glottis. Form a list, as in front of the article, you can use standard command panels with a standard set of control buttons.
The following buttons should be placed before selection:
І for younger versions 8.x:
If we look at the standard checkout panel in the form of a list, we can know the standard checkout buttons on the panel. For 8.1 and 8.2, the stench of the stench is called a trifle, but the stench is similar to the “funnel”-filter.
Aside from the selection buttons, version 8.x has an important function that was not available in version 7.7: the ability to display on the screen, expand or save to disk all the elements of the list in the view table. For whom it is not necessary to ask the programmer to paint the sound.
Otzhe, scho so wіdbіr і navіscho vin?
Show your own classic table:
He may have a number of rows and columns. In fact, the list of elements of the document or the list of documents is such a table.
Often the blame is the need to choose from the global buy and display a row of rows from the required column values:
Abo navpaki, add to the list of elements that “respect”:
The axis is here and come to the aid of the tools of choice. In 1C you can close with the choice of different variations. Ale, the principle of cross-consistency: choose rows with the required values in one or the same rows. Or clean up the rows with non-standard values in the columns.
The main button for managing the selection is the first time
You'll see the main form of the selection for the form of the list
Butt of the form for the selection of the dovіdnik of the main zasobіv
Leather row tsієї form vіdpovіdaє stovpchik stovpchik tabular form list (On tsіy form can be displayed not all stovpchiki. Vіdbіr mozhe buti yak on odnіy so i kіlkoh columns at once.
Row to replace the name of the column with a sign, the type of order and the value for the selection.
Values for alignment can be of different types. If the entry is of a simple type (number, row, date), then you simply enter the value for the alignment in the field (Code = 1000, Name = detail). As a collapsible type column (setting an element of the addendum, document, remapping), then the value field of the selection needs to select an element of that type.
Looked like a match
The cream of a simple “column and value” is often needed for gnuchkishi vidi alignment.
Moreover, you can see these por_vnyan lie in the type of value of the selection. The date can be changed not only by one, but also by the range (date from the beginning of the month to the end of the month), the number - by belonging to the interval (amount from 1000 to 1500). The row can be re-verified at the entrance (comment to leave "pіd zvіt"). In addition, the elements of the dovіdnikіv can be perevіryati on the input to the group, but it can not be more / less. You can also win over multiple values - for example, we need rows to sweep columns with a large number of values.
Before any kind of alignment "equally" є similar kind of alignment "not evenly". Tse means that when choosing this type of order, the list will have rows, krіm quiet, in columns that can be indicated in the value of the selection. New list type of order:
To a number of listings, more species are considered to be more common for zmist:
On the cob of the skin row, there is a field, in which you can put or know the sign. The icon is set to mean the choice of choice, so you did not specify a value for the choice (when it will be set to an empty value). І navpaki - the inclusion of a sign means a vіdmovu vіd vikoristanny vіdboru. When choosing a value for selection, that seemingly equal order is filled with replacements.
As we remember, on the command panel, the cream of the "head funnel", there are other buttons for controlling the selection. Another button for this list - select for exact values. Tsya is convenient for a practical use of a button, about which we have given a rozpovіmo. Її dіya polagaє in the offensive: put a prompt for the values at the flow column. Tse zaoshchadzhuє deaky hour and allow you to speed up the rich day. The third button is the selection history. With the onslaught of vi bachite, all vіdbori, yakі vi imposed on the current list earlier. The list is collected after the completion of work with the program. However, only a few of you ended the session correctly, and not through rebooting or shutting down the computer's life. І hit the rest button - turns on all installed options.
Nalashtuvannya sane looking lists, their saving and seeing for others.
In standard list forms, there are buttons for managing columns and a sign. Column adjustments are called from the menu "dії" by right-clicking on the list form. One button added to the command panel.
After її onslaught, the form of lashing is revealed:
Visible columns marked with checkboxes. You can unmute and unmute invisible columns. At the right part for the flow column, the position of that keruvannya is indicated by the world. You can change the width of all columns by placing the cursor at the table header between the columns (when the cursor appears). Even though the vins do not change looking, the change of the rozmіru is fixed at the fixed column. You can change the change of the world by specifying a different form of adjustment (select the column - Change the size of the world: Change).
If you deselect the desired view of the list, you can debug it or save it to disk.
Shukaєmo instruct from the button to set the list button "enter the list". Onslaught - the dialogue is opened:
Here, the visible columns are also marked with daws, as they will be shown in the Drukar form. We take away non-consumables, including consumables and press OK. After locking the list of views in a spreadsheet document, this spreadsheet document will be displayed immediately on the screen. (if gourmands want to enter a text document, new columns are separated by tabs). With all due respect - be careful with dynamic lists (those that are shown in screen portions, that number of elements is not known in advance). If your nomenclature guide is composed of 100,000 positions, then you simply won’t get the correct form, otherwise your computer won’t be able to read the memory. It is necessary either to know approximately the number of elements, how to display your list, or to correctly insert the selection. So the list can be glanced over from the cob to the end. For a wild person, it’s not enough to bring up a list of over 10,000 positions for each other.
So, the list is on your screen - now you can do it. Yogo can also be saved to disk for transmission or a distant record. For the abbreviations, the wines are taken from the internal format 1C for files with extensions *. mxl. For this view, at the top right corner, select the "File" menu item, give "Save". The standard file saving dialog is prompted. You can only open such a file at the middle 1C. Moreover, this is the version of the platform. ("File" - Open - select your savings file earlier).
Practical examples:
1. The list of vidatkovy invoices, created by Ivanov's koristuvach is overruled
As we bachimo the list of documents, creations of Ivanova, we simply stand in the middle, to avenge "Ivanov" and we press on the flow of the middle. Check for a deaky hour and bachim a list of documents created by Ivanova. If so, we need not all the documents, but only two organizations (for example, IPP "Pidpriyemets" and Trade house "Complex" with a demo base). I press the main selection button, in the dialog we know the “organization” row, we select the order type “At the list” (even if we need two organizations), in the value field we press the button to select and add to the list of 2 required organizations. Pressing OK and Bachimo on the list of those who wanted to get along. We press the list. We only fill in the columns Number, Date, Amount, Organization, counterparty, and press to enter. Ready list. If we want to remember the columns of the columns ("Amount" to keep the rest), we will adjust the form of the list and "ruhaemo" I will need the column down or uphill for additional sorting arrows.
2. We can see from the list of goods in the document that all goods are needed, three of them are needed.
It is possible that we copied some document. And we need to deprive the entire list of only a few positions. Practically at the skin of the tabular part there is a prompt, which is called with the right mouse button.
Vіdkrivaєmo dialogue, choose "nomenclature" NOT from the list, but let's go to the list of goods, yakі need to be removed. Pressing OK and Bachimo list, which is made up of goods that are not necessary for us. Press the button "DEL", the list of docks will not be cleared again. Let's right-click the mouse behind the list - turn off the turn. The list has more than enough goods.
Adjustment of the parameters in the appearance in 1C 8.3 is one of the first steps, yaki you are responsible for the work, the first is the bottom line of the work in the program. The very first of them is to ensure the correctness of the work of your program, the availability of various functionalities and the rules for managing the appearance.
Starting from the version of the program 1C: Accounting 3.0.43.162, the interface has been changed to adjust the parameters in the form. So deakі parameters have become okremo.
Go to the "Administration" menu and select "Appearance parameters".
Tsei razdіl nalashtuvan is composed of six points. Let us look at some of them. All stinks are allowed to be added to the warehouse of subconto at the singing rachunkivs and subrachunkivs.
On the back, we have already set the ensign at two points, so that they do not change the redaction. Also, you can dodatkovo include vedennya for ways of appearance.
Tsya setting was so self-filled. The item “For the nomenclature” is impossible not to win, but then, for the need to improve it, edit it. The list of rahunkіv and subconto, on yakі vplyvayut qі nalashtuvannya, pointed to the little one below.
Here you can see the management of the subconto on 41.12 and 42.02 rachunkiv. Behind the minds, only a look was installed behind the warehouses. Vіn zumovleny, i vіdredaguvati mi yogo is not possible. Crimea, a Danish appearance can be carried out according to the nomenclature and MPE rates.
Tsey kind of appearance obov'yazkovo to be carried out according to the r / r. It is also recommended to administer additional insurance in 1C 8.3 to the rules of the DS for their articles for additional analytics in a managerial guise.
It is possible to lead the appearance of such a type of rozrachunkiv as with spivrobitnik in a tan, and according to the skin okremo. Qi nalashtuvannya without intermediary inject into subconto 70, 76.04 and 97.01 rachunkiv.
The appearance of vitrates obov'yazkovo is carried out for the nomenclature groups. If you have the need to prepare the soundness to be audited in the MSFZ, it is necessary to keep the appearance behind the elements and the statutes.
To go to the final package, it is necessary to go for the same hyperspace in the form parameters. Bagato nalashtuvan here next to zamovchuvannyam, but all the same you have a wide field for diy.
For all intents and purposes, it is significant that the form of salary and personnel form is carried out by this program. Well, obviously, there is your own exchange, but even though your organization has a small number of employees, then the functionality of 1C Accounting will be enough.
You will see a list of skin organization adjustments in front of you, the appearance of which is maintained by the program. Vіdkriєmo nalashtuvannya for TOV "Konfetprom".
Here you can tell how the wages in the BO are supposed to be paid, the terms are to pay, reserve the permit and as a special territorial mind.
Let's turn back and move on to other hyperpowers.
In addition, you can also change the way of ordering the list of records in documents and adjust other forms.
Allows you to create lists of vidi narahuvan and utriman. A back of the stink is already filled with deaky tributes.
Also, for whom you distribute 1C, you can enable the availability of the functionality of librarians, the entry and exit of documents. Nashtuvannya available more than ever in the database of daily organizations, de pratsyuє over 60 osib.
The rest of the setting is narrower, so that when editing, all sums will be reset automatically.
Tsei razdіl nebhіdny in order to show the ways of raznesennja witrat for payment of the cost of obov'yazykovyh insurance payments from FOP for BO's bills. The order of the settings is already fixed, but, obviously, you can correct them.
The number two remaining divided are not able to describe the sensation in a report, the shards here intuitively understood everything. The classifiers are already zapovneni and often overwrite the data without borrowing.
Let's turn back at the shape of the parameters in appearance and take a look at the points on the stitching, which were briefly lost.
Deyakі z tsih parametrіv 1C 8.3 were previously carried out at the parameters of appearance. Now stink of guilt to the okremy interface. You can also know yoga at the Golovne menu.
The shape of the lashing is shown on the little one below. Here, going through the distributions, you can adjust the allowance for income, MPE and other data.
The article continues the cycle "First steps for 1C retailers".
At the configuration on the 1C:Price platform, at the hour of displaying information, tables are most often selected, as they display different information lists. p align="justify"> A robot with such lists can be used both for the list form and for the element form (outline).
In these articles, we are aware of the possibilities of creating lists, as well as other features of creating forms on the side of the coristuvach.
At the article, there is a kernel interface in the version "Version 8.2" configuration, expanded on the platform 1C 8.3.4.482.
If you work with configurations, if you tweak this interface, then for you the information is up-to-date and for streaming versions of the platform.
If you work in the new interface "Taxi", then name some commands you have adjusted, and also the following sequence can be changed a little.
In addition, the current version of the platform has received new opportunities to look at the lists.
For elements of ceramic forms, it is possible to change the visibility and other power. For that in ceramic form in the menu Usі dії serve item Change form.
After the onslaught of the command, the command to appear at the window "Nalashtuvannya forms."
At a glance, as it turned out, for an additional tick, you can change the visibility of certain details. With this, the form is automatically scaled.
You can change the order of the details. Add a new group and place some details (elements) before it, indicating the variant of their grouping (horizontal, vertical).
Requisites that enter the warehouse of the group will be placed in the same order. In addition, for elements you can add such power, like width, height, data on the title.
You can designate requisites, which will be activated when you open the form.
An important authority is the possibility of adding new fields. We can do it through the details of the type of request.
For example, floating on the form requisites sent to the type counterparty, you can add contact person, as this requisite is present at the contractor of the Counterparty.
For consumption, you can see additional fields. Fields created in the configurator cannot be seen. Usі zroblenі koristuvannya nalashtuvannya zberіgayutsya.
To turn to standard settings at the window "Setting the form" at the menu Usі dії next select item Install standard settings.
Krym customization of forms at the ceramic interface, it is possible to customize lists (elements of documents, documents).
At the menu list form Usі dії a special team Nalashtuvati list.
Vіdkriєtsya vіkno "Adjustment to the list". At the same time, you can conduct a selection, sorting, signifying mentally formalized and grouping.
On the little one there is a form for editing the selection.
Vidbir can be carried out for kіlkom fields. For whom I have a desire for promotion, I have a pratsyuvateme for my mind. You can also vikoristovuvati mind ABO that NOT.
For the selection, think ABO (NOT) is necessary for the help of the group.
The form of designated watering sorting is presented on the little one.
It is possible to improve the grouping. For a little yak, a field for grouping has been selected counterparty.
It is presented to the chergovy little one, how to be grouped.
It is possible to complete the list in a sufficient manner, or to add other elements of the mental design (seeing in fonts, the same formatting) for a given mental design, and also to see the list of fields that are being processed.
The result of the mental design of the field by ashes is presented on the little one Suma.
If the sum is > 100,000.
The next step is to indicate that it is possible to review the achievements of the regime of the hierarchy.
The Ієєєєєєрхічный review of dovidnikіv can be made through the point Review mode on the menu Usі dії. You can choose one of the options: Hierarchical list, perelik, Tree.
It is also possible to fine-tune the grouping of elements of the docs for specific details.
For example, you can group the nomenclature of the postal worker. An example similar to that, de mi looked at the grouping of documents "Sale of goods and services" of various contractors.
It is possible to see - many times seen on the lists of distant vicons of group events (carried out, said, carried out, removed the signs of being seen).
Seeing objects in the list is hidden behind the shortcut keys Shift or ctrl.
The search for a song value in the list may be special. Poshuk works at the mode of choice. Those rows are being abandoned, as if they please the mind with a joke.
To search for the values in the current column, it is enough to position the cursor on the desired column and click on the button Know at the command panel. Show up at once, in which next press the button Know.
To advance the concretization of the request, you can win the ensign Shukati from the known.
Search for a row of data for the type of request (for example, singles of vimiruvannya) next choose the best option for the request ... (in a row).
On the other hand, we finish with lists and ways of fixing them. At the next article, we should be familiar with the interface, that is a perceptibly handy tool for informing a koristuvach, about which we have not spoken before. What is that tool? :)
To make it easier to work with a list of documents, ask, change the old look of the doc, 1C transfer the manual mechanism of the adjustment. Let's look at yoga on the butt configuration "1С:ERP Enterprise Management 2" pіd hour work zі list "Document sale".
To search for documents from the system, the selection fields have been transferred, for the help of which you can select documents from the list for the first requisites. For locking, the following fields are transferred:
Baby 1 - List Form "Document sale"
If necessary, you can add additional details for the search. For which list form you need to press the button "Che", team "Create a list".
Figure 2 - Adjustment of the list of elements of the addon
Vіdkryєtsya vіkno "Changing the List", in which case the koristuvach can add additional items for searching, sorting, adjusting the design and grouping.
Malyunok 3 – Vicna form "Changing the List"
Vіknі "Changing the List" on deposit "Vidbir" a list of available fields is displayed. To select a field, select the appropriate one from the list and press the button "Complete editing".
Figure 4 - Tab form "Vidbir"
Vidbir can be carried out for a large number of fields, from the appointed mind. For which coristuvach press the button "Group mind" that point, it is necessary for the mind to select for grouping the designations of the fields: «І», "Abo", "Hi" she pushes the button "Complete editing".
Figure 5 - Tab form "Vidbir"
Added fields are displayed on the panel of the addendum. For zastosuvannya selection, it is necessary to insert a sign and indicate the value. To turn it on, just take a badge.
Malyunok 6 - Dovidnik "Document sale"
On deposit "Sorting" You can set up more sorting of data, as it appears in the list. For example, it is possible to improve the sorting for the increase / change date.
Baby 7 - Tab Form "Sorting"
On deposit "Smarter formatting" Koristuvach can fix the formalization of the dovіdnik for singing tributes. For example, documents to the counterparty "Enigma" seen in color. Also, there is a vision of negative data, a change in the typeface, the visibility and availability of elements in the text.
Malyunok 8 - Tab Form "Smarter formatting"
As a result, the list will look like this:
Figure 9 - Displaying the list
On deposit "Group" a grouping of data is carried out, as in the list for the values of the singing field. For example, you can group documents for the counterparty, and then - for the warehouse. 1st vikonati team "Complete editing".
