Need your help please !!!

Hi,

We are in JD E1 9.0.

Our requirement is, Item A quantity is planned to be produced on 23/09/14 is 8000 Nos. and 27/09/14 is 10000 Nos.

But actually produced on 23/09/14 is 8500 Nos. and 24/09/14 is 8500 Nos.

The pending quantity needs to accumulated with the next day planned qty.

Following tabular column will explain our requirement in more detail :-

     

Date	Pending Qty	Plan qty	Actual Qty	Bal Qty
23/09/2014	1500	8000	8500	1000

     

Date	Pending Qty	Plan qty	Actual Qty	Bal Qty
24/09/2014	1000	10000	8500	2500

Is there any possibility to configure the above requirement in the system ?

If so kindly explain it us at user level please.

Kindly treat this as most urgent please.