Tips for using foreign trade purchasing documents
Foreign trade procurement follow-upHow to fill it out?
1. According to the business process, it can be divided into three categories: front-end tracking, mid-range tracking and full-range tracking.
a) Prompt tracking means following the export goods until they are delivered to the designated export warehouse;
b) Mid-range tracking refers to following up until shipment and customs clearance;
c) Full follow-up means following the payment until the payment is received and the contract is fulfilled.
2. According to the product category, it can be divided into textile follow-up, clothing follow-up, footwear follow-up, toy follow-up, furniture follow-up, etc.
3. According to the nature of the enterprise, it can be divided into follow-up orders for production-oriented enterprises and follow-up orders for trading enterprises.
4. According to specific business links, it can be divided into transportation follow-up, raw material follow-up, packaging follow-up, outsourcing follow-up, production follow-up, and sample follow-up.
5. According to the flow of goods, it can be divided into export documentary and import documentary.
2. You can see many ready-made formats in [Table Style]. You can directly click on any style you like.
3. Then select the area range, which is the data source. Select the default to only apply the table style.
4. You can also set conditional formatting for specific data in the table. For example, if you want to mark data with an amount greater than 2,000 yuan, you can select [Data]--[Conditional Formatting]--select greater than 2000 as the condition, and mark the result in red. Select OK to see the effect.
5. If the amount of highlighted data is relatively large, you can use the [data bar] of conditional formatting to display it. In this way, you can see who has more and who has less by looking at the color in the cell.
6. When you select a cell with the mouse, the color of the cell will become different from other cells. You can choose it at the bottom of the table. The color can also be adjusted according to your own preferences. There is a sun mark for eye protection mode, which can also be changed at any time.
7. When a lot of content is entered in the cell, the text on the edit bar will display multiple lines, which will block the cell content below the edit bar. You can see a small triangle in the middle below the edit bar, which is the "edit box collapse" function. The content of the edit bar is folded to facilitate reading and editing of the cells.
Foreign trade procurement follow-upIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download foreign trade procurement documents, please download it quickly. In addition,Purchase, sale and inventory management table,Graduation thesis design registration formIt is also a good form template. You are welcome to click to download and experience it.
Useful
Useful
Useful