Contributors mailing list archives

contributors@odoo-community.org

Re: Landed Costs improvements in v10

by
Landis Arnold
- 22/11/2017 03:47:36
Not wanting to complicate.
Just looking at ongoing needs for running the business and the ability to know real Landed Costs.

1: Supplier or Build Cost - Correlates to invoice price.  (Perhaps some initial "offsite" BOM could come into play.  Say for instance with a Agency fee, mold amortization, etc)
2: Cost of Shipping In  (needs to be calculated based upon some formula, ie weight %, or value % of overall invoice)

then, if imported
3: Cost of Duties  (should be applied at a certain rate to the time)
4: Cost of Clearance  (could be applied to LC or not, but I feel it is best do do so).

then, if moved internally
5:  Additional cost of movement (for instance warehouse to warehouse)

Ideally a real cost can be tracked through this process, but usually this will require various accounting steps after the fact to initially pay to different vendors, and then have such payments, (ie for clearance or shipping) to be applied to costs on various items.

From a logic point of view, a Landed Cost BOM (Bill of Material) may be a good way to approach such situations.
Perhaps there could be a simple lifting of manufacturing logic into a Landed Cost update.  Hopefully not making "new items" as BOM's tend to do however.  Cost updates should be traceable still.  IE: No double costing of clearances or shipping for instance.

My 2 cents.  I realize there are many ways to accomplish the above.

Landis Arnold
Boulder, Colorado



From: "Nhomar Hernández" <nhomar@vauxoo.com>
To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
Sent: Tuesday, November 21, 2017 8:02:40 PM
Subject: Re: Landed Costs improvements in v10



On Tue, Nov 21, 2017 at 8:23 PM, Nhomar Hernández <nhomar@vauxoo.com> wrote:


On Tue, Nov 21, 2017 at 8:17 PM, Eric Caudal <eric.caudal@elico-corp.com> wrote:

Hi Nhomar,

My main problem is that the LC should be prior to the invoice but it does not need to be incompatible with your workflow:

* Option 1a: we create the invoice and link it to LC after the LC is created (invoice_id field in LC line).


​Is not this the same than simply create the invoice, pay it and then related with the LC?.

I mewn it sound like simple have a WiP landed cost until all is done no¿? If yes you can do it with our approach.​

* Option 1b: from the invoice lines we create LC accordingly: looks more difficult and incomplete (you still need to look for exact SP etc.)

* Option 2: LC is created and a wizard is launch to generate and link the invoice.


​I do not get why a wizard if you can simply create an invoice and may be add a m2o to the landed cost related, instead all a model Transient for that, but it is not complex at all , it is a really simple feature once you have the math nice.​

 


To be noted that our need is in v10, not yet v11. We would still create one separate module per function so it should not be difficult to combine the different approaches later on


​If you are interested we can pass for 10.0 (We do not need it but BTW it should not be too difficult to maintain both).​

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore)
Odoo Gold Partner // Best Odoo Partner APAC 2014 and 2016
On 11/22/2017 10:02 AM, Nhomar Hernández wrote:
<blockquote type="cite" cite="mid:CAKtu5Y6GEnJfWMx-JBZpsCFnorr4dCkCqOhdLGs22d2YJ7t4mg@mail.gmail.com">
Hello Erick.

On Tue, Nov 21, 2017 at 7:32 PM, Eric Caudal <eric.caudal@elico-corp.com> wrote:

Hi Bruno,

Actually in v7 there was an initiative for LC based on PO but later Odoo switch the LC focus on stock picking because LC can be linked to sales/purchase/internal transfers etc.

In v8 we proposed some improvements back in the Odoo days but it got stuck: https://github.com/OCA/purchase-workflow/pulls?q=is%3Apr+author%3Aduanyp1991



​Let me tell you my experience (at least on third world countries like Mexico).

The purchase process is relativity chaotic, even with the product on their way ​they are accumulated on a interim warehouse (frequently when we import from China or EEUU) and then the imported and sent container is organized with no specific relation to the purchase order.

