Historical Inventory Reporting

Posted by Thomas Eubank on December 26, 2007, 5:52 pm

Please log in for more thread options

This is exactly the kind of information that I am looking for at the end of
the year.

If this can be reposted I would apperciate it.

Thanks
--
Thomas Eubank
System Administrator
Statewide Beverage LLC.

"Robby Hill" wrote:

> yes,can the report and document be reposted? the attachments are not

> available anymore.

> >I am needing this too - i can't get this message to show up in the outlok

> > newsreader (only get 2597 messages). hopefully this reply gets it to show

> > up.

> >

> > "hozay" wrote:

> >

> >> thanks a million

> >> works great

> >>

> >> "Ahmed Nashat" wrote:

> >>

> >> > Either run the last "select" statement alone, or use the attached RMS

> >> > report, i had to make it in RMS report coz i felt that people r not

> >> > happy

> >> > using the query i prepared

> >> >

> >> > Nashat

> >> >

> >> > > Hi

> >> > > i tried the sql querie but all o got was

> >> > >

> >> > > Query executed successfully:

> >> > >

> >> > > 2701 records(s) affected.

> >> > >

> >> > > Nothing else. is there another step to see the item list

> >> > >

> >> > > thanks

> >> > >

> >> > > "RMG" wrote:

> >> > >

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

> >> > >> > >>

> >> > >> >

> >> >

Posted by Koit Lahesoo on April 1, 2008, 1:57 am

Please log in for more thread options

I post a note here too to make it be in line with originial posts.

Can anyone post that query/report again to be available next 90 days for
Outlook readers! Or even post it in plain text to be available for copying
from web reader.
Thanks,
Koit

"Thomas Eubank" wrote:

> This is exactly the kind of information that I am looking for at the end of

> the year.

> If this can be reposted I would apperciate it.

> Thanks

> --

> Thomas Eubank

> System Administrator

> Statewide Beverage LLC.

> "Robby Hill" wrote:

> > yes,can the report and document be reposted? the attachments are not

> > available anymore.

> >

> > >I am needing this too - i can't get this message to show up in the outlok

> > > newsreader (only get 2597 messages). hopefully this reply gets it to show

> > > up.

> > >

> > > "hozay" wrote:

> > >

> > >> thanks a million

> > >> works great

> > >>

> > >> "Ahmed Nashat" wrote:

> > >>

> > >> > Either run the last "select" statement alone, or use the attached RMS

> > >> > report, i had to make it in RMS report coz i felt that people r not

> > >> > happy

> > >> > using the query i prepared

> > >> >

> > >> > Nashat

> > >> >

> > >> > > Hi

> > >> > > i tried the sql querie but all o got was

> > >> > >

> > >> > > Query executed successfully:

> > >> > >

> > >> > > 2701 records(s) affected.

> > >> > >

> > >> > > Nothing else. is there another step to see the item list

> > >> > >

> > >> > > thanks

> > >> > >

> > >> > > "RMG" wrote:

> > >> > >

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

> > >> > >> > >>

> > >> > >> >

> > >> >

> >

Posted by Thomas Eubank on December 28, 2007, 6:01 am

Please log in for more thread options

Can you post this informaiton again?

Thanks
--
Thomas Eubank
System Administrator
Statewide Beverage LLC.

"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 Danny on December 28, 2007, 10:41 am

Please log in for more thread options

Yes, would like to sql or report posted again...
Thanks
Danny

> Can you post this informaiton again?

> Thanks

> --

> Thomas Eubank

> System Administrator

> Statewide Beverage LLC.

> "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 Koit Lahesoo on March 31, 2008, 7:20 am

Please log in for more thread options

Can anyone post that query/report again to be available next 90 days for
Outlook readers! Or even post it in plain text to be available for copying
from web reader.
Thanks,
Koit

"Danny" wrote:

> Yes, would like to sql or report posted again...

> Thanks

> Danny

> > Can you post this informaiton again?

> >

> > Thanks

> > --

> > Thomas Eubank

> > System Administrator

> > Statewide Beverage LLC.

> >

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

> >>