In 1C there are several sets of settings that determine the accounting rules in the Accounting Parameter Settings program - the very first one.
Quite often they come into the field of view of the 1C UPP database and Integrated automation, the settings in which were not thought out during implementation and, as documents accumulated, they accumulated and serious problems. Typically, this is an unfortunate result of savings on implementation. The materials presented here do not replace the work of specialists. Their task is rather to give food for thought and make your communication with a 1C specialist more substantive and responsible.
I do not plan to reprint the 1C certificate here. When you get to Accounting Settings, don’t be too lazy to click on the question in the lower right corner of the form. The basic settings are described there quite clearly.
And here we will look at a number of pitfalls, the consequences of which are not so obvious. You may come across them after a significant amount of time working in the program, when correcting them will require significant effort.
1. Where to find Accounting settings
Let's answer this classic question first. The settings are hidden in a separate interface to protect them from accidental intervention.
You need to go to the Account Manager interface. In this interface we find the Accounting Settings - Accounting Settings menu:
The settings window opens, where we will be primarily interested in pitfall No. 1:
2. Cost accounting mode
When creating a new database, 1C fills in the cost accounting mode by default. That is, Advanced Analytics is automatically installed in the Regulated Accounting version with additional analytics.
And just below we see detailed settings for batch accounting.
And here two questions arise at once:
1. What exactly is Advanced Analytics (otherwise it is also called RAUZ)? It may be better to choose traditional batch accounting.
2. What does Regulated accounting with additional analytics mean - is this RAUZ or are we talking about some other setting?
Let's start with the first question:
3. Advanced cost accounting or batch accounting
Which cat should you get out of the bag?
Advanced Analytics- is primarily important for production, since:
+ Calculate costs faster. True, this is seriously noticeable at very large volumes.
In Integrated Automation 1.1, production accounting is only possible in Advanced Analytics. In batch accounting mode, the Cost Calculation document is simply not carried out.
And an advantage for everyone: you don’t have to think about the order of entering documents within a month, since within a month even FIFO is calculated according to the average. FIFO recalculation is done at the end of the month.
There are also difficulties:
× Does not know how to reserve specific series for customer orders. The fact is that when reserving by series, the order is written directly to the batch accounting registers and reserves specific batches. But you cannot write an order to the Advanced Analytics registers. There is no such party analytics provided.
× FIFO inventory accounting is supported not up to the batch, but up to the day of receipt and the supplier. Again, the reason is simple - there is no batch document in batch analytics.
In general, this is enough, but there are companies for which it is critical to control the write-off of the cost of a specific batch. For example, medicines.
Batch accounting in the FIFO version, it is indispensable in cases where it is necessary to accurately determine the actual cost of the batch at the time of write-off. And have real-time gross profit data.
This requirement is often trading companies. But for its implementation it is necessary high level organizing the process.
At a minimum you need to:
- already at the time of the first write-off of the batch, all documents affecting its cost were entered
- do not use entry of goods movement documents retroactively.
Several times I came across more or less successful implementations of this accounting concept on 1C UPP. It works, but only when it's really needed.
The first requirement is not that difficult to implement. The second turned out to be much more difficult for our enterprises.
As a rule, only the accounting department needs to work backwards really often. But, while working in other programs, operational services manage to accumulate a large baggage of habits of doing everything retroactively. It will take a lot of administrative courage for management to break these habits.
Reports on the movement of goods and materials and costs
Cost accounting modes are fundamentally different in terms of reporting on the cost of inventories and cost accounting in production. in 1C UPP and KA 1.1, two separate sets of reports are provided for this. One for classic batch accounting, the other for advanced analytics.
With some caution, I can say that it is easier to master Advanced Analytics reports from scratch. If only because there are significantly fewer of them.
Conclusion
If you calculate the cost based on the average, then leave Advanced Analytics, don’t even think about it.
As a rule, strict control of cost during the month does not bring benefits comparable to the costs of maintaining records in such a way as to achieve this control. Therefore, you should not rush headlong into party records for his sake.
- if you have an objective, balanced need to control margins at the transaction level in real time,
- or, if it is critical for your business to reserve series of goods for customer orders and simpler means cannot be used,
then we should consider switching to batch accounting.
So, we left ROUZ in the settings. But still... the phrase Regulated accounting with additional analytics is confusing. That is, we come to the second question:
4. Advanced analytics mode
In the preset accounting settings, it is not at all obvious to an outside observer that there are options within Advanced Analytics itself. Let's do this:
1. Select the cost accounting mode Batch accounting. In the window that opens, uncheck the Use advanced cost analytics checkbox:
The warning does not scare us; the database is still empty.
2. Click on Change setting and again we see a warning about the need to resend all documents:
3. We agree and look with surprise at the following window:
Here they are - options for setting up Advanced Analytics. And these options contain very significant differences.
Read the explanations under each option carefully. Here important point. Only the last option allows us to enter management accounting data regardless of the regulated one. Technically, this is expressed in the fact that we have two separate Cost Accounting registers: regulated and managerial.
Plus a highlight - the ability to keep track of costs for projects and management departments is also expected only for the last option:
4. In my case, I will choose the last option - separate maintenance of regulated and management cost accounting. And again a warning:
We agree, indicate the start period of work in the database:
5. We finally achieve the result: changing the detailing option of Advanced Cost Analytics:
I think you can quite imagine what it costs to change the Advanced Analytics settings later. It is important to think about what settings will be needed before starting work and select the one you need right away. In a database with a large number of documents this will be much more difficult.
4. Use batch accounting
Let's look at the features of batch accounting settings:
1. Write-off of batches by document.
You are asked to make a decision: write-off of batches is carried out by the document itself or later, by separate processing. In light of all of the above, the choice of batch accounting rather than RAUZ, as a rule, is due to considerations of operational cost control. This means that a batch-by-batch document is required, writing off the batch.
But, for companies with a really large document flow, this can lead to a decrease in performance. In this case, once again it is necessary to weigh the pros and cons of such a setting.
2. Write off batches using an expense note.
This setting does not control the very fact of using the order scheme in warehouses. This possibility is always available in 1C UPP and Integrated Automation 1.1, regardless of the accounting parameters settings.
This setting controls when the cost of a batch is written off from the warehouse and posted in accounting.
The fact is that if you use expense orders without this flag, then when you register the sales document, batches with an intermediate type of operation will be written off. The batches will remain in the batch accounting registers. In accounting they will be written off to off-balance sheet accounting. And finally they will be written off only by an expense order. When will it be issued?
If the flag is set, then the batches are written off and accounting entries will be carried out only by an issue order, and Sales of goods and services will only move goods from Goods in warehouses to Goods for transfer in quantitative terms.
I will warn you that this scheme has unexpected accounting consequences. In accounting reports: SALT, account cards, the document in the posting is the document Expense voucher for goods, and not Sales of goods and services. Accountants, of course, are nervous at first. Inconvenient.
But, if the use of off-balance sheet accounts in a warehouse accounting scheme is undesirable, then such a scheme will be justified.
3. Detailed accounting.
It is proposed to introduce organizations for which management records of parties will be maintained by organization. If you have one organization, then this does not matter. If there are several, then this setting can seriously affect the write-off cost.
If organizations are not specified, then the cost of written off batches in management accounting will be determined without taking into account which organization this batch belongs to. This cost may differ from what will be written off in accounting, since it is always maintained by organization.
This option may be convenient for operational trading with internal resale. That is, during the month, managers sell goods without thinking about which organization it belongs to. At the same time, the remains of organizations are not controlled. And at the end of the month, resale documents are drawn up to equalize negative balances in regulated accounting. This is, so to speak, ineffective.
But if it is important for you to estimate the cost of goods separately for each organization, then you must indicate the organization here. Otherwise, management accounting for the cost of batches will “creep”:
That's all about the Cost Accounting Mode tab for today. Follow the following materials on Setting up accounting parameters. Don't forget to leave your comments and ask questions. And also share on social networks if you found the material useful: so that other 1C users can also see it.
Learn new things every day and change your life for the better!
Webinar recordings
Configuration "Management" manufacturing enterprise» based on the 1C platform is considered one of the largest and most difficult systems to master. It allows the company to control everything that happens business processes, on which its popularity is based. Working with it, as with any other integrated management system, is preceded by installing the software at key workplaces, where employees will subsequently reflect the state of affairs of the company in 1C UPP.
How to install 1C UPP?
Before proceeding with the installation of 1C systems, administrators must download the required version of 1C from the official website or ITS disks. To decide what exactly to download, you need to decide on the type of information base. This can be a file version or client-server. The first is suitable for companies with a small number of 1C users, the second case is the most common, since UPP is a large-scale system and is intended for large enterprises that work specifically with the client-server option.
In any case, we will need to download the 1C platform and the SCP configuration. Make sure that the platform version is suitable for the configuration release. The official website where all updates are posted is users.v8.1c.ru. To download them, you need to purchase a soft starter configuration from 1C. Please remember that only the systems you have purchased are available for download.
After downloading the necessary files, you need to install the platform. This process is quite simple and any administrator can handle it:
Then comes the turn of the archive with the configuration. The process of installing the UPP system is even simpler - you just need to unpack the archive, run the installation file and click “Next” several times. Now you can create a new UPP database and work with it after the 1C UPP has been configured.
In cases where the number of users exceeds a hundred, the installation process of 1C UPP can take weeks. If established local network and set up Active Directory, you can significantly simplify this one. This mechanism will allow you to use group policies to install software at boot account Windows. Proper configuration of this functionality will not only allow you to quickly install 1C UPP on hundreds of PCs, but will also make the life of administrators much easier.
It is worth noting that the server must be powerful enough. First, it will have to process commands from all users. And secondly, a huge load will fall on him during the initial installation of the 1C platform for all users. It is always better to have a significant reserve of power than to constantly listen to users’ complaints about 1C “brakes”.
The installation is always followed by setting up 1C UPP for your enterprise. In order to correctly set all the indicators, a thorough audit of business processes in the enterprise is necessary. Few people manage to do this without the involvement of outside professionals. Remember that mistakes at this stage can cause serious damage to further work.
The authority profile in the 1C:UPP program combines:
· Restricting access to objects, determined by the list of roles
· Access to functionality, is set by setting additional rights.
Examples of profiles:
· operator - ability to create shipping documents
· sales manager - In addition to creating documents, it is possible to change the price
· senior sales manager – ability to disable settlement control
Thus, the authority profile in 1C:UPP fully describes the user’s functionality.
For a profile, you can set the main interface, which will open by default in the user session for which the current profile is assigned. However, you can also set your own interface for each user.
Exchange of profiles in 1C:UPP
In the "Administration" submenu there are tools for exchanging profiles between databases:
· Upload profiles - allows you to upload profiles to an exchange file.
· Load profiles - allows you to load user profiles from an exchange file that was created using the "Upload" service.
Service functions
In the user profile there is useful feature copying configured additional rights to other profiles. It is convenient to use when creating several profiles. You can call the function using the "Copy" button on the command panel of additional rights. In the window that opens, you must select one or more profiles in which you want to install the same additional rights as in the current profile.
In order to see which user has installed this profile, you must click on the “Show users with current profile” button.
It is also possible to set the current profile to several users at once. To do this, in 1C:UPP you need to use processing from the “Administration” -> “Group processing of users” menu. In the window that opens, you can add users manually or using selection.
Roles in 1C:UPP
Each profile can be assigned multiple roles.
In this case, access to objects is determined by the rule: an action is allowed if it is allowed for at least one role of this profile.
There are three types of roles:
1. Mandatory. Without these roles it is impossible to work in the configuration. The only required role is "User". It is assigned by default to users of any profile.
2. Special. These roles provide users with functionality and determine access rights to directories and documents.
3. Additional. These roles determine user access to various service or regulatory configuration mechanisms.
Special roles in 1C:UPP
Shift master
The role determines the ability to enter operational production accounting documents: "Shift foreman's report", "Shift composition report" and "Shift completion".
User Administrator
Provides access to objects of the "User Administration" subsystem: directories "Users", "Profiles", setting up access at the record level and others.
Full rights
Grants full access rights to all system objects (with the exception of direct deletion from the database). This role can only be assigned to database administrators and should never be assigned to users.
Because the system does not perform any checks for this role:
· Monitoring the sufficiency of inventory items
· Control of accounts receivable level
· Control the date of prohibition of editing
· And others.
Additional roles in 1C:UPP
Administration right
Provides access to administrative functions of the system: deleting objects from the database, configuration, managing totals and others.
Administration additional forms and treatments
The role allows you to add entries to the "External Processing" directory, which stores:
· External processing of filling tabular parts
· External reports and processing
· External processing connected to reports
Administering Saved Settings
Assigned to users who need to work with saved report settings based on a universal report. That is, it determines access to delete and create entries in the “Saved Settings” information register. This role is also required to be able to add custom fields in reports built on the access control system.
External connection right
If the user will connect to the database via an external connection (web extension, connection using OLE technology), he needs to install this role.
The right to launch external reports and processing
Allows users to run reports and processing located in external files. This feature should only be provided to responsible users.
Additional user rightsth
Allow document posting without control of settlements
This option affects the visibility of the "Disable settlement control" flag in the "Sales of goods and services" document. Typically, ordinary employees are prohibited from shipping inventory items if the terms of mutual settlements are not met, but for management users this should be possible.
Directory "Users" in 1C:UPP
The directory stores users working with the system. Elements of this directory are indicated in all documents in the “Responsible” field.
There is a classification of users into groups. Moreover, there are two types of groups.
1. The first ones affect the hierarchy in the “Users” directory and are used primarily for ease of navigation through the directory. In this case, each directory entry belongs to one parent group.
2. Also exists directory "User groups", which is designed to restrict access at the record level. In this case, one user can be a member of several user groups. User inclusion in groups is ensured through the menu item “Users” -> “User Groups”.
Figure 1 - Directory "User groups"
Record-level access restrictions
The mechanism of line-by-line data access control is used when it is necessary to organize access only to certain elements. This mechanism is often called RLS. For example, each sales manager works with his own group of clients. The user is prohibited from viewing documents for clients not in his own group. This problem is solved by restricting access at the record level.
Access restriction at the record level is configured for the "User Groups" directory. If a user is a member of several groups, then the data areas that will be available to him are combined. For example, for the group "MSK" data is available for the organization "MebelStroyKomplekt", and for the group "Southern Federal District MSK" - for the organization "Southern Federal District MebelStroyKomplekt". Then if the user is assigned to both groups, he will enter documents on behalf of both organizations.
Enabling restrictions at the record level can be done from the "Account Manager" interface, main menu "Access at the record level" -> "Options". Here you can configure which directories you want to use to configure the restriction.
RLS is directly configured using the access rights configuration form. You can open the form from the main menu "Access at the record level" -> "Access settings". You can also call the access control form from directories for which RLS can be configured.
Within the same user group, restrictions are combined using the logical "AND" condition. For example, for the group "MSK" access is configured for the organization "MebelStroyKomplekt", and for the access group of counterparties of counterparties "Buyer". Then users of this group will be able to enter documents only on behalf of “MebelStroyKomplekt”, and only for counterparties included in the “Buyer” access group.
If a user is a member of several groups, then his rights at the record level are combined across all groups. That is, the rights of different groups are summarized using the logical “OR” condition. For example, the “MSK” group has access to documents only from the “MebelStroyKomplekt” organization, and the “Complex Trading House” group. If both groups are assigned to a user, he will have access to documents from both organizations.
Record-level access restrictions apply only to specified directories. For example, in the figure, access to organizations and external processing is defined for the “MSK” user group. For all other directories, the "MSK" user group has full access at the "RLS" level. In order to access the group settings, you need to open the form using the context menu or the F2 key.
In the form of the directory element "User groups" it is indicated for which types of objects RLS will be applied, as well as the number of configured rules. It is also possible to change the composition of the group: include or exclude users from it.
If no rules are specified for any type of object, this means that there will be no access to the elements of this directory at all. For example, in the figure for the "MSK" group there is not a single row for the "External Processing" object. This means that external processing will not be available for the user of the "MSK" group. However, if the user is a member of two groups: “MSK” and “Trading House”, then all external processing will be available to him, both for reading and writing. Because the user group "Trading House" has not been assigned access restrictions to external processing.
Figure 2 - Processing to restrict access at the record level
Performance
Please note that if you enable the record-level access restriction mechanism, the system may slow down. This is due to the implementation of the RLS mechanism: a condition is inserted into each request sent to the database, where the corresponding rights are checked. Thus, each database access is a little slower, and the load on the server increases.
It is also important that the more groups a user belongs to, the slower the system will work in his session. Therefore, to increase speed, first of all, it is recommended to reduce the number of groups to which the user belongs.
Roles for which RLS is not configured
When configuring record-level access restrictions, be aware that some roles do not have RLS configured.
· The Full Rights role has full access to all objects without record-level restrictions.
· For the "Planning" role, it is possible to read (view) all objects without RLS restrictions.
· The "Financier" role allows the opening of many objects without checking access at the record level.
Therefore, when configuring a user's permission profile, be aware that adding one of these three roles may remove RLS restrictions. For example, a sales manager is configured to restrict access by organization: the user has access to data only for the MebelStroyKomplekt organization. If you add the “Financier” role to the user’s permissions profile in addition to the “Sales Manager” role, then the employee will see documents for all organizations in the “Counterparty Documents” journal.
Access control by levels in 1C:UPP - organizations, divisions, individuals
Setting up access for the directories "Organizations", "Divisions", "Division of Organizations"
The peculiarity of the "Organizations" directory is that it is not hierarchical. However, determining subordination in it is possible using the “Parent organization” attribute.
The directories "Divisions" and "Divisions of Organizations" are distinguished by the fact that a hierarchy of elements is organized in it. This means that any element of the directory can have subordinate divisions. In this case, all records are equal, that is, there is no division into groups and elements.
The features listed above mean that the value of the “Type of inheritance” attribute can be filled with either the value “Extend to subordinates” or “Only for the current element”.
The following restrictions are possible in reference books:
· Reading – determines the ability to view data in the “Organizations” directory, generate reports, as well as documents for the selected company
· Record – sets the ability to create and edit documents for the selected organization
Report on the rights system in 1C:UPP
To view configured user rights, it is convenient to use the “Rights System Report”.
The report displays the following data:
· By access restriction settings at the record level by user group
· Additional user rights by profile
·By user groups
· By user permission profiles
The report on the rights system was developed using the “Data Composition System”, so its flexible configuration is possible.
Figure 3 - Report on the rights system
View permissions by role
In order to find out which roles have access to certain objects, you need to use the configurator. In the “General” -> “Roles” branch, you can view the rights configured for each role.
If there is a need to get a pivot table in which objects will be displayed in the rows and roles in the columns, then you need to use the context menu for the root object “Roles”.
Thank you!
To set the technological parameters of the information base, use the form Setting up the program . Let's consider all its sections.
Contains the title of our database window. If the user does not specify his option, the name of the configuration and the revision number of the application used will be displayed. Also on this tab you can see the configuration version number.
e "Residue control" checkbox indicates whether or not to use the accumulation register Available balances. If you check the box, this register will display summary data of the accumulation registers Goods in warehouses, Retail goods, Goods on reserve in warehouses, Goods for transfer from warehouses.
Serves to set the register usage flag Products of organizations, which contains current information about inventory balances in the context of accounting accounts and tax assignments.
Note . If you use this register, it is worth remembering that own goods enterprises and goods acceptedon commission,must be taken into account on different nomenclature cardsor different series(characteristics) of one cardAnd.
Note . At use V organizations deferred carrying out , carrying out e documents will form minimum kit accounting records , necessary For operational work . Other accounting records document ( V in particular , necessary For summing up results completed months ) necessary With form processing Follow-up documents .
. It contains parameters for routine tasks if the application is used in file mode. To do this, you should register a virtual user of the infobase, give him full access rights, and monitor his constant connection to the infobase.
"CRM» (“Customer and Supplier Relationship Management”) contains:
- Interval reminder checks in seconds - availability check interval entries to remind users.
- Setting up templates for “quick” registration of a new counterparty - allows "quick o » register new counterparty from the document Event .
For settings email used rsection. It is possible to use the email client built into the configuration or the main client operating system. In the first case, you need to set up an account administrator to change the accounts of all users.
01.04.2016
Item accounting accounts
In 1C UPP, two equivalent methods are used for setting item accounts: the information register “Item Accounting Accounts” and using the document “Setting Item Accounting Parameters”. The thing about using these two methods is that they cannot work together. In the default settings, the recommended option is the document “Setting item accounting parameters”. When this setting option is used, the product
The 1C UPP program recognizes accounting accounts only during document posting, so the accounts in the document tables will be hidden. It is possible to independently define accounting accounts; otherwise, the program will take them from the document “Setting item accounting parameters.”
To change the method of setting up item accounts, you must do the following: 1C UPP open the following path “Enterprise” - “Products” - “Item Accounts”. According to this setting, invoices will be installed after selecting the item and will be displayed in the document table.
In the register, you need to create a list of item accounting accounts that are inserted into configuration documents. Each register cell contains information about the accounts of material and production resources used in economic transactions: purchase, sale, transfer, etc. Accounting accounts can be assigned for each item separately or for a group, for each warehouse or warehouse type. Information about the accounts of any item in the item can be obtained in the Nomenclature directory in the Accounts section.
The program independently creates an extra entry in the register that is not associated with any group. This is necessary to automatically insert item accounting accounts into a document if you create a new group in the Nomenclature directory, but do not assign an entry for it in the accounting accounts register. The settings of this group are similar to the “Products” group.
For the convenience of keeping records in one database for several organizations with the same item, it is possible to specify different accounting accounts. This is suitable when different companies apply different operations to the same type of product. You can apply settings to these positions by setting inventory accounts for each company.
Accounts for settlements with counterparties
To enter the corresponding section, open the following menu “Enterprise” – “Accounts for settlements with counterparties”.
This section is used to register accounts for settlements with counterparties, which are automatically used in various configuration documents.
It is also possible to assign account data to a specific company, counterparty or their group, as well as for an individual agreement or type of settlement.
Information on the accounts of a counterparty or agreement can be obtained in the directory “Counterparties” (“Go” – “Accounts for accounting settlements with counterparties”).
The program independently generates the records necessary for inserting accounting accounts into documents if you have not created records for the counterparty or agreement.