Discover the Electronic Invoice Format for Product Quality that Transforms Your Business

Electronic invoice format for Product quality

hello udo experiencers today we're gonna talk about a more technical subject about accounting localizations import export xml keyweb py something that i don't even understand so it's not me who's going to present this it's going to be the mastermind about this subject in the do his name is jos and his striker is jco but i'm not giving up his email address it's with you josh thank you more and more governments in the world decided that when you send an invoice to your customers they want to be aware of it as well can be anti-fraud can be to simplify the administration but finally for us so do it means that if we want to sell accounting in those countries we need to implement the functionality that sends those those invoices do the web services of those governments and it so in practice it means that we did for example the colombian localization the mexican one and each time separate because yeah they are a little bit different so we think as developers yeah it's not so bad that we do a bit the same but yeah it's different so let's put put it in those different modules but if you look at it afterwards and you you say but and you look from a distance and you say yeah no it's not uh it's not ideal maybe we can improve this and then then you see that by by having it common between the modules that you can actually win a lot of time so that's why we made the account edi module um sorry jos uh yet where i come from we call it eddie is it okay if we call account eddie as well yeah you can you can call it eddie as well or only in english it's people mostly talk about edi but yeah i know sometimes eddie is fine as well actually in this talk we were in the in the title we were talking about edi framework or eddie framework but yeah i know do even a complicated framework becomes a simple module so we just created account eddy and what i want to show you is that with account eddy you can it's simple to develop your own edi format it's also simple to use i will give a short demo just to make also the link between the developments and the and the usability and it's also good to evolve together to think about how we can improve this module in the future there are we have quite some ideas about that as well so let's dive into the development we have the object model we have the account edi format if you create your new format you need to specify an xml record with your name and code of your format in the xml itself so it creates a new format we also have the account edi document which is an attachment but it also has some state info has it been sent to the government correctly and so on so act and the document also has a format so actually what happens is that you configure on the account journal which are the edi formats you want and when you validate an invoice a customer invoice what happens is that it will check which other formats to be supported and it will create an edi document for each of those so that's the object model it's good to check which are also the use cases we support so we we have just uh you have you get a file from your vendor you you go to the vendor bills list you have an upload button you put a file there it creates a vendor bill first first case second case you send your customer invoice to the to the to your customer and there you put the files that you need that there you have the xml formats automatically attached it's just an export sent by mail of course if you interact with governments and even other use cases we need to send it to a web service and that becomes a bit more complicated we haven't implemented anything yet into account eddy for receiving through the web services so if you are going to develop with account eddy well just go to the easiest thing to do is just to go to account edi format dot b and the developer there already gave the right indications and put a comment like like import methods to override it's also put a comment import methods not to touch and so you just need to end to overwrite those methods so here it's about when you when you up upload something in the wizard it calls this create invoice from xml if it's an xml file you also have pdf and other formats and you just need to inherit it you need to say is the the form or current edi format i'm on is it my format and then you can execute your code and all you need to return is the right invoice you will see that if you look at the other localizations that we mostly use lxml to find the right elements and the xml like the partner for example and we use often the with form emulator so that if you um if you put a partner in there that it also applies the own changes so you have the right accounts the right fiscal position and so on uh already automatically the same way you would create it in the interface manually we also have the manual export and then the manual export what's that you just also inherit those methods what we mostly do is use a q app render so most of these cases you you get the queb template you send all the information of the uh of the invoice with the render and you get an xml and that's the xml that's then attached to the email or it can also be embedded into a pdf but if we are going to talk about web services it gets a bit a little bit more complicated and so let's go to the to the board oh oh oh i know what it is i know what it is it's the salary of a doctor against the salary of a governor right i think it's the document that is being sent to the government and yeah what we actually want to do is that the document has actually the document you validate the document we don't want to send it immediately because we don't want to block the user and validation if this one is down we don't want to we don't want to block the user so what we do is we just do some primary validations like how does it have a vit number or not and yeah and then we and then in a synchronous cron it's being sent to the government uh and then yeah the thing is all kinds of things can happen and so mostly what people do as they start with us are start uh uh we are two cent but uh then they get an error and then you say uh yeah it's sent with error and then they add a another state afterwards it's sent but it's sent correctly uh and then maybe it's cancelled and then afterwards the cancelled with errors and then it but the errors you say i want to cancel the cancellation of the errors so it's cancel cancelled and then it goes uh yeah then maybe you can boot it back into cent and then maybe you can go there again you look it's like yeah you can it can become endlessly complex certainly if you have two steps or one steps and so for everyone you will see that in a lot of modules it's done like this you have a state and you have plenty of different states there are modules and we do there are certainly models in the oka as well that do that and so what we said this is and we want to make it a lot simpler what we want to have is just one state to send and what we want to know is okay is it sent or not and is it proved by the government because that is common among all that localization is it okay by the government or not is it are we done sending it and then you have what also possible in a lot of cases is that you can do that you can cancel it and you can say okay it is two canceled but suppose that the two cancel scans where it's cancelled you can go back to to send and it's cancelled and there's only one thing that we have extra and that's a message an error message that can go in between so if you have an error it's you are in two cent and you have an error message that can be blocking but can also be yeah go come back later because we saw that the server was down or something or there was a problem with the connection so that way we handle a lot of use cases with the same we end a lot of use cases with the same basic simple structure and we found what's common between them and that's helping us a lot and like and that's why i encourage you to use that as well so just to uh so say again you have um so asynchronous we do a validation and it's also possible in the module to send your things and batch i'm going to give a short demo to to to show you the link between what we are talking about and how it's going into practice so here we have our accounting we go to the customer invoices i will just duplicate because i really want to keep it short and i save i confirm and what i see is that i have this blue banner and that's actually what we do that message that it was talking about is actually put here so if it's an error it will be put in red but you have all the information about the sending here what's happening in v15 is actually that it's also um everything is happening behind the scenes so if so you can click process now but actually everything that the cron is taking it really far immediately so actually it's possible that if i if i refresh that um that it has already been uh that it has already been sent like you can see what you can see as well if i send and print is that i have another format that's being used and that's put into the pdf and that's uh which is called factoryx what i can do is that i i can go i can go back to my other company and try to import it there so i go to accounting i go to my company i take accounting i want to go to the vendor bills and here i have the upload the manual upload so uh i take the vanderbilt i just uh the customer invoice i just exported and i imported it in my in my other company the advantage here is also that yeah if you are if you go to the customer invoices that that just wait a bit in the screen until i that i have a filter where i can group by the different states and if there are invoices that stay into send i can follow it up and that's also the advantage of having something in common i just still want to talk to you a little bit about how do we see the future um and one of the things we did is the tax details so um so actually a lot of a lot of localizations and edi formats i think in uber it's almost standard demand you that if you have multiple taxes on an invoice well no if you have taxes on invoice that you have per line so you have for example one line with two taxes that you have the amounts per tax individually and then oh do we don't store that individual information so what we have is a some kind of method that allows to retract to retrieve that information in a really easy way also efficient way and that will help you that that will help you uh for for other formats as well to to put it in a in an efficient way then another thing has the account edi to to edi so we so here we used edi for invoices you might have seen that it's also used for payments for for mexico but the truth is that in reality governments also more and more wants to send the delivery orders gear it's always called a bit differently uh document to the transport all kinds of uh so these are also need to be sent and so we have this issue already so what are we going to do make a module stock edi no we are going to make a module edi which makes it possible to to mix all of those to put any object and send it to uh to where you want and yeah that's uh this has some some nice opportunities as well and then we have ubl um we see that ubl is we have already quite some implementations and we see that there are common there is common ground between them uh but there are quite some dialects and we also see that we have this 3.0 for people which will uh where it's even more standardized so the difference between the countries is not that big actually and here it's really interesting to try to reuse code both for import where we don't necessarily if i where we try we would like to try to to reuse code more because right now every every every format does does its own code but for a partner address for example to find a partner just some some things that are in common um and this and also for exports we are even thinking about not doing it in qweb but adding uh something that makes it also possible to do validations on the fly so yeah so these are actually quite some interesting evolutions that we can do and so i want to conclude by by again telling what i said in the beginning simply that if you are going to develop your own format please think about account eddie and it's simple to develop and it's also make it simple to use and it makes it good to evolve uh together to think about what we can improve in the future because i i'm sure that from the community there are also a lot of ideas about how we can improve this so so i would like to say don't forget to ask any questions in the questions and answer session and thank you good evening everyone thank you for uh watching uh the latest talk from the audio experience um we're here to to answer some of your questions now so we're going to start uh from the beginning so good evening ready to answer some questions hope so okay so what do you think about creating um a link between promotion lines and the main product line invoice reason being because in some countries negative value in the invoice is not valid well um yeah i i think it can be uh well it's an interesting use case in any in any way in any case that uh in some countries apparently you cannot send negative lines so um somehow you need to find the find a solution for that because people give this coins in all kinds of ways now making a link between a free product and a main product and then yeah who is going to set it is going to be set by the user or automatically i don't see immediately the good solution for that but um yeah we can think about an automatically computed solution uh where we uh repetition the negative line over over over other lines so yeah that's yeah it happens so what are the differences between dcdi and the previous edi module well what we are doing now is trying to convert everything with the account edi module that we that that i have been talking about uh we still need to uh change it for uh for argentina and chile we are working uh also with uh uh heavily on ecuador door with uh or our partner over there um that will be also uh implemented with with account edi um we have a mexico and peru already and we are doing spain and spain and has been done has been merged recently italy have we have been working very hard on on making italy work correctly so it will come in italian don't worry so how to send the ndi doc again like he was doing in previous version uh how to send an edi document again what does he mean by that i don't know [Laughter] um yeah but um i don't know what the the question means is it going back to before i don't think it's a good idea of course you can still do things the way you did before we just encourage people to use uh county tdi because for what i said the usability is better and so on um [Music] yeah and uh if you want to send it uh a second time um well no what we have is that you send an edi document to the that's that's not in fact the reasoning behind it you send the document to the state once this the to the government once the government receives your your document it's uh it's the it's it's it has been received and approved um of course um yeah um yeah and and then you shouldn't change it anymore you shouldn't reset it to draft and change changes of course we see that there are countries where you can easily send it again but most of the countries will say no we have already received it and if you want to change it you need either to cancel or to or to do a refund so that's why we we kind of stick to to that logic with the account india okay it's uh interesting um thank you so much is there an audio documentation sorry is there another documentation for account edi uh actually not what we do what we do however is that for every country we we will have what they see happening at least for the latin countries and but also for for italy i mean we need to do it for spain is do a good documentation online about the the localization itself it's true that i could make a bit more documentation online about opcode adi but as i said in the in the presentation i think the easiest way is to just check the file which already has uh a lot of document which already has the right indications i think in the in the in the code but it's definitely something we can think about okay um and can you give us like an update on the the current uh edi proxy module um [Music] yeah the the idi proxy module is actually something else maybe you saw it in the code or somehow i don't know but the account ei proxy has something that's another module uh next to the account that depends on the account edi and actually is uh is used for um for when you have when we want to use a proxy server when you have an intermediate that we have at odoo and we have some security stuff and and so on and there to uh make sure we we can decrypt the messages and that we have a good security behind it but it's basically for example we might use it for people as well where you send images where you send documents between servers and yeah we as as odoo function as an operator for that so we we will we'll set up that the server ourselves uh but it means that that server cannot be on every you cannot put that uh that server individually on every auto instance you have to have one centralized and that will dispatch to the different auto instances that's what that model is for thank you so much um well i think uh we have to look here for uh some more questions uh well you have here some uh some challenge from hungary yeah you say the government yeah of course the government cannot uh does not ex that's possible that the government does not accept it and then it will return an error and then you will see the error and then you have to reset to draft fix your error and then send it again yeah until the government says it's okay and how long does it take more or less this uh to this uh in case like this how much time does it take you like this process to as a as a user yes uh it depends how difficult the the government but it goes it goes back and but uh normally they react immediately if it's an error that's that's obvious but if it's it can be that the government has a two-step process where it takes uh 10 minutes before uh then yeah 10 hours for example before it reacts and says sorry there's still something wrong with you okay so that can happen we have here another question so you mentioned uh people when can we have it on audio oh i wish we we had it already but uh yeah it's implementing purple is really difficult yeah because we really want to be access point ourselves um but we are getting there and but it will take some time it will uh we will have some some some months at least before and i don't dare to to promise uh anything but i'm i'm i want if we want to have it i mean we want to have it it'd be really nice because it's not only just for government administration also to atmos to simplify your administration that's a good thing about about a more generic uh for format and framework like people okay um there you have it everybody uh once again thank you for uh for watching uh this presentation thank you for participating on the sudo experience it was a pleasure to have you all thank you so much for uh your participation as well just you too well good evening um wish you all the best and uh where is the fester that is the fish you