Add School Supply Order Invoice Mark with airSlate SignNow

Add countersignature Client Supply Order Invoice

welcome to another tech help video brought to you by accesslearningzone.com i am richard ross your instructor in today's video i'm going to show you how to change an order from a quote or quotation or an estimate to an invoice to a paid receipt in your microsoft access order entry database today's question comes from ethan in orlando florida one of my gold members ethan says i've been using your invoicing database for a while now it's very helpful thank you you're welcome is there any way that i can differentiate between quotations or estimates invoices and paid receipts do i need to copy all the data between three tables no ethan in fact you can use the same ordered t table that we use in the invoicing database to track all three things quotations invoices and receipts quotations are basically you're sending this to the customer not sure if they're going to buy it or not right that's a quotation or an estimate then once they decide that they want it you change it over to an invoice so now that indicates they owe you money okay then once they've paid for it we can switch the invoice over to a receipt now there's no need to have three separate tables here all you need is two yes or no fields one to indicate whether it's a quotation or not and the other one to indicate whether it's paid or not so if it's not a quotation and it's not paid it's an invoice if it's not a quotation and it's paid it's a receipt now some people like to copy quotations over to a separate record to track the difference between the estimate and the actual invoice that's a lot more advanced i'll talk about that toward the end of the video but let me show you how to handle this first couple of prerequisites first make sure you've watched the video where i build the invoicing database it's free it's on my website i'll put a link down below and of course that is based on a previous creating the blank database template so go watch that first too all right so watch the invoicing database and the stuff before it and for this video you're gonna also have to know the if function the immediate if if i call it right go watch that video too because we're going to use this to change that label on our report okay so now you've got a copy of the tech help free template the invoicing database right and you know how to use an if function so if we go into our order table design view we already have is paid in here now we just have to add is quotation i'll just make it is quote okay this will be a yes or no value and by default i'm going to say no i would rather have my people put orders in that are accidentally...