1s 8.2 how to change the landscape print format. Publications
How to add a stamp, signature and logo to the printed form of an invoice for payment to the buyer (for 1C: Accounting 8.3, edition 3.0)
2018-07-27T09:42:51+00:00Organizations often ask to embed a logo and a seal with a signature directly into the invoice for payment to the buyer. This makes the account look more solid and representative. Facsimile printing on an invoice is not prohibited by regulations and therefore many people take advantage of this opportunity.
Today I will tell you how to make a similar setup for 1C: Accounting 8.3 (edition 3.0) yourself, without the help of a programmer.
We customize the seal, signature and logo
So, go to the “Main” section and select the “Organizations” item:
Open the card of our organization and expand the “Logo and seal” item:
Immediately after this we will be asked to indicate the picture that we want to use as our logo. You need to prepare a file with such a picture in advance (order it from the designer) or find something suitable on the Internet.
For our experiments, I took the 1C company logo:
In general, any image in formats (png, jpg, bmp) will do.
The logo was inserted into the field and displayed on the form, great!
We will take care of the production of fax stamps and signatures. To do this, click on the item “Instructions “How to create a fax signature and seal””:
Let's print and follow the instructions indicated on the printed sheet:
After that, we will have at our disposal 3 pictures in one of the formats (png, jpg, bmp) with a stamp and signatures, in my case they look like this:
We see that pictures with stamps and signatures have been substituted and displayed on the form. Click the “Record and close” button in the organization card:
Please note the change in BP version 3.0.64.34. About him .Finally, go to some invoice for payment to the buyer and click the “Print” -> “Invoice for payment (with stamp and signatures)” button:
A printed form of the invoice with a logo, seal and signatures has appeared:
If the pictures with the seal and signatures are too small, rescan the sheet with a higher resolution.
We're great, that's all it seems
But what if we want the seal to fit over the signature?
Not everyone needs this, and apparently that’s why 1C by default made an option with a separate location for the signature and seal.
For those who need to combine them, instructions are below.
We combine the seal and signature of the manager
To do this, go to any account and create a regular printed form (without stamps and signatures):
It will turn out like this:
Then we cut off along the bold line at the bottom (before the signatures and seal) and scan the bottom part and save it as a picture on the desktop.
I got it like this (the stamp and signature are fictitious):
Again, go to the organization’s card, section “Logo and Printing”.
Here we delete the pictures with the signatures of the manager and accountant, and instead of the old seal picture, we upload the large picture we just made, combining the seal and signatures:
Click the “Record and close” button in the organization’s card, and then create a printed form of any invoice along with a seal and signatures:
In the printed form that opens, from the “More” item, select the “Change layout...” command:
In the layout that opens, go almost to the very bottom (about the 90th line) and select the invisible square below the inscription “manager”:
Our task is to drag this square a little higher (determined experimentally) than the inscription head and stretch it across the entire width of the printing form, like this:
Don't change anything else! Click the "Record and close" button, the printed invoice form will be reformatted automatically:
Exactly what we wanted happened - the seal climbed onto the signature.
Well done again
By the way, for new lessons...
Change in BP version 3.0.64.34
Now, having set up a signature and seal in the organization, we still must select the “Invoice for payment” item in the invoice, and in the printed form itself, check the “Signature and seal” checkbox:
You only need to install it once. Its value is saved between calls to the print form.
Addition from a site reader. If there was an invoice form - field
will not appear with a checkbox - it is necessary
Let's look at how documents are printed from 1C applications running in service mode (via the Internet).
Both in the local version of the application and in the service, the same document can be printed in different versions. For example, an invoice can be printed, both in the form of a regulated invoice (TORG-12), and, in fact, in the form of an invoice (for the internal needs of the organization). Therefore, before you start printing a document, you should select the desired type of printing in the document form. This can be done from the drop down menu Seal(as shown in Fig. 1 using an example application "1C: Managing our company").
Rice. 1.
Start printing
In some applications (for example, "1C: Accounting 8"), if only one printing form is provided for a document, then you can start printing in one click (in this case, instead of the menu Seal a button with the name of a single printable form is displayed).
Rice. 2. Printing documents with a single printing form
Since printing documents in service mode starts in a browser window, you should pay attention to the following printing features.
- Print confirmation usually needs to be done two times: first in the 1C:Enterprise print form, and then in the corresponding browser form (Fig. 3).
- The user's ability to edit printed form layouts in service mode is limited. If you want to use your own printable (for example, with your company logo placed on it), you can do this by downloading a standard printable from the service, editing it in the local version of the application and uploading it back to the service (more information about using custom printables forms you will find).
Rice. 3.
Printed form of the document
The interface of document printing forms is different in different browsers. Therefore, if you use more than one browser to work in the service, be prepared for the fact that the usual printing procedure will vary slightly, depending on the browser used and its version. For example, the Google Chrome browser offers in an additional dialog box displayed immediately before printing to preview and set print settings (Fig. 4).
Rice. 4. Print a document in the Google Chrome browser
If you want to use your own printed form (for example, with a logo placed on it), you can do this by downloading a standard printing form from the service, editing it in the local version of the application and uploading it back to the service (for more detailed information on using custom printed forms, see you will find).
Printing order
We present the general sequence of actions when printing documents (Fig. 5).
- Start printing by clicking the corresponding button on the document toolbar and selecting the desired printing form from the menu (see Fig. 1).
- In the printed form that opens, determine the available parameters (for example, the number of copies).
Rice. 5. Sequence of actions when printing
- If necessary, edit the text in printed form. To do this, double-click on the desired cell of the form and change the text in it (Fig. 6).
Rice. 6.
Editing a Printable Form
- If you want to save the finished printed form of the document to a file on your local computer, click the button Save in printed form (see Fig. 3), select in the dialog box that opens Saving a Printable Form desired file format by checking the box next to it and click the button Save c (Fig. 7).
Note: You can specify several formats at the same time - in this case, several files with the corresponding extensions will be created.
Rice. 7.
If desired, save the file in the desired format
- Click the button Seal in the printing form window (see Fig. 3).
- In the browser print window that opens, if necessary, select print options (printer, etc.) and click the button Seal again (Fig. 8).
As a result, the document will be printed on the printer.
Rice. 8.
Start printing using the browser system dialog (using Internet Explorer)
Answers to frequently asked questions
1. What is the printing method? Which printing method is better to choose?
The printing method is selected in the 1C:Enterprise settings, available by command Main menu / Tools / Options(Fig. 9).
Rice. 9. Main menu 1C
Parameter Printing method(Fig. 10) determines the degree of user influence on the document layout:
- PDF- printing without changing margins and scale;
- HTML- When printing, margins and scale may be changed.
Rice. 10. Selecting a printing method (recommended PDF )
2. How do I configure print settings?
Settings for 1C:Enterprise printing parameters are available in document form using the command (Fig. 11).
Rice. eleven. Selecting Page Options
Since web browsers have their own print settings, it is necessary that they match the mentioned spreadsheet document breakdown page settings. Browser print page settings can be edited in the dialog Page settings(Fig. 12), which in Microsoft Internet Explorer, Mozilla Firefox and Apple Safari is called by the browser menu command: File/Page Settings...(File/Page Setup...). This setting is not provided for the Google Chrome web browser.
Rice. 12. Selecting page options in the browser
3. Is it possible to preview a document before printing?
To ensure that your spreadsheet document will print correctly, you can use the print preview.
- When using the web browsers Microsoft Internet Explorer, Apple Safari and Mozilla Firefox (in most versions), the preview is opened with the browser menu command: File/Preview(File/Print Preview).
- For the Google Chrome web browser, preview is performed by default immediately before printing (see Figure 4 above).
Typical printing errors
1. What should I do if, when printing, a page appears on the printer with errors?
Check what quality Printing method(Main menu / Tools / Page options) option selected PDF. Then, if the errors are not resolved, check that the 1C:Enterprise print settings are selected correctly ( Main Menu / File / Page Setup- these settings must be called from the window with the printed form of the document, as shown in Fig. 11) and browser print settings (Fig. 12), which are available when you select the command File/Page Settings.
2. What should I do if, instead of printing on a printer, I am offered to save to a PDF file?
In some browsers, if there are no connected printers, the default mode is to print to a PDF file. If this happens, check that the printer is connected and installed correctly in the operating system.
You will find additional information about printing in the article on the ITS website.
We wish you pleasant work!
Colleagues!
We continue the topic of creating reports in 1C. Recently, our client had a problem transferring documentation from 1C 8.3.
Entering additional information into a printed form, numbering print sheets, indicating the date, time and user who issued the report.
We discussed a similar example in configuration 8.2 in the previous release. Now we will look at the print settings, which allow us to do all this in configuration 8.3.
Moreover, much of this is automated in 8.3.
So how can you incorporate the above information into your print? What should be done in this case?
We offer our review of options; perhaps it will also be useful to you.
Option 1. Directly from the printed form of the generated report or document:
Create a printed invoice form for payment and call it through Ch. menu – Table – Printing settings – Header and footer and configure as needed.
This is done once for any FORMED printing form.
Setting up header and footer fields
Pay attention to the icons in the upper left corner of the form:
These are in order: page number, number of pages, date and time. Position your mouse at the desired location in the header or footer and click on the desired icon. After clicking on the button. OK, when printed, this data will be displayed in the printed form where you indicated.
Option 2. Configured for any printing (reports, documents, certificates) from the program
If you do not want to manually configure headers and footers each time, you can use the Administration – Header and Footer Settings section to configure the general appearance of headers and footers for printing.
It looks like this:
There are more options for displaying information in printed forms: the “Report Name” and “User” data is added. This is exactly our case.
Selecting data for the header and footer is carried out as described in option 1, only instead of icons we select the text buttons “Time”, “Date”, “Report Name”, etc. But the essence does not change. After specifying the required information in the required places on the form, the setting is saved.
When the printed form is printed, all specified data will be displayed in it.
Option 3: Edit the layout in custom mode
Why am I considering this method here, which has its own functionality and which, strictly speaking, does not relate to the topic under consideration.
Because it often happens that you have to use a combination of this method and print settings to achieve the desired result. Editing the layouts of printed forms allows us to draw some things we need right in the layout of this printed form.
Layouts can be changed in the Administration – Printed forms, reports, processing – Printed form layouts section.
Here is an example of editing the layout of an Order Invoice (document Invoice for payment to the buyer):
We select a layout, indicating at the entrance that we will edit it and add some text information at the end.
For example, like this:
Save the changes and create the printable form.
And we print with the changes.
But the possibilities for such editing are limited.)
So option 3 is convenient to use for entering constant, unchangeable information; everything else will require modification of the printed form by a programmer.
But often this is enough. 🙂
Knowing how to change a printer in 1C, as well as knowing various ways to connect and configure printers, helps speed up printing and improve the level of customer service.
How to connect a printer
The printing device is connected in two stages:
- To connect a printing device to a PC, connect them using a wire and install a driver that matches the model of the printing device, PC OS and version 1C. To print from a remote server, you need to install a universal driver on the server and on the local machine, and open the printer itself for network access.
- After the printing device is displayed on the PC, you need to connect it to the 1C program. To do this, launch the program, add a new device and enter the basic printer parameters in the appropriate fields. When printing remotely, you will have to select the desired printer manually each time.
How to change and configure a printer
If several printers are connected to the PC, then 1C: Enterprise will use the one specified in the default settings. But only until the user selects another printer when setting up printing of a document. After this, the program will focus on the last choice. You can change the printing device in "Page Setup" when setting the document's print settings.
The most problematic issue when printing is the discrepancy between the label sizes. How to adjust the document size?
- Specify the label dimensions in 1C: File menu, and then Page Options.
- Find printers in the Control Panel, select the bar printer and call its context menu. In Print Server Properties, create a form with label sizes. In the future, when printing from 1C, select this form.
These are the basic settings for a printing device in 1C. The remaining settings vary depending on the program version - 1C 8.3 or 1C 7.7. If difficulties arise, we recommend contacting specialists to debug the program.
It’s no secret that, although nowadays more and more companies are switching to electronic document management, the old saying “Without paper, you...” does not lose its relevance. It so happens that for some reason the inspection authorities are primarily interested in paper documents. Therefore, if you actively use the 1C: Accounting or Enterprise program for financial control, it is important to know how to print an electronic document created using the program.
Printed forms in 1C allow you to transform an electronic document into a printed version.
For this, the developer has provided an excellent tool - Print Designer. With its help, you can create documents in which you can specify any data you need, and not just a few standard forms. This is especially true for those documents that do not have a strictly regulated form, which cannot be changed under any circumstances. This, in particular, may include an act of completion of work, some invoices or payments.
In this guide, we propose to understand the capabilities of the Print Designer, consider what types of printing forms there can be and how they differ from each other. We will also show with an example how to print the created form.
First, it’s worth understanding what, in general, a printed form is in 1C 8. This is a 1C spreadsheet template (like Excel), in which some variable rows are specified, filled with data from the program when drawing up a document.
Printing forms come in two types:
- Internal (built-in). They are stored in the program configuration, so it is better not to change them, as problems may arise later during the update.
- External - stored separately from the program settings. And with their help, you can create and prepare for printing a document of almost any complexity, without affecting the configuration of the 1C 8 program.
How to choose already prepared layouts? After you carry out an incoming or outgoing operation, for example, writing out a report of completed work, you click the “Print” button to print the documents. The list displays a list of printable forms that are already filled with entered data about the transaction performed and your company. By clicking the type of document you need, you open a preview window so you can make sure the data you filled in is correct. The print button prints the document to the printer.
With the basics out of the way, let's figure out where all your printables are stored. Let's move on to the next question.
Where are printed forms stored?
You can view the built-in printed forms both in the configurator mode and in the normal enterprise mode. In the first case, you need to click the corresponding button in the start window when starting the program. You will see the program menu, find the “Sales of Products and Services” branch, which contains the “Layouts” item. It often contains only two items - “Invoice” and “Act”. Where is everyone else then, since the list is much more extensive? They're just hiding somewhere else. You need to open the “General” - “General Layouts” branch, almost all layouts are stored in it.
In the second case, you need to go to the menu section “Administration” - “Print forms, reports and processing” - “Layouts of printed forms”. It will display all document layouts. It is noteworthy that they can be edited in the same menu.
As for external forms, you first need to either create them through the configurator mode, or by downloading a ready-made file, and then connect them to the “Administration” menu - “Printed forms, reports and processing” - “Additional reports and processing”. We'll talk about this a little later.
Creating a simple form using the built-in Print Designer
Such a printed form does not imply the possibility of deep editing, since this will entail a change in the program configuration, as well as further difficulties when updating it. However, if you are completely satisfied with the standard form or want to delve into the intricacies of creating an external form, this method is completely suitable for you.
- First of all, launch into the Configurator mode, find the document you need, for example, Sales of Products and Services, in the document properties go to Actions - Designers - Print Designer.
- When prompted for a work option, select Regular Forms.
- Give the new layout a name, for example, “Print Invoice.”
- Select the details that you would like to see in the header of the document. Moreover, they must be selected in the order in which they will be displayed. To select, you need to highlight the item in the left column with the cursor and press the arrow in the middle of the screen so that the details appear in the right column.
- Mark the details to be displayed in the table section. The selection of details follows the same principle as in the previous paragraph.
- In the same way, select the details of the lower part of the document.
- At the final stage of creation, select whether you want to print immediately without preview, whether you need to protect the table, and then confirm the creation of the form with the OK button.
Creating an external printing form
Forms created through the Print Designer can be compared to a visual software editor, when you do not enter all the code manually, but only compose it from the proposed elements. The external form is a file with manually written program code, which describes the procedure for displaying data on the screen. This is what allows you to edit the printed form however you like, specifying absolutely any data in any sequence.
An additional advantage is that, even if you do not understand or simply do not want to understand the intricacies of 1C 8 programming, you can entrust this procedure to professionals. They will be able to prepare the required form for you and provide it to you as a ready-made file, which you can only activate with a few clicks of a button.
Now let's talk more about the procedure itself. Let's look at the example of creating an “Invoice” layout for the document “Sales (acts, invoices)”.
- Open the 1C 8 program in Configurator mode.
- Click File - New - External Processing, give it a name (it should not include spaces), then click Actions - Open Object Module.
- In the input field that opens, enter the following code (values that can be changed to your own are highlighted in yellow):
Function InformationOnExternalProcessing() Export
Registration Parameters = New Structure;
ArrayDestinations = New Array;
Array of Assignments.Add("Document.Sales of Goods and Services"); //Specify the document for which we are making an external print. form
Registration Parameters.Insert("View", "PrintForm"); //maybe - PrintableForm, Filling Object, Additional Report, Creating Related Objects...
Registration Parameters.Insert("Destination", Array of Destination);
Registration Parameters.Insert("Name", "Order for sale of goods"); //name under which the processing will be registered in the directory of external processing
Registration Parameters.Insert("SafeMode", FALSE);
Registration Parameters.Insert("Version", "1.0");
Registration Options.Insert("Information", "This printable form was created as a sample");
CommandTable = GetCommandTable();
AddCommand(CommandTable, "External Order", "ExternalOrder", "CallServerMethod", True, "MXL Print");
Registration Parameters.Insert("Commands", CommandTable);
ReturnRegistrationParameters;
EndFunction // Information ABOUT External Processing()
Function GetTableCommand()
Commands = New ValueTable;
Commands.Columns.Add("View", New TypeDescription("Row"));//what the description of the printing form will look like for the user
Commands.Columns.Add("Identifier", New TypeDescription("String")); //print form layout name
Commands.Columns.Add("Usage", NewTypeDescription("Row")); //Call ServerMethod
Commands.Columns.Add("ShowAlert", NewTypeDescription("Boolean"));
Commands.Columns.Add("Modifier", NewTypeDescription("Row"));
Return Team;
EndFunction
Procedure AddCommand(CommandTable, View, Identifier, Usage, ShowAlert = False, Modifier = "")
NewCommand = CommandTable.Add();
NewCommand.View = View;
NewCommand.Identifier = Identifier;
NewCommand.Use = Use;
NewCommand.ShowAlert = ShowAlert;
NewCommand.Modifier = Modifier;
End of Procedure
- Save the layout for printing as a file in any folder on your hard drive, name it appropriately.
Insert into the same document the procedure for starting printing from the program menu (commands highlighted in yellow must match the line):
Add Command(Table of Commands, “External Order”, “External Order”):
Procedure Print(Array of Objects, Collection of PrintForms, PrintObjects, Output Parameters) Export
Print Management.Output TabularDocumentIntoCollection(
Collection of Printing Forms,
"External order"
"External order"
GeneratePrintForm(ArrayofObjects, PrintObjects);
EndProcedure // Print()
- Insert a layout for filling out the printed form by clicking on the name of the external form in the lower left corner and selecting “Layouts” - “Add” - “Spreadsheet Document”, give it a name. After that, fill out the spreadsheet with the required data. For example:
- Order for product No. [Realization Number] from [Realization Date] - right-click - Properties - Layout - Filling - Template.
- Create the columns that you want to appear in your document.
- Select the entered cells, click Table - Names - Assign a name - enter the name “Header”.
- Copy the row with the table headers, select them, right-click - Properties - Layout - Filling - Parameter.
- Select a line and name it, for example, “StringTCH”.
- Create a footer: write Total, the cell in which the total amount should be displayed, name it TotalTotal, select “Parameters” in the properties.
- Specify the person responsible, and in the cell properties for displaying the last name, specify “Parameters”.
- Select the bottom rows and name the range "Footer".
- Now in the input window, enter the function for generating a printed form:
Function GeneratePrintForm(LinkToDocument, PrintObjects)
TabularDocument = New TabularDocument;
TabularDocument.Name of Print Parameters = “PRINT_PARAMETERS_Invoice for Payment to VRTU”;
Processing Layout = GetLayout("Payment InvoiceExternal");
//fill the header
AreaHeader = ProcessingLayout.GetArea("Header");
AreaHeader.Parameters.DocumentNumber = LinkToDocument.Number;
AreaHeader.Parameters.DocumentDate = LinkToDocument.Date;
AreaHeader.Parameters.OrganizationName = LinkToDocument.Organization.Name;
//output the header in a spreadsheet document
TabularDocument.Output(HeaderArea);
//fill in the PM lines
RowArea = ProcessingLayout.GetArea("ROW");
For Each Current Line From Document Link.Products Cycle
FillPropertyValues(RowArea.Parameters, CurrentRow);
TabularDocument.Output(RowArea);
EndCycle;
//fill the basement
AreaFooter = ProcessingLayout.GetArea("Footer");
AreaFooter.Parameters.QuantityTotal = LinkToDocument.Products.Total("Quantity");
AreaFooter.Parameters.AmountTotal = LinkToDocument.Products.Total("Amount");
AreaFooter.Parameters.ResponsibleName = LinkToDocument.Manager.Name;
//output the footer to a spreadsheet document
TabularDocument.Output(AreaFooter);
TabularDocument.AutoScale = True;
return TabularDocument;
EndFunction
- Save your changes to the document.
- Now you need to activate the created form. For this:
- Go to “Administration” - “Printed forms, reports and processing” - “Additional reports and processing”.
- Click the “Create” button, select the external form file in Explorer, confirm your entry with the “Save and Close” button.
- To check, go to Sales - Sales (acts, invoices), click the “Print” button, select your form and check that it is filled out correctly.
- Print the document if necessary.
Conclusion
We looked at an example of creating a printable form through the Print Designer and through the tool for creating external forms. We hope everything works out for you. Leave your questions in the comments.