Historical Inventory Reporting

Posted by RMG on May 19, 2007, 10:34 am

Please log in for more thread options

I want to be able to report my inventory levels and cost at any point in
time. Does anyone have any ideas?

The only way I have been able to get this is to remember to run a report
monthly and archive them. There has to be an easier way.

Thanks!!

RMG

Posted by Craig on May 19, 2007, 12:09 pm

Please log in for more thread options

Here is a querie someone posted. I have never used it but it should do what
you want.
Craig

>I want to be able to report my inventory levels and cost at any point in

> time. Does anyone have any ideas?

> The only way I have been able to get this is to remember to run a report

> monthly and archive them. There has to be an easier way.

> Thanks!!

> RMG

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

Posted by RMG on May 19, 2007, 1:09 pm

Please log in for more thread options

Craig, Was there supposed to be an attachment or a link? I did not find
anything...

Thanks for your quick response.

Bob

"Craig" wrote:

> Here is a querie someone posted. I have never used it but it should do what

> you want.

> Craig

> >I want to be able to report my inventory levels and cost at any point in

> > time. Does anyone have any ideas?

> >

> > The only way I have been able to get this is to remember to run a report

> > monthly and archive them. There has to be an easier way.

> >

> > Thanks!!

> >

> > RMG

Posted by Craig on May 19, 2007, 1:31 pm

Please log in for more thread options

Bob,
You need to be using a newsreader like Outllok Express to view and download
attachments. Find a post by Jeff @ Checkpoint Software and follow the
instructions in his tagline on how to set it up. You will get a lot more out
of this newsgroup if you don't use the web interface and instead use a
newsreader.
Craig

> Craig, Was there supposed to be an attachment or a link? I did not find

> anything...

> Thanks for your quick response.

> Bob

> "Craig" wrote:

>> Here is a querie someone posted. I have never used it but it should do

>> what

>> you want.

>> Craig

>> >I want to be able to report my inventory levels and cost at any point in

>> > time. Does anyone have any ideas?

>> >

>> > The only way I have been able to get this is to remember to run a

>> > report

>> > monthly and archive them. There has to be an easier way.

>> >

>> > Thanks!!

>> >

>> > RMG

Posted by RMG on May 19, 2007, 2:36 pm

Please log in for more thread options

Got it! Thanks!

"Craig" wrote:

> Bob,

> You need to be using a newsreader like Outllok Express to view and download

> attachments. Find a post by Jeff @ Checkpoint Software and follow the

> instructions in his tagline on how to set it up. You will get a lot more out

> of this newsgroup if you don't use the web interface and instead use a

> newsreader.

> Craig

> > Craig, Was there supposed to be an attachment or a link? I did not find

> > anything...

> >

> > Thanks for your quick response.

> >

> > Bob

> >

> > "Craig" wrote:

> >

> >> Here is a querie someone posted. I have never used it but it should do

> >> what

> >> you want.

> >> Craig

> >>

> >> >I want to be able to report my inventory levels and cost at any point in

> >> > time. Does anyone have any ideas?

> >> >

> >> > The only way I have been able to get this is to remember to run a

> >> > report

> >> > monthly and archive them. There has to be an easier way.

> >> >

> >> > Thanks!!

> >> >

> >> > RMG

> >>