WEICHX
The key to the application is not to use which tool implementation is used, but the idea of implementing. Engaged for many years of ERP, now I want to share and explore in this regard, I hope that all colleagues interested in ERP come to participate. The following is just a personal experience, for everyone to discuss, I hope to give you some prompts, I will eventually improve from everyone's discussion. In the future, there are individuals in sales, purchasing, distribution, production, production site management, human resource management, quality management, equipment management, financial management, cost accounting management, etc., please participate, huh, huh, huh, 进 进 方式Flexible - there is a sales direction, the output direction, the inventory direction, the inventory amount; 2, the conversion of multi-count units, in the implementation of the ERP, we have several customers who have encountered three metrology units; 3, amount Administrative pricing method: advanced first out, advanced first out, moving average, weighted mobile average, etc., mainly for cost accounting. 4, support historical stock, you can query the inventory of history 5, inventory inventory is a historical stock, not because of the inventory, all warehouse business is stopped when the workshop is taken in advance or the warehouse inventory. 6, supported service: The most scientific practice is the three-dimensional bits (X-Y-Z) to assign some inventory rules to each load. These are very large at the three-dimensional warehouse. 7. Support for the maximum stock, safe inventory, dull, downgraded product inventory control management. This is the core of warehouse management - reducing the backlog of inventory funds. 8, support a variety of inventory methods: ABC, rolling inventory, etc. 9. Support batch management, batch number management, serial number management batch: a batch can have a number of batch numbers, many in the chemical industry. Bottom number: The specific number of quasities in a batch, that is, the batch will be subdivided. A batch number can include multiple products. Serial number: For high value, customer requirements are high, the system wants to give a lifelong number of a product is the serial number, used for the only clues for after-sales service, production process, quality tracking. 10. Supporting sales and purchase return process 11, support red rush management (the unit price of the purchase of the launch is not determined, after the finance has already heeded, it can determine the unit price of the entry and exit library, at this time, to do the adjustment of the inventory price - - Suitable for warehouse management strict management stock amount. Please add, harvest will be everyone. Renyubest About querying any day of stock, what do you do? Is the inquiry from the water supply or save the inventory table? Or push it from the inventory table? WEICHX Every month in stock has a monthly decoration number, according to any day, the number of months to any day, any day to all the in-database orders in the date of the month, dynamically calculate the stock at the time. It is historical stock. The data current inventory table is not changed. In addition, open a historical inventory table, is a temporary stock. Current inventory - stock At the time inventory --- History Stock Theme has no leakage? If you please make up the inventory management written by ZZZSSysyyyweichx is very all, very inspirated, thank you. A few questions: 1. In the inventory management program we have written, it is required to be divided into a warehouse in accordance with the property logic (or actual) in the storage of the warehouse, such as the raw material library, semi-finished library, and productive library. Wait, because some warehouses do not manage the amount, some warehouse management amount, but the pricing method is different.
How do you solve it? Is it set to set the library property or specific to material properties, if the customer only sets how to deal with a warehouse? 2, "Inventory is the inventory is a historical stock" is a very good solution. Is it not to take a historical data plus the income in the current period? Differential differences back to current data, history data still needs to be changed? 3, how is the "rolling inventory" implementation? How is the JLAM3 and "Rolling Point" implement? Each time the item is specified, the input computer is compared to the computer book data, and the conditions must have the conditions necessary to update the inventory information: the location of the goods is relatively fixed to another "rolling inventory" is the specified position of the inventory The goods, this situation is related to the structure and inventory management of the computer data. The inventory information must contain the location of the goods. It is also difficult to implement, that is, every time you enter and leave the goods, you must enter the product WEICHX Answer 1: Warehouse The division is based on the business (submitted decision) without pressing the location, and the location of the geographic location can be divided into different stages. Basically, there are few tube amounts that have some tube in the same warehouse, and some regardless of the amount, if this happens, the properties of the warehouse have no conflict. A 2: In the database, the current inventory should be placed in different tables. Historical stocks are only temporary inventory results or can be implemented using views. If the inventory has a profit, it should be a corresponding input and outline list and then flatter the computer account and physical account. At this time, the current inventory table should be changed without affecting the results of the historical inventory, because historical stocks are calculated at any time. A 3: Rolling inventory has different statements, such as the 8th floor of JLAM is one, you can deserve our learning. It is also the first harvest of our post. There is also something that is very valuable in stock management (such as: gold, silver, uranium, copper, platinum and other expensive amount), because the inventory value is high, this requires the inventory very strict. In this case, it is necessary to set a count cycle (such as: 5 days inventory once), calculate the date and the current date of the last inventory. If it has been more than 5 days, the material should be inventive. . SEISM asked Weichx, for a variety of specifications, what is well-managed method, Weichx allocated a code, a variety is a material category. Fireball system is best to support the multi-warehouse storage room must be transferred. The storage industry's warehousing must have the control of retail amount and purchase amount and must have a price adjustment function, resulting in the price adjustment profitter for system flexibility, whether the inventory number management is enabled by the user, and if the warehouse is managed to the library. If the two libraries are dial (different batches, different prices), how to handle it. How is the category of the input library? What ways can be used to improve query speed issues (database design angles).
Weichx changxianwei@163.com has introduced a good idea, huh, huh, huh. The transfer function (car parking) should be used, there is a relatively simple practice to have a positive number in the outbound order (source goods Bit), at the same time, a negative (to the target breeze). This can be done between a document is completed. Because the negative number is the meaning of the library, it is just in the outbound single. JLAM, please talk about: Moving average algorithm and payment of matters to pay attention to weighted average: this period of unit price = (previous amount current amount) / (previous quantity current quantity) (1) Quantity of the previous period = 0? ? ? (2) There is no negative number: (- 100 40) / (- 2 1) = 60, the previous unit price 50, the current purchase unit price 40, the result is 60, may also have a more extreme unit price (3) The method of solving (2) is to do a negative inventory or push, but it is very difficult to implement zzzssysyyy in the retail industry. I do this: for the nature of the warehouse: (due to the price of the goods), even if it is temporary No price should be submitted to the library, then the retransmission of the = (previous period stock amount this period) / (the quantity of the inventory of the previous period the number of new treasures) This period is updated with the calculated price Out of the library; for the nature of the warehouse for the sales class or workshop, since this type of warehouse is a warehouse in the production, there is no need to know, there is a bit of trouble, and it should be in cost prices after the cost is calculated. Update this issue, and then calculates and updates the library with the aforementioned method, and the outlet amount can be used as a basis for generating financial external rotation vouchers in this period. It may be that the above algorithm is applied to the manufacturing industry, and it is not applicable to business and retail. If (the quantity of the inventory in this period) = 0 does not calculate it according to the formula, directly take the current inventory unit price; the negative inventory is really a headache, the solution is to set the warehouse attribute to allow customer customization if it is allowed Negative storage, check the number of inventory, or notble, or a prompt, or allow. Stonesoft I think should be absolute and plus: this unit price = (ABS (previous amount) ABS (this amount)) / (ABS (previous quantity) ABS (number of this period)) is: (ABS (-100) ) abs (40)) / (abs (-2) abs (1)) = 46.6666666666666666666666czjm1 in price management there are several valuation methods: specific identification method, the planned cost method, gross margin method, the amount of the price Nuclear algorithm, the individual pricing method is also used, it is also known as the batch price method, the method is based on the cost of each (batch) income inventory, the cost of issuing the cost of the inventory. 2. How to determine the best inventory? There is an algorithm when I have been presquenial for school, but the words that are not involved here should not be determined. 3. At the end of the accounting period, the inventory of the actual value enterprise for objective, real and accurate, accurate enterprises should be measured at the end of the time at the end of the period, and there are three ways: single comparison method, classification comparison Method, total comparison method.
How to implement it in the program? Pengyuehui About History - I added a daily measuring table to record the inventory of every day, the quantity, amount of each document, the amount, and then make a calculation column will be the number of warents on the day - out The number of libraries, as long as the summage column is queried in the historical stock, add the column in the condition> = a certain date, what do you want to ask for a batch and batch number in the document? I am now making a cosmetics system weichx, the chemical industry is a lot of batch. But the batch number below is generally used under the batch of batch. We are designed to be batch when designing. The specific practice is in the stock Table, inventory list, outline list, monogram, etc., etc., etc., and inventory-related tables, add a batch column. In the case of a batch and batch number, YANGYHP, how to first processed the inventory and deductible cost, it is best to write a stored procedure, list the table structure, can the landlord? CZJM is here to try to consider the commonality of inventory management, considering the demand in the specific implementation, either consider all possible situations to maintain compatibility, I think the latter may be better, but more troublesome. The help documentation of the inventory part of the software is uploaded here. I hope to use our topic. I hope that I have a similar thing to share Jokfh to go to the SAP Forum to see the MM module information, I believe that QCZ is advanced to you The law is very troublesome when purchasing returns, returning, selling, selling returns, out of the warehouse, such as sales return, sales return equivalent to the storage The first outlet amount. Then, the library is written, and the material is written to the library or directly restore the number of materials that is out of the library? These two methods will also affect the next outlet material. Similar problems, I have recently prepared to upgrade my original import storage system, I want to increase the advanced first out of the batch, and then go out first out, individual pricing method. I hope to discuss together. Wwwhsh is the bits you said. In our factory called storage. In terms of storage. I don't know how everyone entered. If you want to ask a container from stock. So this empty reservoir is needed by other containers (Because our factory's warehouse utilization is very high. The shelves have three layers. 12 rows of groups. If I want to take out one of the containers are middle. Then all outer containers must be corrected. There is one in the middle. Empty container. Wwwhsh now has many people don't like the process. But I don't know the process. How to write code. I only used the write module? Write some people can't do it. There is a ripe module. Everyone is To understand the process clearly. Better understanding of the process. Otherwise you can write every feature. Isn't the program not fight? I don't know if everyone is writing the system. To do this, don't know if there is such a method? In India. When the system is developed, all programmers open the analysis. If there is a month, go to the system. So minimum to have two weeks. Open this analysis. The programmer records the functions of each window first on the notebook. Refine the analysis. The record on the notebook is the code to be written on the computer. Indian software is clear. System stable . So successful. So technology is very important. But the process is the foundation of the software! Please don't fall ink !! Original from www.pdriver.com
