How to display sums from tabular parts in the 1C query console in the report?

Question

1C

The implementation document has two tabular parts (goods, services), each with a different amount of goods and services, respectively. It is necessary to generate a report, the first column is the document number, the second is the sum of all lines from goods, the third is the sum of all lines from services. How can I do this in a query or in the query console?

Answer 1

Is the document held according to any registers? Getting data from tabular parts of documents is not good. But if it suits you, then group your tabular parts and get the sums. There are plenty of examples on the web.