How should I modify the negative inventory of raw materials?

It should be a negative amount, the quantity is correct, and an adjustment entry can be made; Or you check that the anomaly has occurred from **, and the amount is now negative, and it is possible that the previous quantity has also been negative.

Only take your time.

You have been checking up, find out the month when the inventory at the end of the month of the first month is negative, check how much raw materials are in the warehouse, how much is used, and use this formula to calculate: [last month's inventory + that month's incoming material - that month's picking = that month's monthly balance (that is, the inventory at the beginning of next month)]:

1.See if his monthly feed is less material, 2Did the picking of that month inflate the number of picking materials and increase the production cost?

If the first month is negative in and out of the month is not wrong, just check the last month that is not negative, and also see if he is undercounting the warehouse, inflating the number of materials, and then using the formula to calculate, has been so backward to check it.

It's easy to check this account!

You only need to find all the documents for the purchase of materials and the entry and exit documents of the raw material warehouse, and if you owe the documents and vouchers, you can conduct a small inventory of the physical objects of the raw material warehouse, and then check the documents including the electronic file accounts.

The picking unit has a bottom link, and the warehouse also has both manual account books and electronic files, and then checks them, and finally takes the initial balance + this month's warehousing - this month's warehousing - scrap = this month's balance = this month's inventory real number, such a formula can be calculated.

In fact, it is very important to do finance or go down to the workshop to understand the production process, if the following people want to fool the accounts, there is a chance, in fact, I think that such documents should be in triplicate, the issuing warehouse, the picking unit, the finance, so that you will be relaxed.

I hope you can solve the problem, I also work in a shoe factory, and you can discuss each other if you have a problem.

1. The system administrator logs in to the ERP main console, and expands [System Settings] - >Basic Data] - >Public Data] - > double-click to open [Warehouse].

2. Enter the warehouse interface and double-click to open the [Raw Material Warehouse].

3. Enter the Warehouse-Modify interface, switch to the [Project Properties] tab, and the [Allow Negative Inventory] attribute field of [Raw Material Library] is currently invisible.

4. Switch to the [Parameter Settings] tab and check [Implied non-required information].

5. At this time, enter the warehouse interface, double-click to open the [Raw Material Library] Allow Negative Inventory option in the warehouse properties is displayed.

Here's how:

1. Determine the updater of the inventory.

Style. If the inventory update method is "Update inventory when saving", just follow the next step 2. If the inventory update method is "Update inventory on approval", then you need to change the inventory update method to "Update inventory on saving" in the database background, and then follow the second step.

2. Put a checkmark on the option to set inventory to "Negative inventory is not allowed".

Hello, then you check whether the items that allow negative inventory are checked in your warehouse properties.

In System Settings--- System Settings - Inventory Management--- Document Settings--- Inventory System Options.

You can tick the box between the allowed negative balance of the real position and the negative balance allowed for the virtual position.

Raw materials or inventory of goods are negative.

Of course, you can't check out.

Find out the reason and adjust the accounts.

Mainly check the picking voucher and sales outbound voucher to see if there is any wrong quantity and amount.

When the store loses the machine, when the current system inventory of the product is less than the sales quantity, the system will produce negative inventory, and the high inventory will cause a backlog of goods and money.

Causes:

Inbound and outbound document errors.

Receiving errors (wrong quantity, late warehousing);

The quantity of other inventory operation documents such as withdrawal, allocation, distribution, requisition, profit and loss, etc. is incorrect;

Inventory errors. Barcode input error, omission;

Quantity entry errors;

Count Quantity Error:

Wrong sales or loss of goods.

The expiration date of the shelf life. Fresh processing and loss.

The suggested approach is as follows:

First of all, you should establish a daily negative database processing process:

Set a negative warehouse warning limit for goods, and print out the goods that exceed the negative warehouse by commodity department.

Cost Handling of Negative Inventory Sales:

Negative inventory sales must be made provisional cost processing, which involves two factors, that is, the provisional cost of the first quotient and cost price, for different accounting methods can choose different ways, for the average class algorithm (daily average, moving average), use the current average cost price.

At the time of warehousing, if it is found that there is negative inventory, it should be corrected for negative inventory cost reduction, that is, the original negative warehouse sales cost is corrected into a new real warehousing ** business and cost price, and then the new cost is used to re-record the cost of sales.

Causes of Negative Inventory:

1. The document preparation of the information entry clerk. Errors and delays in document formation will affect the inventory, and this situation will disappear after the product is accepted.

