I have encountered this kind of issue for the last two BAQs i need to make and I really wanted to know how to solve it.
BAQ1 - Raw Material Purchase Info
The table is consist of the following columns: Part# (Raw Material) - PO# - Order Qty - Unit Cost - lot# - Spec Info (Thickness High - Thickness Low - Temper - Width).
Supposedly, each PO# would only be associated with one set of the of the spec info and one lot# is only assigned with one PO#; but the result shows differently, one PO is relate to multiple sets of specs and one lot is with multiple POs.
Thank you very much for your help.
BAQ Issues.docx (86.9 KB)