Send this article to my email

To register the sale of goods and materials to a buyer represented as a third-party organization, the primary document Consignment Note (in the TORG-12 form) is used. In the 1C program, the consignment note is a printed form that is displayed on the basis of a document reflecting the fact of the sale of goods or the provision of services to a counterparty called Sales of goods. So, to make an invoice in 1C: Accounting 3.0, you first need to create and post a sales document.

You can enter it either from the journal of sales documents, or create it by entering it based on a receipt document or an invoice for payment.

To enter a document based on it, find the required document and select the Create based on command. The created document will be filled with data from the base document.

For simple input, go to the section Sales → Sales (acts, invoices). In the document log that opens, click Sales and select Products (invoice) or Products, services, commission from the drop-down list. For example, let's choose the second option.

A new document is created, first of all you need to fill out its header.

 Number - filled in automatically when recording a document

 The document date will be set to the current date.

 The organization on whose behalf the sale is executed

 The counterparty is selected from the directory;

 Agreement - if one valid agreement has been created for a customer in the system, then the field will be filled in automatically, if several valid ones have been created for the client, then the field must be filled in by selecting an agreement from the list;

 The Invoice for payment field is filled in automatically if the sale is entered on the basis, or this field can be filled in manually by selecting the account from the list, then the tabular part of the sale document will be filled in automatically based on the invoice data

 Shipping warehouse.

At the same time, general information about the status of mutual settlements with the selected counterparty and the type of prices valid under the agreement will be displayed.

The table indicates the list of goods sold, quantity, price, VAT rate, as well as item accounting accounts. Filling out the list of items is done either line by line using the Add command, or using the selection form. In the item selection window, we see not only the list of items entered in the directory, but we also have access to information about the remaining goods in the selected warehouse. When selecting a directory item, you will be asked to indicate the quantity. The cost will be displayed automatically according to the document price type.

If you have questions on the topic of how to make an invoice in 1c, ask them in the comments under the article, our specialists will try to answer them.

The selected items are first accumulated in the list of Selected Items, from where they need to be transferred to the tabular part of the document using the Transfer to Document command.

The transfer of containers is reflected on the Returnable containers tab; on the Services tab, only items in the item directory with the item type Services are available.

To clarify the data on signatories and delivery, which will then be reflected in printed forms, use the Signatures and Delivery links. For example, if you need to indicate the recipient of the goods and materials by proxy, change the one-time person responsible for the release of cargo, indicate the consignee different from the buyer of the goods and materials according to the sales document, etc.

Based on the posted sales document, you can enter an Invoice. This is done immediately in the open document using the Enter invoice hyperlink. The data of the new document will be filled in automatically; to view it, you can go to the document using the link that appears.

When carried out, accounting entries will be generated.

The printed form is displayed by clicking the Print button and selecting the desired form from the drop-down list. In order to make an invoice in 1C Enterprise Accounting 3.0, you need to select a Consignment Note (TOGR-12) or a Consignment Note (TOGR-12) with services.

In this article we will look at another frequently asked question by our users. It relates to a sales transaction and contains information and accounting data about the item being sold. This document - . Accordingly, we will consider the creation and reflection of an invoice in accounting.

The workflow for completing a sale is simple. Implementation documents include several types of documents and reports. This is an invoice, an invoice, a tax invoice, etc.

Today we will create an invoice.

To do this, you need to go to the main menu item "Sale" and select the item "Sale of goods and services." The magazine of the same name will open. You can achieve exactly the same result by selecting the “Sale” tab of the function panel and clicking the “Sale of goods and services” button.

The magazine "Sales of goods and services" contains sales documents in which you can print both an invoice, an act on the provision of services, and a bill of lading.

Let's create a new document by selecting the "Add" button in the journal menu or pressing the Insert button on the keyboard. As a result, the program will create a new implementation document with some default values ​​filled in.

First, we indicate the type of operation - “Sale, commission”.

Let's fill in the remaining details. We will indicate the counterparty; to which the contract with the buyer, if any, is carried out; the warehouse from which the goods are shipped. The settlement document is indicated if the appropriate options are selected in settlements with the counterparty and/or accounting policy settings.

After adding the item of the sold item, we will indicate the quantity and the program will calculate the items from the tabular section automatically. This will happen if you fill in the necessary details in the product nomenclature directory. You can read how to fill out the nomenclature directory in our article -

Don’t forget to scroll the horizontal slider of the tabular part of the document window to control and fill out all accounting parameters.

