How to generate a report based on multiple documents?

Question

1C

Dear experts in the field of 1C-development, as a beginner I ask you for help. It is required to generate a report on the movements of documents:
- receipt to the current account;
- incoming cash order;
- payment by payment card.
Provide for selection by period and by item of cash flow. Issue in the form of the following table:

This is how I see the task:
1) I create 4 documents: an agreement, receipt on a current account, a cash receipt order,
payment by payment card. The last 3 have the same details: document number, counterparty, contract, cash flow item, amount.
2) I create 2 directories for the details of the last three documents: counterparties and cash flow items. For the attribute "Agreement" I define the data type of the document "Agreements".
But then I don’t know what to do, because. so far I have never encountered creating a report based on several documents. I suspect that you need to create some kind of register (say, accumulation), where you can specify the last 3 documents as registrars. After that, on the basis of this register, generate a report through the ACS. But all my attempts so far have not yielded anything good. I don’t understand what will be as resources, and what will be in the role of measurements.

Answer 1

Judging by the description of the task, this is something unviable. Case study or interview assignment?
The decision depends on additional issues that were not covered.
1) Are all documents of the base needed as an indicator of the work of accountants (including drafts that have not been completed and marked for deletion) or only really changing cash balances?
2) One DDS article is one document, how was it implemented, or could there be 2 or more articles in the payment that need to be described in the tabular section?
For SKD, it doesn’t matter at all whether the request will combine "raw" documents or a mono-request to the accumulation register into which these documents are written during posting (but the latter option will work out faster when there are hundreds of thousands of documents in the database).
If you need a report not on documents, but on events held, this is an accumulation register with the dimensions Counterparty, Agreement and DDS Article, and the resource will contain only the Amount. In the request, use either a physical table of the register or a virtual table of turnovers with details up to the registrar.