Skip to Content
  2. Mailing Lists
  3. Contributors
  4. Re: Simplified standard landed costs

Archives

Contributors

Re: Simplified standard landed costs

Re: Simplified standard landed costs

This is the identical problem to suppler rebates. Essentially the IAS2 requirement to account for full cost of inventories. I wouldn't think of it as a landed costs issue, but the more generic the purchase order price is different to the inventory valuation.

You can actually fudge this by overriding the stock move price unit in Anglo-Saxon and then just using the variance account as a kind of offset.

I did used to have an entire v7 module that handled all of these stock price adjustments on the way in. It was actually really complicated to work in with anglo saxon at the time. At v12 I tried to generalise it such that it was possible for a user to configure, as actually under Revenue accounting you have a similar issue, but at v14 it is still a work in progress.

At its guts you need to know 3 prices to make the following to happen. (Brackets are examples, there are other things to consider)

  • PO at correct price to supplier. (i.e. Purchase Price).
  • Stock receipt at Inventory price (i.e. Purchase price less expected discounts and rebates, plus costs of bring goods to current location and condition)
  • Invoice price at correct invoiced price (sometimes this is Purchase Price, sometimes it is Purchase Price less some discounts like prompt payment included on invoice)
That is the easy part explained. The trick then is in the accounting entries. As you basically need to make sure amounts are accrued to variance accounts and then offset as invoices come in.

As I say you can kind of fudge it good enough just using the standard AS price variance account if you have good accountants who understand why they are porting there, but it needs something a bit more proper. It is kind of on my list for attention in next 3-6 months, but the part you are describing is just a small subset of the inventory cost problem.

On Thu, 10 Mar 2022, 9:07 am Daniel Reis, <dreis@opensourceintegrators.com> wrote:
Thank you Pedro,

IIUC that adds a line to the PO, that will become an expense entry when you validate the invoice.

It doesn’t increase the product unit cost directly, correct?

--dr 

No dia 09/03/2022, às 19:15, Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> escreveu:


I think you can use our module https://github.com/OCA/stock-logistics-workflow/tree/13.0/stock_landed_costs_delivery that simplifies the flow at the same time that reuses existing features.

Regards.

_______________________________________________
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

by Graeme Gellatly - 12:40 - 11 Mar 2022

