Collaborate on Invoice Model PDF for Product Management with Ease Using airSlate SignNow

Invoice model pdf for Product Management

hi friends what's this invoice we'll continue learning our PDF generation using our python report uh lab uh library and this invoice will try to create it this is used from a from a blank invoice then these datas are whatever the items or the products with price quantity total all these are taken from a data file and the data file has some variables like in the dictionary list and all and those can be replaced by taking data from a MySQL or SQL light so in future we can integrate it our invoice to the database right now we'll take it data from the file it's a separate file we kept it keeping in mind that in future that will be replaced by a database and we will be running this uh generating this one and we'll learn also how the blank this uh invoice format is created and then we'll move it note that all this price wherever we are writing we are right aligning the text this total column and the price column these are all right aligned this is our blank template where we have written our uh Watermark then the top then address tax information all this whatever is the common to all the invoice that we have taken there few things to these are all lines and funds only you can see that there are some basic funds are available along with the it comes with the library so you can one up that suppose you want to know what are all the funds that for that that you can use the get available funds method in another video we'll see how that you can uh run and uh you can display what are the available funds are there here we have used some two three funds only not many but fund sizes we kept on changing you can see the inside this template one important thing is let's first run once and see the template here is the output this is the blank template what you are using was that this Watermark sample whatever it is we have written it for first then we have drawn the line otherwise what will happen this sample will come forward it will be coming above the lines so first take care of the sample in the uh at the beginning so it will be written first then the lines are drawn one another important thing is whenever vertical lines are to be drawn note that X1 or the x coordinate because x coordinate starts from here horizontally so X1 will be equal to X2 similarly whenever I want to draw a horizontal line I have to draw y1 equal to Y2 because Y starts from the bottom and it goes up so here the end is here the end is both the ends the y coordinate has to be same and then keep on adjusting that SW actually being done here and the all the lines the fonts and the dimensions are done it is not that the one stroke all this blank template is being created no by trial and error positioning the lines with all this thing this is nothing more is there only if you have followed our first part where you how a line is drawn how a text is drawn how the coordinates Works everything is uh same only only multiple lines are drawn so the source code anyway it's available for you to download so you can use this now another important thing is invoice data what this this is the data file now this temp file and the data file both we use in our invoice file to generate the invoice now the here the idea is you see it's a dictionary first one only few lines so my product my sell discount rate tax rate these are the four variables whereas my product and my sell are the two dictionaries I have created then you may ask me why like this I could have copied this entire four five lines of code to the my main file also I just want to keep it separately and call these these variables reason is tomorrow we can replace this by taking it from a mySQL database or for SQL light database or from Excel page any where so this kept as a separate module our main generation of invoice Remains the Same now let's move to our main generation of invoice this is our main file invoice file so where it will be will generate our invoice now here you can see the path we have set it if you have seen our earlier tutorial we have explained that in this you can change the path now we are importing the inches and letter page sizes and all watch this line number five here I importing the my temp my temp is here I have invoice here it is I have declared it here my temp inside my this one this I am calling it here so my temp import the template the blank template I am importing so it is ready now now next line from invoice data import all the variables so whatever data is there in invoice data what you have seen just now here my product my cell my cell is my cell and my product are AR and these are discount rate 10% tax rate 12% because this keeps on changing so suppose discount rate is no more 10% you can increase it here also now in the my cell this is a dictionary you can see this is the all keys are the product IDs one three one this one and based on that quantity this quantity is taken from here and here my in my product uh dictionary name is given and the price is given this is 80 is the price Ram 90 is the price whereas in the sales table which product the quantity in fact in the real situation from the database we'll get similar type of we may get something more also but similar thing whereas the product and price goes to the product because that is the attribute of the product and when you are giving sales figure what which product the product ID and what is the quantity then you link it up and generate the invoice now let me just come back here so here then I have just this uh sorry at here I am using this line number 10 I'm running the template getting the template now ready canvas I have created now to the template I'll be adding our we'll learn how to add our data so this part we'll be understanding now rest of the things are standard only we have already seen this now if I'll run at this stage if I let me run it if I run at this stage once I'll get a blank uh template so I I have created the file is my PDF is is created now let me just go there refresh it the same thing I will get here it is I will start here by using the font color C set fill color now a color I use RGB so here it is now I'm giving 0 comma 0 comma 1 why it is red green blue I'm giving blue so I want blue font okay if you want change it change the font color I'm writing it here font color now now see set font what font you can see I'm using this but but you can use any font family there is a set of font families are available uh now the size of the font is 20 okay now it's known so okay now let me give row Gap so these are some variables I am setting row Gap what is the row Gap actually by the way it is the gap between two products the gap between the lines so row Gap let me give 0.6 then I'll give line Y where from the my Top Line will start and then it will row Gap row Gap I will keep on reducing it equal to 7.9 you may ask how I so precisely I'm getting actually I have done some experiment trial and error you also have to do it position little up little down that way only because it's a print format we are getting no so and total total is equal to zero I'm just starting zero uh total value then I will go on incrementing it now what I will do I will do a for Loop for items in my cell what is my cell my cell is the invoice data whatever it is this line number seven this is my cell line number cell this this one I am getting it because I have here at the top I have imported it line number six from invoice data import all get all data required so that I am using it here now what I will do c do draw string and now the dimensions because first I have to place the product name so product name then product name product quantity price all this thing so I'm saying four sorry 4.5 multiplied by in now then line uh y multili by in then then I'm converting the string uh so string my product my what is my prod my prod is the my product dictionary me 1 minute we'll just check once more whether I'm doing anything wrong here now zero what is zero okay fine now this inside this is inside a loop what uh line Y sorry here I have to give underscore here okay what I'm doing it here you can see I'm taking the item item in my cell my cell is here first item I taking so here one two everything is there so I'm using the item that that product ID from the first one item zero I'm taking it and displaying the product name the zero item of the product is the product name you can see here the product name is here so this one against I'm matching with the one key this key I'm taking this key then the product I am displaying okay let's just run this once we can see what the output is I have run it okay no error so let's just run this I'm refreshing this sorry some mistake ID here it is okay what mistake I'll tell you because what happens all the product are written one by one one by one there so that's the mistake here I will just something draw zero sorry uh here here I have missed it 0.1 at the left it will be there because it has moved right then inches line Y into in then Str Str my product item zero uh item zero okay this is fine I'll just write it I'm writing the this comment I'm writing product or I'm just writing product name only now because it's inside a loop it is overwritten so what I have to do is first thing most important is I have to increment the line Y Line y equal to line underscore y then minus row underscore Gap if I am not using doing this then at the same point next Loop next Loop it will keep on writing it there that's what has happened so let me just save it now once again I'm executing now the file is again created let's go there and see what I'm refreshing it see all the product names are displayed now we'll go for the price I'll just copy this line now come here and paste it note that price will be price will be taken from the same product uh dictionary and it will be the next value so it is one and one more thing actually this before printing if it is a numeric or float I had to to use St Str here it is not required because uh it's a product name only it's it's a string by default whereas in the next line when I'm putting price I have to use this St Str to convert it the uh integer to a integer or float whatever you are used that to a uh string now let's I'm saving it sorry here I did the mistake again I have to shft to R right side so it is 4.5 because I'm moving the X direction towards right because price will be placed towards right you may ask again how I got it 4.5 that's trial and error only you may F adjust it also note that to move right direction I have to increase x value to move in y direction I have to increase sorry vertically I have to move then I have to change the Y and that care is taken by line Y which is decrementing because first line next line next line because y value keeps on decreasing I'm writing it here vertical line okay that will give the indication now let's just run this and see how my price looks so here it is I'm just reloading see here price has come off here so that's the uh now we'll go for quantity and total because it's a price we'll use right align so this function will use it and uh let me just SL slightly no no 4 point okay let let's see where it comes I'm just saving this again creating just slightly right uh okay too much it is coming so I'll just keep it there whatever earlier value was there five and or otherwise I will make it 45 so it'll be slightly better okay now I'll just again copy this next is my it is quantity note that quantity is not in the product table or the in the product dictionary it is changed so here the value will change so I will put it as 5.5 I'll keep it again this I have experimented so then line y s my CES items it's I directly my cell item there is nothing because it's a single item only key and value the value is the uh in our sales table if you'll just see the value is this is the key it is the value this is the key this is the value so product ID is the key so that is why reason why I'm just my sorry here it will be not be uh let me just see it will not be product it will be sell okay so that's all let's just saving on running it no error let's just refresh this and see yeah quantity has come up here now the total now let's calculate the total it is not total it is subtotal because horizontally the end so two quantity price is one so 2 into 50 100 that will be displaced that sub total we are telling so we'll give the value of like that only subtotal equal to now my product this is price I have to take it from there uh items uh it is items fine now one one is my price so I'm taking the price here also you can see at line number just above 18 we have taken the price here let me write it here price product price now here sell quantity this two I had to multiply it that's all my job is so here I will say multiplied into my cell items so now I got the sub total now this top total I will press it there so see I will just copy this line uh okay seed draw string here it will be 7 in I have to move right further the 7 in here then line Y into in Str Str now I'll just write here subtotal because I have already calculated it so I'm just writing the sub total that's all so subtotal will come now one more line I will draw but I'll write but I'll not display it so I'll say total this total we have at line number 15 we have set it to here you can see set it to zero this total equal to because every time I have to sorry let me first Total it I have to Total plus subtotal because inside the loop I had to add up all these things and get the total price now to display it I want some little bit of decimals and all will come so for that purpose I will put it inside a round so I'm rounding it off the value whatever has come two subtotal means total I will make it up to here then one then close it so one place in the uh decimal I am going it uh let it be round total plus sub total this is not required here okay so now line that's all up to this let's check it so right side only the sub totals will be displayed now I'm running it again let's go there reload it yeah here you can get it and see the text are all right aligned because currency we have to write it in this format so whatever the price multiplied by quantity sub tootal now we'll move Bottom now I'll calculate the discount part and same way I have to display I'll come out of the loop because I it's not the all product are over so the I need not do anything on the product looping this is the uh final one so I'll just paste it what this four lines of code I have copied now you see the same thing I doing I'm writing it here float the total value whatever I am getting it from here I'm just converting it into float because the decimals may come and before printing it I am converting using Str Str so I'm converting into string now discount I'm just rounding of discount rate by 100 what way you you have taken you can just check it up because it's a discount is 10% so it is from our invoice data file here it is discount rate is 10% that data actually we are taking and here we are printing that one because we have to show it also total and multiplying it by total and decimal place is one because round now what we are doing is in the next line we are just displaying the discount rate by converting into St Str and this string we are adding it giving a percentage symbol then we are right finally whatever discount we have calculated this is the discount value not nothing thing we are displaying it here now let's just run up to this point I'm just saving this run up to this point and see how the discount is visible here I am just reloading it see here 10% 910 these three things are added this 10% and this sorry this 910 initially One display second display is percentage third display is here we'll just go back here it is the first display this is not sub total this is our total actually then the discount is calculated here the discount uh rate is displayed discount rate actually and the final the discount value now let's add the tax part so I'm just writing here tax part I will just past three lines of code same fashion I'm just reading the tax rate where from I got it tax rate it is in our data file invoice data here tax rate is there 12% if you want to change it change it here now invoice uh okay so we we have come to the tax part here tax is added let's see run this I'm saving this running it let's see how the tax is displayed okay here it is 12% and 98.3 I'm not you you have to experiment it I have just experimented with the layouts and all and if you want that further to come left or move this to right you can do that fine now let's go to the printing the total value here is our final total let me just write it final total or whatever you want write I'm just testing again four lines of code you see the total final is created by discount a total minus discount plus tax okay the formula if you want to change it change it here now here you can see I have set the funds to different size times bold I have used the available funds whatever it is you can again keep it change slightly font size also I have increased anyway I'll write it font size for total Now set the font color in RGB so here I am selling 1 0 0 RGB mean one means here it is red color so red is one GB is 0 0 so I'll get a red color finally I am drawing the here it is seven slightly I have moved towards uh right and very bottom I have think this values if you want to move left reduce this if you want to go further up increase this like that only then because it's a final value I have to convert it to a string and then display now let me just save this run once no error so let's go and refresh this so here it is 917 is displayed if you want this total to come here fine in keep on increasing let's just toal this total will move towards the right a bit so for that what we have to do is here x coordinate is 7 in now let me just move make it8 what happens if I'll make this coordinate now let me re run once now let me What's the total location of this total whatever is WR written sorry sorry I have moved this particular font now sorry that is in the template sorry I'll will not this is the okay let it bring it to seven only I want to bring it to towards the left means let me bring it put it 6 in so now that fun will come to now let's just six means this total should move left side let me just okay but you don't want it to be it should be aligned so you just see 9 because where this is the same position this should have so let's just put it here you just see the tax is at the position seven many things this discount we have written at seven that is why discount tax and all this total value all are aligned in the x d or horizontal Direction sorry I had to run it once now refresh it so again it will be so all are aligned because they are x value is same that's all friend the idea here is to understand how the invoice is generated and the data can be taken from MySQL sqlite that can be integrated anyway and I'll just show you once more so I'll remove some product from here you can to understand that let me go to invoice data I just removing the last product this I will remove it saved it now come back to my invoice file run it once now you see you can see that microphone will not be the last data will be removed okay so this is removed so entire calculation is adjusted that's all that is how we generate it fur we'll improve it again we'll go for tables and all so I'll request you friends to subscribe to our Channel and press the Bell icon so you'll be notified the next time whatever the tutorial frequently upload the new new tutorials and you have any doubt idea suggestions use the comment section below and post it ingly we'll improve it or we'll post new tutorials also share it with your friends and I request them to subscribe also thank you for watching