1C:Enterprise 8.3. Practical Developer’s Guide. Lesson 15 (2:50). Charts of characteristic types. Report with characteristics

Report with characteristics

To polish the result, let us create a report that shows the availability of materials with certain properties. To create the report, you will use the data composition system features that provide support for characteristics (fig. 15.47).

Lesson 15 (2:50). Charts of characteristic types / Report with characteristics 
Fig. 15.47. Resulting report 

Briefly, a data set for the data composition system it retrieved by a simple query to the BalanceOfMaterials register. The platform automatically includes the material option properties to the report based on the description that you created for the MaterialOptions catalog in section Description of material option characteristics

Based on the description, the platform generates a straightforward and user-friendly interface for selecting characteristics. It also generates the required database queries based on the user-selected values.

In Designer mode

Let us proceed to report creation.

  1. Create a report configuration object named MaterialBalanceByProperty.
  2. Run the Data composition schema wizard.
  3. Add Data set – query and run the Query builder.

In 1C:Enterprise mode

Let us check the report.

  1. Start 1C:Enterprise in the debug mode.
  2. In the Inventory section, run the Material balance by property command (fig. 15.53).

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.53. Report form

    You can see that the Filter setting is available in the report form. You can use it to obtain the balance of materials based on their characteristics.

    First, let us check the availability of materials with a cross-section of 2.5 sq mm.
  3. In the Filter field, click the Select Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode button (see fig. 15.53).

    This opens the Edit filter dialog box. The list on the left contains all available report fields.
  4. Expand the Property set item (fig. 15.54).

    Note that the data composition system added all the characteristics defined for various property sets in the database (Manufacturer, Cross-section, and Color) to the standard attributes of the MaterialOptions catalog. So filtering the report by values of some characteristics is straightforward and intuitive.
  5. Select the Cross-section, sq mm field and set the condition where its value is equal to 2.5.

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.54. Creating a filter
  6. Click OK.
  7. In the report window, click Create.

    The report should look as shown in fig. 15.55.

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.55. Resulting report

    Now let us check which of the available materials are black.
  8. In the Filter field, click the Select Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode button, click the current filter condition, and click the Delete button.
  9. In the left pane, double-click the Color field.
  10. In the Value field, click the Select from list Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode button and select Black from the list of available material properties (fig. 15.56).

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.56. Creating a filter
  11. Click OK.
  12. In the report window, click Create.

    The report should look as shown in fig. 15.57.

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.57. Resulting report

    And finally, to ensure that the report functions properly, let us obtain the number of black rubber tubing units.
  13. In the Filter field, click the Select Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode button and then, in the list on the left, double-click the Material field.

    This adds another filter condition.
  14. In the Value field, click the Select from list Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode button and select Tubing, rubber from the list (fig. 15.58).

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.58. Creating a filter
  15. Click OK.
  16. In the report window, click Create.

    The report should look as shown in fig. 15.59.

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In 1C:Enterprise mode
    Fig. 15.59. Resulting report

    So you can be sure that, by using this logical design, you can perform material accounting based on any number of material properties and property values.

    It is worth mentioning that the example we have covered in this chapter is not the final solution for this configuration. We have simply demonstrated the available options. In order for your configuration to fully use material properties, you have to make appropriate changes in the remaining registers, documents, and some reports.

Query for a data set

Let us specify the query data set.

  1. Select the BalanceOfMaterials.BalanceAndTurnovers virtual table as the data source.
  2. Select the following fields from this table (fig. 15.48):
    • Material
    • PropertySet 
    • QuantityOpeningBalance
    • QuantityReceipt
    • QuantityExpense
    • QuantityClosingBalance
    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In Designer mode / Query for a data set
    Fig. 15.48. Fields selected for the query
  3. Click the Unions/Aliases tab and set the aliases for the numeric fields by removing Quantity from their names (fig. 15.49).

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In Designer mode / Query for a data set
    Fig. 15.49. Unions/aliases
  4. Click OK.

    This completes the query creation.

Resources

Let us add the resources.

  • On the Resources tab, select all available resources (fig. 15.50).

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In Designer mode / Resources
    Fig. 15.50. Data composition schema resources

Settings

Let us specify the report structure.

  1. On the Settings tab, add the <Detailed records> grouping.
  2. On the Selected fields tab, select the fields that you want displayed in the report (fig. 15.51):
    • Material
    • PropertySet
    • OpeningBalance
    • Receipt
    • Expense
    • Closing balance
    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In Designer mode / Settings
    Fig. 15.51. Report groupings and fields
  3. On the Other settings tab, set the report title to Balance of materials by property.

    To be able to test the report, let us include the Filter setting to the list of quick user settings.
  4. Click the Custom settings item properties Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In Designer mode / Settings button in the command bar at the top of the window.

    In the window that is opened you can edit the assortment of user settings for the report.
  5. Select the check box next to Filter and, in the Edit mode list, keep the default Quick access value (fig. 15.52).

    Lesson 15 (2:50). Charts of characteristic types / Report with characteristics / In Designer mode / Settings
    Fig. 15.52. Specifying user settings

    Finally, let us specify the subsystems where the report is available.
  6. Close the data composition schema wizard and then, in the editor of the MaterialBalanceByProperty report configuration object, click the Subsystems tab.
  7. Select the Accounting and Inventory check boxes.

    This completes the report creation.

Leave a Reply

Your email address will not be published. Required fields are marked *

1C:Enterprise Developer's Community