Even if 60 or 70% comply fully with the Purchase Orders and you have all teh information for landing, what actually the Goverment Check in customs IS the content of the container, and the **Invoices** related to it, the customs agents does not care at all about the purchase order (that's just for internal control purposes).

Then we have 2 process.

1.- The picking + invoices relation (what actually landed costs does).
2.- The internal auditory (if we can call it on that way) which allow us to compare if what we asked for was what actually arrived.

About (2) What happen if they are differences?

You simply follow a return process (but the products where already imported and costed) or you make agreements with suppliers for future elements (through credit notes or reverse logistic) which IS NOT generally impacted by customs, and if they are, then you can re-use the past logic in (1) to manage that.

That was the algorithm we used and the one I understand is trying to do Odoo itself even if it is incomplete (i.e. it does not support load the actual cost from the invoices, and only works from FIFO) but conceptually the model is Ok, from my PoV.

I hope it helps you.



So IMO it should be not be linked to sale-wkf or purchase-wkf. LC is not only about transport so I would discard the stock-logistic-transport too. Probably best so far would be stock-logistics-workflow but I would even be in favor of a specific repo if we get to have enough interest in the maintenance.

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore)
Odoo Gold Partner // Best Odoo Partner APAC 2014 and 2016
On 11/21/2017 10:01 PM, Bruno JOLIVEAU | personnel wrote:
<blockquote type="cite" cite="mid:64baf0eb-f128-ea51-3d10-df9dea397719@joliveau.com">

Hi Éric,

I begin with your "one-million dollar question :-)": Last improvements were in the assigned's workflow repo. For example "purchase_landed_costs" in https://github.com/OCA/purchase-workflow

We should remember the landed cost flow matches with accounting even if we use the concept before in purchases or sales.

I had recently to look for addons about landed cost for a customer quotation on v10.

The most recent and interesting addons i found were:

https://github.com/rossasa/odoomrp-wip/tree/8.0/purchase_landed_cost

https://github.com/anhsonnt79/NEDCOFFEE/tree/master/besco_erp/besco_warehouse/general_landed_cost

Have a nice day,

Bruno JOLIVEAU

ERP Project Director @ Savoir Faire Linux
More links : bruno.joliveau.com


On 2017-11-21 03:02, Eric Caudal wrote:
<blockquote type="cite" cite="mid:5a13db56.05c6620a.ca89c.6feaSMTPIN_ADDED_BROKEN@mx.google.com">

Hi,

Is there any good improvements for the landed costs in v10?

We are thinking about:

* Automatic LC creation from PO service lines

* Creation of Vendor Bills from LC

* Currency in LC

* Reports


If nothing, we might contribute with some of it in the coming months.

The one-million dollar question: which repo? could be sale-workflow, purchase-workflow, stock-logistics-workflow, stock-logistics-warehouse, stock-logistics-transport, account-invoicing, etc...



--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Hong Kong/Shenzhen/Singapore)
Odoo Gold Partner // Best Odoo Partner APAC 2014 and 2016

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe




--

--
Nhomar Hernandez
CEO Vauxoo.
Twitter: @nhomar
Odoo Gold Partner
Skype: nhomar00 (Envia mail previo no lo superviso siempre).
Móvil Venezuela:
+58 4144110269 (Telegram)
Móvil México:
+52 1 4773933942 (Whatsapp)

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe


_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe




--

--
Nhomar Hernandez
CEO Vauxoo.
Twitter: @nhomar
Odoo Gold Partner
Skype: nhomar00 (Envia mail previo no lo superviso siempre).
Móvil Venezuela:
+58 4144110269 (Telegram)
Móvil México:
+52 1 4773933942 (Whatsapp)



--

--
Nhomar Hernandez
CEO Vauxoo.
Twitter: @nhomar
Odoo Gold Partner
Skype: nhomar00 (Envia mail previo no lo superviso siempre).
Móvil Venezuela:
+58 4144110269 (Telegram)
Móvil México:
+52 1 4773933942 (Whatsapp)

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe