Sign Arkansas Banking Purchase Order Template Mobile

Order spreadsheet voucher

welcome to code with kurt the channel that brings you the latest google sheets and google apps script videos in today's video i'm going to show you how to create purchase orders using google apps script and basically what this does is you can fill in the information you need for a purchase order and i use the purchase order template that google sheets provides that populate the fields that are needed to create a purchase order so you got the vendor here i got date invoice purchase order number ship date sevilla terms the vendor information the items and the totals but with this also i'm keeping track of the vendors that you're using so you can keep a list of your vendors you can keep a list of your items as well and when you're done creating a purchase order you're keeping a log of each purchase order you create and it's also keeping track of the total and i also got one setting here that keeps track of your purchase order number so it increments every time you create one so i'm going to show you how it works i'm going to clear the form i'm going to select a vendor i'm going to give it an invoice number a ship date i'm just going to select it uh ship via say ups my terms b and my shipping and handling cost which i'll say fifty dollars uh the items i want on the purchase order select item one give it a quantity i'm gonna add that one and i'm gonna select another item 155 and i'm gonna switch the quantity to two add that item and again i'm keeping track of my big list of items so that can keep track of the item description and unit price of all my items that way i can make quicker pos by just selecting which purchase which items i need for the purchase order so here i'm gonna go back to my form here and i'm gonna just get hit create purchase order and now it's going to generate my purchase order from there i can just print this off i filled out all this information the vendor information with this information here this is what you fill out this is static information as well as your ship to this is the stuff that changes the vendor the date the invoice purchase order ship date should be in terms as the items the quantity the unit price it pulls off from the list here and keeps track of the total price by adding that then you get your subtotal your shipping handling your tax rate comes from your vendors it's one of the fields in your vendors your tax rate over here and then your sales tax and then your total so that's pretty much it for how this works in this video i'm going to show you a step-by-step process of how i put this together let's...