Back to the basics

[CTB]

When submitting a return we've all been taught since the dawn of time to look at MNS (months no sales.) I've been taking a different approach & I'm curious as to how everyone else (except Randy's wife) feels about this. I look closely at MNR (months no receipts) before MNS. Here's a hypothetical to explain my thinking: Let's say a part # has been sitting in the system for 16 months with zero O.H. & we special order one in. It turns out the part doesn't actually get sold so into stock it goes. 2 months later when I pull up a return, per CDKs logic, that part has 1 O.H. & 18 MNS, therefore it should be returned. This completely disregards the fact that the part has been on the shelf for only 2 months. My fix for this is a spread sheet I built in RPX that allows me to manipulate all of this data to get rid of the truly oldest inventory. Would anyone care to offer feedback on this? I'm interested in any & all suggestions, thoughts & opinions.
Thanks & remember, drink responsibly.

[Zep33]

I posted just last week about this in one of the Automate threads. I can't stand that CDK logic either. Here's how I deal with it in more detail:

We are held accountable for our parts over 12 and they put the value into a reserve that counts against the department so I typed this up a few months ago... YMMV

If there is a part number on file (in the CDK system) and you order that part, the MNS date will revert back to the last time you actually sold that part, even if you haven’t had it in a very long time. You don’t even have to have ever sold the part for this to be an issue. Just adding the part in to do a price quote will do this. I believe it may stay in the system as long as 36 months unless you control that number yourself. So you could purchase a part today and the MNS could actually say 36 months until you sell that part.

One way to counteract that is to stay on top of those numbers. What I do is on the last day of each month, I take all NS and parts with either no bin or SOR bin and ZERO on hand AND ZERO on order with 11 months no sale and put them on delete status. At midnight, those part numbers will be deleted and if you now purchase a part, the MNS will start the day you purchase it, not 2 or 3 years ago when you last sold it or added it.

The reason I wait until the last day of the month is CDK does not seem to like part #s on delete status that have not yet been actually deleted. IRE orders can hassle you and not see the part unless you take it off delete status first. That can be a headache for whoever is putting in an order unless they fully understand what is happening. I've found t’s just best to wait until the afternoon on the last day of the month to avoid any issues. There's some known "defect" with CDK where if there's no unit price or something, it can mess up your whole order and not roll your SORs into the order. CDK can fix it as they know all about it. For m,e it's always happened with parts either on delete status or recently removed from delete status.

Also keep in mind, you will lose your phase in/out records for that part once it is deleted. But I think if you hadn’t sold it in 11+ months, it wasn’t worth stocking anyway.



HOW TO:

RPG – arrow up 2 spaces to “ENG Enter English”

After ? type – SELECT PART-NO. WITH O.H. = “0” AND WITH O.O. = “0” AND WITH MNS GE “11”
Press enter TWICE and you will see the total # of parts
After the > type – SAVE-LIST PM-BATCH-LIST

Now go to PART MAINTENANCE (PM)
Choose “Batch-change”, F5(Use Save List) and choose the top one (PM-BATCH-LIST), click GO
Popup will show you the # of parts selected (should match what RPG told you), press F3 to exit

Now your parts are loaded so arrow down to Special Status, type DEL in the box and press F3 again to start, leave CONTINUE checked and click OK

[CTB]

That's a lot of good info. I like the idea of house cleaning at end of the month. Having extended part # history has its advantages for sure. If, however, someone who doesn't understand the ins & outs of PI/PO in CDK (& you all know of whom I speak) was to see an MNS report, that person could easily draw some very inaccurate & potentially detrimental conclusions. Thanks for the help.

[Zep33]

The history will still be there under PDA if needed. It's just that the numbers will have to be added again next time they come up. Which will start the clock over again, as it should be doing without any help from me LOL

Phase in/out shouldn't matter after a year of no sales anyway. It sure doesn't to me.

I just like to keep everything really clean and this works great for me.

I've actually got 3 brake pad #s right now from last April that we added but never purchased until this year showing 12 MNS and obsolete. That shit really pisses me off.

[Zep33]

It looks like the latest update from CDK - 2.12 has addressed this...

see the last sentence:

"Calculate Months No Sale by Shelf Life (MSDA)
The Months No Sale (MNS) for a part starts accumulating when the part was added to
the Parts file. The MNS increases each month unless the part is sold, which resets the
MNS to zero. The MNS is used with the phase-out setups in Replenishment Options
(IRO) to determine when a stocking part begins to phase out of the active parts file, or it
can be used in Multiple Stock Return (MSR) for selecting parts to be returned to the
manufacturer.
Previously, the MNS was reset to zero only when the part was sold. This didn’t take into
consideration parts that were added to the file but not stocked until they were needed.
Those parts could phase out before they were expected to.
A new option in Set Up Dealer Accounts (MSDA) allows the Parts department to
calculate MNS by shelf life, restarting the MNS calculation when the part is stocked. The
new prompt is RESET MNS WHEN PART WITH 0 ON-HAND IS RECEIPTED (Y/N) ?
„ No is the default – the MNS is reset only when the part is sold.
„ Yes turns on MNS calculation by shelf life – the MNS is reset when the part is sold,
OR if the part is receipted when the part’s on-hand quantity is 0."

[TimK]

Thanks, just turned it on.

[CTB]

That's exactly what's needed. Apparently, though, I don't have that version of CDK. I don't see that prompt. Oh well, so what's new?

[Zep33]

That's exactly what's needed. Apparently, though, I don't have that version of CDK. I don't see that prompt. Oh well, so what's new?

maybe it's still rolling out - we got it last week but I didn't get around to reading the readme pdf until yesterday



Give them a call or open up a case in Service Connect

[dgalietti]

GM is a little bit complicated when it comes to actual obsolescence..

I build my own spreadsheet using a CDK report and combining it with the "Rim Protection KPI" which I have sent to my email.

Then I have a yearly aging spreadsheet that I update all of the info with.

It is time consuming and a little complicated, but a very helpful tool.

For me I count MNS12+ with MNR 4+ minus the RIM protected parts.

-David

[dbuck]

It just rolled out with the latest update. I was able to reset that just this morning for the first time.