How to manage the warehouse out of the warehouse, how to do the warehouse on the computer to do the

The outbound management process business department issues an outbound order, indicates the information on the document, checks the physical details of the outbound goods, and then hands over the procedures. Warehousing management process: The purchasing department places an order, so that after the purchase is fixed by sales and the order is entered, the purchasing department notifies the supplier of the delivery time and notifies the warehouse in time.

1. In order to make it convenient for the goods to enter and exit the warehouse and easy to move in the warehouse, the basic condition is to store the goods facing the channel.

2. Stack as high as possible to improve storage efficiency.

3. The effective use of the library content should be stacked as high as possible, in order to prevent damage and ensure safety, scaffolding and other storage equipment should be used as much as possible.

Handling of warehousing and warehousing:

Goods acceptance: the use of a special party inventory system for management, procurement personnel to buy back the company's goods, should be notified in time to the material management personnel. For goods that require special professional acceptance, the person in charge of the relevant department or designated personnel must also be notified to participate in the acceptance and sign.

The material management personnel are responsible for the acceptance of the quantity, and the personnel of the use department are responsible for the acceptance of the quality and the preservation of relevant technical data. The acceptance of the goods can only begin after the acceptance personnel are all in place (if they are on a business trip, they can be replaced by their designated personnel). The supplier's delivery note must be signed by the above personnel and the delivery person.

If the acceptance personnel find that the purchased materials are inconsistent with the contract and cannot be used, the quality of the materials is unqualified and the quantity is inconsistent with the contract, the receiving personnel shall not go through the acceptance procedures.

Filling in the warehousing documents: the delivery personnel will bring the material arrival list and invoice and other information to the material accounting office for relevant procedures after passing the acceptance and signing. Material accounting fills in the quantity of the warehousing order according to the actual arrival quantity, and fills in the warehousing order amount according to the contract amount or the detailed unit price (no contract).

You can use the excel software installed in the computer system to make an excel file of outbound and warehousing, and then enter the corresponding data and formulas respectively according to different items and the date of warehousing, and the specific production method is as follows:

1. Open the excel file on the computer, and enter the header of the file first, such as the registration form of a certain company.

2. Then enter the serial number, item name, date, previous balance, current inventory and other information in the cell below.

3. Then enter the name of the item, the balance data of the previous period and other basic information.

4. Then enter the formula = (C6+E6+G6+I6+K6+M6)-(D6+F6+H6+J6+L6) in the cell below the current inventory, which means that the current inventory is equal to the balance of the previous period plus the daily warehousing number and then subtract the daily outbound number, so as to automatically calculate the daily inventory balance.

5. At this time, you can enter according to the actual inbound and outbound numbers. The system will automatically calculate the inventory balance for the current day.

6. Place the mouse in the cell below the current inventory, and pull down the calculation formula, then other items will also be automatically calculated according to the setting of the formula.

The warehouse outbound and warehousing management is as follows:

Warehousing process:

1. When placing an order, the purchasing department should carefully review the inventory quantity and make sure that the purchase is determined by sales.

2. When the purchasing department reviews the order, it should verify the number of purchases according to the actual situation of the company, so as to prevent the occurrence of inventory backlog and unsalable.

3. After the order is entered, the purchasing department shall determine the delivery and arrival time of the factory, and notify the warehouse in time.

4. When the goods arrive at the warehouse from the manufacturer, the receiver must strictly and carefully check whether the outer packaging of the goods is in good condition. The consignee must refuse to receive the goods and report to the purchasing department in a timely manner; If the consignee fails to inspect the goods in time, the damage and lack of original packaging shall be borne by the consignee.

5. After confirming that the outer packaging of the goods is intact, the consignee must verify the name, grade, quantity, specification, amount, and unit price of the purchased goods in accordance with the relevant documents: orders and accompanying goods, and only after verifying that they are correct can they be stored in the warehouse; If the documents do not match the physical goods, they should be reported to the procurement personnel in time; If the purchased goods are not checked and put into storage, and the goods and bills do not match, the consignee shall bear the losses caused by the letter stool sales.

