Last Buy Date

The BOMs for part numbers PH659920 and PH659921 are nearly identical. However, the “Last Buy Date” is showing up on the parts for PH659920 and it isn’t showing up for the same parts that are listed on PH659921.

Also, the last buy date is not always accurate. On assembly PH659920, part number S10132 has a last buy date of 4/3/25, but on assembly PH659923, the same part, S10132, has a last buy date of 9/13/23

Hi @patg

To answer the first part of your question, the “Last Buy Date” isn’t showing up for the parts on PH659921 because you have a different revision pulling.

On BOMPH659920, PRTS10092 is showing a ‘Last Buy Date’ of 2025-03-10, but notice that it is pulling from REV B:

On BOMPH659921, PRTS10092 is showing a ‘Last Buy Date’ of nothing, but notice that it is pulling from REV “BLANK”, not REV B.

Drill into the Revision page for PRTS10092 and notice you have two revisions, Blank and B:

If you update your Revision appropriately, the ‘Last Buy Date’ will pull through appropriately as you are expecting.

In regards to your second question, it’s the exact same principle at play here. PRTS10132 has two revisions, “REV BLANK” and “REV A.”

I would recommend doing some data cleanup here to ensure that the Revisions you want pulling on your BOM Overview screen matches the data you’re looking for.

Hope this helps.

  • Cetec ERP Support

We do have a blank rev and a Rev B for part number S10092. However, the blank rev is set to “obsolete” and this part has only ever been bought as Rev B. There is a note in CETEC that says when the revision is “unset” it will automatically use the newest revision. So if the blank revision is “obsolete” and never have been used or purchased, then why would the last buy date grab that for some assemblies? Shouldn’t it automatically grab from the current revision and not the obsoleted revision? Does this mean that any time we rev up a part, we have to delete the old revisions? We would lose the history of the old revisions then.

Hi @patg,

You’re absolutely right, Rev B is the only revision that’s ever been used for purchasing S10092, and the blank Revision is currently marked as “obsolete.”

One thing to keep in mind is that while the system generally uses the most recent revision when older ones are unset, the BOM Overview behaves a bit differently. That view won’t automatically reflect newer revisions. Instead, it shows whatever revision was initially selected when the BOM was created or imported. So, to ensure the correct revision is displaying, you’ll need to manually update those settings. Cetec doesn’t make that change automatically.

With that in mind, my suggestion still stands: it might be helpful to do a bit of data cleanup. For example, when I click into the “Rev Blank” for the Component Labor Plan of S10092 there’s nothing populated there. If those blank revisions aren’t serving a purpose, you might consider removing them to reduce clutter. In our experience, these often come from incomplete or incorrect BOM imports and can sometimes get in the way.

Of course, I’m not suggesting you remove every obsolete revision, but tidying up any unused or empty entries could make things a lot clearer and easier to manage moving forward.

Please let me know if you’d like help with that or if there’s anything else I can clarify!

  • Cetec ERP Support