Setting up additional details and additional item information. Setting up additional details and additional information for the item 1s 8.3 check the condition for additional details

Question: Additional details, program address.

Good day.

I'm trying to figure out the additional details of the directories.
I figured out how to pull out the necessary data using a query, but something tells me that there is an easier way.
On the form for adding additional details in the “For Developers” group there is a single parameter “Name”, which indicates that using this parameter you can programmatically access the additional details.
So the question is, how is this appeal carried out?

Answer:() Thanks a lot. I'll know.

Question: Additional information about Bukh 3.0 software

how to fill in additional information programmatically
for the implementation document, the upload attribute with type Boolean was created in additional information
how to write it down programmatically

Answer:

Make such a procedure in a common server module and call it where necessary.

Procedure WriteAdditionalProperty(lxDoc, lxPropertyName, lxValue)Export lxProperty = Plans of Types of Characteristics.Additional DetailsIdetails.Find ByName(lxPropertyName); If Not ValueFilled(lxProperty) Then //the property was not found, exit //trying to report if it was called from the client mode, //then the user will see this message Report("Not found Additional attribute: " + lkPropertyName); Return; endIf; //SetPrivilegedMode(True); //status entry in the RS (this is the main one) lkSet = Information Registers.Additional Information.CreateRecordSet(); lxSet.Selection.Object.Set(lxDoc); lxSet.Selection.Property.Set(lxProperty); lkRecord = lkSet.Add(); lkRecord.Object = lkDoc; lkRecord.Property = lkProperty; lxRecord.Value = lxValue; lkSet.Write(); //SetPrivilegedMode(False); End of Procedure

Greetings, dear ones.

I’m sitting, making additions to UT11. For the directory, the nomenclature created its own additional attribute (boolean). To use it, queries become more complex - first you need to find this item among others in the “additional details” table of the item, and only then connect it to the main item table.

If you add the details directly in the configurator, the queries are not complicated, I just select “Nomenclature.MyProperties”. And I display it programmatically once in the form “When CreatedOnServer”, which leads to a common module, i.e. One line has been added to the standard form - the update does not become more hemorrhoids because of this.
otherWorksWithFormsServer.AddDocumentStatusToForm(ThisForm.Elements, ThisForm.Elements.Parent of NewElement); Actually, the idea is that if (in my case) there are a lot of modifications, there may be no need to worry about additional ones. details?

Answer: Depends on how often reports and other mechanisms that use these details are created and how convenient selection is required somewhere based on them.

Question: Location of additional details on the form

Good day. We have 1C:Enterprise 8.3 (8.3.6.2152) managed forms mode.
For the "Nomenclature" directory, the composition of additional details has been changed. On the form of a directory element, these additional details, as far as I understand, are displayed here - Group Additional Details.

Please tell me how I can place these details in the order and place I need.

Answer:

Thanks for the function, now I’ll take a closer look at it tomorrow. Regarding the question - everything is the same with the details, but there are too many of them and I want to group them into some logical groups, perhaps even on several pages.

Question: Exchange UT 11.3 -> site to Bitrix, upload additional details

Hi all.
The exchange between UT 11.3 and the site on Bitrix is ​​configured, the nomenclature with additional details (properties) is uploaded. There is one attribute with a string type of unlimited length, which stores an arbitrary description of the product. So the platform does not allow you to write more than 1024 characters in it; this is limited by the plan of types of characteristics. And it’s really necessary to store large text in additional details, and then upload it to the website. We don’t offer standard props, it does allow you to store an unlimited number of characters with subsequent uploading to the site, but it is already used. Please advise what to do?

Answer: Or add an additional register to store this text

Question: Additional props or regular props + extension.

Hello.
Let's take the new configurations of ERP, UT11, etc.
The task is to add your own details to the directory; you can do this using the standard additional details mechanism, or you can add your own details in the configurator and display it on the form using an extension.

Which is better from experience? From the point of view of subsequent updates and the use of this property in algorithms/reports.

Answer: This is only needed for reports - do additional things. props.

Question: Additional details, request

Please help me with this request.
in the directory "Acquiring terminals" there is a PM "Additional details", there are two additional details "Use" (boolean) and "End Date" (date)
those.:
EkvTherm1, Org "Horns and Hooves"
PM:
Use:true

EkvTherm2, Org "Horns and Hooves"
PM:
Use:true
End date: 06/10/2017

EkvTherm3, Org "Horns and Hooves"
PM:
End date: 06/12/2017

We need a query that looks like this:
EqTherm1 true
EqTherm2 true 06/10/2017
those. For each terminal, those with the sign to use, show the date, I’ve been trying to write a request for three days, but it doesn’t output as it should:
EqTherm1 true 06/10/2017
EqTherm2 true 06/10/2017

Here is my request:

SELECT Acquiring TerminalsAdditional Details.Link.Bank Account.Owner AS Owner, Acquiring TerminalsAdditional Details.Link AS Link, SELECT WHEN Acquiring TerminalsAdditional Details.Property.Name SIMILAR to "%Use%" THEN Acquiring TerminalsAdditional Details.Value END AS Use PUT table 1 FROM the Directory. Acquiring Terminals. Additional Details AS Acquiring TerminalsAdditional Details WHERE Acquiring TerminalsAdditional Details. Link.Remove Mark = FALSE AND Acquiring TerminalsAdditional Details.Property = &PropertyUse; //////////////////////////////////////////////// ///////////////////////////// SELECT Acquiring TerminalsAdditional Details.Link.Bank Account.Owner AS Owner, Acquiring TerminalsAdditional Details.Link AS Link, SELECT WHEN Acquiring TerminalsAdditional Details .Property.Name LIKE "%Date%" THEN Acquiring TerminalsAdditional Details.Value END AS Termination Date PUT table 2 FROM Directory.Acquiring Terminals.Additional Details AS Acquiring TerminalsAdditional Details WHERE Acquiring TerminalsAdditional Details.Link.Deletion Mark = FALSE AND Acquiring TerminalsAdditional Details.Property = &PropertyDate; //////////////////////////////////////////////// ///////////////////////////// SELECT table1.Owner AS Owner, table1.Link AS Link, table1.Use AS Use, table2 .Date of Termination AS Date of Termination FROM table1 AS table1 LEFT JOIN table2 AS table2 BY (table1.Owner = table2.Owner) ORDER BY Owner

Answer:

1s-nick said:

First, we select terminals that have the “Use” property set to true, and then we take all the rows of the additional table. details.

SELECT Acquiring TerminalsAdditional Details.Link AS Link, Acquiring TerminalsAdditional Details.Property AS Property, Acquiring TerminalsAdditional Details.Value AS Value FROM Directory.Acquiring Terminals.Additional Details AS Acquiring TerminalsAdditional Details WHERE Acquiring TerminalsAdditional Details .Link IN (SELECT Additional Details.Link FROM Directory.Acquiring Terminals.Additional Details AS Additional Details WHERE Additional Details.Property = &Property And AdditionalDetails.Value = TRUE)

It’s just not clear why you need NULL

How to add additional details to a directory element in 1C Accounting 8.3 (revision 3.0)

2016-12-07T18:20:33+00:00

It happens that we lack the capabilities already available in 1C. And you don’t always need to contact a programmer. I will tell you about one of these cases in relation to the new 1C: Accounting 8.3 (edition 3.0).

Let us not have enough fields to enter information about our counterparties. And we want to add a new field, which will be called "Status" and have one of three values ​​- "High", "Medium" and "Low". I will tell you below step by step how to add such a field without going into the configurator.

1. Go to the "Administration" section and select "General settings" ():

2. Find and check the “Additional details and information” checkbox if it is not already checked. Click the "Additional details" link:

3. In the left part of the settings window that opens, select “Account”. Click the New button on the toolbar.

4. A window for creating new details for elements of the “Counterparties” directory has opened. Enter "Status" in the Name field. Leave "Additional value" as the value type, although in the future keep in mind that other value types are possible (string, number, date, etc.). But what we need now is the additional value, since we want to provide the user with a limited choice of three options.

5. To create each option, go to the “Values” tab, click the “Create” button there, enter the name of the value (for example, “High”) and click the “Save and close” button.

6. And so on until all three values ​​are created with the names “High”, “Medium” and “Low” as shown in the figure below. Click the "Save and Close" button.

7. As you can see, the Counterparty now has the Status attribute in the list of additional details.

8. Now, if we go to any element of the counterparties directory, we will see at the very bottom of the form a new Status field ( If you don’t see it, expand the “Additional details” group collapsed on the form.):

9. In this field we can substitute one of the three values ​​we created. You can make a selection using this field in the form of a list, it can be displayed in reports, etc.

In applications of the 1C family, the user is provided with a tool with which, if necessary, you can expand the list of object fields and add new ones. The operating mechanism is available to users with full rights. Solving the problem does not require developer intervention to make changes to the standard configuration. The ideology of using functionality is similar for different products. This material will show how to use additional details in 1C.UNF.

The idea of ​​a mechanism for additional details

The existence of additional details in directories and documents is provided for by the system developers. Their difference from other fields is that these fields are implicitly present in the object until they are specified. After the declaration, work with the created fields is carried out in the usual way. The method of using the tool includes several main points:

• The user has the opportunity to specify the name of the parameter, determine its type, and whether it must be filled in;
• After making the settings, the field of the created details is displayed on the input form in a separate group, the functioning of the field depends on the settings made;
• The values ​​of the entered data can be used when building reports along with other data elements of the directory or document.

Setting up additional details

Access to the operation of creating a new object detail is provided in the “Settings / Administration / Additional details” section. The flags “Details and information with a general list of values” and “General details and information” declare the possibility of reusing created parameters and their values.

Clicking on the “Additional details” link opens an editing window, where on the left side there is a list of objects for which it is possible to expand the list of attributes. The right side of the window displays a set of user-defined characteristics of the object selected on the left side.

The 1C.UNF configuration offers more than forty directories and documents for introducing new attributes:

• Nomenclature;
• Counterparties;
• Individuals;
• Expense reports;
• Agreements;
• Income adjustments;
• Receipt invoices;
• Invoices for payment and other objects.

