Inventory value on a specific Date

Posted by Mickie on January 3, 2007, 2:00 pm

Please log in for more thread options

Any way to get inventory value on a date, like Dec 31st?

I need it for taxes.

Posted by Mickie on January 4, 2007, 6:41 pm

Please log in for more thread options

.........or was I supposed to come into work on Jan 1 and run that
inventory value report?

Mickie wrote:

> Any way to get inventory value on a date, like Dec 31st?

> I need it for taxes.

Posted by Craig on January 4, 2007, 8:08 pm

Please log in for more thread options

If you have a backup from 12/31, you can restore from that backup and print
your reports. After your done, restore from a current backup. I have a
seperate system setup that I use to go back and forth between backups
Craig

> .........or was I supposed to come into work on Jan 1 and run that

> inventory value report?

> Mickie wrote:

>> Any way to get inventory value on a date, like Dec 31st?

>> I need it for taxes.

Posted by Jeff @ Check Point Software on January 4, 2007, 9:54 pm

Please log in for more thread options

: quoted-printable

Mickie,

Of course you were!!

Try this;

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

.........or was I supposed to come into work on Jan 1 and run that=20
inventory value report?

Mickie wrote:
> Any way to get inventory value on a date, like Dec 31st?
>=20
> I need it for taxes.
>=20
>
------=_NextPart_000_07BC_01C73031.C3620460
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.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Mickie,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Of course you were!!</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000>Try this;</FONT></DIV>
<DIV><FONT color=3D#008000></FONT> </DIV>
<DIV><FONT color=3D#008000><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></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>"Mickie" <<A=20
=
emoveplace.com</A>>=20
wrote in message <A=20
=
4928@TK2MSFTNGP06.phx.gbl</A>...</DIV>.........or=20
was I supposed to come into work on Jan 1 and run that <BR>inventory =
value=20
report?<BR><BR><BR>Mickie wrote:<BR>> Any way to get inventory =
value on a=20
date, like Dec 31st?<BR>> <BR>> I need it for taxes.<BR>>=20
<BR>></BLOCKQUOTE></BODY></HTML>

------=

Posted by Nashat on January 7, 2007, 9:25 am

Please log in for more thread options

try the attached script, i think it does what u need, i recommend that u run
this script while your store is closed or at least while no transactions are
being posted

> Any way to get inventory value on a date, like Dec 31st?

> I need it for taxes.

begin 666 Previous date2.sql
M:68@97AI<W1S*'-E;&5C=" J(&9R;VT@<WES;V)J96-T<R!W:&5R92!N86UE
M/2=T,2<I(&1R;W @=&%B;&4@=#$-"FEF(&5X:7-T<RAS96QE8W0@*B!F<F]M
M('-Y<V]B:F5C=',@=VAE<F4@;F%M93TG=#(G*2!D<F]P('1A8FQE('0R#0H-
M"F1E8VQA<F4@0&UY1&%T92!D871E=&EM90T*+2UP;&5A<V4@<V5T(&AE<F4@
M<B!S=&]C:PT*<V5T($!->41A=&4])S(P,#8M,#$M,#$@,# Z,# Z,# G#0H-
M"E-%3$5#5"!D:7-T:6YC="!$97!A<G1M96YT+FYA;64@05,@1&5P87)T;65N
M="P@0V%T96=O<GDN;F%M92!!4R!#871E9V]R>2Q)=&5M;&]O:W5P8V]D92Q)
M=&5M+D1E<V-R:7!T:6]N#0HL:71E;2YI9"!A<R!)=&5M240-"BQ)=&5M+E%U
M86YT:71Y+6ES;G5L;"A3=6TH26YV96YT;W)Y5')A;G-F97),;V<N475A;G1I
M='DI+# I(&%S(%%T>4=R;W-S#0II;G1O('0Q#0I&4D]-($ET96T@;&5F="!*
M3TE.($1E<&%R=&UE;G0@3TX@:71E;2YD97!A<G1M96YT:60@/2!D97!A<G1M
M96YT+FED( T*;&5F="!J;VEN(&-A=&5G;W)Y($].(&ET96TN8V%T96=O<GEI
M9" ](&-A=&5G;W)Y+FED( T*3$5&5"!*3TE.($EN=F5N=&]R>51R86YS9F5R
M3&]G($].($ET96TN240]26YV96YT;W)Y5')A;G-F97),;V<N271E;4E$( T*
M=VAE<F4@9&%T971R86YS9F5R<F5D(#X@0$UY1&%T90T*1U)/55 @0ED@86QL
M($1E<&%R=&UE;G0N;F%M92QC871E9V]R>2YN86UE+&ET96TN:71E;6QO;VMU
M<&-O9&4L271E;2Y$97-C<FEP=&EO;BQI=&5M+G%U86YT:71Y+$ET96TN240-
M"@T*<V5L96-T(&ET96TN:60@87,@:71E;6ED+&ES;G5L;"AS=6TH5')A;G-A
M8W1I;VY%;G1R>2Y1=6%N=&ET>2DL,"D@87,@471Y4V%L97,-"FEN=&@5#(-
M"F9R;VT@271E;2!L969T(&IO:6X@5')A;G-A8W1I;VY%;G1R>2!O;B!I=&5M
M+FED/6ET96UI9 T*;&5F="!J;VEN(%MT<F%N<V%C=&EO;ET@;VX@6U1R86YS
M86-T:6]N72Y4<F%N<V%C=&EO;FYU;6)E<CU4<F%N<V%C=&EO;F5N=')Y+E1R
M86YS86-T:6]N;G5M8F5R#0IW:&5R92!T:6UE(#X@0$UY1&%T90T*9W)O=7 @
M8GD@86QL($ET96TN240-"@T*<V5L96-T(&1E<&%R=&UE;G0L8V%T96=O<GDL
M:71E;6QO;VMU<&-O9&4L9&5S8W)I<'1I;VXL<71Y9W)O<W,K<71Y<V%L97,@
M87,@475A;G1I='D-"F9R;VT@=#$@:6YN97(@:F]I;B!T,@T*;VX@=#$N:71E
M;6ED/70R+FET96UI9 T*;W)D97(@8GD@9&5P87)T;65N="QC871E9V]R>2QI
-=&5M;&]O:W5P8V]D90``
`
end