2. Tally clerk inspection error. Boxes are not unpacked for inspection, but it is common for a box of goods to be mixed with two or three barcodes; The original barcode of the product was not found to be wrong or replaced; Because it is not careful, the two goods are accepted as one commodity.

3. Some goods are single-in, but they are sold out of the box, resulting in a big difference.

4. In the process of returning, a product needs to be returned in full, but it is not taken off the shelves in time and is bought by the customer, forming a sale. This reason is easier to check, and the document can be modified after it.

5. Not all the goods are directly distributed to the stores by the headquarters, the stores are widely distributed, and they choose the nearest suppliers, so that the information issued by the headquarters can not be completely accurate.

For example, the suppliers of store A and store B are different, but the headquarters is unified when issuing information, so there are two suppliers for many products. Some products are available in store A, but not necessarily in store B; Some products are not available in store A, but shop B has them.

6. A large number of goods in the cultural and sports department store area often use the in-store code, and the in-store code is applied to the warehouse during acceptance, but there is still scanning the barcode information of the goods when selling, resulting in a long and short inventory. Special attention should be paid to the fact that when the tally clerk uses the store code, he should confirm that the barcode has no information, or cover the original barcode; On the other hand, cashiers should have corresponding inspections for such products that use a large number of in-store codes when selling, and scan the in-store codes first if they have in-store codes.

7. For customers to choose n varieties or flavors of similar goods, when checking out, the cashier did not scan the code one by one, and used the "* quantity" key to check out the goods with different item numbers at the same time. In addition, when the code scanner cannot be scanned, you need to enter the checkout by hand, and when the input is wrong, it will also cause negative inventory.

8. The internal transfer operation is wrong, and the checkout item number is not the actual item number.

9. Gifts are sold as general commodities. During peak traffic periods, it is difficult to avoid this happening.

10. Omissions in the inventory process. Taking stock once a month, this work requires a great sense of responsibility. Preparation before taking stock is important. My store uses price tag counting.

Explain that the inventory information is incorrect, and there are more outbound than inbound, check the inbound and outbound situation to see if there is an error.

At the end of the month, the statistics of raw materials appeared negative, and the god of the servant was scattered, whether it was not registered in the warehouse this month.

The negative receipt of materials may not be used this month, but there is a situation of return, which may be the case that You has received and not used up last month, but has not returned to the warehouse.

For example, if there is no stock in the ERP, it will be sold or shipped.

This has a lot to do with inventory management. This phenomenon often occurs if it is not strictly managed. For example, the warehousing is not timely.

The warehousing procedures have not yet been completed; The handwritten documents of the library management are inaccurate, resulting in confusion of models. There are also some units of raw materials that need to be pre-checked, but the production department urgently needs to skip the pre-inspection procedures, so the inventory will definitely have negative inventory. This phenomenon has a lot to do with the actual operating conditions.

Some equipment can not be stored in the warehouse, and there are also some units that cannot install ERP equipment terminals in the warehouse. These all determine your level of warehouse management.

Generally, the system has a limit to whether the inventory is negative or not! If you can't set it to negative, it may be that the data of June was modified in August, which affects the accuracy of inventory, so it is necessary to standardize the operation of employees in order to make ERP run better!

There are many reasons for negative inventory in the system, the main reason is that the warehousing operation is not timely, that is, the product has been put into storage and used and issued, while the corresponding warehousing operation (such as not entered, or has been entered without review, etc.) has not been carried out, resulting in negative inventory. In Kingdee K3 settings, the "hook" of the option of "system settings" - system settings - warehouse management - document settings - warehouse system options - real warehouse allows negative inventory will not appear, but there may be a phenomenon that inventory materials cannot be collected, and to prevent this phenomenon from occurring, it is necessary to put into the warehouse first and then issue it during business operations.

At the same time, before removing the "hook", all inbound and outbound operations must be audited, and no new business occurs, and the system must be backed up, otherwise there will be data errors.

There must be an invoice for the raw materials to be recorded, even if the invoice has not arrived for the time being, and it has been temporarily estimated to be put into storage, there must be an invoice in the later stage.

If it is the reason that VAT should be paid every month, you can purchase raw materials, the input invoice is not certified, and the current certification period is 180 days, which can be reserved for certification when needed in the future. If it is expected that the certification will not be carried out within 180 days, then a general invoice will be issued for the purchase of raw materials.

At present, only agricultural products purchased from rural households can be invoiced, and primary agricultural products purchased from small-scale taxpayers can also be deducted. As long as it is a real purchase, it can be deducted, and the input is greater than the output, so it can be retained.