Original: XXX company-SAP-based inventory management system solution

 

 

 

 

XXX company-SAP-Based Inventory Management System

 

Solution

 

 

Version: v0.3.0

Excel_cortan

File status: [] Draft [] Official release [√] Modifying	File ID:
	Current version:	V0.3
	Author:	Excel_cortana
	Completion date:	2014-2-7

 

Modify resume

Version	Revision Date	Modify content	Author
V0.0.1	2013-11-9	Draft	Excel_cortana
V0.0.2		Add System	Excel_cortana

 

 

Project Overview

In the entire logistics distribution center, the plan is a nerve hub that controls almost all business activities of the entire logistics system's core departments, such as procurement, production, warehousing, and stores. Therefore, the accuracy of the procurement plan and production plan is of vital significance to the entire distribution center. Inaccurate plans may result in: Inventory squeeze, product decay, and decommission; out-of-stock stores, customer complaints, urgent procurement, increased procurement costs, high inventory costs, and a large inventory profit, increased labor intensity and reduced employee satisfaction;

The premise of an accurate plan is that there must be accurate inventory. Due to the temporary replenishment, goods adjustment and reduction of the store, goods can be obtained at any time during production, natural loss of dishes, and employee's work mistakes; temporary price adjustment for procurement; and other reasons may cause problems in our receiving, sending, and storing business, and eventually cause inconsistency of our accounts, cards, and things;

We hope to achieve the following through this project:

• Optimize and improve the existing paper inventory card loading and unloading methods, improve the efficiency of staff card loading and unloading, improve efficiency 6-7 times;
• Using workbooks, the system automatically calculates the inventory, eliminating the error of manually adding or subtracting the inventory from the database management, and completely eliminating it;
• Through the automatic comparison between the inventory management adjusted store order and the store order adjusted by the account, it is found that, even if the account is used to find the cause, the system effectively avoids incorrect changes to the number of stores that require goods due to misoperations;
• By means of a list of differences between the electronic inventory card and the SAP system inventory card every day, the system promptly helps the database management and account to find the cause of the difference, and even if the problem is rectified; effectively ensures the consistency of the card account
• The system automatically generates the top 10 most frequently imported products, or the top 10 most frequently imported products, or the top 10 products with the largest number of warehouse receiving and warehouse picking and randomly generated 10 products are used to generate inventory card spot check lists from time to time. The Warehouse Supervisor and Warehouse Manager conduct regular or irregular random spot checks, to effectively guarantee the consistency of the card;
• By spot checks on the daily card account difference and irregular card content, you can promptly locate and solve the problem, effectively avoiding the inventory loss and inventory profit ratio when the chassis is in the middle of the month.
• By performing spot checks on daily card account differences and irregular card content, you can promptly locate and solve problems, effectively improving the inventory accuracy of the SAP system.
• All database management data is stored in and out of all system databases. Data will never be lost through effective data backup methods. This prevents important data loss problems caused by improper storage of paper inventory cards;
• All data is shared. The planning, finance, Regional Assistant, warehouse Warehouse Supervisor and logistics manager of the new factory can access the Internet either in the office or in the dormitory, you can always learn about the different items and quantity of different items in the inventory card of the warehouse department and the SAP system, the result of spot check on the inventory card of each warehouse supervisor, and the inventory and warehouse receiving details of the items on the current inventory card.
• The electronic inventory card system can help the ledger management to identify the day when the SAP Inventory is different from the electronic inventory, and can see the reason why the inventory is incorrect. For example, if an SAP system has not been written into the database, or the employee's meals are not delivered out of the warehouse; this helps the account to discover problems existing in the warehouse receiving and receiving process, and avoids the SAP system inventory inaccuracy caused by the account's own errors;

Project Background

