Page 1 of 1

PNC's during Annual Inventory

PostPosted: Tue Nov 15, 2016 7:37 pm
by PartsPlant81
Well yet again we had our annual inventory and this time I went as far as getting a spreadsheet of all of the parts on my shelf that had a part # change and recording the cost of old part #; the new part # (what I have the part in my inventory as) and the new part # cost.
For the 44 #'s I counted the cost difference was literally $27. Since they always say "it's not the actual part #'s it's the value we are looking for..."
Well it still wasn't good enough because they put everything back to the old # again and it creates literally 2 hours of unnecessary work when I have to put everything back to the new # after inventory.
I explained that the catalog is going to give me the new part # and Auto/Mate does not show the old part # in a memo in certain parts of our system; and if it is a RIM part; RIM will re-order the new part # if it doesn't show quantity on hand or on order.
How do you guys handle this issue?

Re: PNC's during Annual Inventory

PostPosted: Tue Nov 15, 2016 7:57 pm
by Zep33
wouldn't the monthly appreciation/depreciation take care of any of the supercessions that have price changes? -

Just use a sticky note with the new # on the parts that still have the old # on them when it says you have the new # in your DMS

Re: PNC's during Annual Inventory

PostPosted: Tue Nov 15, 2016 8:01 pm
by TimK
I change the part to the new number in our system and make a new bin tag that also shows the old number.

For inventory purposes we count it as the new number.

It's your inventory, tell them how you want it counted.

Re: PNC's during Annual Inventory

PostPosted: Tue Nov 15, 2016 8:53 pm
by PartsPlant81
TimK wrote:I change the part to the new number in our system and make a new bin tag that also shows the old number.

For inventory purposes we count it as the new number.

It's your inventory, tell them how you want it counted.

I have. 5 different ways for 5 different inventories and they still end up doing the same damn thing. It is ridiculous.

Re: PNC's during Annual Inventory

PostPosted: Tue Nov 15, 2016 9:21 pm
by LOKI1
We use the new # also. We just had our inventory and it was not an issue.

Re: PNC's during Annual Inventory

PostPosted: Tue Nov 15, 2016 9:41 pm
by TimK
PartsPlant81 wrote:
TimK wrote:I change the part to the new number in our system and make a new bin tag that also shows the old number.

For inventory purposes we count it as the new number.

It's your inventory, tell them how you want it counted.

I have. 5 different ways for 5 different inventories and they still end up doing the same damn thing. It is ridiculous.


Time to have someone else count your inventory?