Next, we go through the bookmarks, indicate the container if necessary, check and adjust the expense accounts filled in by the program, check and fill out additional details. On the "Advanced" tab for the TTN, you can fill in the values ​​of the consignee and delivery address. On the "Print" tab, you can fill in information about the power of attorney and the details of the person receiving the goods.

We check the entered header details and the completion of the table section. If everything is correct, click the “Record” button. If we do not currently plan to print the document in physical form, then we can click the “OK” button, after which the created document will be recorded and closed.

We plan to print the invoice. Therefore, after clicking on the “Write” button and waiting for some time, which means saving the document, click the “Invoice” button in the lower menu. If you need to print documents of a different type, you can select them in the menu displayed by the "Print" button.

A printed form of the invoice is generated.

The result of the transaction can be viewed both in the journal of consumable documents and in the top menu of the document itself.

This completes the creation of the invoice.

In this article I will outline how to make changes in the configurator to automatically fill out the fields in the waybill in order to print the form without spending a lot of time.

In the configurator: Documents - Sales of Goods and Services - open the object module. Expand the required function: Function PrintTTN().
TTN is responsible for the printing form Processing.PrintTTN1208(see image no. 1).

Image #1

We find this processing. In the configurator window: Processing - Printing TTN1208 - Forms. Open the form, select the “Consignment note” tab, etc. mouse call properties. At the very bottom of the properties window, look at the name of this form. I have this name "Application4". Open the "Module" tab and expand the function "Get DataFor TTNPapplication4". See image no. 2.

Image #2

It is in this function that the changes must be registered (see images No. 3 and No. 4).
Image #3


Image No. 4

Next, we set up the properties of the graph. Go to the "Module" tab.
1. Point 5_1 - when you click on the selection button, the “Vehicle Brand” directory will open, which should be created in advance. This directory stores the names of car models, as well as their carrying capacity (see image No. 5).
Image No. 5 2. Points 6_6; 6_7; 7_7 - when you click on the selection button in these columns, the directory “Individuals” will open. This directory stores full names. managers, drivers.
Clause 11_1 - as in clause 5_1.
Point 11_2 - when you click on the selection button in this column, the directory “But” should open

The essence of this method is to use the “loading into the tabular section” processing.

In the work of a modern accountant, a lot of time is spent on operator work entering the same type of information into a database.

For example, the posting of office supplies consists of multi-page invoices with a large number of items.

There are software systems for automatic scanning and entry into the database. Their cost starts from 10,000 per year for 1 workplace.

The proposed method is free and does not require the installation of additional software packages. The example is written on the basis of 1C Enterprise 8.3 Accounting of a government agency, respectively, the account numbers are different. Otherwise, the essence and procedure are the same for other configurations and versions of platforms.

Procedure:

Scan the invoice

We recognize it in xls format.

We download from the Internet or take the processing “Download into a spreadsheet document” from the ITS disk.

If the reference books do not contain the nomenclature, which is an invoice, select processing.

If, as in this example, article numbers are indicated before the position name, write in cell C26 the formula “=PSTR(B26;FIND(" ";B26;1)+1;999)". We copy this formula to the remaining rows in column C. Next, we copy from column C to processing.

If the amounts are recognized as text, then enter the formula “=K26*1” into the empty column and also copy it for processing. If it doesn’t work out, we hammer it in with our hands.

To make it easier to fill out the tabular part, open the item card already in the database and rewrite the data that is filled in (accounting units, VAT, accounting account, etc.).

After you have filled out the tabular part of the work, press Download.

In 1C we create a document Purchase of materials.

In 1C, we create a document for purchase of materials in it, the first line of the invoice.

Go to the recognized file in xls format.

If, as in this example, article numbers are indicated before the position name, write the formula “=PSTR(B26;FIND(" ";B26;1)+1;999)” in cell C26. We copy this formula to the remaining rows in column C. Next, we copy from column C to processing.

If the amounts are recognized as text, then enter the formula “=K26*1” into the empty column and also copy it into processing

Let's go to processing, select the boot mode in Table part Next, purchase materials and select our document, I click update.

This will show us which columns to fill and how to fill them. We also copy the lines from the recognized document there: names, units of measurement, accounting account, quantity, VAT, amounts, etc. Click download.

Now we go to our document in 1c, check it against the invoice and post it.

P.S. This method is applicable for all types of documents that can be processed.

The document requirement-invoice is needed to account for the movement of valuables, write-off of inventories, and capitalization of balances and waste within the organization.

Write-off of materials for business needs

Let's look at how to make a claim invoice in the 1C:Enterprise accounting program, as well as filling it out, using the example of writing off materials for the administrative needs of a company.

