Historical Inventory Reporting

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

begin 666 Previous date2.sql M:68@97AI2Y1=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

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

Thanks for your quick response.

Bob

"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

Hi i tried the sql querie but all o got was

Query executed successfully:

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

thanks

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

begin 666 Custom - Item Quantity History.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

yes,can the report and document be reposted? the attachments are not available anymore.

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

Can you post this informaiton again?

Thanks

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:

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:

==

"Danny" wrote:

Koit,

I see that Ahmed helped you out.

For future reference, all posts and attachments made in this newsgroup are available on Google. Click on the "Search this newsgroup" link in my tagline. Then search for the post's subject.

--

Jeff Check Point Software

"Danny" wrote:

there the attachments, e.g. Ahmed's post at 03. apr 2008 (with the report discussed here) - I can only see Amy's question. Maybe something wrong with configuration?

About the report - I used Ahmed's information and one Jocelyn query and existing reports and compiled my own report (e.g. added the cost value that my client was interested of). I attach the report, maybe someone finds it useful.

I see that Ahmed helped you out.

For future reference, all posts and attachments made in this newsgroup are available on Google. Click on the "Search this newsgroup" link in my tagline. Then search for the post's subject.

--

Jeff Check Point Software

"Danny" wrote: