Now for a useful comment. What about special pricing from a supplier due to, for example, a contract with the supplier and customer? Normally, the flow goes just like you demonstrated in this video. But what happens when I can purchase supplies at a lower cost because I'm selling those supplies to a specific customer? (Why the supplier would offer a lower cost is not significant to the scenario.) With Odoo's strict FIFO system, a sale to my special pricing customer is not guaranteed to use the supplies purchased for them. Instead, it evaluates at FIFO. Other ERP systems handle this by keeping track of reservations between SO and PO: when a PO is made from an SO, and cost is manually changed on the PO, the system will use the cost from that PO when fulfilling the SO. Without taking this into account, margins get all out of whack. One SO could look like it lost money while another SO could look like it made a larger-than-usual profit. This is currently holding us back from adoptiong Odoo but the last time I tested this was about nine months ago. Has anything changed?
Hey there, thanks for the in-depth question. :) The solution to this would actually be doable! It is a mix of some configuration and analytic accounts to keep track of purchases bought for a specific customer. The margins will take into account the cost on the products template. I know this isn't the most exact solution however this could help you keep track of it for a specific project/scenario/customer. If possible, for a more concrete solution could you email me direct: jorc@odoo.com so I can chat with you more about this? Let me know. ( Anyone can if they have super specific questions. If I can't find you a solution I know many smarter people who can :) )
This is great and all but what about new customers to Odoo that already use FIFO. Apparently it is not possible to import your FIFO inventory/costs into Odoo. Odoo themselves say you just need to average your costs then Odoo can do FIFO from there on. That is just not acceptable. Sad the sales guys sell the world until it comes to implementation. We cannot be the only ones with this need/issue. (Tried moving from Fishbowl just to find Odoo has different limitations - they take ~$70,000+ and just say, " *all sales are final* ")
Now for a useful comment.
What about special pricing from a supplier due to, for example, a contract with the supplier and customer?
Normally, the flow goes just like you demonstrated in this video. But what happens when I can purchase supplies at a lower cost because I'm selling those supplies to a specific customer? (Why the supplier would offer a lower cost is not significant to the scenario.) With Odoo's strict FIFO system, a sale to my special pricing customer is not guaranteed to use the supplies purchased for them. Instead, it evaluates at FIFO.
Other ERP systems handle this by keeping track of reservations between SO and PO: when a PO is made from an SO, and cost is manually changed on the PO, the system will use the cost from that PO when fulfilling the SO.
Without taking this into account, margins get all out of whack. One SO could look like it lost money while another SO could look like it made a larger-than-usual profit.
This is currently holding us back from adoptiong Odoo but the last time I tested this was about nine months ago. Has anything changed?
Hey there, thanks for the in-depth question. :)
The solution to this would actually be doable! It is a mix of some configuration and analytic accounts to keep track of purchases bought for a specific customer. The margins will take into account the cost on the products template. I know this isn't the most exact solution however this could help you keep track of it for a specific project/scenario/customer. If possible, for a more concrete solution could you email me direct: jorc@odoo.com so I can chat with you more about this? Let me know.
( Anyone can if they have super specific questions. If I can't find you a solution I know many smarter people who can :) )
This is great and all but what about new customers to Odoo that already use FIFO. Apparently it is not possible to import your FIFO inventory/costs into Odoo. Odoo themselves say you just need to average your costs then Odoo can do FIFO from there on. That is just not acceptable. Sad the sales guys sell the world until it comes to implementation. We cannot be the only ones with this need/issue. (Tried moving from Fishbowl just to find Odoo has different limitations - they take ~$70,000+ and just say, " *all sales are final* ")
ZAA t
First.