Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Abstract module for exporting invoices

by
Web-veistämö Oy/Avoin.Systems, Miku Laitinen.
- 14/08/2015 16:13:24
Ah yes, I forgot to mention about the data transformation. The expected format is Finvoice XML (http://www.fkl.fi/verkkolasku/english/) – which is Finland's most commonly used B2B e-invoicing standard – with a couple non-standard fields. I already have created a module (account_finvoice) for generating a Finvoice XML file from a sales invoice and I hope that someday I'll have enough time to OCA'ize it, since basically ~every Finnish company using Odoo for invoicing would need it.

So the module I'm planning to create would call account_finvoice to generate the XML file, add a few non-standard fields and use pysftp to send it to the external system. Thus using odoo-connector or connector flow seems a bit overscaled. Thanks for the tips though!

- Miku

On Thu, Aug 13, 2015 at 9:53 AM, Joël Grand-Guillaume <joel.grandguillaume@camptocamp.com> wrote:
After lot's of discussion to cover this need, I think this is the best option, but it is still not fully completed. Your opinion/review here might speed up things.

Thanks for contributing,

Regards,

Joël



On Thu, Aug 13, 2015 at 3:23 AM, Eric Caudal <eric.caudal@elico-corp.com> wrote:

Additional thoughts: you could use current csv extract module as extract module and focus on the transformation and transport modules for your customer.

--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Shenzhen/Singapore) Odoo Gold Partner, best Odoo Partner 2014 for APAC
On 08/13/2015 08:34 AM, Eric Caudal wrote:
<blockquote cite="mid:55CBE633.3020302@elico-corp.com" type="cite"> Hi Miku,
Thanks for the contribution.
How do you plan to transfer the data from Odoo to external system? Do you plan to use odoo-connector? Please note that there is for example a module to export to CSV file in this project.
Anyway, I would suggest that you abstract the layer related to data creation and separate in 2 (or more if necessary) modules like you suggest. It is far more flexible in the future as this kind of requirement seems to me quite common.
Looking forward to reading you
--
Eric Caudal [Founder and CEO]
Skype: elico.corp. Phone: + 86 186 2136 1670 (Cell), + 86 21 6211 8017/27/37 (Office)
Elico Shanghai (Shenzhen/Singapore) Odoo Gold Partner, best Odoo Partner 2014 for APAC
On 08/13/2015 02:07 AM, Miku Laitinen wrote:
<blockquote cite="mid:CAD-eYikby8BcUAHKd+VDeAJKdC8kN-Q_TYd=qktc3UPun=A0JA@mail.gmail.com" type="cite">
Hello,

I'm currently planning to create a module for exporting sales invoices to a 3rd party accounting software. After confirming the invoice the user only has to click a "Send" button and the invoice is then transferred to the 3rd party system via SFTP. A cron job then queries two SFTP directories (successful & unsuccessful) and checks if the invoice was successfully saved in the 3rd party system, and updates the export state of the invoice in Odoo.

Does anyone know if there is an abstract base module for exporting invoices into other systems? Like account_bank_statement_import is for importing bank account statements and account_bank_statement_import_ofx is just one implementation of it.

I'm asking this because I _could_ make a single "all-in-one" module that handles everything, but I know there will be a need for other similar integrations in the future. That is why I think there should be a base module for this (eg. account_invoice_export) and modules that depend on the base module (eg. account_invoice_export_vendorX). The base module should at least manage the export states and message logs.

Miku Laitinen
AVOIN.SYSTEMS



_______________________________________________
Mailing-List: http://odoo-community.org/groups/oca-contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe




--


camptocamp
INNOVATIVE SOLUTIONS
BY OPEN SOURCE EXPERTS

Joël Grand-Guillaume
Division Manager


_______________________________________________
Mailing-List: http://odoo-community.org/groups/oca-contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: http://odoo-community.org/groups?unsubscribe


Reference