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
I want to share a testimony on how Le_Meridian funding service helped me with loan of 2,000,000.00 USD to finance my marijuana farm project , I'm very grateful and i promised to share this legit funding company to anyone looking for way to expand his or her business project.the company is UK/USA funding company. Anyone seeking for finance support should contact them on lfdsloans@outlook.com Or lfdsloans@lemeridianfds.com Mr Benjamin is also on whatsapp 1-989-394-3740 to make things easy for any applicant.
ReplyDelete