Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > Sum of the amount in the table

Forum

Search UsersRules
Sum of the amount in the table
#1
Active user
Points:: 0
Joined:: Oct 15, 2024

I create Document InvoiceExchange, create DocumentForm. See screenshot 6.1. Total in InvoiceExchange
I want Field Total in Footer is sum of the amount in the InvoiceListDetail table.
For example, the total should be 30 = 10 +20. See screenshot 6.2. Total in InvoiceExchange
How to do that?

Profile
#2
Administrator
Points:: 0
Joined:: Oct 3, 2019

Dear Gigha,

take a look at the screenshots below please. It is quite easy to implement.

Profile
#3
Active user
Points:: 0
Joined:: Oct 15, 2024

Thank you, it works

Profile
#4
Active user
Points:: 0
Joined:: Oct 15, 2024

I need the Total field in the footer of the ListForm. I opened FooterDataPath, but I can't find TotalTersedia. Is there another way to do this?

Profile
#5
Administrator
Points:: 0
Joined:: Oct 3, 2019

Hello!

It is impossible to implement what you want through the settings, but it can be done using program code.

But - I strongly advise you not to do this, this is the wrong approach to work!

The fact is that the document list form is a dynamic list, and if you add code to the program that will receive the totals for documents, then this code will be called every time the user does something with this list: scroll, set filters, etc.

This will negatively affect the performance of the program interface. Simply put - the interface will immediately start to "slow down".

Therefore, if you need to see the totals for some documents, then the system has reports for this.

Profile
Subscribe
Users browsing this topic (guests: 7, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.