Spanish Professional Localization Pack Extension Module Webinar

1. Spanish Professional Localization PackExtension Module Webinar November 26th, 2009

2. Agenda Functionality and Demo 10 min. Process and Tools 10 min. Development Technique 10 min. Q & A 30 min.

3. Agenda Functionality and Demo Process and Tools Development Technique Q & A

4. Content & Installation Spanish Professional Localization Pack Content: • Invoice Register Books • 347 Third parties transactions annual tax statement • 349 Summary statement of Intra-community transactions • Spanish Community Localization Pack • Spanish translation • Charts of Accounts • Tax ID validation • Domestic bank account validation • Accounting Alerts • Spanish tax rates • Dependent modules -> Tax Report launcher Installation: (Demo – focused on module dependencies)

5. Functional Highlights Spanish Professional Localization Pack (SPLP) • Goal: • To show you how the tax report launcher allows us to generate and launch tax reports • To show you how Spanish tax reports are launched • Functional Concept • Ability to setup different types of tax parameters: • Input • Constant • Output -> Tax parameters

6. DEMO - BUSINESS SCENARIO: • “My Organization” is a Spanish company • It sales and purchase goods to either National or EU customer/vendors; therefore it needs to submit those transactions to the tax authorities by using the corresponding tax reports: • 347 tax report for those sales/purchase transactions done with National customer/vendors • 349 tax report for those sales/purchase transactions done with EU customer/vendors

7. Spanish Professional Localization Pack – Tax Report Launcher Functional Highlights DEMO Tax Report Launcher & 347, 349 tax reports

8. FUNCTIONALITY AND DEMO : RECAP • SPLP content and SPLP installation • 347 and 349 “Official” Spanish tax reports built by using the Tax Report Launcher framework • Tax Report parameters as the way to get tax report data • Output tax report parameters linked to Tax Rates

9. Agenda Functionality and Demo Process and Tools Development Technique Q & A

10. Spanish Professional Localization PackPack as a container of modules. Managing module's dependencies, releasing new module's versions. • A module can depend on another module. • 3 attributes in a dependency: • Dependant module • First version • Last version (not mandatory) • Always a dependency on core 347 Depends on TRL

11. Spanish Professional Localization PackPack as a container of modules. Managing module's dependencies, releasing new module's versions. IRB esES valid. 349 valid. tax CoA 347 CoA alerts SLP • A pack includes modules and/or other packs • 2 attributes in an inclussion: • Included module • Version • In one only .obx file, all modules are included SPLP

12. Spanish Professional Localization PackPack as a container of modules. Managing module's dependencies, releasing new module's versions. • 4 possible cases while installing packs / modules from file system/central repository • Installing a pack from file system may install different versions of it’s contained module than installing from central repository

13. Spanish Professional Localization PackPack as a container of modules. Managing module's dependencies, releasing new module's versions. Module versionstructure: XXX.YYY.ZZZ New majorversionrequiredwhen: • Dependenciesmodification • Addedor removed dependencies • Modifiedfirstversion of a dependency • API change Major version Minor version

14. Agenda Functionality and Demo Process and Tools Development Technique Q & A

15. AEAT 347 Report AEAT 349 Report Sample Report Future Reports Spanish Professional Localization Pack Implementing Java interfaces for modular development Openbravo ERP JAVA INTERFACE TAX REPORT LAUNCHER JAVA IMPLEMENTATION

16. Spanish Professional Localization Pack Implementing Java interfaces for modular development JAVA INTERFACE • Abstract type which defines a list of: - Method signatures - Constant declarations (static and final) • The reserved word interface is used • It can't be directly instantiated. Another class must implement the interface, i.e., it must implement all the methods publicinterface OBTL_TaxReport_I { public HashMap<String, Object> generateElectronicFile(String strOrgId, String strReportId, String strAcctSchemaId, String strYearId, String strPeriodId, Map<String, String> inputParams) throws OBException, Exception; }

17. Spanish Professional Localization Pack Implementing Java interfaces for modular development HELLO WORLD IMPLEMENTATION package org.openbravo.module.taxreportlauncher.helloworldreport; // Imports are hidden public class HelloWorldReport implements OBTL_TaxReport_I { public HashMap<String, Object> generateElectronicFile(String strOrgId, String strReportId, String strAcctSchemaId, String strYearId, String strPeriodId, Map<String, String> inputParams) throws OBException, Exception { HashMap<String, Object> myMap = new HashMap<String, Object>(); // Use StringBuffer because it is safe in multi-thread StringBuffer sb = new StringBuffer(); sb.append("Hello World!"); // File content. Mandatory myMap.put("file", sb); // File name. Input Parameter with Search Key "fileName“. Not mandatory myMap.put("fileName", inputParams.get("fileName")); return myMap; } }

18. Wrap-Up Functionality and Demo Process and Tools Development Technique

19. Advanced Payments Pack Q & A Next webinar: Advanced Payments Module November 12th 4-5 PM (CET) eduardo.argal@openbravo.com gorka.mauleon@openbravo.com gorkaion.damian@openbravo.com