Excise Difference Program
I have a requirement for a program for excise difference details.
I have the fields like this
Qty_Rece(A) ,O/b_qty(B), qty_consider(C), qty_remain1(D), qty_remain2(E)
1st record i have
12 , 10 , 10 , 2(A-C) , 0(B-C)
(A) , (B) , (C) , (D) , (E)
from 2nd record onwards the Qty_consider (c) should take value from QTY_REMAIN1(D) for 1st row
Logic is like if there is positive value in column D then for next record the C column will pick value from column D for the previous row. If there is positive value in column column E for next record the C column will pick value from column E for the previous row.Also one more constraint here if the value is positive it should search for new excise number.
I have all the values stored in internal table based on excise number and material number and date.