inventory approach -- by (bin) location or by department?

Posted by OlyBikes on December 14, 2006, 8:44 pm

Please log in for more thread options

My store is separated into different areas that we have names for. Within
each area we have items from several different Departments. Before RMS we
did physical inventory "by area" so that we would methodically "sweep"
through areas of the store, capturing what was in each area.

I can create physical inventory sheets "by area", but the problem with this
approach under RMS is that a particular item might be in more than one
location (e.g. Aisle 3 on the sales floor AND in backstock). Unfortunately,
there is only one bin location that can be specified per item. There is no
practical way of having different items for each area an item can be found
in.

Printing the physical inventory sheet "by Department" is problematic since
it entails skipping all over the store and still requires knowledge of what
is in backstock.

Is there another option I'm missing?

How do others handle this issue?

Thank you very much!

______________________________________________________

Larry Leveen
OlyBikes
Bikes, Parts, Repairs
& GREAT Customer Service!

124 State Avenue NE
Olympia, WA 98501

P: 360-753-7525
F: 360-528-7526
info@olybikes.com

www.olybikes.com
Featuring free bike advocacy and safety materials!

Posted by Jeff @ Check Point Software on December 15, 2006, 9:06 pm

Please log in for more thread options

: quoted-printable

Larry,

How about creating an additional ILC for each physical location and sell =
the one you pulled it from?

101 is your floor
101-W is your warehouse
101-B is your backstock

Each item can have stock and a different Bin location.

You also need to be careful when you are taking inventory with your =
current situation. As long as you are working on the same physical =
count sheet, you can add the same item, multiple times and they will be =
added together.

If you create a separate count sheet and count the same item in a =
different location, when you commit, it will overwrite the previous =
commit from the other count sheet.

Another option in Retail Realm's Multi-location www.retailrealm.co.uk

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment(s). If you are not using a reader, =
follow
the link below to setup Outlook Express. Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

My store is separated into different areas that we have names for. =
Within=20
each area we have items from several different Departments. Before RMS =
we=20
did physical inventory "by area" so that we would methodically "sweep" =

through areas of the store, capturing what was in each area.

I can create physical inventory sheets "by area", but the problem with =
this=20
approach under RMS is that a particular item might be in more than one =

location (e.g. Aisle 3 on the sales floor AND in backstock). =
Unfortunately,=20
there is only one bin location that can be specified per item. There =
is no=20
practical way of having different items for each area an item can be =
found=20
in.

Printing the physical inventory sheet "by Department" is problematic =
since=20
it entails skipping all over the store and still requires knowledge of =
what=20
is in backstock.

Is there another option I'm missing?

How do others handle this issue?

Thank you very much!

______________________________________________________

Larry Leveen
OlyBikes
Bikes, Parts, Repairs
& GREAT Customer Service!

124 State Avenue NE
Olympia, WA 98501

P: 360-753-7525
F: 360-528-7526
info@olybikes.com

www.olybikes.com
Featuring free bike advocacy and safety materials!

------=_NextPart_000_05DB_01C72073.C4FC85C0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Larry,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>How about creating an additional ILC for each =
physical=20
location and sell the one you pulled it from?</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>101 is your floor</FONT></DIV>
<DIV><FONT color=3D#008000>101-W is your warehouse</FONT></DIV>
<DIV><FONT color=3D#008000>101-B is your backstock</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Each item can have stock and a different Bin=20
location.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You also need to be careful when you are =
taking=20
inventory with your current situation.  As long as you are working =
on the=20
same physical count sheet, you can add the same item, multiple times and =
they=20
will be added together.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>If you create a separate count sheet and =
count the=20
same item in a different location, when you commit, it will overwrite =
the=20
previous commit from the other count sheet.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Another option in Retail Realm's =
Multi-location <A=20
href=3D"http://www.retailrealm.co.uk">www.retailrealm.co.uk</A></FONT></D=
IV>
<DIV><FONT color=3D#008000></FONT><FONT color=3D#008000></FONT><BR>-- =
<BR><BR>Jeff=20
<BR>Check Point Software</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>You must be using Outlook Express or some other type of newsgroup =
reader=20
to<BR>see and download the file attachment(s).  If you are not =
using a=20
reader, follow<BR>the link below to setup Outlook Express.  Click =
on "Open=20
with newsreader"<BR>under the MS Retail Management System on the =
right.</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"OlyBikes" <<A=20
wrote in=20
message <A=20
=
tBsx7YnZ2dnUVZ_qqrnZ2d@zhonka.net</A>...</DIV>My=20
store is separated into different areas that we have names for. Within =

