Topic: Multiple manufacturer's part numbers and BOMs
By: Ken at DTS
Posted on: Sep 20 2023 at 08:53:52 AM
Could the process MRP uses to populate the dbo.itemsupplier's "MfrPNo" column that (I presume) is shown on the Assembly Editor screen and BOM CSV export be shared?
In ItemDetail screen, a part can have the same manufacturer listed more than once. We use this to track a manufacturer's old and new Supplier PartNo's. Here is a simple example: In the ItemDetail screen...
DefaultSupplier Company x Supplier PartNo
(checked) McMaster-Carr MFR 91780A162
(unchecked) McMaster-Carr MFR 91780A720 (OBSOLETE)
...but the Assembly Editor and BOM CSV file both report the obsolete part.
I've testing the following ideas but I can't find a pattern for how dbo.itemsupplier's "MfrPNo" column is populated:
1. The order in which each Supplier record was added to the ItemDetail screen (noted by the dbo.tblstockitems's AutoID field).
2. Unchecking/saving/re-checking/saving Default Supplier selection.
I'm not asking for a change to MiniMRP but only for information to help us develop internal procedures such that the Assembly Editor screen and BOM CSV export not show obsolete manufacturer's part numbers.
Posted on: Sep 21 2023 at 04:44:05 AM
Ken. That's strange. There should only be one row with the "MFR" set.
If you have two rows set then it looks like a glitch that's showing MFR by any row that contains that exact company name. We need to fix that.
In the meantime, to confirm my understanding of the problem, please email a screenshot of the Item detail window.
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.