Delivery note content and points to note:
1. The delivery order generally consists of: customer name, delivery order number, delivery date, product name, specification, unit, quantity, unit price, amount, delivery person, signee and other fields. Delivery notes can generally be divided into single, double, triple or multiple copies.
2. If the company is the consignee, it should require the other party to stamp the company's official seal on the delivery note. The contract between the two parties should stipulate the consignee (the name should be stated in the contract, and the authorization letter from the receiving company and my signature should be provided). A mistake that is easy to make in practice is that the receiving company often does not stamp the official seal on the delivery note, but only assigns employees in the warehouse to sign for the delivery note.
3. This situation is very common, but it is risky: if Party B denies that it has received the goods in a lawsuit to collect payment, and also denies that the person who signed for the goods on the delivery note is its employee, and the labor contract between the consignee and the employee It has not been verified by the labor department or they have not signed a labor contract. Then the delivery person will not be able to prove that the person who signed the delivery note is an employee of the consignee. In the absence of other circumstantial evidence, he will have to bear the burden of proving the failure and lose the case.
2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
4. To allow the system to automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1. "Male", "Female"), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.Recommended by the editor of Huajun Software Park
excel delivery note templateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download an excel delivery note template, download it quickly. also,Warehouse entry and exit registration ledger,Student homework registration formIt is also a good form template. You are welcome to click to download and experience it.
it works
it works
it works