Home Button  Buy Button 

Topic:   Multiple manufacturer's part numbers and BOMs

By: Ken at DTSPosted 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.

By: SupportPosted 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.

Topic:- Multiple manufacturer's part numbers and BOMs

Enter the numbers.

Your name here is optional