Forum Discussion
Records for incoming and consumption @Riny_van_Eekelen
Riny_van_Eekelen Sir, I attached the working format, In which column Annexure or doc no. have the doc. no. in which we receive the material (col C,G,K....etc) then Next column for rec...
Arun051119841780 I'm really sorry, but I do not grasp what you want to do. You ask to make "the activity short and simple". But your schedule is difficult to oversee for an outsider. You have color coded cells (orange and green). What does it mean? The formula that calculates "Balance Qty" (for instance in F), takes previous balance plus Qty minus Dis Qty. And it is copied all the way down. It doesn't seem to be related to the different varieties of a product. For instance, the Balance Qty for "80 ml DC" rolls over to the next variant "80 ml IR". Perhaps, absolutely clear to you, but not to me.
What is it exactly that needs to be simplified?