Which is the best software to print out the warehouse list, and it is best to be able to change the

You can use label printing software, after designing the shipping label in the label printing software, if it does not meet the needs, you can customize and modify it according to your own needs, and the relevant operations can be referred to:

First of all, the label content on the shipping label should be added according to the packing information, and the information of the boxed product is as follows:

1. Open the label making software, first set the label paper size in the paper wizard according to the actual size of the label paper, we use 1 row and 1 column of 80*70 label paper, the width and height of the paper is 82*70mm, and the left and right margins are 1mm.

2. Add fixed content in the shipping label The so-called fixed content refers to the fixed content on the label paper, such as the column name of the first row in the first picture in this article, which is the fixed content, and the fixed content can be added by "manual input" when adding. Here's how:

3. Add variable content in the shipping label.

1. Import the shipping information table Click "Database Settings" in the upper toolbar to import the shipping information excel sheet into the label making software. (For the specific import method, please refer to How to Use Excel to Print Barcode Labels in Batches, which will not be described in detail here.) ）

2. Draw the normal text in the appropriate position on the newly created label paper in the early stage, and then use the database import method to add various variable content.

3. Add a barcode from the product information to see that there is a barcode, in the label making software, you can click on the left barcode icon, first draw a barcode on the label paper, the content of the addition method is the same as above, or use the database import method to add.

At this point, all the information on the shipping label has been added and all other label contents in Excel are automatically generated in batches.

If there is no problem with the preview, you can click the printer icon in the upper left corner to open the print settings, page numbers, start and end page numbers, and then directly connect to the printer to print.

Print out of the warehouse list software, can also be statistics in and out of the list details and summary, out of the single grid can be modified according to their own requirements, for different users can choose different out of the single printing format for printing, out of the warehouse, sales order printing software has been applied to various industries for use.

Are you now walking out of the A4 after printing? If so, add a paper type to the printer properties, 210 91, and then select this paper by default. Give it a try, and I don't know if it's the problem.

This can be achieved by setting up the software to print the outbound list.

The specific steps are available on the office equipment forum or the four seas**!

The key is that you provide the format. It's not difficult at all just to print, but if you want to print and store data at the same time, you need to use macros.

There are many templates, outbound orders, warehousing orders, delivery orders, and sales lists come with more than 100 templates, as long as you modify the header, you can use two equal parts, three equal parts.

Support automatic summing of amounts, automatic uppercase of amounts.

Statements are issued by customer.

The outbound list printing template generally needs to be done with professional software, and excel can also be used, but there is no statistical function.

You can sell a single printing software, this can be tried, there are many templates that come with it, and you can also count it.

You can design the format of the document. It's quite convenient to print the sales slip.

Just use an excel to make one

In Basic Settings - Document Settings - Document Format Settings - Inventory Management - Other Outbound Orders - Printing, you can modify the template.

(2) Open the UFIDA ERP-U8 enterprise portal, financial accounting - general ledger - setting - options - account book - voucher, and modify the number of foreign currency amount vouchers to the same number as **;

It is recommended that you add a custom paper format (mm) to the printer and then use it in the application.

1. Let different types of data be displayed in different colors.

In the salary table, if you want the total salary greater than or equal to 2000 yuan to be displayed in "red", the total salary greater than or equal to 1500 yuan to be displayed in "blue", the total salary less than 1000 yuan to be displayed in "brown", and the others to be displayed in "black", we can set it like this.

1.Open the Payroll Workbook, select the column of Gross Payroll, and execute the Format Conditional Formatting command to open the Conditional Formatting dialog box. Click the drop-down button to the right of the second box, check the "Greater than or equal to" option, and enter the value "2000" in the following box.

Click the Format button to open the Format Cells dialog box, and set the Color of the Font to Red.

2.Press the "Add" button and set the other conditions as above (greater than or equal to 1500, the font is set to "blue"; Less than 1000, the font is set to "brown").

3.Once the setup is complete, press the "OK" button.

Take a look at the payroll to see if the total salary data is displayed in different colors as you request.

2. Create a category drop-down list to fill in the items.

We often have to enter the name of the enterprise into **, in order to maintain the consistency of the name, we use the "Data Validity" function to build a classification drop-down list to fill in the item.

1.In Sheet2, enter the company name into different columns by category (e.g., "industrial enterprise", "commercial enterprise", "individual enterprise", etc.) to create a business name database.

2.Select column A (the column where the name of "Industrial Enterprise" is located), enter the character "Industrial Enterprise" in the "Name" column, and press "Enter" to confirm.

Following the above operation, b, c ......The columns are named "Commercial Enterprise", "Individual Enterprise", ......

3.Switch to Sheet1, select the column for which you want to enter Enterprise Category (for example, Column C), and run the Data Validity command to open the Data Validity dialog box. In the "Settings" tab, click the drop-down button to the right of "Allow", check the "Sequence" option, and in the "**" box below, enter "Industrial Enterprise", "Commercial Enterprise", "Individual Enterprise" ......Sequence (with commas separating the elements) to determine the exit.

Then select the column for which you want to enter the enterprise name (for example, column D), open the Data Validity dialog box, select the Sequence option, and enter the formula: =indirect(c1) in the ** box to exit.

4.Select any cell in column C (for example, C4), click the drop-down button on the right, and select the corresponding Enterprise Category to fill in the cell. Then select the cell in column D corresponding to the cell (for example, D4), click the drop-down button, and then you can select the required enterprise name from the list of enterprise names of the corresponding category and fill in the cell.

If it is a simple report, assuming that you already have data available for printing, automatic pagination is a function of the system to be automatically implemented when printing, without special settings, mainly to say how to achieve fixed content, in the "page settings", there are two pages related to this, "header and footer" is used to set the title, date, page number, signature and other content, and the top title row in the "worksheet" is used to set the title of each page repeatedly.

Document customization in the system tool.

If you want to print, you need to set up the set.

It depends on whether you are buying the professional version or not, if you are in the professional version, you --- all programs in the start menu - Kingdee KIS Professional Edition - System Tools - Custom Documents.

First of all, you need to set: unit price, quantity, and amount.

Biaofeng delivery note printing software free version You can try it, support delivery order, outbound order, inbound order, very easy to use.

The latest version is divided by industry, there are electronic industry delivery order, delivery order, furniture industry delivery order, delivery order, delivery order, delivery order, delivery order, food industry delivery order, delivery order, delivery order, delivery order, delivery order, and commonly used set template.

Custom templates are supported.

Support printed document printing.

Support continuous printing paper, blank printing paper, printing delivery note, delivery note, delivery order, outbound order, inbound order.

The total amount is supported, and the amount is automatically capitalized.

Automatic document number (automatic document number) is supported

The software supports issuing statements according to customers, monthly, weekly, and yearly, how many goods and how much amount are taken and they come out at a check.

Support exporting the statement to Excel and printing it according to your needs.

Support printing, bills, checks, etc.