Skip to Content
Menu
This question has been flagged
4 Replies
3956 Views

Hi there,

We have raised a vendor bill for a stock item and marked it as paid. The entry raised credited accounts payable and debited interim stock received account. We did not raise a purchase order.

What is the correct way to now receipt the items in stock and offset the amount in interim stock received account? I would like to update the qty on hand and offset the value against the entry in the iterim stock received account.

thanks

Avatar
Discard
Best Answer

Hi Mike:

You need to make sure all of the following configurations have been done for the stock quantity to be tracked:

  • Install Inventory module

  • Configure Products as Storable Product.

  • Configure the Inventory Valuation, Account Properties, Account Stock Properties and Logistics fields at the Product Category level.

You will find the following documentation useful:

 Inventory

Update:

The quantities get updated via a Delivery Order (outward), Receipts (inward) and Internal Transfers (movements within the company). The Accounting entries are determined by the Accounting related settings on the Product and the Product Category.

If there is no PO, you would still need to manually create a Receipt in the Inventory module for the quantities to get updated. For the valuation and accounting part, you need to make sure that the Product Categories have been correctly configured and the "Inventory Valuation" is set to "Automated" on the Product Category. If you are creating an Inventory Adjustment for setting up Opening Stock, you also need to ensure that the "Cost" field is updated on the Product/Product Variant before you do the Inventory Adjustment so that the valuation of the opening stock is correctly calculated.


Avatar
Discard
Best Answer

If  you want to do this steps in right way this apps my help you 

https://apps.odoo.com/apps/modules/10.0/invoice_with_stock_move/

https://apps.odoo.com/apps/modules/11.0/integration_invoice_with_stock/


If  you want to do standard as   Lars Aam                      

You should follow the standard procedure. Create purchase order and from there you get a  delivery and can create a billing doc.

Be aware of setting the accounting properties correctly on product category.  And have in mind that they can be overwritten by the properties on the product.

You may manually create receipt in Inventory app. The posting will be done to the account set in the product / product category.  


Avatar
Discard
Best Answer

You should follow the standard procedure. Create purchase order and from there ytou get a inbound delivery and can create a billing doc.

Be aware of setting the accounting properties correctly on product category.  And have in mind that they can be overwritten by the properties on the product.

You may manually create receipt in Inventory app. The posting will be done to the account set in the product / product category.  

Avatar
Discard
Author Best Answer

Thank for the reply Paresh,

I have seen that the official way to tack stock is to raise a purchase order and then a shipment/delivery and vendor bill. I am looking to find a way to fix things if the purchase order was not raised just the vendor invoice. The main thing is to get the debit part out of interim stock account. Preferably I would like to track the items in stock but its ok to just journal the amount out of interim stock and to cost of sales to fix things and I may end up doing this.

If I raise a stock adjustment or change the quantity on hand where does the credit side go? I want it to go to the interim stock account. We use a perpetual inventory system. Its the accounting entries I am concerned about. If I am misunderstanding how the entries work with odoo, or the information you provided, please let me know.

thanks

Avatar
Discard

Please see the updates made to my original response