Archives
Contributors
Simplified standard landed costs
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
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
Follow-Ups
-
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?--drNo 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
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