Simplify Procurement with Our Google Sheets Receipt Template for Procurement

Google sheets receipt template for Procurement

hey there everyone I'm Talha and in this video I'm going to show you how to create a purchase order in Google Sheets a purchase order is an important document during trade transactions and you may need to create a purchase order before you can issue it to your client in this video we're going to see how you can create a purchase order that is very easy to use and that's the job for you first of all you're going to select the purchase order template from the Google Sheets template Gallery you can also create your own purchase order template if this one doesn't fit your needs after that you're going to create various sheets to store the different data required to create this purchase order firstly the vendor sheet to store the vendor information then the items sheet to store the item information and APO logs sheet to log each which is order and a setting sheet to store the purchase order number after you've created these important sheets you can go ahead and create the POS sheet for this sheet you're going to create rows such as vendor invoice ship date and so on to store different data that is going to be added to the invoice before you can print the purchase order after you've added all of these rows right here and created this table right here you can go ahead and add a drop down right here from which you can select your vendors easily you can also add a drop down for the items so you can select the items easily first let's go ahead and see how the vendors drop down is created first apply to range POS B6 meaning the sheet POS and the cell B6 the criteria will be dropped down from a range and the range will be from the window sheet cell A2 to a 100. click on done and we're good to go next we're going to do a similar thing for the items drop down and instead of vendors this is going to be the item sheet and cell A2 to a100 once we've created the drop downs we can go ahead and create three different buttons that will automate the process of creating the purchase order clearing any existing information from the invoice and adding items to the invoice for that we're going to go ahead to insert drawing and then shapes from here we're going to select bevel and then save and close once you've added the first shape you're going to go ahead and add two more shapes head over to insert again drawing and then select bevel foreign shape and then click on Save and close or press enter head over to insert one last time and then add our last shape once we've added all three shapes we're going to add some text to these shapes to label them we can do that by clicking on these three dots and then edit right here we're going to write create purchase order and then for our second one we're going to write clear and make sure it's all in bold we're going to Center the text and then save and close and for the last one we're going to write add items once we've done that we're going to Center the text and then save our shape once we've saved all our shapes we're going to go ahead and click on extensions and then go to apps script the reason we're going to apps script is we're going to have to assign a script to each of these shapes or buttons that will carry out the tasks that we want them to carry out for example the create bu button will create the purchase order the clear button will clear the invoice of any previously entered data and the add item button will add any items that we have selected over here to the invoice right here so let's go ahead to Google apps script and here we have pasted this script right here you can find this script on our website spreadsheetbun.com and once you have the script you can paste it into your sheet and then save and then head back to your sheet once you're in the sheet you are going to click on these buttons right here and then assign a script for this one right here the script is create purchase order create Bo and for this one the script is clear invoice just like this and for this one the script is add item like this and and then item once we've assigned their element Scripts we're going to click on the first button right here clear our invoice of any previously entered data it's going to request authorization and we're going to click on continue select your account click on Advanced and go to purchase order then click on allow and authorization successful now we can click on clear and you'll see that it has cleared all other data from this table right here and from our invoice we're going to it's going to add the data once we create the PO so we're going to select the vendor as Corey Smith we're going to add an invoice number such as one two three four a shift date a ship via value we're going to select UPS and a random shipping and handling fee next we're going to select our first item and add the value for the quantities and then we're going to click on add item once we click on add item we can see that that I can have been added next we're going to click on create po you'll see right here that the items have been added to the invoice over here then you can click on the print button right here and then select your requirements and then print the purchase order and that's how you create a purchase order in Google Sheets I hope this video was useful to you please leave a like And subscribe