FIFO Help

[SpecialSauce02]

I'm looking for some help with doing a FIFO calculation for multiple item numbers. I was wondering if someone could help me out with this. Here is a sample data for people to view while trying to create something that might work. Output is the units being created and sale is obviously the sale of the good. Any help would be greatly appreciated. Thanks



[TABLE="width: 848"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Posting Date[/TD]
[TD]Document Date[/TD]
[TD]Entry Type[/TD]
[TD]Document No.[/TD]
[TD]Source No.[/TD]
[TD]Lot No.[/TD]
[TD]Item No.[/TD]
[TD]Quantity[/TD]
[TD]Cost Per Unit[/TD]
[TD]Cost Amount (Actual)[/TD]
[/TR]
[TR]
[TD="align: right"]5/19/2012[/TD]
[TD="align: right"]5/19/2012[/TD]
[TD]Output[/TD]
[TD]W0533[/TD]
[TD]B357[/TD]
[TD="align: right"]0[/TD]
[TD]01200-6144[/TD]
[TD="align: right"]2,880[/TD]
[TD="align: right"]15.23901[/TD]
[TD="align: right"]43,888.35[/TD]
[/TR]
[TR]
[TD="align: right"]5/20/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Output[/TD]
[TD]W0533[/TD]
[TD]B789[/TD]
[TD="align: right"]0[/TD]
[TD]01200-6144[/TD]
[TD="align: right"]1,102[/TD]
[TD="align: right"]15.23997[/TD]
[TD="align: right"]16,794.45[/TD]
[/TR]
[TR]
[TD="align: right"]5/20/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Sale[/TD]
[TD]S3640[/TD]
[TD]A100[/TD]
[TD="align: right"]0[/TD]
[TD]01200-6144[/TD]
[TD="align: right"]-16[/TD]
[TD="align: right"]15.23875[/TD]
[TD="align: right"]-243.82[/TD]
[/TR]
[TR]
[TD="align: right"]5/20/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Sale[/TD]
[TD]S3643[/TD]
[TD]C105[/TD]
[TD="align: right"]0[/TD]
[TD]01200-6144[/TD]
[TD="align: right"]-192[/TD]
[TD="align: right"]14.9676[/TD]
[TD="align: right"]-2,873.78[/TD]
[/TR]
[TR]
[TD="align: right"]5/23/2012[/TD]
[TD="align: right"]5/23/2012[/TD]
[TD]Sale[/TD]
[TD]S3394[/TD]
[TD]E100[/TD]
[TD="align: right"]0[/TD]
[TD]01200-6144[/TD]
[TD="align: right"]-1[/TD]
[TD="align: right"]15.24[/TD]
[TD="align: right"]-15.24[/TD]
[/TR]
[TR]
[TD="align: right"]5/30/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Output[/TD]
[TD]W0302[/TD]
[TD]B788[/TD]
[TD="align: right"]0[/TD]
[TD]01200-7877[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]1,300.00[/TD]
[/TR]
[TR]
[TD="align: right"]6/2/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Sale[/TD]
[TD]S3643[/TD]
[TD]C324[/TD]
[TD="align: right"]0[/TD]
[TD]01200-7877[/TD]
[TD="align: right"]-45[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]-1,170.00[/TD]
[/TR]
[TR]
[TD="align: right"]6/4/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Sale[/TD]
[TD]S3643[/TD]
[TD]E223[/TD]
[TD="align: right"]0[/TD]
[TD]01200-7877[/TD]
[TD="align: right"]-30[/TD]
[TD="align: right"]28.45[/TD]
[TD="align: right"]-853.50[/TD]
[/TR]
[TR]
[TD="align: right"]6/10/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Output[/TD]
[TD]W0533[/TD]
[TD]C579[/TD]
[TD="align: right"]0[/TD]
[TD]01200-7877[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]16.57[/TD]
[TD="align: right"]14,913.00[/TD]
[/TR]
[TR]
[TD="align: right"]6/15/2012[/TD]
[TD="align: right"]5/20/2012[/TD]
[TD]Sale[/TD]
[TD]S3641[/TD]
[TD]E223[/TD]
[TD="align: right"]0[/TD]
[TD]01200-7877[/TD]
[TD="align: right"]-70[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]-2,240.00[/TD]
[/TR]
</tbody>[/TABLE]