Stock Running Balances

[shamitshah]

Hi,

Please see attached file in which I have Sales Orders, Purchases , Adjustments for each day.

The current stock balance is 5.

I want to insert three columns:

1) show the stock balance at the start of each day,

2) show the stock balance at the end of each day, and

3) show the average stock for the past 30 days on each day

Any suggestions as to how I can do that?

Thanks

Shamit

[shamitshah]

File attached below.

Thanks

Shamit

[#3]

Hi ,

PFA,

Start of day & End of Day stock calculated.Please verify it.

But, could you please check for past 30 day logic N 3rd row of Excel.