Effortless Busy Invoice Format for Facilities to Streamline Your Billing Process

Busy invoice format for Facilities

hello everyone I hope you all are well so I am manchi rihani and today we are conducting a webinar on mastering in voice design with special commands in this webinar I will explain all the steps for the configuration of mastering in word design with special commands first I will present you the topic mastering invoice design with special commands and after that I will show practical steps in busy through this presence presentation we will understand how to use special convo commands in advance inverse if you have any queries and doubts you can ask at the end of the session now I am starting the webinar mastering invoice design width special commands session objectives first we will introduce what is special commands and how you can use it in PC itself for advanced configuration for advanced invoicing after that we'll learn the special conversion Advanced invoice that how can you use special commands in advance invoice after that explaining the special commands and intro to introducing the special commands in busy I'll show the demonstration in busy practically I'll show you the demonstration in VC after that we'll go to the Q a session if you have any doubt in queries you can ask in Q a session topics to be covered what are the topics where we can cover today so what are the topics we are covering today first the topic is fonts and characters how you can use the fonts and the characters in advance invoice lines how you can configure the timelines the lines alignment you can use how you can configure that in inverse you know it full line you need half line or you need horizontal line vertical line how you can use the lines in busy will learn today formulas we'll learn how you can apply the formula if the field is not given in advance format how you can call a field by using the formulas like addition subtraction multiplication or division after that we'll learn data manipulation Fields data manipulation field that means hashtag #many fields we can use like TW we want amount in words we want to trim the words we want to trim the line we want to round off the amount automatically Lower Side upper side we can use the data manipulation Fields how you can use the data manipulation fields in advance in invoice after that last point is QR code we'll learn how you can configure the QR code in busy the two type of QR code in busy is there the first one is static and this second one is dynamic how you can configure the QR code in PC itself if we want the static QR code or you want the dynamic QR code we learn how you can configure the QR code in busy moving to the next slide let us see these features features practically in busy now we'll see this practically features in busy fonts and characters normal characters if you are using a normal characters no lines has been mentioned in A4 page it will take 80 characters in a single line I am explaining you again if you are not calling any fields in advance invoice if the page is A4 in a single line you can configure 80 characters if you call more than 80 characters it will go out of the page or if you call below 80 characters it will show the blank space so in normal A4 page the normal lines per number of lines number of lines in a single line you can call the 80 characters if you are calling the CPI there is a field in busy CPI if you call the CPI field it will call 96 characters in a single line in a single characters you can call the 96 characters I will show you in busy the CPI line this is my company I will login I'll go to Administration configuration invite document designing Advanced I will call the standard invoice I'll call the any of the format you can call I'll go to the header part the shortcut keys is F4 or you can call it from here print styles the shortcut key is F4 while you press F4 key the CPI is a field available here the CPI 12 CPI 12 off if I call this field CPI 12 on in a single line it will shrink the characters in a single line it will call the total number of characters is 96. if I call the CPI line or if I call the condensed line it will call total number of characters in a single line it will call one day 36 characters this is the contents field I will show you condense if I press C this is the condense on condense off if I call the condensed on field it will call total number of characters in a single line is 136 so how you can use in a normal you can use 80 characters if you call CPI command it will total number of characters in a single line it will call 96 characters if I call condense field it will call number of total characters in a single line it will call 136 characters we have a font Fields also available font 18 field fault 15 field uh data form Fields if I want to call the phone Fields I can call data font this is the data phone on data font of font 18 font 15 these are the print style available in busy you can if you want to call the font you can call for font 18 font 15 or data font you can call in busy itself moving to the next slide lines the vertical lines is you can see the symbol vertical line vertical line is this one and horizontal line is in landscape mode the the line which is coming in horizontal line This is the horizontal line and this is the vertical line if you call blv a dlv means BL is the field V means vertical line and a means it if I call a I call a b c in a single line it will print the line it will print the line till the text only after that it will blank the line it will if I call a it will call the field I it will call the line till text only if I press F instead of a it will print full vertical line whether the content whether the text or content is in half page coming or full page coming it will call the lineage in full page if I call a line it will call the field in till text only horizontal line blh is the field BL h means horizontal a mean it will print the horizontal line till your text only if I call F instead of a it will print horizontal line full in Full Line in the full page it will print the horizontal line if I call blh L that means it will print the line from from left in left it will print the line instead of L if I configure r that l means left R means right if I configure blh r that will print the horizontal line in right hand side so this is how you can call the fields like blh v a blh v f a means till text only f means full page line plha till text horizontal blh f f means full length horizontal PL l means left line horizontal blh R means right horizontal line after that I will show you the formula how you can configure the formulas in busy itself this is the baby busy screen I configure a format like formula this is the header which I configured as low default this is the footer icon configured as load default this is the body part this is the field which I configured load default but this is the field which I configure manually this is the first field I want the amount na total amount minus compound discount I applied at a discount in item wide discount I call in voucher I want a value me amount I am I am calling item white discount and item by sticks so so the value is coming after text in after discount so I want to feel like I want total amount minus compound discount field so how you can configure that you can you can call the field like alt f4 you press old Air Force is the shortcut key or you can select from here Fields available amount this is the amount field which I called this is the amount field which I called again I am pressing it F4 key again I am pressing die 4p I am calling discount field I am calling the discount compound discount amount 1 field so how you can do that if you want to minus the amount if you want to do minus if you want to subtract amount minus compound discount what you can do you can call two Fields the first field is amount and after that you can call the field compound discount after that what you can do you have to remove this character from here carrot line from correct carrot corrected from here remove R from here remove com comma from here remove a York size from here remove comma from there or what we have to do we have to Define minus sign from this this means amount minus compound discount the total number of corrector is 16 in this field or you can print the alignment will will be printed right inside if I'll show you in voucher this this is my voucher I called a discount here this is the m price coming this is the itemized text coming I want total amount minus discount amount I need so I call the field from here if I print alt p I am printing the field data formula format I selected here preview you can see the amount is coming 1924 the amount is coming by nine two four that means it will call the field amount total amount minus your compound discount amount the field is coming as per that you can use that if the field is not available in your standard format or Advanced format you can configure the formula like uh addition subtraction or multiplication or division the second field which I called is I want the amount quantity minus into price I want a amount field that will call if I call amount feed it will consider your tax amount also it will consider your discount amount also but I need only amount field which will multiplication your quantity into price that will not include your uh discount amount discount amount that will not consider your tax amount I want to feel like before discount or before text I want to feel multiplication of your quantity into price that amount I need so I called quantity quantity field in the price field I called here I remove the characters from here I in between quantity and price I applied star here star meals multiplication the symbol is for minus minus is the simple for multiplication star is the simple in keyboard so applied I applied quantity between price and quantity will apply multiplication so I applied start here I will show you now in voucher alt P print formula I selected the format here preview see it will come in the amount 1800 that means the it will not consider your discount amount it will not consider your tax amount it will only multiply your quantity into your price that is the value coming here so the field which is not available here you can call it from formula I'll go to the body part again now I want amount divide price I want total amount divide price what will be the actual amount if I consider the total amount that means include your tax amount that will include your discount amount divided by your price amount this is the field it's not available in fields Fields available so I applied the formula I called a field total amount I configured that amount field here I call the price field here I remove the characters as I shown you in previously in compound discount field I remove the characters from here in come amount and price in between these two Fields I applied division formula division sign will be like this slash like this in the right hand side so I applied the division here means I want a field amount total amount minus division by Price this is the field I want so I applied the field I will show you the print now formula I selected the format here preview see the amount is this and the price is this so dividing by your amount and your price it will calculating the amount is 1.18 this is the amount calculating 1.18 so you can call the fields like that I'll go to the body part again I will show you the plus sign I need a feel like if you want a big formula I want configure many of the fields many of the fields like uh first I want to multiply your quantity into your into your list price what is the list price after that I want multiplication of quantity into your price ah the net value coming by multiplication of quantity into list price and quantity into price I want the net value by placing the those two values by multiplication of those values so I configured the formula I configured the field like quantity here first I configured the call the field list price here after that I will again call the field quantity here and after that I call the field price here I want multiplication of quantity into list price first so I have used the brackets like this line here this is the bracket I want to use so I configure the quantity into list price first it will multiply your quantity into list price the amount will come like 1. the multiplication of quantity into list price so I configured the uh colon here the colon is like that bracket is like that I will configure the configuration the a formula like that it will multiply your quantity into list price after that it will multiply your value quantity into price so both the value which will come like layer here after the value the net value by multiplying your quantity into list price and quantity into price it will add the value sum of the value of both so I configured the fields like in between bracket here it will multiply the fields like here the net value is coming for both it will plus the values like that so in between these fields are configured in it will multiply first and after that it will addition means sum of the value so in between the brackets I configured the plus sign that means the net value of quantity into price and the net value of quantity into list price will sum up the single value so I configured the formula like here and last you can Define another number of characters I need and the alignment will be left or right so I configured like this I will show you formula preview see it will come in 3800 so first of all it will multiplying your quantity into list price the value come like 1. let's suppose the value is coming like 1. after that it will multiply your uh quantity into price the value is coming like 2. after that the the value is coming like 1 and 2 it will plus the one value and the two value the sum of value will be the configure will be single digit value single digit value means it will sum up the value so 1 plus 2 is 3 the value will coming like suppose the value will be coming like 3 here so 1300 will be configured like that first of all it will multiply after that it will addition like some of the value so how you can configure the formula in BG by multiplication by your Edition by your subtraction by your multiplication by your division though so the sign for multi Edition is plus subtraction is minus multiplication means star in your keyboard and division is like slash I defined it here so how if the field is not available in BG you can call the many of the fields and apply a formula like by adding adding or by subtracting or you or you can do the multiplication or you can do the division you can configure the formula like that NPC after that we'll learn data manipulation field #t if I apply hashtag t which it will trim the value #w means the value is coming like 20 rupees I want the 20 rupees like amount in words I want so if I apply amount field if I apply hashtag W it will print the fields in a mountain watch if I apply NZ hashtag NZ it will print the Dash that Dash syntax in instead of blank value let's suppose 20 is the value added configured 20 characters so after that it will break the dash dash like sign which I have shown you in the end it here it will print the options like that instead of blank value in hashtag nzb it will print the blank value um let's suppose I configure 20 characters in a field and the amount is 10 Rupees so it will print 10 rest amount will be print as blank value your nothing will be printed it will print as blank value so RL if you want to lower your round of value let's suppose the uh item voucher amount is 19.88 it will lower the roundoff amount it will it will print 19 inch sheet of 19.88 because it will print the lower round of value it will lower the round of value so it will print 90. up around of value if the invoice amount is 19.88 it will upper the round of value so it will print the value like 20 if you because it will value #ra automatic roundoff I will show you in brief I am just explaining right now how you can configure the fields in busy itself if I use the highest tag ra automatic round off so it will check the value is below 50 it will automatic round off below 90. 19 if the value is below 0.50 it will upper up the value so if the value is 19.49 if I selected a hashtag are a automatic round off it will print the value 19. if I can invoice value it will be 19.88 so in this case it will print the value like 20. #lt if you want to trim if you want to cut the value from left hand side you can use the hashtag LT content syntax if you want to cut or trim the value from right hand side you can use hashtag RT padding characters if you want to print like star star you want to print so you can use the padding characters like thank you in Inlet inside and right inside I want to print the pattern characters you can use the padding characters like hashtag p if you want to break the lines if one if the line is printing if you want to break the lines you can use like hashtag L it will break the line and the next content will be printed in the your next line as what the characters you defined in your busy itself I will show you in busy all these fields how you can configure that hashtag s character speech if you want to print the characters number of characters view defined as 10 so total number of characters will be put in 10 whether it is above 10 it will print only 10 characters if you want to print the barcode I configure some barcode as you know you can configure barcodes in busy if you want to configure barcode in busy you can use the field as hashtag BC so it will print the barcode in in your Advanced format itself if you want to print barcode with its caption caption like item name item Alias name whatever caption you want to need it will print your barcode with caption so the Syntax for that we have to use hashtag bcwc if you configure the field in dictionary dictionary for cycle language you can use the syntax as hashtag SL so I'll show you in busy itself now in World document printing advance these are the configure which I feel I configured here I will show you data manipulation fields header part this is the first value I printed hashtag W so I selected blank space as 40 and after that I selected amount grand total and before you are corrected total number of character I applied hashtag comma W comma close and after that I configured the amount I'll show you alt effort amount grand total it is coming like that you have to print hashtag comma W comma close this is how you can configure the field I defined the total number of characters as 40. so I configure hashtag comma W hashtag comma closed so if I show you the print data manipulation field I selected here preview see in the top end side it will keep printing 19 and PSI 1880 8 only so it's printing like that it will print the amount in both it will I selected amount grand total i w means the field will print in amount in words I want amount in words the field is not available for amount inverse let's suppose the field is not available or I want I I want to use a syntax that the value will print in amount in words so I selected amount grand total field I selected hashtag W so see the amount grand total value is coming in amount in words like 19 and PESA 88 only so it will print the value like that next option I will show you this is amount amount grind total RN RL means round of lower value if you want to round off the lower value it will round off your lower value it will round off see the invoice amount is 19.88 so it will round off your value it will not uh print 19.88 it will lower your round of value that means the value should come as 19 it will lower round of your value so I press alt P data manipulation format I selected preview see the second line it will printing as 19. because I selected R L that means the inverse amount will be lower the round of the lower value the invoice amount is 19.88 it will lower the value that means the value is printing as 18. so now I configure amount grand total Ru means I selected hashtag comma Ru comma closed all the configuration will be done like this hashtag comma the syntax r u r l w comma closed and after that I'm going to just call the field before your number of characters you have to Define hashtag comma like that you have to configure the fields are you means it will upper your round of value so the invoice value is 19.8 width it will upper your roundoff value though so that means it should bring like 20. so I will show you the data manipulation field see the value is coming as 20. because the value is 19.8 to it it will upper your round of value it will print like 920 instead of 19.88 it will upper your roundoff value God I will go to the format again I say selected data manipulation feed I selected here amount grand total #ra that means #ra means #ra means automatic round of your automatic value so I selected R8 that means hashtag RF that means it will automatically round off your value I saved it here the value is 19.88 it 8 it means the it will check point it is it is above 1.50 it is above 1.50 it is above 0.50 so it will automatic print the value L as 20. so I selected the data manipulation here review here it will print 20. I selected nineteen point 4 4 now I save the item now see what it will print in case of 4 4. I selected the format data manipulation it will print 19. so in case of automatic grind off if the value is above 0.50 it will upper the value it is if the value is below or lower 0.50 it will round off the lower value so it will print print like that next option I will show you the next release padding characters for padding characters I configure hashtag comma P I want to print star so I selected configure here as star from Center I want to print if I have sent configure L it will print from L I will show you first how it will print the padding characters data manipulation feel like that see left hand side it will print the value in the right hand side and it print the star characters so this is how you print the padding characters I configured that data manipulation field header if I selected c means I want it Center so I configured in Center here so padding character will print in both side and left hand right hand side in both characters see the value is coming in center and the padding characters in coming in left hand side in right hand side both itself if you want to con change the sign you can change the sign from here all the which is whatever you want to configure like if you want to print select star if you want to print another like minus it will print like this data manipulation field preview see it is coming like minus so the padding character the what field you need you have to call that field for that you have to do what you have to do you have to call the field like amount Grant tutor full field you need and you want to print the value in Center in the left hand side and right hand side I want to print minus sign so I configure hashtag p minus if you configure star it will print star if you configure plus it will print your plus you go if you configure comma it will print comma if your configure dot it will print your dot it will configure comma it will configure the comma whatever you need to print the padding characters in lifetime side or right hand side or only right hand side dot left hand side you have to configure the character here alphabet here like slash comma minus star whatever you want you have to configure here like that star I need after that what you have to do you have to close the comma it will print the petting characters like that after that I will go to the geta field now so the next field which I configured is L1 that means line break if you want to Let's suppose the value is too much too high value is there for the amount in words if you want to print only 30 characters in first line rest of the 30 characters you want in second line or rest of the 30 characters only in Needle oh third line on fourth line for short that we have to con configure like that you have to call first amount in word field after that you have to apply hashtag comma L1 L1 means line one in line one I want to print only 30 characters rest of the character will be printed in line two so I configure L2 in the second line I want to print 30 characters if the still the amount in inverse is still remaining it will print the 30 characters in L3 so I configured it as L3 still the amount is remaining at the amount in words in remaining so the rest of the amount and watch L4 so I configured light that amount in words I call the field I call the field light #l1 comma save I'll show you like that I will in this is the uh more value I'll show you the print now data field preview see the only 13 characters is coming in the first line in dress of the characters will be coming in second line so it will print like this only 30 characters will print in first line rest of the characters will be printed second line and rest of the character a will be printed second line if let's suppose I increase the characters from here increase the character here like I configure 40 year instead of 40 30 so I configured 40 here now see what is the difference data field I selected the format c i it will configure character will be printed as 40 characters number of character will be 14 in first line and this of the character will be print in second line so number of characters if you want to print in number of line you can Define them number of characters that characters will be printed in first line rest of the characters will be printing second line third line and fourth line you can configure like that amount in words S110 S1 means number of characters you want to print so I called a mountain word hashtag S10 that means only take 10 characters will be printed here so I configured amount in words as 10. and save this field now I'll see show you the print now data field see 1500 though total of 100 characters is not coming because I configured 10 only so I configured that number of characters as 20 S10 is the field so I configured the field here as S10 only those characters are printing here so this is how you can configure the fields amount in words grand total ra I already told you RL I already told you are you I already told you how you can configure that #slr barcode I will show you now how you can print the barcode this is the data field I configured the body part I selected here item print name hashtag BC 40 characters I need PC 40 characters and 18 is the number of characters I want new line means from New Line it will print the quantity so how you can configure that I configured the field as item print name after comma you have to Define hashtag BC 4040 means number of character of barcode you need and this is the length you need for your item print name after new line I called a new knight from New Line it will print the quantity so I saved the field here I will show you the print here data field see it will coming like this hashtag this is the hashtag BCI configure so this is the barcode is coming number of characters is 40 this is an image 40 characters is this the barcode and from New Line it will print the quantity that is your one quantity for particular this voucher so you can configure the voucher like this if you want to print your barcode if you print the uh if you want to print the second language you can call it from dictionary miscellaneous data entry from from General we have to enable the option second language I configure the language as English here from miscellaneous data entry I have to go to second language dictionary I configure the value local value I configured here the second language value second language means your Arabic language your Hindi language any of the language you have to configure like this here after that what you have to do you have to go to the invoice format invoice document printing Advance you have to select your data format after that you can configure your data format select the field body I configured alt or F4 here item C SL means second language that means alternate Newton unit Elias will be print your second language alternate unit print name will be print your in your second language these are the fields available from here you can select the fields which are the fields which is not available you can Define as alt f4 static text you can configure it as new hashtag 20 hashtag SL how you can configure the fields if you have any or second language it will print your second language like that it was configured as coming if you have any of the other language in your system it will print in your Arabic format in your Hindi format any of the language which I configure or installed in your system it will print like that so what you can call you have to what you have to do is you have to call the fields like static field I configured the value like I configure in dictionary as new miscellaneous data entry second language dictionary I configured it as new and the second language as new so I configure static text here I write in now written down as new hashtag SL number of characters you need in a new characters you have to configure like that and print like in your sales voucher take the format here and it will print your the configured language here it will print like that after that the format will be QR code there are two type of QR code format that first one is your static and the other one is your Dynamic for the static you have to write down the T all the vouchers will be printed as 6. the QR code will be fixed for all the vouchers if you configure the dynamic QR code if you have to write it down as F in that case what you have to do you have to configure the format name I will show you how you can configure the dynamic QR code in static QR code in busy itself this is the company I will show you for the static field first I configured the uh format here QR text I'll go to the header part I configure I call the field as from F4 QR code this is the field I have to write down T instead of f because this is the static field after that you have to define the format what you have to print this is original copy so I configured two QR codes from here so I will print like that see QR code text preview it is coming like that QR code is coming when you scan this QR code from busy it will go to your site and print the this is your original copy I configured the field here I configured the field here as .bg.in it will in all the voucher it will print the same content it will print the same contest context so it will print dot busy.in when you scan any of the voucher when you scan this particular barcode the QR code when you scan it it will go to the site .bz.in so you have to configure if you want to print and if you want to print another line to whatever content you want to print just write down call the QR code field first write down T instead of text in because the shortcut key is t means static test after that Define the semicolon after that Define the field Define the content which you want to print after that s means size what will be the size for your QR code means one means one inch QR code I want so this is how you can figure the static static QR code this is how you can configure so now now I'll show you the dynamic QR code for that I have to configure the format first I configure the format QR code I add the format as QR code header I I want these all Fields will be printed in your QR code when you scan any of the voucher it will print your company name your company gsta number your invoice number invoice date buyer name GS chain bill amount text amount item name so obviously all this information vary from voucher to voucher so it will be your Dynamic QR code because the information changes as per your voucher so I configured the filter which is the the content which you need in our QR code to call the fields from here like what are the fields I not need in your QR code this order are the field when you scan your QR code these all are the fields I want so I configured the company name company gstn invoice number invoice date buyer name gstn bill amount tax amount item amount so in QR code format I configured these fields this that means when you use when you scan your QR code these all invo information will be come when you scan your QR code so I configured the field here save it after that I have to configure another new format so I configure another new format QR bill for that I have to go to footer part or from from any of the field you want to print if you want to print your header part you can configure the printing header part if you want to print in QR code in body part you can configure in that if you want to print your QR code in your footer path you can configure it like that so I configured uh or F4 QR code for that this is the dynamic code QR code for dynamic QR code you have to press the you have to define the F Dynam f means f means Dynamic QR code format name to format meaning name means the format name this is the format name the this is the content which I want to print in your QR code so I have to define the QR code name so uh QR code means format name I have to configure QR code this is the format name QR code I have to copy the format name Prim I have to go to QR bill footer part I configure f I defined the name as copy paste here like QR code so it will print the QR code in this format and scan the information from your QR code the content which I configure in QR code format this is the size s mean size and 1.5 inches is the QR code length so I configured like this again I am repeating you first I have to create a format new format in which I have to call the fields which I need in QR code when you scan it after that I have to create an another new format in that new format what you have to do you have to call the QR code field name when you call the QR code field name you have to Define if the f means Dynamic QR code after that you have to define the format name from which it will pick the QR code details so I configured the QR code details format name I defined here as QR code format name is QR code showing QR bill I configured it as QR code so I configured like that when I print make sure I have to print the QR bill because the QR code will be printed QR bill see it will print the QR code light that when you scan this QR code from your Barcode Scanner or your QR code scanner it will print all the information which I defined in QR code it will print all the information which are defined in this format this in this header part it will come when you scan this QR code format it will print your all these information will be picked from your QR code from here itself so these type of two type of QR codes are there in busy thank you all for your precious time I hope you all understand today webinar topic please do practice for your better knowledge for further queries our hello stream is just a call away helpline number any email ID is given in screen please note it down thank you all