6. In the process of handling, the warehousing goods should be handled according to the identification on the outer packaging of the goods; When stacking, it should be carried out in accordance with the warehouse stacking distance requirements and the principle of first-in-first-out. If the operation is not carried out in accordance with the regulations, the consignee shall be responsible for the damage to the goods caused by it.

7. The details of the warehousing goods must be checked and signed by the consignee and the warehouse management personnel to ensure that the accounts and goods are consistent. After the goods are accepted, the warehouse manager.

According to the acceptance form, keep accounts in a timely manner, and record the name, quantity, specification, warehousing time, document number, acceptance situation, inventory unit, etc. of the goods in detail, so that the accounts and goods are consistent. If the acceptance is not carried out in accordance with the system, the economic loss caused by the warehouse manager shall be borne by the warehouse manager.

8. When the documents are circulated according to the receipt process, each link shall not exceed one working day.

The outbound process of the product

1. The sales department issues a delivery order or a transfer order, or the purchasing department issues a return order. The document should indicate the place of origin, specifications, quantity, etc.

3. After receiving the above documents, the warehouse must carefully check the accuracy and correctness of the physical details of the outbound goods, so as to sign and approve the delivery, otherwise the economic losses caused shall be borne by the parties.

4. The responsibility of the person in charge of the physical object and the carrier should be clearly distinguished, and the two sides should carefully check the name, quantity, specification and other aspects of the goods out of the warehouse when the goods are out of the warehouse, as well as the intact outer packaging, and complete the handover procedures. If the cargo is damaged after leaving the warehouse, the responsibility shall be borne by the carrier.

5. After the goods are out of the warehouse, the warehouse administrator will write off the account and count the balance of the goods according to the official delivery voucher on the same day, so that the accounts are consistent with the sliding.

6. When the documents are circulated according to the shipping process, each link shall not exceed one working day.

Warehouse out of the warehouse management is a very important work in modern enterprise management, management suggestions are as follows:

1. Establish a sound warehouse management system: Establish a complete warehouse management system, including warehousing process, outbound process and inventory management. The system should clearly define the classification, numbering, marking and storage location of the inventory, so that it can be quickly found and identified during the management process.

And all personnel must operate in accordance with the system to ensure the standardization and standardization of work.

2. Storage according to inventory classification: Classification and storage are carried out according to the nature and characteristics of the items. For example, perishables can be placed in a cool and ventilated place, sun-facing items can be placed in a shaded area, and hazardous items such as chemicals and paints need to be specially stored.

At the same time, different storage equipment and tools are required for different types of items.

3. Fine management of inventory: Warehouse management should be accurate to the quantity, type and quality of each item, and update the information in time to ensure that the inventory quantity is accurate, and there will be no problems such as loss and overflow during inventory. At the same time, it is necessary to regularly evaluate and analyze inventory, and adjust the inventory scale and location in a timely manner according to the sales situation and inventory usage.

4. Strengthen the outbound approval system: establish an outbound approval system, and items of different natures must be reviewed by different departments or leaders before they can be shipped out of the warehouse. Only outbound requests that have been strictly approved can be shipped outbound.

At the same time, all outbound operations should be recorded, including information such as outbound time, item name, quantity, and recipient, so as to facilitate future tracking.

5. Comprehensive use of modern management means: for the management of the warehouse can be with the help of modern management means, such as the use of barcode, RFID and other intelligent technology to manage the inbound and outbound information, the use of management software to assist in the management and control of inventory and network-based cargo tracking management, etc., these measures can improve the accuracy of information, reduce the error rate, improve the efficiency of the enterprise and reduce costs.

The benefits of warehouse outbound and warehousing management

Warehouse outbound and warehousing management helps to optimize inventory management, reduce inventory costs, improve the controllability and turnover rate of inventory management, ensure the safety of inventory, improve customer service quality, provide accurate and timely inventory data for enterprises, and provide reference and basis for management decision-making. Improving efficiency and enhancing management control is also conducive to improving the organizational efficiency and customer service level, laying a good foundation for the long-term development of the enterprise.