after physical inventory THEN what?

Posted by OlyBikes on December 13, 2006, 6:08 pm

Please log in for more thread options

I did a physical inventory of my smallest department to test out how that
works in RMS. I had a few "deltas" which I double-checked. I set reason
codes and committed the new amounts to the database.

NOW WHAT?

Obviously, there is some entry that needs to be made in my accounting
software for those deltas. I use Quickbooks, though I do not have any
automatic posting to it set up yet (a goal for next year). How do I make an
entry to correct for the corrected inventory values?

Thanks and PLEASE Cc me directly.
______________________________________________________

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 Craig on December 14, 2006, 12:22 pm

Please log in for more thread options

After your done with your inventory, do a 'Item Movement History Report' on
the reason code you used when you did the inventory. You will need to enter
the name of the reason code in the filter, not the code#. This will give you
the total $ amount you will enter as an adjustment in QB. You will need to
do this adjustment manually, as it won't be included in any post. The
default 'Item Movement History Report' that comes with RMS doesn't give you
a $ amount,just quantity, so you will need to download 'Item Movement
History Report with Cost' from Customersource to get these totals.
Craig

>I did a physical inventory of my smallest department to test out how that

>works in RMS. I had a few "deltas" which I double-checked. I set reason

>codes and committed the new amounts to the database.

> NOW WHAT?

> Obviously, there is some entry that needs to be made in my accounting

> software for those deltas. I use Quickbooks, though I do not have any

> automatic posting to it set up yet (a goal for next year). How do I make

> an entry to correct for the corrected inventory values?

> Thanks and PLEASE Cc me directly.

> ______________________________________________________

> 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 14, 2006, 3:25 pm

Please log in for more thread options

: quoted-printable

Oly & Craig,

Actually its even easier. Go back into the Physical, print it while =
adding the Delta Cost column. Then click the Group icon once and the =
Delta Cost is now totaled. That is your inventory adjustment amount =
that you post to your accounting program.

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

After your done with your inventory, do a 'Item Movement History =
Report' on=20
the reason code you used when you did the inventory. You will need to =
enter=20
the name of the reason code in the filter, not the code#. This will =
give you=20
the total $ amount you will enter as an adjustment in QB. You will =
need to=20
do this adjustment manually, as it won't be included in any post. The=20
default 'Item Movement History Report' that comes with RMS doesn't =
give you=20
a $ amount,just quantity, so you will need to download 'Item Movement=20
History Report with Cost' from Customersource to get these totals.
Craig

>I did a physical inventory of my smallest department to test out how =
that=20
>works in RMS. I had a few "deltas" which I double-checked. I set =
reason=20
>codes and committed the new amounts to the database.
>
> NOW WHAT?
>
> Obviously, there is some entry that needs to be made in my =
accounting=20
> software for those deltas. I use Quickbooks, though I do not have =
any=20
> automatic posting to it set up yet (a goal for next year). How do I =
make=20
> an entry to correct for the corrected inventory values?
>
> Thanks and PLEASE Cc me directly.
> ______________________________________________________
>
> 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!
>
>
>=20

------=_NextPart_000_03CE_01C71F7A.F9E67650
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>Oly & Craig,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Actually its even easier.  Go back into =
the=20
Physical, print it while adding the Delta Cost column.  Then click =
the=20
Group icon once and the Delta Cost is now totaled.  That is your =
inventory=20
adjustment amount that you post to your accounting program.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV> </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> </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> </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>"Craig" <<A=20
=
pets.com</A>>=20
wrote in message <A=20
=
K2MSFTNGP06.phx.gbl</A>...</DIV>After=20
your done with your inventory, do a 'Item Movement History Report' on =
<BR>the=20
reason code you used when you did the inventory. You will need to =
enter=20
<BR>the name of the reason code in the filter, not the code#. This =
will give=20
you <BR>the total $ amount you will enter as an adjustment in QB. You =
will=20
need to <BR>do this adjustment manually, as it won't be included in =
any post.=20
The <BR>default 'Item Movement History Report' that comes with RMS =
doesn't=20
give you <BR>a $ amount,just quantity, so you will need to download =
'Item=20
Movement <BR>History Report with Cost' from Customersource to get =
these=20
totals.<BR>Craig<BR><BR>"OlyBikes" <<A=20
wrote in=20
message <BR><A=20
=
F1Gh3YnZ2dnUVZ_vamnZ2d@zhonka.net</A>...<BR>>I=20
did a physical inventory of my smallest department to test out how =
that=20
<BR>>works in RMS. I had a few "deltas" which I double-checked. I =
set=20
reason <BR>>codes and committed the new amounts to the=20
database.<BR>><BR>> NOW WHAT?<BR>><BR>> Obviously, there =
is some=20
entry that needs to be made in my accounting <BR>> software for =
those=20
deltas. I use Quickbooks, though I do not have any <BR>> automatic =
posting=20
to it set up yet (a goal for next year). How do I make <BR>> an =
entry to=20
correct for the corrected inventory values?<BR>><BR>> Thanks and =
PLEASE=20
Cc me directly.<BR>>=20
______________________________________________________<BR>><BR>> =
Larry=20
Leveen<BR>> OlyBikes<BR>> Bikes, Parts, Repairs<BR>> & =
GREAT=20
Customer Service!<BR>><BR>> 124 State Avenue NE<BR>> Olympia, =
WA=20
98501<BR>><BR>> P: 360-753-7525<BR>> F: 360-528-7526<BR>> =
<A=20
=
<A=20
href=3D"http://www.olybikes.com">www.olybikes.com</A><BR>> =
Featuring free=20
bike advocacy and safety materials!<BR>><BR>><BR>>=20
<BR><BR></BLOCKQUOTE></BODY></HTML>

------=

Posted by Craig on December 15, 2006, 9:00 am

Please log in for more thread options

Thanks for that Jeff, but I do a report on reason codes once a month so I
get the total then.
Craig
Oly & Craig,

Actually its even easier. Go back into the Physical, print it while adding
the Delta Cost column. Then click the Group icon once and the Delta Cost is
now totaled. That is your inventory adjustment amount that you post to your
accounting program.

--

Jeff
Check Point Software

=====================================================

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

After your done with your inventory, do a 'Item Movement History Report' on
the reason code you used when you did the inventory. You will need to enter
the name of the reason code in the filter, not the code#. This will give you
the total $ amount you will enter as an adjustment in QB. You will need to
do this adjustment manually, as it won't be included in any post. The
default 'Item Movement History Report' that comes with RMS doesn't give you
a $ amount,just quantity, so you will need to download 'Item Movement
History Report with Cost' from Customersource to get these totals.
Craig

>I did a physical inventory of my smallest department to test out how that

>works in RMS. I had a few "deltas" which I double-checked. I set reason

>codes and committed the new amounts to the database.

> NOW WHAT?

> Obviously, there is some entry that needs to be made in my accounting

> software for those deltas. I use Quickbooks, though I do not have any

> automatic posting to it set up yet (a goal for next year). How do I make

> an entry to correct for the corrected inventory values?

> Thanks and PLEASE Cc me directly.

> ______________________________________________________

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