<BR>each area we have items from several different Departments. Before =
RMS we=20
<BR>did physical inventory "by area" so that we would methodically =
"sweep"=20
<BR>through areas of the store, capturing what was in each =
area.<BR><BR>I can=20
create physical inventory sheets "by area", but the problem with this=20
<BR>approach under RMS is that a particular item might be in more than =
one=20
<BR>location (e.g. Aisle 3 on the sales floor AND in backstock).=20
Unfortunately, <BR>there is only one bin location that can be =
specified per=20
item. There is no <BR>practical way of having different items for each =
area an=20
item can be found <BR>in.<BR><BR>Printing the physical inventory sheet =
"by=20
Department" is problematic since <BR>it entails skipping all over the =
store=20
and still requires knowledge of what <BR>is in backstock.<BR><BR>Is =
there=20
another option I'm missing?<BR><BR>How do others handle this=20
issue?<BR><BR>Thank you very=20
=
much!<BR><BR>______________________________________________________<BR><B=
R>Larry=20
Leveen<BR>OlyBikes<BR>Bikes, Parts, Repairs<BR>& GREAT Customer=20
Service!<BR><BR>124 State Avenue NE<BR>Olympia, WA 98501<BR><BR>P:=20
360-753-7525<BR>F: 360-528-7526<BR><A=20
href=3D"http://www.olybikes.com">www.olybikes.com</A><BR>Featuring =
free bike=20
advocacy and safety materials!<BR><BR><BR></BLOCKQUOTE></BODY></HTML>

------=

Posted by OlyBikes on December 16, 2006, 2:32 pm

Please log in for more thread options

: quoted-printable

Jeff @ Check Point Software wrote:

> Larry,

>=20

> How about creating an additional ILC for each physical location and

> sell the one you pulled it from?=20

>=20

> 101 is your floor

> 101-W is your warehouse

> 101-B is your backstock

>=20

> Each item can have stock and a different Bin location.

I thought about that, but it seems problematic if I am moving items from =
one area to another. Even if I manually adjust the quantities as things =
are "brought forward" from the backstock to the sales floor, I'd be =
potentially mixing item costs incorrectly.=20

The need for multiple location within a store (at LEAST backstock and =
floor) seems pretty basic to me. I'm surprised that there is no support =
for that built into RMS. I better suggest it!

> You also need to be careful when you are taking inventory with your

> current situation. As long as you are working on the same physical

> count sheet, you can add the same item, multiple times and they will

> be added together. =20

>=20

> If you create a separate count sheet and count the same item in a

> different location, when you commit, it will overwrite the previous

> commit from the other count sheet. =20

Right. That'd be bad.

> Another option in Retail Realm's Multi-location www.retailrealm.co.uk

I'll look into it.

Thanks for trying.
______________________________________________________

Larry Leveen
OlyBikes
Bikes, Parts, Repairs
& GREAT Customer Service!

124 State Avenue NE
Olympia, WA 98501

P: 360-753-7525
F: 360-528-7526
info@olybikes.com

www.olybikes.com
Featuring free bike advocacy and safety materials!

------=_NextPart_000_0127_01C72105.E9D67E90
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2900.3020" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
How=20
about creating an additional ILC for each physical location and<BR>> =
sell the=20
one you pulled it from? <BR>> <BR>> 101 is your floor<BR>> =
101-W is=20
your warehouse<BR>> 101-B is your backstock<BR>> <BR>> Each =
item can=20
have stock and a different Bin location.<BR></DIV>
<DIV><FONT face=3DArial>I thought about that, but it seems problematic =
if I am=20
moving items from one area to another. Even if I manually adjust the =
quantities=20
as things are "brought forward" from the backstock to the sales floor, =
I'd be=20
potentially mixing item costs incorrectly. </FONT></DIV>
<DIV><FONT face=3DArial></FONT> </DIV>
<DIV><FONT face=3DArial>The need for multiple location within a store =
(at LEAST=20
backstock and floor) seems pretty basic to me. I'm surprised that there =
is no=20
support for that built into RMS. I better suggest it!</FONT></DIV>
<DIV><FONT face=3DArial></FONT> </DIV>
<DIV><FONT face=3DArial></FONT> </DIV>
<DIV>> You also need to be careful when you are taking inventory with =

your<BR>> current situation.  As long as you are working on the =
same=20
physical<BR>> count sheet, you can add the same item, multiple times =
and they=20
will<BR>> be added together.   <BR>> <BR>> If you =
create a=20
separate count sheet and count the same item in a<BR>> different =
location,=20
when you commit, it will overwrite the previous<BR>> commit from the =
other=20
count sheet.  <BR></DIV>
<DIV><FONT face=3DArial>Right. That'd be bad.</FONT></DIV>
<DIV><FONT face=3DArial></FONT> </DIV>
<DIV>> Another option in Retail Realm's Multi-location=20
www.retailrealm.co.uk<BR><BR>I'll look into it.<BR><BR><FONT =
face=3DArial>Thanks=20
for=20
trying.</FONT><BR>______________________________________________________<=
BR><BR>Larry=20
Leveen<BR>OlyBikes<BR>Bikes, Parts, Repairs<BR>& GREAT Customer=20
Service!<BR><BR>124 State Avenue NE<BR>Olympia, WA 98501<BR><BR>P:=20
360-753-7525<BR>F:=20
free bike=20
advocacy and safety materials!<BR><BR></DIV></BODY></HTML>

------=