• The on-board and off-board time of the inventory card. In theory, the inventory card should be an action to make and import materials on the inventory card when the materials are stored in or removed from the stock space;
• Inventory card filling efficiency issues. For a single item, if there is a store for goods on the day, there are warehouse receiving, there is a processing room for use, there is a Jiaozuo store for goods. Similar operations such as viewing documents, viewing inventory card directories, finding a single item, and filling in data are required three to four times.
• Accuracy of inventory card filling. Whether it is the root database, leaf dish database, frozen database, or raw material database, when the Warehouse Management sends the goods to a store, it is necessary to promptly mark whether the goods have been delivered, or the actual number of goods delivered on the contract, due to the writing environment problems, the handwriting clarity cannot be ensured. As a result, when the inventory card is made after delivery, the entered handwriting is not clearly identified or the input is incorrect;
• Inventory card day Settlement Calculation Problem: Due to the day's settlement = yesterday's settlement + today's warehouse receiving-today's warehouse picking quantity, if a single item has five stores asking for goods on the day, this calculation is the result of addition and subtraction of the seven numbers. If you use a calculator manually, it is difficult to ensure the accuracy of the calculation by multiple checks;
• It is difficult for the paper inventory card to effectively differentiate the intentional modification of historical data by the database management. When the database management finds problems by itself, it may intentionally modify the historical data, if the filling errors caused by individual reasons during Warehouse Management's on-board or off-board operations are modified after discovery, they cannot be distinguished; it is not conducive to finding out the cause of inventory discrepancy;
• The paper inventory card cannot or is difficult to find the differences between the paper inventory card and the SAP system's book inventory in a timely manner. It is important to find the differences between the paper inventory card and the SAP system. problems cannot be found in time and corrected in time.
• During spot checks on inventory cards, the warehouse supervisor can only make random spot checks, the items that are prone to errors cannot be found for spot checks (for example, the items with the highest frequency of warehouse receiving, the items with the largest warehouse receiving amount, and the items with the largest number of warehouse receiving and warehouse picking );
• The paper inventory card cannot be used for data sharing. Due to the limitation of the office environment, the finance or plan of the new factory can only be viewed in the on-site warehouse if you want to view the inventory of the old factory.
• The paper inventory card is not convenient for Financial reconciliation. When a half-month or monthly disk finds a difference, you can only look through the historical documents for search, and it is time-consuming and laborious to query.
• Improper storage of paper inventory cards can easily be lost or damaged, leading to loss of important data

   

Solution

By adjusting the paper inventory card to an electronic inventory card, it is equivalent to establishing a self-use inventory management system for the database management, which is different from the SAP system;

• How can we improve the efficiency and accuracy of stock card loading and unloading?

Solution:

A) For store goods that have the largest workload of on-premise and off-board cards, the Warehouse Management should directly modify the items whose actual delivery quantity is different from the number of goods required by the store on the basis of the original electronic order, if there is no difference, you do not need to handle it. For example, if the white radish Zhengzhou stores require goods of 45 kg, the database management actually delivers 47 kg, the Zhengzhou 3 stores require goods of 30 kg, and the database management actually delivers 30 kg, the database management only needs to change the 45kg of the Zhengzhou 1 store to 47 kg, zhengzhou 3 stores do not need to be modified because they are the same;

 

B) For warehouse receiving and internal collection of some data, the Warehouse Management should input the mnemonic code of a single item to quickly enter the data. Saves you the trouble of viewing the inventory card directory by hand turning to the corresponding page. For example, if the size of the white radish is 400 kg in the database, you only need to enter BLB on the corresponding page, and then the white radish specifications and units are associated with each other, and then enter the quantity. (For the number of input, you can use the voice broadcast function provided by Excel. after entering a number, the system automatically prompts you to enter a number, minus unfamiliar with the computer keyboard, steps to confirm whether the input is correct after the input)

• How can we avoid the human error of manually calculating the settlement of a single item?

Solution:

The system automatically calculates the inventory after the warehouse receiving, warehouse receiving, and internal collection data are input ;,

• How can I ensure the consistency between the inventory card and the account inventory of the SAP system?

Solution:

After the Database Manager enters the corresponding data of the inventory card every day, the system automatically obtains (or manually) the SAP system inventory and matches the data according to the material code, the system automatically generates the details and quantity of each item that is inconsistent with the account. After the account is printed, it is handed over to the database management for the reason. The process requires the differences between the card accounts of the day, the warehouse management, accounting, receipt, production, and other departments must work together to find the cause, even if the problem is solved;

