跳至内容
菜单
此问题已终结
1 回复
1615 查看

So I'm using automatic inventory accounting FIFO method, though it was disabled and reenabled during the last updated to 16.3 saas, so there may be some weird side effects from that, but I believe I've cleaned all those up though, and these discrepancies were present before that.


Occasionally we get extra units that aren't billed, it's not common but happens. So there end up being credits to the interim inventory account and a debit to the inventory account for the nominal value of the extra units. So inventory value is increased and the interim account is decreased.


I'm not sure how to reconcile these, I could manually adjust the WH transaction amounts to match what was invoiced, but I think the inventory valuation will still be wrong, and CoG's will be wrong when the free units are sold.

Should I just transact these amount to an inventory shrinkage account?

形象
丢弃

Hi Nat,

Did you find a solution for this?
We buy rolls of material that are normally longer than purchased and Odoo wants to create liabilities for the addition materials that will never be billed.
Thanks in advance.

See my answer below

最佳答案

Check with your Accountant for the standards that apply to the country you are in. 


Example: You order 10 units at $10 each and receive 11


You have $110 in current assets and a liability for $100.


You can either

  1. record the difference as other income (* may have tax implications)
  2. re-value your inventory to $100


In both cases, everything is the same until you process the Vendor Bill:

  • Purchase Order for 10 units at $10
  • Warehouse Receipt for 11 units


Note: at this point you have 11 units at $10 each in Inventory - a valuation of $110 - it is important to record every material asset you receive


Vendor Bill:

  • debits the interim account for $110 with a line showing 11 units at $10 each 
  • credits the other income account with a second line showing 1 unit of a -$10 discount


After validating the Bill, your interim stock account is balanced. You have $110 worth of inventory, a $100 liability and $10 of other income.


This is where you stop if you elect option (1).


If you elect option (2), you use the Add Manual Valuation feature from your Inventory Valuation Report (a plus icon next to the Product):



Be sure the Added Value and Counterpart Account are the same as the discount line on the Vendor Bill.


After this you have $100 worth of inventory, and a $100 liability.



Note: if the Vendor Bill was already incorrectly processed for 10 units at $10 and your stock interim account is unbalanced, create a second Bill as outlined above debiting the stock interim account for the value of the extra products received with a second line that credits your other income account - the bill should net to $0 because of the discount line you add.  THEN complete the final step of revaluing your Inventory.


形象
丢弃
相关帖文 回复 查看 活动
0
11月 23
1140
1
3月 23
2544
2
5月 25
1878
0
4月 24
990
2
12月 23
1843