I have an inventory database I'm working on, and want to allocate inventory based on ship date. For example
Part Date Qty On Order Qty On Hand Adjusted On Hand
ABC 10/30/08 5 6 1
DEF 10/30/08 1 4 3
ABC 11/5/08 3 1 -2
DEF 11/6/08 4 3 -1
Where the Qty On Hand for oldest shipments is pulling from an adjusted on hand. I may have been looking at this too long, and staring an easy answer in the face - but right now I'm stumped...
I appreciate (in advance) any help!