• How can we ensure the consistency between the inventory card and the physical inventory?

Solution:

The warehousing supervisor enters the system at the specified time or irregularly, the system automatically generates a spot check item list based on rules such as top 10 with the highest frequency of warehouse picking or top 10 with the highest number of warehouse picking or top 10 with the highest amount of warehouse picking or random generation (the most prone to errors, after spot check, the Warehouse Supervisor will report the result to the account and warehouse manager even if the cause is found, and the logistics manager will assist in the corresponding rewards and punishments;

• How can we ensure that the daily account is correct for the changes to the store's required mail?

Solution:

After each day, the Warehouse Management completes the modification of the number of original goods orders exported from the system at nine o'clock according to the Warehouse account. After the modification, the system automatically matches the number of emails after the account modification, generate a differential list and promptly discover account or database management errors;

• How can I prevent the database management from modifying the historical data of the inventory card?

Solution

The system uses the multi-user login permission control method. Different database administrators need to use different users to log on. Different Levels of permissions vary. For example, the permissions of the team lead and supervisor are higher than those of normal database administrators; in addition, the system will require the database management to only modify the incoming and outgoing data of the current day (---). The changes to historical data must be reported to the storage director, A warehouse supervisor logs on to the system to make changes. It also solves the problem that the Warehouse Management Board is not timely. For example, the stock card on the 10th must be completed before on the 10th, but it cannot be done on the 11th. If there are special reasons, you must be authorized by the warehouse supervisor;

• How can we prevent data loss of inventory cards?

Solution:

Warehouse receiving and picking data related to inventory cards are all stored in the database (the database is installed in the data center or IDC of the Information Department headquarters) and backed up every day, data is exported from the system every month or every six months and stored in the physical hard disk. Such as a mobile hard disk or a CD. (Except for uncontrollable factors such as fire and earthquake)

• How to achieve data sharing?

Solution:

All the data is stored in the network server and can be accessed at any time as long as you can access the Internet.

• How can we solve the problem that the database manager does not use a computer or does not have a computer?

Solution:

The system uses user-friendly settings. As long as the database manager knows Chinese characters or the English spelling, the operation can be performed. In the future, the actual operation training and contacts will be used to increase the number of operations;

Currently, the number of employees with computers in Zhengzhou's old logistics warehouse management is about 70%, for database management systems without computers, you can use recreation room public computers or other database management computers (the efficiency of work can be improved by about 8 times after the use of electronic inventory cards, such as the work of the original database management needs to be completed in 150 minutes, now it can be completed within 20 minutes, so we can share the rest of the time with the computer for the database manager without the computer)

Main technologies (all based on Excel)

• Use WinRAR to package it into an installation file and define the shortcut icon
• With version update detection and new version release function
• Based on the SQL Server database, it can be used based on the network and can be quickly switched between Intranet and Internet
• With the function of automatically creating databases and table structures, one-click table creation in data after designing the table structure in Excel
• Flowcharts-Based Functional menu, novel design
• SQL-based update, query, deletion, and insertion
• With the user login and registration, password modification function
• The role-based permission control function allows you to control user logon permissions and change passwords.
• Use the TTS function with the voice Broadcast Function

   

 

 

Business ValueImprove the efficiency of inventory card management, shorten the working time, and reduce the number of times of criticism and education and financial penalties caused by inventory card errors and inventory shortage, improve employee satisfaction by finding the differences between cards, accounts, and items in a timely manner, and finding the cause in a timely manner is to solve the problem, reduce the inventory shortage and inventory profit ratio of the logistics center in a timely manner to identify the differences between cards, accounts and things, find the reasons, standardize and optimize the logistics business process of receiving, sending, and storing, improve the level of logistics operation management to improve the inventory accuracy of the SAP system, improve the accuracy of the property control plan, improve the inventory turnover rate, reduce the stock occupation to improve the inventory accuracy of the SAP system, and improve the accuracy of the property control plan, reduces the shortage caused by inaccurate planning and fails to meet the customer's (Store & processing room) needs, improving customer satisfaction Contact us