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.
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.
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.
Useful
Useful
Useful