Document totals calculation

Hi!

I have a new question: when the document totals should be calculated what is the right beh * avior: to calculate it on each tabular section attribute change or during posting? For example I have a document with tabular section containing the following attributes: Item, Quantity, Price, Amount and overall Total attribute of the document.

And one more question: what if to store prices in the information register to update them all at a time? I’m not sure if it is useful feature…

Hi, Lies Susann,

You need to add a procedure for calculating totals and use it in separate OnChange event handlers for each attribute which, if changed, influences the total values.

Thank you, Xin Wang!

And what if I have a document with 10-100 thousand lines and calculate totals for each change event wouldn’t it be too slow for a user?

In standard 1C configurations(like 1C Accounting for Ukraine or 1C Trade Management for Ukraine), total amount calculates at the procedure "Before Write".

As the user will wish
If you care about performance, you can calculate totals inside OnEditEnd event handler.
You can use local variables for storing totals and decrease totals inside "BeforeRowChange"  and increase new totals inside "OnEditEnd"

Thank you! That is interesting idea to calculate overall total incrementally.