Date and Qty

A

Arlan

I was wondering if anyone has a possible solution to the
following. I have a table that holds Item Information, a
Table that holds Inventory Information (At the Location
Level, therefore any given item could have multiple
locations)and a table that holds Purchasing information.
(Qty,Date Received etc...) All this data is stored either
in a Oracle Database or on our as400. What I need to do
is pull a certain group of items, and show the received
date for the total quantity on hand for each item. My
Inventory table holds my location info as well as received
date info, the problem is if I receive the same item every
day, the received date is updated with the most current
date, even though there is quantity left over from a
earlier date.

My AS400 has the table that show each time an item was
recvd, the qty rcvd and the date it was rcvd. What I need
to do is pull the group of items (easy part), and somehow
show based on the quantity I have on hand the different
recvd dates for that item.

for example:

Item 1234567 has 5 cases on hand. I recvd 2 cs of this
item on 7/11 and 1 cs on 7/12 and 3 cs on 7/14. I would
like to show the data in a report similar to this...

Item# QTY Rcvd Dates:
1234567 5 3cs 7/14
1cs 7/12
1cs 7/11

Thanks for the help....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top