RE: Quick BPCS question

["Angela Wawrzaszek(EXCH)" <wawrzaszeka@xxxxxxxxxxx>]

last date on ili should be the last time inventory was affected, and ttdte
on ith is the date the transaction occurred.  If you are trying to do a
query though that will show you the inventory on a certain day in the past
you will not be able to do it, you can only get the inventory as of right
now.

Angie Wawrzaszek
M.I.S. Department


-----Original Message-----
From: L. S. Russell [mailto:leslier@datrek.com]
Sent: Friday, June 16, 2000 2:13 PM
To: MIDRANGE-L@midrange.com
Subject: Quick BPCS question


I know you will know the answer to this!
We are trying to look at Inventory on hand, issues and receipts and we
have a big question. 
We need to be able to restrict this query to a date range and we can't
figure out which of the date fields in the ILI and ITH are the
transaction date. The text isn't much help.

--
L. S. Russell Programmer/Analyst
Datrek Professional Bags, Inc.
2413 Industrial Drive
Springfield, TN. 37172
mailto:leslier@datrek.com
http://www.datrek.com
--
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---