Tips for using the warehouse item requisition registration form
Warehouse item requisition registration formHow to fill it out?
Product shipment: sales shipment or other shipments, the shipment order number can be automatically generated, and different shipping methods such as normal shipment and gift shipment can be distinguished;
Inventory management: When entering and exiting the warehouse, the inventory quantity of the product is recorded for easy query;
Inventory management: Users can inventory the warehouse at any time and automatically generate inventory documents, making the inventory work convenient and fast.
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 let the system 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")) The "C2" in the formula represents the cell where the ID number is entered.
Warehouse item requisition registration formIt is a very practical form, and most of the forms to be filled in are for general purposes. If you happen to need to download the warehouse item collection registration form, download it quickly. In addition,Work Injury Report Form,Business trip application formIt is also a good form template. You are welcome to click to download and experience it.





















Useful
Useful
Useful