Raw material procurement and warehouse receiving processing in Production Enterprises

From: http://shine-it.net/index.php/topic,4178.0.html

There are two kinds of raw material procurement situations: one is to first receive the goods and pay according to the actual amount of goods received; the other is to pay first, and the other party then delivers the goods. For domestic suppliers, the former is usually used for processing, but some imported raw materials, the other party will require first payment, or partial prepayment, the other party will ship. The two cases have different processing methods in openerp.
1. receive the goods before making payment
Generally, the warehouse receiving quantity and financial payment amount should be subject to the quantity and amount on the purchase order. However, due to the following common causes, the warehouse receiving quantity and payment amount are different from those of the purchase order. A) the quality control fails, and the actual warehouse receiving quantity is less than the purchased quantity. B) low Quality Grade, receive at a discount; c) Supplier gifts, the actual number of warehouse receiving exceeds the number of purchases.
To solve the problem that the quantity and price of the purchased items are different from the warehouse receiving quantity and price, we recommend the following processing in openerp:
1) when purchasing an order, do not generate an internal invoice (invoice) based on the purchase order. Instead, open Invoice Based on the number of warehouse receiving. By default, the system automatically generates an invoice for an order.
2) separate input location should be set for the raw material warehouse. The default input location is equivalent to stock location. When purchasing and warehouse receiving, the warehouse receiving is first input location, and the input location is associated with stock location through location chain. In this way, when raw materials enter the input location, the system will automatically generate a stock location inter-database dial-up ticket.
3) after quality control, the quantity on the inter-database transfer order is actually stored in the database.
3.1) if the warehouse receiving quantity is lower than the quantity on the purchase order, there are two possible solutions after consultation with the Purchase Department:
A) Number of suppliers required
In this case, the system will automatically split the transfer order into two records when the actual number of incoming records is entered, one is the number of incoming records, and the other is the insufficient number, wait for the supplier to replenish the goods before receiving the goods again. And issue an invoice based on the input location receiving ticket.
B) warehouse receiving by volume
In this case, you must first change the number on the dial to the actual number, and then import the data to the database for processing. After warehouse receiving is completed, return the receipt ticket on the input location and return the inventory portion. (If no return is processed, the inventory quantity recorded on the input location is incorrect ). And issue an invoice based on the receipt form on the input location. At this time, because the number on the receipt form is more than the actual number of warehouse receiving, the number of invoices generated by the system is incorrect, you should manually modify the number of invoices.
3.2) if the warehouse receiving quantity exceeds the number on the purchase order, there are three possible solutions after consultation with the Purchase Department:
A) receive by number of purchase orders
In this case, the actual number of warehouse receiving is entered during the transfer order processing, and an invoice is issued based on the input location receiving order.
B) receive gifts as suppliers
In this case, you need to add a detailed line on the dial. The source database space is "purchase Profit and Loss". The target database space is the same as the original detail line, and the quantity is the number of gifts. Then, you can import the data to the database for processing. In this way, the system will automatically generate the gift accounting credential:
Borrow: Raw Materials
Loan: Business fee
After warehouse receiving is completed, an invoice is issued based on the receipt form on the input location.
C) receive after increasing the payment amount
In this case, the Sourcing Department is required to open another purchase order. The warehouse receives the order according to the quantity of the previous order, issues the invoice, receives the extra amount from the next order, and issues the invoice.
4) The accounting creden automatically generated by the system
4.1) when the warehouse handles the transfer order, the system generates the following accounting creden:
Borrow: Raw Materials
Loan: materials in transit
If there is a gift, the system generates another credential as follows:
Borrow: Raw Materials
Loan: Business fee
4.2) The system generates the following accounting credenwhen the Finance confirms the purchase invoice:
Borrow: Materials on the road
Tax payable-Value-Added Tax (input tax)
Loan: Accounts payable
5) Setting of accounting subjects for raw materials
5.1) the inventory valuation on the product of raw materials is real time (automatically). In this way, the system will automatically generate corresponding accounting subjects when receiving and picking data.
5.2) the product category of raw materials should be set as follows:
Stock input account: materials in transit
Stock valuation account: raw material
Expense Account: materials in transit
6) Repository settings
6.1) the system automatically generates warehouse receiving and warehouse receiving accounting creden based on the following principles: a) migrating from a non-Internal location to an internal location, the system automatically generates creden;; B) when the locations of different companies are moved, no matter whether they are internal locations or not, creden; are always generated. c) when the creden are generated, the stock valuation account (incoming) of the target location is used ), the stock valuation account (outgoing) of the loan source location. If no value is set on the location, the stock input account, stock valuation account, and stock Output account on the product are obtained.
6.2) add an input location of the inventory type, which serves as the input location of the system default repository and is associated with the stock location of the default repository through the location chain. Set accounting subjects on input location:
Stock valuation account (incoming): materials in transit
Stock valuation account (outgoing): goods on the way
6.3) Add a "purchase loss overflow" location, whose type is inventory, which serves as the source location for the supplier gift warehouse receiving, and set the accounting subject on the "purchase loss overflow" location:
Stock valuation account (incoming): Operating fee
Stock valuation account (outgoing): Operating fee
2. payment before delivery
In this case, you need to issue an invoice based on the purchase order, instead of issuing an invoice based on the receipt quantity when receiving the goods.
1) when purchasing an order, the system automatically generates a purchase invoice. When the Finance confirms the invoice, the system automatically generates the following accounting creden:
Borrow: Materials on the road
Tax payable-Value-Added Tax (input tax)
Loan: Accounts payable
2) After the warehouse arrives, as in the previous case, first enter the quality control database (input location), and then adjust the quantity on the inter-database dial to the database.
2.1) if the warehouse receiving quantity is lower than the quantity on the purchase order, there are two possible solutions after consultation with the Purchase Department:
A) Number of suppliers required
In this case, the system will automatically split the transfer order into two records when the actual number of incoming records is entered, one is the number of incoming records, and the other is the insufficient number, wait for the supplier to replenish the goods before receiving the goods again. Because the system has launched an invoice when purchasing an order, you do not need to issue an invoice at this time.
B) warehouse receiving by volume
In this case, you must first change the number on the dial to the actual number, and then import the data to the database for processing. After warehouse receiving is completed, return the receipt ticket on the input location and return the inventory portion. (If no return is processed, the inventory quantity recorded on the input location is incorrect ). Note: In this case, you must select "to be refunded/invoiced" on invoicing to issue a return invoice. Because the payment has been paid, a refund is required from the supplier.
2.2) if the warehouse receiving quantity exceeds the number on the purchase order, there are three possible solutions after consultation with the Purchase Department:
A) receive by number of purchase orders
In this case, the actual number of incoming records is entered during the transfer order processing.
B) receive gifts as suppliers
In this case, you need to add a detailed line on the dial. The source database space is "purchase Profit and Loss". The target database space is the same as the original detail line, and the quantity is the number of gifts. Then, you can import the data to the database for processing. In this way, the system will automatically generate the gift accounting credential:
Borrow: Raw Materials
Loan: Business fee
After warehouse receiving is completed, an invoice is issued based on the receipt form on the input location.
C) receive after increasing the payment amount
In this case, the Sourcing Department is required to open another purchase order and issue an invoice. The Warehouse first receives the order quantity, and then receives the excess parts of the last order.
3) after the above processing, the system automatically generates the following accounting creden:
3.1) The system generates the following accounting credenwhen the Finance confirms the purchase invoice:
Borrow: Materials on the road
Tax payable-Value-Added Tax (input tax)
Loan: Accounts payable
3.2) when the warehouse handles the transfer order, the system generates the following accounting creden:
Borrow: Raw Materials
Loan: materials in transit
If there is a gift, the system generates another credential as follows:
Borrow: Raw Materials
Loan: Business fee
If a return is returned, the system automatically generates a return invoice. When the Finance Department confirms the return invoice, the system generates the following creden:
Borrow: Accounts payable
Loan: materials in transit
Tax payable-Value-Added Tax (input tax)
4) Handling of prepayment
If the supplier does not require full payment, partial prepayment is enough. This can be achieved by setting the payment term on the purchase order.