Streamline your sales order workflow for NPOs

How to create outlook signature

hello friends welcome back to one more video on lsnw in this video we are going to see how to create lsnw for sales order see we might be having a trouble to create like a bulk data through manual but with lsnw we can easily create a sales order with multiple lines so in this video i'm going to show you one trick how to create sales order with multiple lines so in this i'm going to explain like see first we are going to create one lsnw with creation of sale order which means first we have to create two lsnws here one to create a single line in a sales order in the change mode again we are going to add multiple lines to the existing sales order because of the some technical difficulties we are not we are not able to add multiple lines in the creation modes itself so it's better alternative is create one line item in creation sales order and then go to change mode there you can add multiple line items so now we are going to record for of sales order so project sales order create create execute so okay first we are going to record it creation so these are my default values or okay this is my customer i am going to enter which are the fields i will be entering see sold to party i will be entering ship to party only in case uh you have a different ship to parties right so that is why i'm also recording it so customer then uh let's enter one these fields are not required mandatory and then directly come to material because other data comes from the material master then i will enter what i need okay now we'll save it so now it's got recorded right default all what we are going to need is here so can i i have a multiple kns right so what i'm going to do is i will make it as like okay nr1 okay can i r1 so this this will be my default values and then comes here material okay mabnr i will say like okay i will make it okay then name kw meng so uh okay we'll go from fog in first so okay first here what is the customer reference bst kd okay we need vst k d k u n n r k n r one matte order quantity these things we will be entering it in a creation mode just save it okay so we are going to maintain fields yesterday kd okay okay you and i okay you nnr1 sorry we have to come in nr so it's better to give characters because if you give numerical system will take it as like zero zero so better to avoid that we'll take characters okay uh corner will be obviously dead length shift to party length 10 customer reference value 20 and now i have like less length is less but still i can give it 20 kw mng okay fine so these are my okay i will change the description okay save it save it again okay with the relation you again go to change mode and save it so here what we need to do is we need to do mapping here so as i said i am using constant right so it will be over [Music] distribution channel then so these things will come automatically you you can just ignore these fields now comes matter okay so other views are to have to do this go here select the field okay first one then comes second kunar one then i will be scaring okay next comes our material okay order quantity finally okay just save it now i am specifying file path desktop so i have a folder here test so here01 assign it create and given text tab later and it has file name at the startup file yes i have given file name field name sorry at the start of file save it now assign files edit data so i have only one record here okay we'll see what happened to our skip data you can see it here how it comes sorry just double click on this record you can see okay so cumulative fine material magnet so test data however i taken same thing came you see here because of some conversion routines order has become as ta but still it will take it as or no worries now create session okay create created run so okay what we are going to we are going to see how this works in a foreground okay process continue okay again you see here data this this field got filled up press enter so okay it's got saved exit by session so i'm going to see what is the number it took so 79 it took in a va0 file i need to make it as 79 so already have my data 79 fine now we are going to create one more lsmw to edit new lines in the change create okay now it comes great go here click on this and create change one changes va002 going to use my old recorded sales order number here 78 so here what is the trick part is since instead of entering the material here what you have to do is select this line and then click on create item so what it does is automatically takes curses to the next line so here mit nr 2 and i will give some three quantity press enter save it fine it's got saved it so i'm not bothered about any fields i just defaulted only thing i need is vbln and this indicator selection indicator this one i will make it as constant and all things is fine okay what i'm going to do here is go here and make it as mit nr and this is kwm eng and save it so it's fine now go back here and make it as like change so maintain change here change as well okay changes so it's done now important part here three fields right maybe ln c 10 mit nr 20. save it now is the mapping part here so i know vbln i will assign here then material order then most important part is selection of selection indicator right so that we cannot do it through excel it's better to make it like constant x and save this records now the part is specified files vs02 change tabulator field names i have field names at the starting of the file save it so recording is the only thing it takes time but this parts will take you through easily okay 11 12 13 14 4 lines got updated here display converted data now the how sap converter data looks like here you can see so this is how it goes into the screen here create session yes so i'm going to still i'm going to execute it in foreground to see process foreground remove this process you see selected entered in the second cell god saved it and again it goes same way you see here you can see right it's getting updated here this is the only logic which we required so it is done i am going to say it in change mode 79 you see here all the items are updated same way you can update hundreds of line items easily okay don't forget to like subscribe thank you