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 received quantity of material (col D,H,L....etc) next column for dispatch qty of manufactured material which will be reduced form all consumption or components material (col E,I,M....etc) Col A is the name of manufactured material, col B for produce qty,then you can see the common material which is used to all variants is stabilized in starting from Col C TO F and other variant after it. whatever material produced we enter the qty in it's variant dispatch columns in front of it's receiving/balance qty and Doc/Annexure No. after it at last col bk we mention the SAP Doc. no of production booking or other references. This is the process which initialized by us to keep record. ( for understanding short form - fist sheet Dove 80ml i.e 80 ml Dove Shampoo labelled bottle...it's components are 11471494 plain bottle (common), and variants are hair fall rescue (HFR), dandruff care (AD),intense repair (IR), oxygen (oxy, natural oil care (NOC),DND. All variants have to components one is front label and secondly Back Label. for one type of material consumed three component i.e. plain bottle, front label and back label. each component and produce product have own 10 digit sap code. which you can find previous cell of it's name, Product code are not there in sheet but it is.
Hope you understand So please help to create the activity short and simple.
thanks you...........
2 Replies
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?
In this process we have different two list one the record of received material (all details ) and second we have the production details to we are taking values from both list and entered on working sheet.
