Serial Numbers and Qty On Hand

Posted by Terrible Tom on January 12, 2006, 5:43 pm

Please log in for more thread options

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
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.

Posted by Jeff on January 12, 2006, 9:51 pm

Please log in for more thread options

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.
--
*
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
--
The worst words in business:
"We''ve always done it that way"
--
Stop Fishing for eMail.

Posted by Terrible Tom on January 13, 2006, 11:46 am

Please log in for more thread options

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:

> TT,

> If you add your serial numbers manually instead of letting RMS create them

> for you, it works like you want.

[examples snipped]

> 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

> --

> The worst words in business:

> "We''ve always done it that way"

> --

> Stop Fishing for eMail.

Posted by Jeff on January 13, 2006, 2:17 pm

Please log in for more thread options

TT,

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

--
*
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:

> TT,

> If you add your serial numbers manually instead of letting RMS create them

> for you, it works like you want.

[examples snipped]

> 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

> --

> The worst words in business:

> "We''ve always done it that way"

> --

> Stop Fishing for eMail.

Posted by Terrible Tom on January 13, 2006, 3:53 pm

Please log in for more thread options

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,

> The only way I could reproduce the situation you described was to let RMS

> autogen the numbers, with sync on or off.

> --

> *

> 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:

> > TT,

> >

> > If you add your serial numbers manually instead of letting RMS create them

> > for you, it works like you want.

> [examples snipped]

> >

> > 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

> > --

> > The worst words in business:

> > "We''ve always done it that way"

> > --

> > Stop Fishing for eMail.