Having selected an editing object, to create a new attribute, use the “Add / New” or “Create” button.

The availability of buttons is determined by the flag settings in the previous step: in the case of an “individual” approach to each object in terms of creating additional fields, the “Create” button is shown on the form, but if “multiple” use of parameters and their values ​​is expected, the application will offer the “Add” button.

Features of creating props

Specification of new object parameters includes:

• Specifying a name;
• Determining the value type;
• Setting parameters that determine the availability of the parameter and mandatory input.

If a parameter is declared mandatory, the application will begin to control this aspect and will not allow the user to save an object with an empty attribute value.

The configuration offers an extensive set of data types for assigning additional details:

• Boolean values;
• String and numeric values;
• Arbitrary transfers;
• Links to the reference book;
• And other options.

As an example, the “Category” attribute of the “Transfer” type has been added to the “Property” directory element. After the settings have been made, when you open a directory item for editing, the field corresponding to the created details is located at the bottom of the form and can be filled out.

Additional details in reports

After filling in new fields with data in documents or directories, they can be used in reporting forms.

Returning to the example, let’s create the “Inventory Card” reporting form, which is created on the basis of the edited “Property” directory. On the right side of the form there are tools that provide customization according to the user's wishes. The display of a new parameter in the report is ensured by adding a new position in the “Rows” group. The “+Add line” command opens a window for selecting possible details, among which are the new details of the “Property” directory.

Additional data can also be used to filter objects. In the “Filters” settings group, the “Category” parameter can be used in the usual way to create a selection condition.

Software processing of additional details

The described actions for changing objects do not require programmer intervention. A user who has the required level of access to the objects and sufficient experience in working with the application can supplement configuration objects with the necessary parameters. The decision to use the proposed tool must be thoughtful and justified. In the case where it is intended to use the details solely for storage and display in reports, the described mechanism is best suited.

Data that is likely to require special code to be processed should not be placed in additional fields . When writing code, such data is accessed in a different way compared to standard details, has its own characteristics, and increases the labor costs of writing code. In such a situation, it is rational to contact the programmer initially and make changes to the configuration with his help.

In order to add additional details to a product (= attributes in OpenCart), click on it twice with the left mouse button, or once with the right mouse button, and select “Edit”. A card with information about the product will appear on the screen. Here you can add an image (group of images), manufacturer, material (or other characteristics and their values) and description.

Note. Before adding new details and values ​​of goods in the 1C nomenclature, you need to make sure that in the “Administration - General Settings” section the lines “Additional details” and “Sets of additional details” are active.

Rice. 1

Left-click on the item “Sets of additional details and information”. A list will open with a set of additional types. details and values. Here you can make changes to any type of item.

Rice. 2

How to add a 1C item type

In order to add a new type of item, open the section "Regulatory and reference information" - "Types of item".

Rice. 3

Click on the "Create" button - a form for filling out will open. In field " Name"enter the name of the type of additional details. Next, open the "Additional details" tab and create the necessary parameters, for example, "Country of production", "Model", "Material", etc..

Rice. 4

The values ​​of additional details, for example, "Country of production" - "Russia", are created in the product card.

Assigning additional details in the 1C product card

If item types were created after the creation of goods in the 1C item, in the product card you must click “Allow editing of object details” - “Allow editing”. Next, on the “Accounting Information” tab, select the required type of item. On the "Description" tab, the corresponding fields will appear to be filled in. Values ​​are created directly for each field.

The list of predefined directory details may not be sufficient for a specific business model. For example, we require that all items have additional props Owning division (i.e., the department ultimately responsible for a given item). Also, the directory can be added additional information . Unlike details, which are an integral part of the directory itself and are displayed directly on its form, information is stored in the information register and is accessible by a separate command from the directory position. It is better to use additional details for storing publicly available information, and additional information for information that should not be visible to everyone.
To include additional details and additional information, you need to go to the menu Master data and administration -> General settings, and check the box Additional details and information:

In the process of adding a property or information, its data type is set, and the parameters of accessibility, visibility, and mandatory are specified:

Additional details and information can be not only system data types, but also specified as arbitrary lists. In this case, the value type should be left as Additional details, and on the tab Values list a list of values ​​in strings:

From the same tree of additional details, you can add details specific to specific types of items:

But it’s more convenient to add additional details (or additional information) directly in the item type itself:

Question 1.32 of exam 1C: ERP Professional Enterprise Management 2.0. Additional details for the nomenclature are:

1. Not required
2. Required
3. Mandatory or optional to fill in (determined when creating additional details)
4. Mandatory or optional (determined by setting the item type)
5. Options 3 or 4 depending on whether this additional attribute is general

Verified. The correct answer is fifth.

Question 1.33 of exam 1C: ERP Professional Enterprise Management 2.0. Uniqueness control for additional item details:

1. Not executed
2. Defined when creating additional details
3. Determined by setting the item type
4. Options 2 or 3 depending on whether this additional attribute is general

Verified. The correct answer is the third. Uniqueness control is performed in the form of nomenclature; uniqueness in this case means unique combinations of details marked with checkmarks in the column Uniqueness control: