Community mailing list archives

community@mail.odoo.com

Re: Upload os lot numbers

by
mudoko
- 02/16/2016 07:45:12
This is the error am getting on my template yet i have used right product_id insert or update on table "stock_inventory" violates foreign key constraint "stock_inventory_product_id_fkey" DETAIL: Key (product_id)=(13160) is not present in table "product_product". at row 12


Production Team Leader

SoftlinkOptions Ltd,

Nairobi:gate 256, Rhapta Road,Mvuli road,Westlands, Nairobi.

P.O.Box - 45855 -00100, Nairobi.

Tel:+254 721449067

Email petypi@gmail.com

Mobile: +254 721449067

Website www.softlinkoptions.com


On Tue, Feb 16, 2016 at 3:37 PM, Peter Mudoko <petypi@gmail.com> wrote:
Hi guys i have realized the inventory adjustment requires  
__export__.product_product_5 and yet when i do export csv for 
line_ids/product_id/id i get the id 
__export__.product_template_59 , this export id cannot be recognized in inventory adjustments any help how to go about please working on odoo 9 community module for our company.
Peter



Production Team Leader

SoftlinkOptions Ltd,

Nairobi:gate 256, Rhapta Road,Mvuli road,Westlands, Nairobi.

P.O.Box - 45855 -00100, Nairobi.

Tel:+254 721449067

Email petypi@gmail.com

Mobile: +254 721449067

Website www.softlinkoptions.com


On Tue, Feb 16, 2016 at 12:05 PM, Peter Mudoko <petypi@gmail.com> wrote:
Hi guys i want to upload stock quantities with lot numbers into inventory but i need first i upload the lot numbers into serial numbers/lots but the system cannot allow me to upload same product id/id into lots table violation of ' foreign key constrains', how do you go about in uploading inventory quantities based on lots(batches)

Peter


Production Team Leader

SoftlinkOptions Ltd,

Nairobi:gate 256, Rhapta Road,Mvuli road,Westlands, Nairobi.

P.O.Box - 45855 -00100, Nairobi.

Tel:+254 721449067

Email petypi@gmail.com

Mobile: +254 721449067

Website www.softlinkoptions.com