Streamline Your Workflow with Our Open Office Invoice Template for Planning

Open office invoice template for Planning

I've seen a few articles about creating your own invoice database Where a person from home can create and keep track of his or her own invoices, using base The database in the articles is usually called invoice or mini-invoice I didn't think the articles provided enough information for the reader to fully understand what was going on So, in the next few videos I'm going to create my own version of a home invoice database Using LibreOffice Base I've create a new database and I'm calling this one odb73-Invoice-pt1-tables Using LIbreOffice Draw I've create a picture of what I want my invoice to look like This will be the invoice that I send out to my customers. I'm going to have my company name and address, as well as a logo in the upper right hand corner. It' is going to say "INVOICE" here. Then have the customer information The invoice number and date And then down at the bottom, it is going to have the tasks, that I am charging my client for. And then a total at the bottom with the total cost for all the tasks. I'm going to use this invoice to help me design My database tables. The first thing I notice is that I want an invoice table. and on that table I will want the invoice number, as well as an invoice date. And a link to our customer table I'm going to have all my customers on a separate table. I'm also going to put my tasks on a separate table. So, I will have 3 tables in this database. I'm going into tables... and I'm going to use the wizard to create a new table. I want my first table to be a customers table. and they do have a customers table... In the sample tables I want a customerID company name address, city... state or province postal code country or region phone number email address, and notes clicking next... I want to create another field here, so I'm going to click the plus sign. I want this field to be Website. We will leave this as a Text - Varchar but, I'm going to move it up before the notes. and click next on this screen, I'm going to Use an existing field as the primary key. I want this to be the CustomerID and auto-value then next customers is a good name for this table. so I will click finished. This table looks good as is; I'll close it. and let's create another table Using the wizard again. Now we want to keep track of the work we've done... Looking over our sample tables... We have something called tasks We're going to use that... for this table. Here we want a taskID the description and some notes. clicking next I'm going to add another field. This one I'm going to call amount owed I want this to be a decimal (there's decimal) and I want to give this 2 decimal places. I'm going to move this up... After the description, I want the amount owed. and then the notes... and I'm going to add - 1 more field. this one will be and invoice ID and we want this one to be an integer. Now, we will notice at the TaskID We can set the auto-value here. but I'm not going to because i know I'm going to do that On the next screen So, this one should be No. If you change this to Yes, You might have issues. I'm going to the next screen Where we set our primary key, I'm going to... Click this radio box - use an exiting value and I want this to be the taskID and I'm going to set "auto-value" here. and we will leave this name of "Tasks" We see we have auto-value in the taskID The last table, we are also going to use a wizard for this This one is going to be the Inoivce Table and we've got one here called Invoices The first thing we want is an invoiceID we also want to add a customerID an Ivoice Date (do we have something here for the status???) Yes, we want a status. and then notes. and I'll click next. I'm going to change this status instead of a varchar I want this to be a Yes or No boolean - it is either "Paid" or "Not Paid" Let's go to the next screen setting the primary key again. I want this to be the invoice ID Auto-Value and leave the name as invoices The last thing we are going to do in this video is set up the relationships I'm going into "Tools" -> "Relationships" I"m going to add all 3 tables. I want to add a relationship between the customer table and the invoice table with a customerID relationship I want to check my update options I'm going to right click on the line and click "edit" I want to update cascade and I'll leave the delete as no action I also want to create a relationship for the InvoiceID to InvoiceID right clicking on the line - Edit and we will set this one to update-cascade as well Let's place this box in the middle. this one to the right so it looks a little nicer... A little easier to read... I'm going to save this and then save the database