The 1C: Accounting 8 program allows you to perform not only accounting operations, but is also a means of generating primary documents. Such documents include certificates of completed work, TORG-12, invoices and many others. The 1C function for printing documents in most cases suits users, but there are situations when the standard functionality of “1C: Accounting 8” clearly does not cover all the needs of the company. Such features include printing of waybill.
Bill of lading in 1c
Using the function of filling out the TTN in "1C: Accounting 3.0" DOES NOT require modification standard configurations "1C: Accounting".
Functionality filling out the consignment note connects as external printing forms and processing. This means that your ability to update 1C: Accounting software products will NOT be affected or changed.
In “1C:Accounting” in the document “Sales of goods and services”, when you select the printed form “Bill of Lading (1-T)”, the ready-made “Standard Interindustry Form No. 1-T” printed form TTN immediately opens, in which almost all the fields are filled in , except:
- Vehicle data
- Driver details (full name, driver's license)
In addition, difficult situations are possible when the consignor may not be the organization itself that issues the documents. Or there may be a situation where the payer for transportation services is not the same company that receives the cargo.
In this case, it is necessary to fill out the finished printed document “1-T” manually, as in MS Excel. In addition, a typical situation is when in 1C: Accounting you need to print some document from a previous period and see what was indicated in the TTN. But printed data is not saved in 1C. Under all these conditions, filling and printing waybill in 1C
Solution for 1C printing TTN in “1C: Accounting 3.0”
We offer you the function printing TTN (1-T), which connects to the “1C: Accounting 8” configuration and allows you not only to print the TTN from the document “Sales of goods and services”, but also to pre-specify the necessary parameters (car, driver, driver’s passport data), as well as save the information in the database. This will allow you to open the document and print it after any period of time. waybill just as it was previously printed.
And most importantly, there is no need to make changes to the 1C: Accounting 3.0 configuration
How does this work
The program “1C: Accounting 8” already has all the necessary data to indicate them when generating the printed form of TTN
Information about the car. For information about the vehicle, we use the “Fixed Assets” directory of the 1C: Accounting 8 program. In addition, along with the main asset in 1C, you can also indicate data on the registration of a vehicle with a state number.
Driver of the vehicle. For information about drivers, we use the “Individuals” directory. In addition, for an individual, you can specify information not only about the individual’s passport data, but also information about the driver’s license. We use this information to print TTN in 1C: Accounting.
In the following fields you can specify and change information:
- Counterparty. Payer of transport services
- Consignee
- Shipper
- Loading point
- Unloading point
When you click on the “Print” button, the completed printed form opens and at this moment the specified information is saved in the additional parameters of the document “Sales of goods and services”. The next time when you select the “TTN” printed form, exactly the values that were filled in will be inserted into the filling form.
You can do it yourself test the printing of the consignment note in our demo database.
To do this, you need to enter the path http://217.173.74.78:8090/AccDemo in your browser in the address bar and the web client "1C: Accounting 3.0" will load. In the list of users, select "Demo" and enter the database.
Next you go to the section "Sales" -> "Sales (acts, invoices)", open any document “Sales of goods and services” and in the “Print” menu select the “TTN” item. Fill in the fields and print TTN
If the demo database does not have enough data for you to fully test the printing of a consignment note, then you can enter any necessary information.
The essence of this method is to use the “loading into the tabular part” 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 stationery for an office consists of multi-page invoices with a large number of items.
There are software packages 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 “Download into a spreadsheet document” processing 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 Tabular 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.
One of the most frequently used documents that we prepare in the 1C: Accounting program is the delivery note. A consignment note (hereinafter referred to in the TORG-12 program) is compiled in the database for the sale of goods if an organization is engaged, for example, in trading or production activities and at the same time sells its products to counterparties (buyers). In this article, I want to clearly examine the topic of how to make a consignment note in 1C; the word make means to compile, print and provide to the counterparty (buyer).
Where is the delivery note in the 1C program?
To fill out TORG-12, you need to go to the main menu of the 1C program, section “Sales”, in the “Sales” block find the journal “Sales (acts, invoices)”. In this journal, invoices are issued.
First you need to fill out two fields in the log:
- Counterparty;
- Organization.
These fields are filled in from the directory:
- The name of the counterparty is selected from the “Counterparties” directory, if the buyer is already included in the directory, if not, then this procedure must be done first;
- The name of the organization is selected from the provided list by clicking on the arrow button located on the right side of this field.
In a journal, a delivery note can be compiled in two ways:
- When you click on the “Implementation” button, in this case a new, unfilled document will open;
- By copying an already created document, when you click on the right side of the mouse, a window will open in which we select the “Copy” option.
Do not forget that when copying an invoice, you need to appear in the journal exactly on the line where the counterparty (buyer) is indicated for which you need to draw up a new invoice.
In the photo above, this is the Eurotrade organization.
Creating a new delivery note in the 1C program
In TORG-12, all the data necessary to process the document is filled in, which is located in the header of the document and the tabular part:
- Counterparty;
- Agreement;
- Organization;
- Warehouse;
- Bank account;
- Nomenclature;
- Quantity;
- Price;
- Sum;
- VAT rate (value added tax);
- VAT amount;
- Accounting accounts;
- And others.
Creating a delivery note, function - copying in the 1C program
When using the “Copy” function, all the fields that were specified in the selected document will be filled in the copied document (TORG-12). You need to look carefully and change only those that do not match the new data.
Printing a delivery note in the 1C program
Find the “Print” button at the top of the document and click on it. We need to select the topmost line “Consignment note (TORG-12)”. A completed TORG-12 will appear on the screen.
In order to prevent mistakes, you can quickly check the entered data in the delivery note again.
If everything matches, then select the required number of copies of TORG-12 copies and click on the “Print” button. The minimum number of copies sent for printing must be at least two:
- One “To the Seller”, i.e. our organization;
- Another “Buyer”, i.e. organization of the counterparty with whom the supply contract was concluded.
What other functions are provided in the consignment note in the 1C program?
One of the convenient functions is the preparation of an invoice without closing the delivery note. To do this, find the “Invoice” position in the bottom field of the document and click on it.
Also, one of the convenient functions is to create another document based on it. When you click on this “Compose based on” button in the TORG-12 document, a list of documents that can be used appears. At the same time, the structure of subordination of documents will be preserved.
Also, it is not unimportant in the future work of the company that the program developers took into account the requirements of the tax department about the transition of organizations to electronic documents in the near future. This also applies to the delivery note. For this purpose, in the document itself, there is an “EDO” button, when clicked, the necessary list appears, this is to create, send, and view an electronic document, as well as other functions.
Hello dear readers.
The topic will be about Invoice in 1C its modification and creation of an external printed form.
In 1C Trade Management and Enterprise Accounting, the Invoice reflects the sale of goods and contains information about the goods.
In the document “Sales of goods and services” you can see what an invoice looks like in 1C.
Invoice in 1C usually means the document Sales of goods and services.
There are practically no differences between UT and BP, see the screenshot.
Invoice in 1C BP
Invoice in 1C UT 10.3
But standard printing forms do not always satisfy the company’s requirements. I often modified the printed forms of invoices and the requirements were completely different: it is necessary to display a volume and weight column, add a delivery address, divide the goods into warehouses, and someone duplicates the invoice one application from the forwarder and another from the client.
It is said that it is better not to modify printed forms, but to create new ones in the form of external printed forms.
Yesterday we were asked to create an external printed form of the invoice for UT 10.3 with the output of the weight of the goods and some differences from the standard one. This is how the customer wanted to see it
