Inventory valuation report

Posted by ccycle on July 11, 2006, 4:29 pm

Please log in for more thread options

When I run an inventory valuation report, it seems to pull the cost
associated for each item from the item properties, not from costs entered on
purchase orders. For our inventory, we have items we bough at booking prices
early in the season and items we bought on regular prices later in the
season. We need to have the item properties reflect the higher cost but that
inflates our inventory valuation report. Is there a way to have the report
draw the costs paid for each item by PO instead of the cost entered when we
created each item? Otherwise that report really is not accurate at all.

Posted by Jeff on July 11, 2006, 6:25 pm

Please log in for more thread options

: quoted-printable

CCycle,

The program does not keep track of costs this way.

Your options are listed in SO Manager | File | Configuration | Inventory =
tab

None, Weighted Average or Last Cost. =20

You should look at Help in that screen to describe the differences, but =
most hard goods probably use Weighted Average.
--=20
*
Get Secure! - www.microsoft.com/security

You must be using Outlook Express or some other type of newsgroup reader =
to
see and download the file attachment. 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

**********

When I run an inventory valuation report, it seems to pull the cost=20
associated for each item from the item properties, not from costs =
entered on=20
purchase orders. For our inventory, we have items we bough at booking =
prices=20
early in the season and items we bought on regular prices later in the =

season. We need to have the item properties reflect the higher cost =
but that=20
inflates our inventory valuation report. Is there a way to have the =
report=20
draw the costs paid for each item by PO instead of the cost entered =
when we=20
created each item? Otherwise that report really is not accurate at =
all.
------=_NextPart_000_0506_01C6A4FE.4E700350
Content-Type: text/html;
charset="utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>CCycle,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>The program does not keep track of costs this =

way.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Your options are listed in SO Manager | File =
|=20
Configuration | Inventory tab</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>None, Weighted Average or Last=20
Cost.  </FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>You should look at Help in that screen to =
describe the=20
differences, but most hard goods probably use Weighted =
Average.</FONT></DIV>
<DIV>-- <BR>*<BR>Get Secure! - <A=20
href=3D"http://www.microsoft.com/security">www.microsoft.com/security</A>=
</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.  If you are not using a =
reader,=20
follow<BR>the link below to setup Outlook Express.  Click on "Open =
with=20
newsreader"<BR>under the MS Retail Management System on the right.</DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><A =
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV>**********<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"ccycle" <<A=20
=
soft.com</A>>=20
wrote in message <A=20
=
B23C1-4BC3-4CBF-9816-B5526A553D22@microsoft.com</A>...</DIV>When=20
I run an inventory valuation report, it seems to pull the cost =
<BR>associated=20
for each item from the item properties, not from costs entered on =
<BR>purchase=20
orders.  For our inventory, we have items we bough at booking =
prices=20
<BR>early in the season and items we bought on regular prices later in =
the=20
<BR>season.  We need to have the item properties reflect the =
higher cost=20
but that <BR>inflates our inventory valuation report.  Is there a =
way to=20
have the report <BR>draw the costs paid for each item by PO instead of =
the=20
cost entered when we <BR>created each item?  Otherwise that =
report really=20
is not accurate at all.</BLOCKQUOTE></BODY></HTML>

------=