Streamline Your Processes with Excel Invoice Software for Operations

Excel invoice software for Operations

hello everyone good evening welcome to the new session of the Udo but this is not regarding with manufacturing or import export this is something new which is the project in this session we will cover that Milestone base P this are only the concept which will be useful for that the beginners so without wasting the time let's jump to the data base in this video let me explain what's the use case is in this video we will check how you can create the payment based on Milestone we will check both cases let's consider you have the business of that constructions and you are collecting the payments from your Cent based on the Milestones so let's do it so I'm just creating one product so I'm let me open just a minute I'm creating one product first of all so let's create it and that product name is Construction Services so I have created let me make it that construction service and it sales price is a 10,000 now what I want that product type we must be service create an order which is a task and I want to create that task and project meaning is that confirmation of this product will create the task and project particularly and here invoicing policy is based on mind everything everything is set up these all are very important now let me duplicate the screen and let me create the cell order for the same so I'm just going to create the quotation my customer let me PPS let me add okay now let me save it just before that I have to activate this addresses I have iate so the view of order will be quite good so now let's jump to that and the are things now you can see the invoice address delivery address now our product is Construction Services everything is there now let me confirm it so here you can see that on one task is created because we have mentioned that that confirmation of that product will create the one task and one project so here you can see that one task is created one project is created and here one Milestone is created so let me go to that here you can see that the construction services and it's a 100 now let's consider that you don't want to collect the payment on the 100% Milestone so if you want to divide it and add multiple milston then you can do it so let me make it as a 25 percentage for this and which is the construction initial okay if I want to add one more I can which is the foundation Foundation complete and which is also again 25 percentage and here again I want to add one more roof complete which is again 25 and last one is the Handover so I want to make it as a hand over which is again the 25 here you can see that de line if you want to add it you can hear that checkbox is automatically there now all set now let me go to the sales order I'm into this task now this task is that if we want to make it as a done then we can this everything is detailed but let me just cover up the uh Concepts only I want to make it as a done so now let me go to there this is the Milestone now here let me go to that this is my first second third and fourth so here 25 percentage is completed and here this is very important here we have to mark as a rich so before that let me jump to the sales order here you can see that delivered quantity is zero and if I'm going to create the invoice I'm going to create the regular invoice system is not allow us so for that what is important in the Milestone we can see that we have that options for the rich so I'm going to do it and save it now let's jump to the sales order and here you can see that that automatically accounts for delivered quantity why it consider as only the 25 because we have divided this product into the four miles Zone if we haven't and if it was only one then it will deliver the one but now just you are collecting the payment for only the 25% so now let's check create the invoice regular invoice and boom here you can see that its amount is only the 25 so you have just completed the 25 percentage so you are collecting only those amount now this is the thing now let's consider that another Milestone is also completed which is the foundation so let me make it as a rich save let's jump to the sales order here you can see that the 50 is delivered so if I'm going to create the invoice it is again for that 25 and boom now again let's jump to that and that Milestones now the third Milestone is there before Rich before making that Milestone Rich let's check it's a 50 Milestone and save and boom it will be a 75 and the create the invoice and it will be again for that 25 now let's complete the last step which is the Milestone 4 and boom and save so here you can see that now it's one but if we are going to create the invoice again it will be 425 so if we will check that here you can see that one project one task four invoices and four Milestones are that this is just only the overview we will check all those features in detail in our next videos thank you thank you everyone