Stock value on a given date

Posted by Philip Gass - Creative Gardens on July 3, 2007, 4:55 am

Please log in for more thread options

If i wanted to see what my stock value was on a given date, e.g. 01st July
2007 is it just a case of running an item value report for the required
date?

--
Philip Gass
Donaghadee Garden Centre

Posted by Charles on July 3, 2007, 4:46 pm

Please log in for more thread options

Philip,

I think that to get an inventory value at some time in the past you must
take the current inventory and undo all movement back to the date you wish.
I don't think you would do this in Active Reports. You could do it in
Crystal, but it would be a complicated and slow running report. I have not
tried it yet, though we could use it around here. If there is a better way
to get at this information, I would like to know it.

Charles

Posted by Marc Wagner on July 3, 2007, 6:08 pm

Please log in for more thread options

These are far from perfect options...

Periodicaly print on paper a summary report of your item value report.

Periodcaly export your item value report... and then import into a workbook
in Excel or better... load it into Access.

And... if you backup regularly... restore the file for that date... or
closest to the date... and run the movement report.

I hope these help a bit.

Marc Wagner
www.gmroii.net

> Philip,

> I think that to get an inventory value at some time in the past you must

> take the current inventory and undo all movement back to the date you

> wish.

> I don't think you would do this in Active Reports. You could do it in

> Crystal, but it would be a complicated and slow running report. I have

> not

> tried it yet, though we could use it around here. If there is a better

> way

> to get at this information, I would like to know it.

> Charles

Posted by Jim on July 6, 2007, 1:39 pm

Please log in for more thread options

Philip

Retail Realm have a module called merchandising that will do this for you.
Contact afshin@retailrealm.co.uk

Regards

Jim

> These are far from perfect options...

> Periodicaly print on paper a summary report of your item value report.

> Periodcaly export your item value report... and then import into a

> workbook in Excel or better... load it into Access.

> And... if you backup regularly... restore the file for that date... or

> closest to the date... and run the movement report.

> I hope these help a bit.

> Marc Wagner

> www.gmroii.net

>> Philip,

>> I think that to get an inventory value at some time in the past you must

>> take the current inventory and undo all movement back to the date you

>> wish.

>> I don't think you would do this in Active Reports. You could do it in

>> Crystal, but it would be a complicated and slow running report. I have

>> not

>> tried it yet, though we could use it around here. If there is a better

>> way

>> to get at this information, I would like to know it.

>> Charles

Posted by Jeff @ Check Point Software on July 19, 2007, 9:48 pm

Please log in for more thread options

: quoted-printable

Philip,

Try; http://tinyurl.com/yecfbv

Must have access to CustomerSource.
--=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/Windows Mail 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

If i wanted to see what my stock value was on a given date, e.g. 01st =
July=20
2007 is it just a case of running an item value report for the =
required=20
date?

--=20
Philip Gass
Donaghadee Garden Centre

------=_NextPart_000_010A_01C7CA35.726A6040
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.6000.16481" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Philip,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Try; <A=20
href=3D"http://tinyurl.com/yecfbv">http://tinyurl.com/yecfbv</A></FONT></=
DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Must have access to =
CustomerSource.</FONT><BR>--=20
<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/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).  If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express. =20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
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>"Philip Gass - Creative Gardens -" <<A=20
=
>=20
wrote in message <A=20
=
4688@TK2MSFTNGP04.phx.gbl</A>...</DIV>If=20
i wanted to see what my stock value was on a given date, e.g. 01st =
July=20
<BR>2007 is it just a case of running an item value report for the =
required=20
<BR>date?<BR><BR>-- <BR>Philip Gass<BR>Donaghadee Garden=20
Centre<BR><BR></BLOCKQUOTE></BODY></HTML>

------=