Key Highlights
Automatic Interim Account Journal Entries
Automatically generates accurate journal entries for Stock Input (GRNI) and Stock Output (GDNI) during inventory transactions, eliminating manual accounting work and ensuring real-time financial accuracy.
Complete Three-Way Matching Support
Implements a complete Receipt → Vendor Bill → Customer Invoice accounting flow by automatically clearing interim accounts (GRNI/GDNI), providing a professional three-way matching process for perpetual inventory valuation.
Product-Level Flexible Configuration
Enables Journal On Move Creation on individual products, allowing businesses to selectively apply automatic stock valuation entries without affecting products that use the standard Odoo accounting workflow.
Are you ready to make your business more
organized?
Improve now!
Navigate to Inventory Configuration
Open the Inventory module and navigate to the Configuration menu. This step is used to access the inventory configuration options required for setting up product categories, valuation accounts, warehouses, and other settings necessary for the automatic stock valuation process.
Enable Perpetual Inventory Valuation View
Open the required Product Category and change the Inventory Valuation method from Periodic (at closing) to Perpetual (at invoicing). Once Perpetual inventory valuation is selected, the Journal On Move Creation option provided by the module becomes available. Enable this option to activate automatic journal entry creation for stock valuation during inventory transactions.
Enable Journal On Move Creation
After selecting Perpetual (at invoicing) as the inventory valuation method, the custom Journal On Move Creation option provided by the module becomes visible. Enable this option to activate automatic journal entry creation for stock movements. Once enabled, the module will automatically generate the required accounting entries for Stock Input (GRNI) and Stock Output (GDNI) during inventory transactions.
Configure Stock Interim Accounts
After enabling the Journal On Move Creation option, two additional configuration fields become available: Stock Input Account (GRNI) and Stock Output Account (GDNI). Select the appropriate interim accounts for the product category. These accounts are used by the module to automatically generate journal entries during purchase receipts, vendor bills, delivery orders, and customer invoices, ensuring accurate three-way matching and real-time inventory accounting.
Configure the Product Category
Navigate to Inventory → Products → Products, open the required product, and assign the Product Category that has Journal on Move Creation enabled. This ensures the product follows the automatic interim accounting process during stock movements and invoice validation.
Create a Purchase Order
Navigate to Purchase → Orders → Purchase Orders and click New to create a new Purchase Order. Select the desired vendor and add the same product that was configured in the previous step (the product assigned to the category with Journal on Move Creation enabled). Enter the required quantity and confirm the Purchase Order.
Receive the Purchased Products
After confirming the Purchase Order, click the Receive button to open the Receipt. This will create the incoming stock transfer for the purchased products. Validate the receipt to move the products into inventory and trigger the automatic stock valuation journal entry.
Validate the Receipt
Open the generated Receipt and click the Validate button to confirm the receipt of the purchased products. Once validated, the inventory is updated automatically, and the stock valuation journal entry is created based on the configured accounting settings.
Verify the Automatically Generated Journal Entry
Navigate to Accounting → Accounting → Journal Entries to view the accounting entries created by the system. After validating the Receipt, the module automatically generates the stock valuation journal entry without requiring any manual intervention.
Upload and Confirm the Vendor Bill
Open the validated Purchase Order and click the Upload Bill button. Create or upload the Vendor Bill, review the bill details, and then click Confirm (Post) to validate the Vendor Bill.
Verify the Journal Entries After Bill Payment
After confirming and paying the Vendor Bill, navigate to Accounting → Accounting → Journal Entries. Odoo automatically generates and posts the corresponding Journal Entries for the bill payment. You can verify the posted accounting entries from this menu.
Create a New Sale Order
Go to Sales → Orders → Quotations, click New, select the Customer, and add the same product that was configured with the product category containing Journal on Move Creation. After entering the required quantity, click Confirm to confirm the Sale Order.
Confirm the Sale Order
Once the Sale Order is confirmed, Odoo automatically generates a Delivery Order for the selected product. Click the Delivery smart button to proceed with the product delivery.
Open the Delivery Order
In the Delivery Order, verify the product quantity and ensure the product is ready for delivery. Then click the Validate button to complete the delivery process.
Validate the Delivery
Click Validate to complete the stock transfer. Once the delivery is validated, the inventory is updated and the stock movement is completed.
Verify Automatic Journal Entries
You will notice that the journal entries are automatically created after validating the Delivery Order because Journal on Move Creation is enabled for the selected product category.
Create the Customer Invoice
Return to the confirmed Sale Order and click Create Invoice. Generate the invoice and click Confirm/Post to validate it.
Register Customer Payment
After posting the invoice, click Register Payment, enter the payment details, and confirm the payment to mark the invoice as Paid.
Verify Final Accounting Entries
After the customer payment is completed, the corresponding accounting entries are automatically recorded in the Journal Entries, ensuring accurate financial tracking.
Open the Journal Items tab on the posted invoice.
Here, you can verify that the invoice-related Journal Items have been automatically created. These entries contain the detailed debit and credit records generated during invoice validation and payment, ensuring accurate accounting for the transaction.
For printing images in the report first we have enable 'Show Product image in the report' option in the configuration settings.
Our Services
Support & Customization
We're here to help you with setup, customization & support
🚀 Free Installation Support
One-time free setup on Odoo server with proper configuration.
Third-party or custom development requests may be chargeable.
Odoo Experts | ERP Solutions | Custom Development
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) • Inventory (stock) |
| Lines of code | 258 |
| Technical Name |
inom_automatic_stock_valuation_entries |
| License | OPL-1 |
| Website | https://www.inomerp.in |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module