Regarding the new valuation method, how do we go about investigating the amounts shown in the Stock Variation section?
I can't upload my screenshot but here's one from the Odoo documentation: 
What is that $385 composed of?
Thanks!
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.
Regarding the new valuation method, how do we go about investigating the amounts shown in the Stock Variation section?
I can't upload my screenshot but here's one from the Odoo documentation: 
What is that $385 composed of?
Thanks!
There is no drilldown report showing what the pending transactions are - there are multiple places where this value comes from - it is not just pending transactions (also known as anticipated variations - although that is the bulk of the balance).
How do you interpret the Inventory Valuation Report?
Initial Stock: The inventory value recorded in your General Ledger (Balance Sheet) at the start of the period.
Ending Stock: The inventory value from the Inventory App (a Subledger) at the end of the As Of date.
Stock Variation: The difference between those two.
Note: If your initial or ending stock is ever negative, this just means you sold more inventory than you entered Bills for. You have more Customer invoices crediting your inventory than Vendor Bills debiting it.
The variation number is the amount the closing entry needs to post to make the General Ledger agree with the Inventory App Subledger.
The variation is the sum of:
1) Anticipated Variations (Timing Differences) - these are amounts you can accrue for via the Bills To Receive; Billed Not Received; Invoices To Be Issued; and Invoiced Not Delivered Menus. Generate each applicable accrual entry to post to update your Balance Sheet at the end of the period to account for these variations.
If you receive $100 worth of Inventory without recording a Vendor Bill, you anticipate a future inventory debit of $100.
If you deliver $100 worth of Inventory without recording a Customer Invoice, you anticipate a future inventory credit of $100.
2) Unanticipated Variations (Value Differences) - these are amounts related to adjustments to cost of goods for inventory sold before the price was confirmed with a vendor bill.
If you receive a purchase order for 10 units @ $10, sell 5 ($50 cost of goods) then record a Vendor Bill for 10 units @ $11 - you need to account $5 more of cogs.
If you receive a purchase order for 10 units @ $11, sell 5 ($55 cost of goods) then record a Vendor Bill for 10 units @ $10 - you need to account $5 less of cogs.
Period End Close Process:
A. Generate your Accrual Entries to post the anticipated variations (timing differences).
B. Generate the Closing Entry to post the unanticipated variations (value differences) and match your balance sheet with the Inventory App Subledger.
Any final balance in your Inventory - Variation account represents a P&L adjustment for cost of goods. You can reclass it so the ending period variation balance is $0.
Note: we recommend adjusting product cost price or product total value - due to damage, obsolescence or low demand - on your Balance Sheet at the same time you make the same adjustments via the Inventory App Subledger (either by updating the cost price on the product or using the Adjust Valuation wizard after clicking on the Total Value in the Stock Report) - so you can always keep on top of Impairment Variations. This is not strictly necessary because Odoo will account for them by detecting the difference between the Balance Sheet and the Inventory App Subledger, but it is a best practice to recognize these changes as soon as possible since there is no real need to delay the postings - so you can recognize the expense and update your Inventory App Subledger at the same time.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up