Distributing Adjustment Quantities Across FIFO Tiers

[meangene]

I am trying to create a delimited file for use by my ERP import tool that
will show item adjustment detail in the correct format for the ERP. Example:
Have a FIFO tier for an item with two tiers (Item, Date, Qty)
Item Date Qty
ABC 1/1/08 13
ABC 2/12/08 100
Total QtyOnHand: 113

I am adjusting -40 from the total QOH but need to create two records to do
this (Item, Adj Qty):
ABC -13
ABC -27
Unfortunately can't create file with just single ABC -40 entry and import it
because ERP Adjustment process won't let me adjust single entry across
multiple tiers, so have to do the math for it! I think I'm looking at a
cascade process here but not sure. Any ideas? Thanks!

 

[meangene]

I meant running totals process instead of "cascade"...

 

[meangene]

CLOSE THIS - AM MOVING QUESTION TO QUERIES!

I meant running totals process instead of "cascade"...