To avoid editing each row of a document's tabular section manually, you can change the value of an entire column with a single action — using the "Change selected" command. This is a standard mechanism of 1C:Accounting for Kazakhstan: you select the required rows or column, invoke the command, and set a single value for all selected rows at once.
How to do it
Select the required column (or rows) in the document's tabular section, right-click, and in the context menu that opens, choose "Change selected". This lets you set a single value for all selected rows at once, without filling them in individually.
Step-by-step procedure
- Open the document and go to its tabular section (for example, "Goods", "Services", "Materials").
- Select the rows in which you need to change the value. To select several consecutive rows, hold down the Shift key; to select rows selectively — hold Ctrl and click on the required ones. To select the entire tabular section, you can press Ctrl+A while in the list of rows.
- Right-click the selected rows and choose "Change selected" in the context menu.
- In the window that opens, specify the attribute (column) whose value you need to change — for example, the VAT rate, warehouse, item group, accounting account, unit of measure.
- Set the new attribute value and confirm the change.
- Check the result: the value should apply to all selected rows.
In which documents it is convenient to use
The technique works the same in most documents with a tabular section, where the same value is repeated across many rows. The command is most often needed when:
- you need to set the same warehouse or department in all rows;
- a single VAT rate is required across the entire tabular section of a sales or receipt document;
- you need to set the same accounting account, cost item, or item group;
- a single unit of measure or one price type is specified for all items.
The set of attributes that can be changed depends on the specific document and its tabular section: the system will offer a choice from the columns available in that table.
Why this is more convenient than manual entry
- Time savings. With dozens and hundreds of rows, manually filling in each cell takes a lot of time and is tiring.
- Fewer errors. A single value is entered the same way in all rows, so typos and inconsistency across the column are eliminated.
- Uniformity of accounting. The same accounting accounts, warehouses, and rates across the entire tabular section reduce the risk of incorrect reflection in postings and reporting.
What to pay attention to
- The command will change the value only in the selected rows. If you do not select all rows, some data will remain unchanged — before confirming, make sure the required range is selected.
- After a bulk change, some related indicators (for example, VAT amounts, document totals) may require recalculation. Check that the document's total amounts have been updated correctly.
- If some rows should keep a different value, do not select them — either first make the bulk change and then correct individual rows manually.
- Changing an attribute in a posted document may require reposting so that the new data gets into the registers and postings.
- The appearance of the context menu and the set of attributes available for change may differ depending on the configuration version and interface settings.
Common mistakes
- Selected the wrong rows. The value was applied in bulk to unnecessary items. If this happens, undo the action or manually restore the required values before reposting the document.
- Forgot to repost the document. The data in the tabular section has been changed, but the postings and registers remained with the old values.
- Did not check totals and VAT. After changing the VAT rate or price, the document's total amounts were not reconciled with the source data.
- Changed the wrong attribute. In the "Change selected" window, a column with a similar name was selected — before confirming, check that you are changing exactly the required attribute.
What to check
- Whether all the required rows were selected before invoking the command.
- Whether the attribute (column) was chosen correctly and the new value was entered.
- Whether the document totals and VAT amounts were recalculated after the change.
- Whether the document was posted (reposted) so that the changes are reflected in accounting.
- Whether the accounting accounts, warehouse, and rates match the source documents' data and the organization's accounting policy.
The "Change selected" command is a simple and safe way to speed up filling in tabular sections in 1C:Accounting for Kazakhstan. The main thing is to carefully select rows, check the chosen attribute, and after a bulk edit, monitor the totals and the correctness of document posting.