Real Costing Method

by
Odoo

214.56

v 14.0 Third Party 32
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Purchase (purchase)
Sales (sale_management)
Discuss (mail)
Invoicing (account)
Lines of code 413
Technical Name real_costing_method
LicenseAGPL-3
Websitehttp://rightechs.info
Versions 16.0 13.0 11.0 15.0 12.0 14.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Inventory (stock)
Purchase (purchase)
Sales (sale_management)
Discuss (mail)
Invoicing (account)
Lines of code 413
Technical Name real_costing_method
LicenseAGPL-3
Websitehttp://rightechs.info
Versions 16.0 13.0 11.0 15.0 12.0 14.0

Is used to issue the delivery shipment with real incoming cost, specially that will help companies which are using LOT/Serial numbers feature to issue the cost according to the selected LOT/Serial number nosed on FIFO. also it will be good base for stock card app as it will update the cost of outgoing shipment cost based on additional landed cost which is added after selling the items

Features

Features

- Reduce the quantities issued from the selected LOT/Serial number.
- The cost is correctly calculated from the selected LOT/Serial Number,
- Return items will be with real cost which is calculated when issue it.
- Updating outgoing (already out) stock move based on the additional landed cost that's added after selling it (useful for Stock card)

Create two Purchase orders for Product-1

First Purchase order with quantity 10 units and cost is 10 $.



Receipt order for Product-1 with lot number 0001 (Related to PO00008)


Second Purchase order with quantity 10 units and cost is 20 $.



Receipt order for Product-1 with lot number 0002 (Related to PO0009)

Create a sales order for Product-1.

Sales order with quantity 1 unit



System will recommend the first incoming lot number


Change the lot number and select the second one 0002


Delivered order for Product-1 with lot number 0002 (Related to SO020)


Check the cost of the lot number issued.

Check the journal entry that generate from delivery order (WH/OUT/00009), stock valuation has been reduced with 20 $, that is the cost of second lot number 0002.



Create invoice for this sales order (SO020)


In Anglo-Saxon Accounting the cost is reported when validate the invoice


- Check the cost in the journal entry related to this invoice
- Cost is 20 $, the cost of second purchase order (second shipment lot number 0002)


Free Support

You will get 60 Days free support incase any bugs or issue (Except data recovery).

Please note that You're not allowed to distribute or sell this module after purchase! Incase of any question regarding this module feel free to email us on sales@rightechs.net or raise a ticket on support.

OUR SOLUTIONS

Website SAAS-HR SAAS-CRM

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.
Works well!
by
Egon Raamat
on 3/23/21, 11:04 AM

AssertionError!
by
sales@onedayonegroup.com
on 1/9/24, 7:51 PM Confirmed Purchase

Hello, I am using Odoo 14, and I have purchased and am using your module. Now, I am facing an issue where if a product with a Lots/Seral Number undergoes multiple Manufacturing Orders  and Unbuild Orders , the system encounters an error during the outbound delivery process, preventing successful shipment. I hope you can optimize and resolve this issue. 


Odoo Server Error
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 683, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 359, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 347, in checked_call
    result = self.endpoint(*a, **kw)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 912, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 531, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1390, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1382, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 399, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 386, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/stock/models/stock_quant.py", line 204, in write
    return super(StockQuant, self).write(vals)
  File "../build/oejia_weshop/od13.py", line 33, in write
  File "../build/task_queue/od13.py", line 33, in write
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3703, in write
    fields[0].determine_inverse(real_recs)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1187, in determine_inverse
    getattr(records, self.inverse)()
  File "/usr/lib/python3/dist-packages/odoo/addons/stock/models/stock_quant.py", line 131, in _set_inventory_quantity
    move._action_done()
  File "/roaddons/real_costing_method/models/product.py", line 336, in _action_done
    return super(StockMove, self)._action_done(cancel_backorder)
  File "/usr/lib/python3/dist-packages/odoo/addons/stock_account/models/stock_move.py", line 271, in _action_done
    stock_valuation_layers |= getattr(todo_valued_moves, '_create_%s_svl' % valued_type)()
  File "/roaddons/real_costing_method/models/product.py", line 289, in _create_out_svl
    svl_vals = move.product_id._prepare_out_svl_vals(forced_quantity or valued_quantity, move.company_id, move)
  File "/roaddons/real_costing_method/models/product.py", line 86, in _prepare_out_svl_vals
    fifo_vals = self._run_fifo(abs(quantity), company, move)
  File "/roaddons/real_costing_method/models/product.py", line 212, in _run_fifo
    assert qty_to_take_on_candidates > 0
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 639, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 315, in _handle_exception
    raise exception.with_traceback(None) from new_cause
AssertionError

/

by
Ahmaed elsaka
on 11/15/22, 10:09 AM

For V14 Demo

URL: http://206.189.188.206:8014/
DB for Odoo Enterprise   =====>  Demo_EE

DB for Odoo Community =====>  Demo_CE

Username: demo

Password: demo


Demo request v14.0 (CE & EE)
by
Qaddafi Putra Gary
on 11/8/22, 8:41 AM

hello there, what a great app you have. This is gonna solve my problems with the FIFO costing method from Odoo. Can I request a demo, I want to try several cases, for example returning a product, thank you :D


I can't reply to the comment above haha, but I'm using v14, both CE and EE, thank you..


Demo request
by
Qaddafi Putra Gary
on 11/8/22, 7:29 AM

hello there, what a great app you have. This is gonna solve my problems with the FIFO costing method from Odoo. Can I request a demo, I want to try several cases, for example returning a product, thank you :D

Re: Demo request
by
Mahmoud Elsaka
on 11/8/22, 8:13 AM Author

Hello Sir,


Could you please tell us which version you need?


When can you make it for V15?
by
Talal Albahra
on 11/4/21, 6:34 AM Confirmed Purchase

When can you make it for V15?

Re: When can you make it for V15?
by
Mahmoud Elsaka
on 11/22/21, 4:44 PM Author

Hello,

V15 it's Available now.


When will it be available for V15?
by
Talal Albahra
on 10/26/21, 12:56 PM Confirmed Purchase

We bought it for V14 and it is working well, but is it ready for V15?

Re: When will it be available for V15?
by
Mahmoud Elsaka
on 10/26/21, 1:27 PM Author

Yes, we are working on it and it will be available soon inshallah


It only work with a lot at the time
by
Egon Raamat
on 3/17/21, 6:49 AM Confirmed Purchase

I have tested this and it does not work, whem you have more than 1 cost in 1 lot. If you have Lot A with product X qty 5 cost 5 and Lot A product X qty 5 cost 7. If you make sale order product A qty 7 on confirmation you get singleton error.

Re: It only work with a lot at the time
by
Mahmoud Elsaka
on 3/17/21, 7:45 AM Author

It's solved now,