Error: "You must specify a valid bill for this bill revision"
When: While creating the sales order on BOM item
Reason: BOM is not created in ship from organization.
Solution: Either create a BOM in Warehouse (ship from org) entered on the order or create a common BOM in the Warehouse from the master org.
Useful Queries:
1) Extract item and organization
SELECT inventory_item_id, ship_from_org_id
FROM oe_order_lines_all
WHERE 1=1
AND line_id = :line_id
2) Check if bill is created in the warehouse
SELECT inventory_item_id, ship_from_org_id
FROM bom_bill_of_materials
WHERE 1=1
AND assembly_item_id = :inventory_item_id
AND organization_id = :ship_from_org_id
When: While creating the sales order on BOM item
Reason: BOM is not created in ship from organization.
Solution: Either create a BOM in Warehouse (ship from org) entered on the order or create a common BOM in the Warehouse from the master org.
Useful Queries:
1) Extract item and organization
SELECT inventory_item_id, ship_from_org_id
FROM oe_order_lines_all
WHERE 1=1
AND line_id = :line_id
2) Check if bill is created in the warehouse
SELECT inventory_item_id, ship_from_org_id
FROM bom_bill_of_materials
WHERE 1=1
AND assembly_item_id = :inventory_item_id
AND organization_id = :ship_from_org_id
