Purchase and Track Landed Costs
| Technical name | to_purchase_landed_cost |
| License | OPL-1 |
| Website | https://viindoo.com/apps/app/16.0/to_purchase_landed_cost |
| Read description for | v 10.0 v 11.0 v 12.0 v 13.0 v 14.0 v 15.0 |
| Required Apps | Purchase (purchase) Invoicing (account) Discuss (mail) Inventory (stock) |
| Included Dependencies | Stock Move & Account Move Links |
The problems
By default, Odoo's Stock landed cost app only provides inventory cost allocation methods for storable products, but cannot track or manage landed costs per purchase order (PO). For example, when you purchase product A, you may need to purchase transportation services from another vendor. In this case, if you want to manage such information, you will need to:
- Create 2 PO;
- Receive product A;
- Open the second purchase order to record the transportation cost;
- Create a landed cost to allocate the cost of the transportation service to product A.
Afterward, after thousands of landed cost lines, how can you tell which ones are related?
The Solution
This app was developed to solve the above problem by providing the needed features to ensure that:
- Landed cost can be auto-generated when you confirm a PO that has landed costs;
- You can create landed cost from landed cost bills;
- Everything landed cost-related is traceable, e.g. landed cost adjustment, landed cost PO, landed cost bills, original PO, journal items for the landed cost account, etc.
Editions Supported
- Community Edition
- Enterprise Edition
Installation
- Navigate to Apps.
- Search with keyword to_purchase_landed_cost.
- Press Install.
Instruction
Instruction video: Purchase and Track Landed Costs
1. Activate the feature
Navigate to Inventory > Configuration > Settings, activate the Landed Costs feature and press Save to save the information.
2. Set up Landed cost for a product
Create the Transportation cost with the following information:
- Product type: Service;
- On the Purchase tab:
- Set up vendor information, quantity, and price;
- Check on Is a Landed Cost;
- Default Split Method: How the landed cost is split to the cost of the stocks. The system supports the 5 splitting methods: Equal, By Quantity, By Current Cost, by weight, and by volume;
- Control Policy: On order quantities.
Press Save to save the information.
Go to the product list, select the product that needs to add the landed cost, at the Purchase Landed Costs tab, press Add a line and then select the Transportation cost product and check on Auto-Purchase.
3. Create a purchase order for the product and landed cost
Navigate to Purchase > Orders > Requests for Quotation, press Create to create a purchase order Press Confirm Order, the system will auto-create a purchase order and add the vendor of this service.
Proceed with the inventory receipt and create the vendor bills for the purchase order. For the landed cost purchase order, you also create the vendor bill.
4. Split the landed cost
On the bill that has the landed cost, press Create Landed Cost. The system will auto-create the landed cost sheet and auto-recognize the receipt to split. Check the landed cost, the split method and press Validate.
Press the Valuation button to check, you can see the cost of the transportation will be added to the inventory cost.
Return to the landed cost bill, confirm, and proceed with the payment. On the purchase order view, you can track the information relating to the cost, and landed cost applied for this purchase order.
5. Check the product's inventory valuation
Navigate to Inventory > Reporting > Inventory Valuation, and group by the product to see the updated cost.
This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file).
You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one).
It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software.
The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.