o(╥﹏╥)oSad

WeChat cannot downloadSales issue order, but just click on the upper right corner and select open in browser or Safari!
Sales issue order

Sales issue order

The sales outbound order is a voucher for merchants to transfer goods to each other in order to facilitate reconciliation and settlement. The free download of the sales issue order Excel template is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free download of the sales issue order download template, please pay attention to Huajun Software Park.

Tips for using sales outbound orders

Sales outgoing orderHow to fill it out?
      (1) Check the order. When reviewing the goods delivery voucher, attention should be paid to reviewing the contents of the goods delivery note or deployment order, paying special attention to whether there are any traces of alteration.
      (2) Log in. For outbound goods that have been verified correctly, the warehouse goods accountant can register the items listed on the voucher.
      (3) Distribution. The custodian will review the delivery voucher, and after confirming that it is correct, distribute the goods according to the listed items and labels. When sorting goods, the principles of "first in, first out", "perishable first out" and "broken items cannot be put out" should be followed.
      (4) Packaging. When goods leave the warehouse, it is often necessary to assemble, reinforce or repack the goods, which all involve packaging of the goods.
      (5) Awaiting shipment. After packaging is completed, the warehouse goods that have been reviewed by the reviewer need to be gathered at the tally location and go through the handover formalities with the tallyman. After review, the tallyman signs or stamps the outgoing form; then fills in the cargo waybill and notifies the transportation department to pick up the goods and ship them.
      (6) Review. Review the title, seal, and date of the goods delivery voucher to see if they meet the requirements. Goods that do not meet the requirements after review should be stopped from being shipped.
      (7) Delivery. After the warehouse delivery personnel have prepared all the goods and verified that they are correct, they must hand over the goods individually to the picker or transporter in person, clarify responsibilities, and go through the handover procedures.
      (8) Write off accounts. After the above delivery operations are completed, the inventory on the custody account and card needs to be written off to ensure that the account, card, and goods are consistent.

General skills for sales outbound orders
​ ​ 1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
​ ​ 2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
​ ​ 4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, sum the corresponding area of the C2:C5 cell.
Recommended by the editor of Huajun Software Park

Sales issue orderIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the sales outbound order, please download it quickly. In addition,Contract management registration form,Express delivery and receipt registration formIt is also a good form template. You are welcome to click to download and experience it.

Version: Free version | Update time: 2024-10-31

Similar recommendations

Latest updates

Sales issue note comments

  • 1st floor Huajun netizen 2022-01-12 02:41:23
    Free download of sales delivery note, good experience
  • 2nd floor Huajun netizen 2021-10-06 18:48:17
    The sales order template is very comprehensive, thank you!
  • 3rd floor Huajun netizen 2022-01-21 12:18:43
    General template for sales outbound orders, very practical

Recommended products

everyonealso likeThese:

+

This application has not passed real-name authentication. You can download it through the mobile assistant.

CancelOK