To create a document, go to the “Warehouse” menu item and follow the hyperlink to the document log “Requirements-invoices”.

Fig. 1 Window of the 1C: Accounting program, menu item “Warehouse”

Fig.2 Creating a document

Pay attention to the button next to the “Create” button.

This is the Copy button. If you have to fill out documents with the same nomenclature, for example, write off gasoline every month, then you can simply copy the previous document, correcting the quantity in it.

In the form that opens, fill in the necessary details - the date of the document, the warehouse from which the materials will be written off, and using the “Selection” or “Add” button, select the item for write-off or transfer.

Fig.3 Filling in the details “Request-invoice”

Please note that if the checkbox “Cost accounts on the materials tab” is not checked, then write-off accounts are filled out on a separate tab of the document - “Cost accounts”, which are set in accordance with the accounting policies of your company.

Fig.4 Filling in details

When selecting an item (the “Selection” button), by selecting an item group in the window on the left and clicking the “Only balances” button, in the right part of the window we can see the current balances for the selected warehouse. In the “Settings” button, the “Request quantity” checkbox is checked (if not, then you can check it). In this case, when you select an item, a dialog box will appear where you enter the number of units to add to the document. The selected items will be pre-displayed at the bottom of the selection window. Then, using the “Move to Document” button, they are transferred to the tabular section.

Fig.5 Item selection window

Fig.6 Dialog box for selecting the number of items of an item

From the document, you can print the “Demand-invoice (M-11)” form and a simple printed form “Demand-invoice” by clicking the “Print” button.

Fig.7 Selecting a printing form

Fig.8 Request-waybill M-11

Fig. 9 A simple printed form of the document “Demand invoice”

Creating a “Request-invoice” document based on another document

There are many useful functions in 1C programs, one of which is document entry based on. Thus, the document we are considering can be entered on the basis of a previously executed document “Receipt (act, invoice)”. To do this, open the receipt document (from the “Purchases” section) (Fig. 10) and click the “Create based on” button. From the list, select the “Request-invoice” document and, if necessary, edit it.

Fig. 10 “1C: Accounting” program window, “Purchases” menu

Fig. 11 Document selection menu “Create based on”

Fig. 12 Document “Request-invoice” created from the document “Receipt (act, invoice)”

Creating a document “Requirement-invoice” based on other documents in production activities

Also, the “Requirement-invoice” document is available in the “Production” menu item. And if the company is engaged in production activities, then there are several more options for the design of this document, and the materials that were spent by the production workshop can also be written off through this document. Another document can be entered manually or based on the documents “Production report for a shift”, “Provision of production services”, “Sales of processing services”.

Fig. 13 Window of the “1C: Accounting” program - menu item “Production”

Let's consider creating a “Request-invoice” document based on the “Shift Production Report”.

The program provides two ways to produce finished products:

• 1 method with write-off of materials. In this case, they are filled out according to the specifications in the document “Production Report for the Shift”;
• Method 2 without writing off materials. Here materials can be written off based on the “Shift Production Report” using our document.

In our example, in accordance with the accounting policy, the formation of the cost of finished products is carried out according to the planned cost per unit of production without using account 40. In the future, we need to issue a “Request-invoice” and write off materials for the production of these products. The “Butter Bun” product was released from production and was previously capitalized with the document “Production Report for the Shift”. To create our document and write off materials in the “Production report for a shift” document, click the “Create based on” button and select the appropriate document.

Fig. 14 Creation based on “Production report for a shift”

In the “Requirement-invoice”, the tabular part was filled out in accordance with the specification for the products specified in the “Production Report for the Shift”.

Fig. 15 Completed document form

Each line indicates a “Cost Account”, to the debit of which all materials will be written off in accordance with the accounting policy of the enterprise (in our example, this is account 20.01 - “Main Production”), as well as “Nomenclature Group” and “Cost Item”. Thus, the document reflects the postings for writing off materials for production. Button “Show transactions and other document movements”:

Fig. 16 Accounting entries generated by the document “Request-invoice”

Write-off of customer-supplied materials using the “Demand-invoice”

The program provides the ability to keep records of operations for processing customer-supplied materials, i.e. materials transferred for processing by third-party customers. The document “Requirement-invoice” has a tab “Customer Materials”, which reflects the transfer of customer materials to production. They are accounted for in the off-balance sheet account 003.01 “Materials in warehouse”, and for processing they are transferred to account 003.02 “Materials transferred to production”.

Fig. 17 Document “Requirement-invoice” - tab “Customer Materials”

Thus, the “Demand-invoice” document can be considered a universal document for the write-off and transfer of materials.