« Return to Thread: Error creating supplier

Error creating supplier

by PCS-Lists :: Rate this Message:

Reply to Author | View in Thread

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?

 « Return to Thread: Error creating supplier