Serial Numbers and Qty On Hand

Jan 12, 2006 5 Replies

When I started with RMS, we did not use serialized inventory. I am slowly moving to serialized inventory for two departments and have been doing it by category. I've noticed something strange, though...



Let's say I have two of a particular TV in stock. None committed, none on order. Item type = standard. Enter the item properties, change the item type to serialized, select the serial tab and enter the two serial numbers. When I click OK, the quantity changes from 2 to 4. I have to select a reason code, go back into the item properties and change the QoH back to 2--with another reason code.



Is there a way to avoid this? Can I enter serial numbers for existing inventory without changing the QoH?



Thanks, Tom


TT,

If you add your serial numbers manually instead of letting RMS create them for you, it works like you want.

But be careful with this whole thing. RMS is missing all kinds of inventory validation rules on this. Couple of examples, change a serialized back to standard and the quantity stays, but then so do the serial numbers in the database. They should be deleted when changed to a non serialized item. Now they are in never-never land.

OR

It you set your Configuration | Options | Serial # options, set serial numbers to synchronize the inventory with the same number of serial numbers. It will not deduct or even ask if you take inventory and count 6 and RMS says 10. Then will be 10 serial numbers still in the file.

OR

If you have 10 serial numbers, you can change the inventory qty to 15 on the inventory page, yet still only have 10 serial #'s

OR

Another bug I found yesterday, sell a serial number to a customer, then return it. It will change from sold back to available correctly, but the customer account number still shows in the sold to field, instead of being blanked out when returned.

I have been entering the serial numbers manually (no auto-generated serial numbers here)--and the quantity does increase. I wonder if it is tied to the 'synchronize quantity' option. I do have that feature turned on. I may try turning it off and adding a few serial numbers-just to see if my QoH changes. Once I have everything serialized, I can turn it back on.

Tom

"Jeff" wrote:

[examples snipped]

TT,

The only way I could reproduce the situation you described was to let RMS autogen the numbers, with sync on or off.

Jeff,

Are you using v1.3 or v1.2? I'm using v1.2 and I think it was you that said you'd already made the switch. I wonder if my problem is one that was fixed in the new release.

Thanks for the help,

Tom

"Jeff" wrote:

TT,

I'm using 1.3, but don't find anything about this issue in the upgrade notes.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required