Discover Fusion Invoice for Communications & Media that Transforms Your Workflow

Fusion invoice for Communications & Media

hello all welcome to our trainings.com in this session we'll discuss about how do we create ar invoice and also some of the tables details of it so let's start with what is a invoice so generally like when you try to create an invoice there are different types of invoice you'll come across one is invoice a generic invoice a credit memo as a debit memo and these are the header information and coming to the line information in the lines generally you'll have three kinds of lines receivables revenue and tax will not get into much of the functional area so the major concentration is on how do we create from ui and what are the main tables involved okay and also the standard report of it so in which particular cycle or a process air invoice comes into picture if you observe carefully so generally air invoice comes in the part of otoc cycle and here if you observe generally you know you may start we may start with sales order creation then you may have a ar invoice then receipt cash management and gl general okay that could be the process but you can also create them individual nothing but you can create air invoice individually and then you can i mean like what you call you can post it to gl and you know sl stuff all those things okay now so let's see how do we create the invoice now let us say what is the navigation involved and how do we start with creation of it and what are the prerequisite so to create our invoice of course you may need to have appropriate responsibility and air invoice is created for the like if you want to create your invoice first of all you require a customer okay nothing but is a receivable you're receiving some amount on a particular sales order or you know like maybe receivable information right so you're you need to create invoice on a particular customer okay nothing but like you need to have a customer created based on that only you can create invoice okay and of course it should have the bill to and ship to location ship 2 is not mandatory but they have to have a built-in role okay so let's start so we'll just navigate to our application so once you navigate to application and click on the receivables okay and then click on building so once you click on building it may show a screen like this and make sure that you have the appropriate bu roles and then click on the task and here in the transaction area so these are the information which is related invoice one is the first one here if you observe create transaction and that this one is a credit transaction credit memo manage transaction is for the purpose of like if you're at all if you want to update something you can just go with that okay so now let's start with this one click on create we want to create invoice so we'll just click on create invoice and now here if you observe it shows set of fields which are mandatory like asterisk okay so now transaction class will go with invoice and a business unit so i'll just go with us1 business unit okay based on the business unit you may have the appropriate configuration you would have done already for the transaction sources to be displayed for the business unit so by default it populated these things of course you can change it and transaction number also you can have a auto auto generator transaction number or you can also have it like a user enabled auto number i mean enter field user enter field or router numbering okay next one is a customer details so like uh first thing is that build to is mandatory shipper is not mandatory so i'll just select this pop list and maybe i'll select some name easy solutions and search and account number and it may have the default ship to primary built to site will get populated and even the payment terms will be displayed based on that okay this is the header information and of course the amount of lines and tags will be this i mean it will get calculated when you enter the line number transaction number i'm not entering as of now and salesperson is not mandatory but if at all if you want to mention them you can mention them okay now let us start with entering the line details let us say line description i'll just say and uom i'll just go with each and then quantity as hundred thousand maybe the unit price is one so for now i'll just click on save it will perform validation and also probably it will generate the invoice number or maybe we can call this transaction number okay so as of now what are the data which we entered it would have populated around a couple of tables the first table i can tell you is this one is header part okay nothing but it will be stored in header information then there's a line information okay and also we have something called tax tax will also have a separate table and if at all if you would have entered sales credit it would have populated a sales table also okay so what i'll do is as of now our invoice number is this one and let us enter the tax details also maybe you can just click on sales credit sorry sales information sales person details it it has not populated anything for the sales so i'll just click on now in the line information so there are few things which you can enter detail information line level so just click on details so now in the detail level you can mention the tax details as well as salesperson details also sales credit details also just click on here in the sales credit just click on add row and you can mention what is the sales person name name or number and based on that you can mention the percentage let's see it'll try to check out within a person starting a okay i think yeah maybe ralph okay you can mention percentage or maybe you can just ignore if at all if you don't want to mention anything and now in the tax details you can just click on edit tax lines it would have it will mention the existing tax liens if any of them are already available you can also add up things but how does this generated like as we have not explicitly mentioned actually so this would have been populated based on the tax configuration of your business unit okay save and close okay now just try click on sales credit can you see it populated something but you know like as we have not mentioned the percentage nothing was nothing you know like it is not displaying anything right so maybe you can just click on details and mention the percentage of information let's say percentages 10 okay that's it 10 percentage the sales person commission is 10 percent and it says like uh okay you must enter revenue sales credit for the line that equal to the line amount okay what was the line number we mentioned thousand okay now i can see this one and here also you can see the tax lines which we have mentioned at the line level it tells you what is the line what is a like invoice line and there's a tax line so for a single invoice line we have two tax lines okay and this is a tax rate and this is a percentage okay now the status of the invoice is incomplete okay so now what you can do is just click on in this particular button second button and click on complete and review okay if at all if any errors it will populate else the invoice status will get changed to complete right now the status is complete and when the status is complete you will not have a delete option and when the status is complete then only this view image option will be shown just click on this view image it will show a bi report which is a standard like a report generally most of the customers customizes this particular standard bi report okay nothing but the template or of course of course they mod they change the data model also but this is one of the standard report of the print reciprocal transaction invoice okay and now let us say if at all if you want to change something okay now what you can do just click on incomplete once you change the status to incomplete you can also delete the invoice okay this first thing and you can modify the invoice okay and you can just see the distribution click on actions click on edit distributions and you can check you can see like how when you create invoice what level of account classes data it is getting populated the last thing if you observe taxes we know it gets populated and the revenue information okay and the other one is a reasonable information okay so out of this particular revenue revenue was 1000 but in in real time what exactly will get you will get the revenue plus tax also right nothing but for a customer let us say 1000 he has to pay and the tax was 90 rupees you will collect 1090 definitely right so now revenue was now actual revenue which you receive is one thousand but the total amount which you receive from the customer is 1090. that's why receivables was 1090 revenue was 1000. and the tax information is this one and of course the distribution this will be this would have been configured based on the chart of account structure which generally has to be defined before you start with creation of invoice okay so this is all about ar invoice creation maybe i'll show you some table information from my slide also so that you can remember them so first thing is the header level information i mean the main table main set of tables information the first one is ar invoice header ra customer transaction all then the invoice lines transact customer transaction lines all okay in the transaction in the invoice lines table here if you object cust r a customer transaction lines all you'll have the data of both line type data as well as tax line data also okay so for a given for a given invoice line you may have multiple tax lines there will be a linkage between the tax line with a line with a normal line also that you have to carefully understand then the other one is a distribution it will have a linkage between the tax line i mean the line line invoice line i mean next one is the sales strip of course we know it it will have the information about the linkage between the invoice line of course it will also have a linkage between the invoice header then the tax lines are again now coming to the next one so there are dependent tables like customer information currencies inventory item reset methods invoice rules and business unit table batch sources these are some of the other dependent tables of course there are many other things like a payment what you call payment terms are there and maybe if you consider the other information like when you click on show more it shows the other extra information which you may need to populate if required you can just click on that and maybe in the customer the payment information payment to show payment terms miscellaneous you can check out the flexi field information special instructions tax details vivo details all these things you can mention here okay so this is all about uh er and voice in the fusion er okay thank you