L
Lynn
I am trying to find a way to calculate remaining balance within a specific
date code.
This is an inventory control spread sheet. The left side is for receivables
with date code and the right side is for reduction to inventory for
production base on date codes (not working!).
ex:
REC TOT EX DATE PROD DATE REL QTY EXP DATE 10
10/1/2009 11/2/2007 15
2/14/2008 7056 9/1/2010 2/13/2008 48 4/1/2010
2/14/2008 7056 9/1/2010 2/18/2008 2222 4/1/2010
2/14/2008 7056 9/1/2010 2/18/2008 2148 9/1/2010
2/14/2008 3696 9/1/2008 2/20/2008 5404 9/1/2010
In this ex. I need to be able to deduct 2148 and still reflect that I have
X amount left in that code date. And once all of that code date is used up,
I need a flag saying use next code date or 0 remainin or something like that.
Is there a way to do this?
date code.
This is an inventory control spread sheet. The left side is for receivables
with date code and the right side is for reduction to inventory for
production base on date codes (not working!).
ex:
REC TOT EX DATE PROD DATE REL QTY EXP DATE 10
10/1/2009 11/2/2007 15
2/14/2008 7056 9/1/2010 2/13/2008 48 4/1/2010
2/14/2008 7056 9/1/2010 2/18/2008 2222 4/1/2010
2/14/2008 7056 9/1/2010 2/18/2008 2148 9/1/2010
2/14/2008 3696 9/1/2008 2/20/2008 5404 9/1/2010
In this ex. I need to be able to deduct 2148 and still reflect that I have
X amount left in that code date. And once all of that code date is used up,
I need a flag saying use next code date or 0 remainin or something like that.
Is there a way to do this?