Error creating supplier
Nathan,
perp svn 3345. In AP>>supplier>>new supplier I put supplier id and name. When I click save this happens:
Database error
Invalid SQL: SELECT count(supplier_code) AS count
FROM perp_supplier_stock LEFT JOIN perp_stock
ON (perp_stock.stock_id = perp_supplier_stock.stock_id)
LEFT JOIN perp_unit_of_measure AS stock_uom ON
perp_stock.unit_of_measure = stock_uom.uom_id LEFT JOIN egw_categories
ON (perp_stock.stock_category = egw_categories.cat_id )
LEFT JOIN perp_unit_of_measure AS supplier_uom ON
perp_supplier_stock.supplier_uom = supplier_uom.uom_id
LEFT JOIN (
SELECT
stock_id,
sum(quantity_on_hand) AS total_on_hand
FROM perp_location_stock
GROUP BY stock_id
) AS total_inventory ON
total_inventory.stock_id = perp_supplier_stock.stock_id
NATURAL JOIN perp_supplier WHERE supplier_id='2' AND (perp_stock.status_flag IN ('E', 'P') OR perp_stock.status_flag IS NULL ):
Column 'supplier_id' in where clause is ambiguous
What does it mean?