Reference

  • Simplified standard landed costs
    Hello,

    By now I've come up with the same requirement from two different customers.
    I wonder if there is some OCA module that can help with it.

    On purchases, we want to be able to add a per unit additional product cost, on top of the price of purchase.
    This additional cost be a thumb rule to distribute shipping costs, for example: "We know for each unit received there is  an average additional 5 cents for shipping costs".
    You can think of it as a simplified landed costs feature.
    Average Cost was being used in theses cases.

    Has anyone else come across something similar?

    Thanks

    --
    DANIEL REIS
    MANAGING DIRECTOR

    M: +351 919 991 307
    E: dreis@OpenSourceIntegrators.com
    A: Avenida da República 3000, Estoril Office B, #34

    by Daniel Reis - 08:00 - 9 Mar 2022

    5 replies 5 replies

    • Re: Simplified standard landed costs
      This is the identical problem to suppler rebates. Essentially the IAS2 requirement to account for full cost of inventories. I wouldn't think of it as a landed costs issue, but the more generic the purchase order price is different to the inventory valuation.

      You can actually fudge this by overriding the stock move price unit in Anglo-Saxon and then just using the variance account as a kind of offset.

      I did used to have an entire v7 module that handled all of these stock price adjustments on the way in. It was actually really complicated to work in with anglo saxon at the time. At v12 I tried to generalise it such that it was possible for a user to configure, as actually under Revenue accounting you have a similar issue, but at v14 it is still a work in progress.

      At its guts you need to know 3 prices to make the following to happen. (Brackets are examples, there are other things to consider)

      • PO at correct price to supplier. (i.e. Purchase Price).
      • Stock receipt at Inventory price (i.e. Purchase price less expected discounts and rebates, plus costs of bring goods to current location and condition)
      • Invoice price at correct invoiced price (sometimes this is Purchase Price, sometimes it is Purchase Price less some discounts like prompt payment included on invoice)
      That is the easy part explained. The trick then is in the accounting entries. As you basically need to make sure amounts are accrued to variance accounts and then offset as invoices come in.

      As I say you can kind of fudge it good enough just using the standard AS price variance account if you have good accountants who understand why they are porting there, but it needs something a bit more proper. It is kind of on my list for attention in next 3-6 months, but the part you are describing is just a small subset of the inventory cost problem.

      On Thu, 10 Mar 2022, 9:07 am Daniel Reis, <dreis@opensourceintegrators.com> wrote:
      Thank you Pedro,

      IIUC that adds a line to the PO, that will become an expense entry when you validate the invoice.

      It doesn’t increase the product unit cost directly, correct?

      --dr 

      No dia 09/03/2022, às 19:15, Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> escreveu:

      
      I think you can use our module https://github.com/OCA/stock-logistics-workflow/tree/13.0/stock_landed_costs_delivery that simplifies the flow at the same time that reuses existing features.

      Regards.

      _______________________________________________
      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

      by Graeme Gellatly - 12:40 - 11 Mar 2022
    • Re: Simplified standard landed costs
      Not really. This is supported by its dependencies:

      - delivery_purchase: This module allows to use the shipping methods of the core `delivery` module in purchase orders. You select one shipping method, and the price is computed from the rules, and you can also set a fixed price. But no PO line or anything more is added.
      - stock_landed_costs_purchase_auto: A landed cost associated with the PO IN picking and the purchase order will be auto-created when you confirm the PO.

      The last piece is completed with this module stock_landed_costs_delivery, that just adds an expense line in the auto-created landed cost with the delivery cost.

      Regards.
      by Pedro M. Baeza - 08:46 - 10 Mar 2022
    • Re: Simplified standard landed costs
      Thank you Pedro,

      IIUC that adds a line to the PO, that will become an expense entry when you validate the invoice.

      It doesn’t increase the product unit cost directly, correct?

      --dr 

      No dia 09/03/2022, às 19:15, Pedro M. Baeza (Tecnativa) <pedro.baeza@tecnativa.com> escreveu:

      
      I think you can use our module https://github.com/OCA/stock-logistics-workflow/tree/13.0/stock_landed_costs_delivery that simplifies the flow at the same time that reuses existing features.

      Regards.

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

      by Daniel Reis - 09:06 - 9 Mar 2022
    • Re: Simplified standard landed costs
      Daniel and Pedro,
      I have been diving into this just now as well for version 14.
      I would be happy to "help" to move this from 13.0 to 14.0 but I state up front that I have not been involved in a true OCA workflow.
      Seems like these things move pretty well.  I am a integrating machine (but not a runbot).

      The standard "Odoo way" is outlined here:
      https://www.odoo.com/documentation/14.0/applications/inventory_and_mrp/inventory/management/reporting/integrating_landed_costs.html

      Landis Arnold

      Nomadic Inc.
      Niwot, CO USA

      From: "Pedro M. Baeza (Tecnativa)" <pedro.baeza@tecnativa.com>
      To: "Odoo Community Association, (OCA) Contributors" <contributors@odoo-community.org>
      Sent: Wednesday, March 9, 2022 12:15:30 PM
      Subject: Re: Simplified standard landed costs

      I think you can use our module https://github.com/OCA/stock-logistics-workflow/tree/13.0/stock_landed_costs_delivery that simplifies the flow at the same time that reuses existing features.

      Regards.

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


      by Landis Arnold - 09:05 - 9 Mar 2022
    • Re: Simplified standard landed costs
      I think you can use our module https://github.com/OCA/stock-logistics-workflow/tree/13.0/stock_landed_costs_delivery that simplifies the flow at the same time that reuses existing features.

      Regards.
      by Pedro M. Baeza - 08:06 - 9 Mar 2022